tomcat连接mysql报错,折磨了我好久,急求大侠救命!!

cliu0207 2006-04-27 03:58:27

我在学习用JSP连接MYSQL数据库,但总是不成功,急求大侠救我!!JSP源代码如下:
<%@page contentType="text/html;charset=GB2312"%>
<%@page language="java"%>
<%@page import="java.sql.*"%>

<html>

<head>
<title>testDriver</title>
</head>

<body>

<%
String url="jdbc:mysql://localhost/sql_test";
String driverName="org.gjt.mm.mysql.Driver";
String userName="root";
String password="liucheng0207";
String sql="select * from student";//SQL语句

try{
Class.forName(driverName).newInstance();
}//try over;
catch(ClassNotFoundException e){
out.println("Error1:ClassNotFoundException");
}//catch over;

try{
Connection conn=DriverManager.getConnection(url,userName,password);
Statement stat=conn.createStatement();
ResultSet rs=stat.executeQuery(sql);
while(rs.next()){
String id=rs.getString(1);
String name=rs.getString(2);
String address=rs.getString(3);
String birthday=rs.getString(4);
out.println(id+","+name+","+address+","+birthday);
}//while over;
}//try over;

catch(SQLException e){
out.println("Error2:SQLException");
}//catch over;

finally{
try {
rs.close();
stat.close();
conn.close();
} //try over;
catch(SQLException e) {
out.println("Close SQLException");
}//catch over;
}//finally over;
%>

</body>

</html>

报错提示如下:
org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 15 in the jsp file: /testDriver.jsp
Generated servlet error:
rs cannot be resolved

An error occurred at line: 15 in the jsp file: /testDriver.jsp
Generated servlet error:
stat cannot be resolved

An error occurred at line: 15 in the jsp file: /testDriver.jsp
Generated servlet error:
conn cannot be resolved

org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:397)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:288)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:267)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:255)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:556)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:293)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

同样的程序,我用JAVA就可以实现,为什么用JSP就不行?
我将驱动的jar放在了WEB-INF下的LIB内,同时也放在了COMMON下的LIB内和SHARED下的LIB内.
求大侠救我!!

...全文