tomcat连接mysql报错,折磨了我好久,急求大侠救命!!
我在学习用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内.
求大侠救我!!