org.apache.jasper.JasperException: An exception occurred processing JSP page /exa7_7.jsp at line 18
15: Context initCtx = new InitialContext(); //这里四句是连接池的关键语句,见教材
16: Context envCtx = (Context) initCtx.lookup("java:comp/env");
17: DataSource ds = (DataSource)envCtx.lookup("jdbc/stu_admin");
18: Connection conn = ds.getConnection();
19: Statement statement=conn.createStatement();
20: String count_sql="select count(*) from studentInfo as s,class_bigClass as b, classes as c where s.classId=c.classId and c.classId=b.classId and b.bigClassId='"+bigClassId+"'";
21: ResultSet rst=statement.executeQuery(count_sql);
这个不知道是哪里的错误。
我在tomcat
conf文件下的
context.xml文件加入了几句连接池的
auth="Container"
type="javax.sql.DataSource"
driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:stu_admin"
username="web"
password="prog"
maxActive="0"
maxIdle="10"
maxWait="1000" />
也同时在web.xml加入了
DB Connection
jdbc/stu_admin
javax.sql.DataSource
Container
但是还是有错误。怎么解决