加了 Connection 后上段能通过,
可我后面加上代码
Statement stmt=conn.createStatement();
String strSQL="SELECT * FROM users";
ResultSet rs=stmt.executeQuery(strSQL);
后程序又有问题,
完整代码为:
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
try{
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
out.print("Connect to Database error: " + e.getMessage());
}
try{
Connection conn = DriverManager.getConnection("jdbc:odbc:forum","sa","");
}
catch(SQLException e){
out.print(e.toString());
}
}
catch (Exception e) {}
Statement stmt=conn.createStatement();
String strSQL="SELECT * FROM users";
ResultSet rs=stmt.executeQuery(strSQL);
%>
出错提示为:
Internal Servlet Error:
org.apache.jasper.JasperException: Unable to compile class for JSPD:\tomcat\work\localhost_8080%2Fexamples\_0002fforum_00031_0002fmenu_0002ejspmenu_jsp_17.java:99: ?????????conn
Statement stmt=conn.createStatement();
为什么?
