|
楼主 |
发表于 2008-5-4 23:14
|
显示全部楼层
源程序代码如下:<%@page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,javax.naming.*,javax.sql.*" errorPage=""%>
<html>
<body>
<%
out.print("使用连接池连接SQL Server2000数据库成功!<br>");
out.print("<br>");
Context ctx=null;
DataSource ds=null;
Statement stmt=null;
ResultSet rs=null;
Connection con=null;
ResultSetMetaData md=null;
try{
ctx=new InitialContext();
ds=(DataSource)ctx.lookup("java:comp/env/jdbc/my_db");
con=ds.getConnection();
stmt=con.createStatement();
rs=stmt.executeQuery("select * from stu_info");
md=rs.getMetaData();
out.print(md.getColumnLabel(1)+"");
out.print(md.getColumnLabel(2)+"");
out.print(md.getColumnLabel(3)+"");
out.print(md.getColumnLabel(4)+"");
while(rs.next()){
out.print(rs.getInt(1)+"");
out.print(rs.getString(2)+"");
out.print(rs.getString(3)+"");
out.print(rs.getString(4)+"<br>");
}
}catch(Exception e){
out.print(e);
}finally{
if(rs!=null)rs.close();
if(stmt!=null)stmt.close();
if(con!=null)con.close();
if(ctx!=null)ctx.close();
}
%>
</body>
</html> |
|