错误500 不知道代码哪里出错了求大神解答

qq_33504179 2015-12-28 01:04:09

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>

<html>
<head>
<title>在线购物</title>
</head>
<%
//装载MySQL5.5的JDBC驱动
Class.forName("com.mysql.jdbc.Driver").newInstance();
//建立数据库连接
String url ="jdbc:mysql://localhost:3306/eshop?user=root&password=123&useUnicode=true&characterEncoding=gb2312";
Connection conn= DriverManager.getConnection(url);
//建立一个Statement对象，用于执行SQL语句
Statement stat = conn.createStatement();
//执行查询并得到查询结果
String sql = "select * from show";
ResultSet rs = stat.executeQuery(sql);
%>
<body>
<h2>在线购物</h2>
<hr>
<table border="1" width="600">
<tr bgcolor="#dddddd">
<td align="center" width="80">商品缩图</td>
<td align="center">商品摘要</td>
<td align="center" width="100">在线购买</td>
</tr>
<%
String bm,name,price,info,img;
//将查询结果集中的记录输出到页面上
while (rs.next()){
//从当前记录中读取各字段的值
img = rs.getString("SP_PIC").trim();
bm = rs.getString("SP_NO").trim();
name = rs.getString("SP_NAME").trim();
price = rs.getString("SP_PRICE").trim();
info = rs.getString("SP_INFO").trim();

out.println("<tr>");
out.println("<td><img src='"+ img +"' border=0 height=60 width=60></td>");
out.println("<td>");
out.println("商品编号："+ bm +"<br>");
out.println("商品名称："+ name +"<br>");
out.println("商品价格："+ price +"元<br>");
out.println("商品简介："+ info +"<br>");
out.println("</td>");
out.println("<td><a href='buy.jsp?op=add&bm="+bm+"'>放入购物车</a></td>");
out.println("</tr>");
}
%>
</table>
<br>
<a href="cart.jsp">查看购物车</a>
<a href="buy.jsp?op=clear">清空购物车</a>
</body>
</html>
这个是我的页面代码

下面是我出错的页面

org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 13

10: Class.forName("com.mysql.jdbc.Driver").newInstance();
11: //建立数据库连接
12: String url ="jdbc:mysql://localhost:3306/eshop?user=root&password=123&useUnicode=true&characterEncoding=gb2312";
13: Connection conn= DriverManager.getConnection(url);
14: //建立一个Statement对象，用于执行SQL语句
15: Statement stat = conn.createStatement();
16: //执行查询并得到查询结果

求帮助啊。新手小白很多东西不会希望有人可以给我仔细解答

...全文

286 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

老黑牛 2015-12-31

打赏
举报

avax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/eshop? 驱动不正确，是不是没导入connection的jar包

jijiqw 2015-12-28

打赏
举报

avax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/eshop?user=root&password=123&useUnicode=true&characterEncoding=gb2312 没有驱动包，说的很明显啊 No suitable driver found for 你这段代码在servlet里面估计也执行不了。另外，现在还有直接在jsp里面写java代码的工作方式？？？

减肥啊啊啊啊啊 2015-12-28

打赏
举报

你的机器上是否有mysql数据库呢？如果有的话那就是localhost不识别了，请把localhost改127.0.0.1 另外是否有引用mysql的jar包

qq_33504179 2015-12-28

打赏
举报

HTTP Status 500 - An exception occurred processing JSP page /index.jsp at line 13 -------------------------------------------------------------------------------- type Exception report message An exception occurred processing JSP page /index.jsp at line 13 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 /index.jsp at line 13 10: Class.forName("com.mysql.jdbc.Driver").newInstance(); 11: //建立数据库连接 12: String url ="jdbc:mysql://localhost:3306/eshop?user=root&password=123&useUnicode=true&characterEncoding=gb2312"; 13: Connection conn= DriverManager.getConnection(url); 14: //建立一个Statement对象，用于执行SQL语句 15: Statement stat = conn.createStatement(); 16: //执行查询并得到查询结果 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.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/eshop?user=root&password=123&useUnicode=true&characterEncoding=gb2312 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:916) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845) org.apache.jsp.index_jsp._jspService(index_jsp.java:136) 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.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/eshop?user=root&password=123&useUnicode=true&characterEncoding=gb2312 java.sql.DriverManager.getConnection(DriverManager.java:596) java.sql.DriverManager.getConnection(DriverManager.java:233) org.apache.jsp.index_jsp._jspService(index_jsp.java:77) 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. -------------------------------------------------------------------------------- Apache Tomcat/7.0.56 这是完整的报错

laogao598599 2015-12-28