JSP连接mysql出现的异常
我的代码如下:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<body>
<div align="center"><strong>数据库连接</strong></div>
<br>
<table width="800" border="1" align="center">
<tr>
<td align="center">用户名称</td>
<td align="center">用户密码</td>
<td align="center">用户权限</td>
</tr>
<%
try{
String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPassword="root";
String dbName="test";
String tableName="user";
String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPassword;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection(url);
String sql="select * from"+tableName;
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
<tr>
<td align="center"><%=rs.getString("username")%></td>
<td align="center"><%=rs.getString("userpwd")%></td>
<td align="center"><%=rs.getString("userxian")%></td>
</tr>
<%
}
rs.close();
stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>
</tabel>
</body>
</html>
我将代码放在E:\Program Files\Tomcat 6.0\webapps\test中,出现的异常为:
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP:
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:308)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.10 logs.
我试着在MyEclipse里运行,同样出现异常,每次启动tomcat的时候没事,但是访问的时候就报错了:
Source not found for JkMain.pause() line: 679
还望高手指点。。。