81,092
社区成员
发帖
与我相关
我的任务
分享我的连接池使用出现错误
刚学jsp,树上有这样的程序:但运行后结果不正确!请高手指教!!!谢谢先!!
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,javax.naming.*,javax.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>连接池连接MS SQL Server 2000</title>
</head>
<body>
<%
out.print("使用连接池连接MS SQL Server 2000<br>");
out.println("<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/firm");
con=ds.getConnection();
stmt=con.createStatement();
rs=stmt.executeQuery("select * from user");
md=rs.getMetaData();
out.print(md.getColumnLabel(1)+" ");
out.print(md.getColumnLabel(2)+"<br>");
while(rs.next()){
out.print(rs.getInt(1)+" ");
out.print(rs.getString(2)+"<br>");
}
}catch(Exception e){
out.print(e);
}finally{
if(rs!=null)rs.close();
if(stmt!=null)stmt.close();
if(con!=null)con.close();
}
%>
</body>
</html>
结果显示如下:
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
不知是什么问题?
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,javax.naming.*,javax.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>连接池连接MS SQL Server 2000</title>
</head>
<body>
<%
out.print("使用连接池连接MS SQL Server 2000<br>");
out.println("<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/firm");
con=ds.getConnection();
stmt=con.createStatement();
rs=stmt.executeQuery("select * from user");
md=rs.getMetaData();
out.print(md.getColumnLabel(1)+" ");
out.print(md.getColumnLabel(2)+"<br>");
while(rs.next()){
out.print(rs.getInt(1)+" ");
out.print(rs.getString(2)+"<br>");
}
}catch(Exception e){
out.print(e);
}finally{
if(rs!=null)rs.close();
if(stmt!=null)stmt.close();
if(con!=null)con.close();
}
%>
</body>
</html>
结果显示如下:
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
不知是什么问题?
...全文
请发表友善的回复…
发表回复
