JSP 数据连接池的问题

Follow_Inner_Heart 2010-11-11 07:26:55

<%@ page import="java.sql.*" contentType="text/html;charset=gb2312" %>
<%@ page import="javax.servlet.*" import="javax.servlet.http.HttpServlet" %>
<%@ page import="javax.sql.*" %>

<html>
<head><title>数据连接池</title></head>
<body>
<%
DataSource pool = null;
Context env = null;
Connection con = null;
Statement st = null;
ResultSet rs = null;

try{
env = (Context) new InitialContext().lookup("java:comp/env"); //检索指定的对象，返回此上下文的一个新事例
pool = (DataSource)env.lookup("jdbc/DBPool"); //获得数据库的连接池
if(pool==null)
out.println("找不到指定的连接池");
con = pool.getConnection(); //从池中取得一个连接
st = con.createStatement();
rs = st.executeQuery("select * from student");
}catch(Exception ne){
out.print(ne.toString());
}
%>

<table width="600" border="1" align="center">
<tr>
<th scope="col">学号</th>
<th scope="col">姓名</th>
<th scope="col">地址</th>
<th scope="col">电话</th>
</tr>
<% while(rs.next()){%>
<tr>
<td><%=rs.getInt(1) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(2) %></td>
</tr>
<%}
if(rs!=null)
rs.close();
if(st!=null)
st.close();
if(con!=null)
con.close();
%>
</table>
</html>

//运行后抛出一下内容
org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 10 in the jsp file: /pool.jsp
Context cannot be resolved to a type
7: <body>
8: <%
9: DataSource pool = null;
10: Context env = null;
11: Connection con = null;
12: Statement st = null;
13: ResultSet rs = null;

An error occurred at line: 16 in the jsp file: /pool.jsp
Context cannot be resolved to a type
13: ResultSet rs = null;
14:
15: try{
16: env = (Context) new InitialContext().lookup("java:comp/env"); //检索指定的对象，返回此上下文的一个新事例
17: pool = (DataSource)env.lookup("jdbc/DBPool"); //获得数据库的连接池
18: if(pool==null)
19: out.println("找不到指定的连接池");

An error occurred at line: 16 in the jsp file: /pool.jsp
InitialContext cannot be resolved to a type
13: ResultSet rs = null;
14:
15: try{
16: env = (Context) new InitialContext().lookup("java:comp/env"); //检索指定的对象，返回此上下文的一个新事例
17: pool = (DataSource)env.lookup("jdbc/DBPool"); //获得数据库的连接池
18: if(pool==null)
19: out.println("找不到指定的连接池");

Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:443)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:362)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:340)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:327)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:594)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:314)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

请高手指教

...全文