<%
Connection conn = null;
Context initCtx = new InitialContext();
if (initCtx == null)
throw new Exception("不能获取Context!");
Context ctx = (Context) initCtx.lookup("java:comp/env"); //获取连接池对象 Object obj = (Object) ctx.lookup("aaa"); //类型转换 javax.sql.DataSource ds = (javax.sql.DataSource) obj;
conn = ds.getConnection(); Statement stmt = conn.createStatement();
String strSql = "select * from member";
ResultSet rs = stmt.executeQuery(strSql);
while(rs.next())
{out.println(rs.getString(1));
}rs.close();
stmt.close();
conn.close();
out.println("连接池测试成功");%>出现在错误:
D:\tomcat5.0\Tomcat 5.0\work\Catalina\localhost\myjsp\org\apache\jsp\Test_jsp.java:57: cannot resolve symbol
symbol : variable ds
location: class org.apache.jsp.Test_jsp
conn = ds.getConnection(); 是怎么回事啊/ds明明给他定义了呀
Connection conn = null;
Context initCtx = new InitialContext();
if (initCtx == null)
throw new Exception("不能获取Context!");
Context ctx = (Context) initCtx.lookup("java:comp/env"); //获取连接池对象 Object obj = (Object) ctx.lookup("aaa"); //类型转换 javax.sql.DataSource ds = (javax.sql.DataSource) obj;
conn = ds.getConnection(); Statement stmt = conn.createStatement();
String strSql = "select * from member";
ResultSet rs = stmt.executeQuery(strSql);
while(rs.next())
{out.println(rs.getString(1));
}rs.close();
stmt.close();
conn.close();
out.println("连接池测试成功");%>出现在错误:
D:\tomcat5.0\Tomcat 5.0\work\Catalina\localhost\myjsp\org\apache\jsp\Test_jsp.java:57: cannot resolve symbol
symbol : variable ds
location: class org.apache.jsp.Test_jsp
conn = ds.getConnection(); 是怎么回事啊/ds明明给他定义了呀
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货