java吧 关注：1,244,001贴子：12,717,994
- 4回复贴，共1页
，头要炸了
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>JSP访问数据库</title>
</head>
<body>
<h3>从数据库读取职工表:</h3>
<hr>
<table border="1">
<tr><td>sus</td><td>姓名</td><td>性别</td></tr>
<%
String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPassword="950826";
String dbName="student";
String tableName="sense";
String url="jdbc:mysql://localhost:3306/"+dbName+"?characterEncoding=utf-8";
String sql="select * from "+tableName;
Class.forName(driverName);
Connection con=DriverManager.getConnection(url,userName,userPassword);
Statement s=con.createStatement();
ResultSet rst=s.executeQuery(sql);
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("susheid")+"</td>");
out.println("<td>"+rst.getString("name")+"</td>");
out.println("<td>"+rst.getString("chuangid")+"</td>");
out.println("</tr>");
}
out.println("</table>");
rst.close();
%>
</body>
</html>
这是我的代码
<%@ page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>JSP访问数据库</title>
</head>
<body>
<h3>从数据库读取职工表:</h3>
<hr>
<table border="1">
<tr><td>sus</td><td>姓名</td><td>性别</td></tr>
<%
String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPassword="950826";
String dbName="student";
String tableName="sense";
String url="jdbc:mysql://localhost:3306/"+dbName+"?characterEncoding=utf-8";
String sql="select * from "+tableName;
Class.forName(driverName);
Connection con=DriverManager.getConnection(url,userName,userPassword);
Statement s=con.createStatement();
ResultSet rst=s.executeQuery(sql);
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("susheid")+"</td>");
out.println("<td>"+rst.getString("name")+"</td>");
out.println("<td>"+rst.getString("chuangid")+"</td>");
out.println("</tr>");
}
out.println("</table>");
rst.close();
%>
</body>
</html>
这是我的代码
HTTP Status 500 - An exception occurred processing JSP page /qinshi.jsp at line 22
type Exception report
message An exception occurred processing JSP page /qinshi.jsp at line 22
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /qinshi.jsp at line 2219: String url="jdbc:mysql://localhost:3306/"+dbName+"?characterEncoding=utf-8";20: String sql="select * from "+tableName;21: 22: Class.forName(driverName);23: Connection con=DriverManager.getConnection(url,userName,userPassword);24: Statement s=con.createStatement();25: ResultSet rst=s.executeQuery(sql);Stacktrace:org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)javax.servlet.http.HttpServlet.service(HttpServlet.java:727)org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause
javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driverorg.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:916)org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845)org.apache.jsp.qinshi_jsp._jspService(qinshi_jsp.java:116)org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)javax.servlet.http.HttpServlet.service(HttpServlet.java:727)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)javax.servlet.http.HttpServlet.service(HttpServlet.java:727)org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause
java.lang.ClassNotFoundException: com.mysql.jdbc.Driverorg.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720)org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571)org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:126)org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63)java.lang.Class.forName0(Native Method)java.lang.Class.forName(Class.java:264)org.apache.jsp.qinshi_jsp._jspService(qinshi_jsp.java:85)org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)javax.servlet.http.HttpServlet.service(HttpServlet.java:727)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)javax.servlet.http.HttpServlet.service(HttpServlet.java:727)org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.56 logs.
这是报错500
type Exception report
message An exception occurred processing JSP page /qinshi.jsp at line 22
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /qinshi.jsp at line 2219: String url="jdbc:mysql://localhost:3306/"+dbName+"?characterEncoding=utf-8";20: String sql="select * from "+tableName;21: 22: Class.forName(driverName);23: Connection con=DriverManager.getConnection(url,userName,userPassword);24: Statement s=con.createStatement();25: ResultSet rst=s.executeQuery(sql);Stacktrace:org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)javax.servlet.http.HttpServlet.service(HttpServlet.java:727)org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause
javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driverorg.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:916)org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845)org.apache.jsp.qinshi_jsp._jspService(qinshi_jsp.java:116)org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)javax.servlet.http.HttpServlet.service(HttpServlet.java:727)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)javax.servlet.http.HttpServlet.service(HttpServlet.java:727)org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause
java.lang.ClassNotFoundException: com.mysql.jdbc.Driverorg.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720)org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571)org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:126)org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63)java.lang.Class.forName0(Native Method)java.lang.Class.forName(Class.java:264)org.apache.jsp.qinshi_jsp._jspService(qinshi_jsp.java:85)org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)javax.servlet.http.HttpServlet.service(HttpServlet.java:727)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)javax.servlet.http.HttpServlet.service(HttpServlet.java:727)org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.56 logs.
这是报错500
扫二维码下载贴吧客户端
下载贴吧APP
看高清直播、视频！
看高清直播、视频！
贴吧热议榜
- 1Xun离开blg算不算双输2834640
- 2小米su7断轴事件迎来大结局2690910
- 3吴敬平炮轰WTT力挺樊振东陈梦1905204
- 4饺子成为内地票房最高的导演1419282
- 5浅谈中配争议乱像1414712
- 6原来补牙会导致怀孕1286100
- 7哪吒2票房赶超复仇者联盟988752
- 8cb选手赛场刻字整活被扣工资913882
- 9为啥不直接把原作给日本做动画721534
- 10情人节垃圾桶寻宝经验655998
