请教resultSet问题
我的JSP页写成这鬼样:
<%@page import="java.sql.*" %>
<%String connectStr = "jdbc:mysql://localhost/test";
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection(connectStr,"root","");
Statement st = con.createStatement();
ResultSet rs=st.executeQuery("select * from table1");
}catch(Exception e){System.out.println(e);}
while(rs.next()){}
%>
为何会出现
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 2 in the jsp file: /gbook.jsp
Generated servlet error:
rs cannot be resolved
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
错误呢?
还有,SERVLET的CHM版API哪里有得下啊?
谢谢