HTTP Status 500 小白求教

Young9518 2017-12-30 11:03:27

导入了一个工程，可是怎么调试都是500错误，初接触，已晕，求教，谢谢啦
type Exception report

message An exception occurred processing JSP page /ManagementInsertBook.jsp at line 75

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 /ManagementInsertBook.jsp at line 75

72: String Publish=request.getParameter("Publish");
73: if(BookName!=null)
74: {
75: Class.forName("com.mysql.jdbc.Driver");
76: Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/book","root","root");
77: Statement stmt =conn.createStatement();
78: ResultSet rss=stmt.executeQuery("Select BookNO,BookName,Author,Publish from bookdb where BookNO='"+BookNO+"'");

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)

...全文

378 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

Young9518 2017-12-30

打赏
举报

已经解决，发现是我的mysql-connector-xxxx.jar的位置的问题，在Tomcat文件夹lib文件夹下加入.jar重启Tomcat后再运行就解决了问题

Young9518 2017-12-30

打赏
举报

<%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>无标题文档</title> <style type="text/css"> body { text-align: center; } body strong { font-size: 72px; text-align: center; } body { } #f1 { position: absolute; left: 11px; top: 136px; width: 1025px; } #f1 { border: thin solid #03F; } #ff { position: absolute; left: 1082px; top: 136px; width: 241px; height: 157px; text-align: right; } #ff { position: absolute; left: 1082px; top: 136px; width: 241px; height: 157px; text-align: right; } #ff p #bt { background-color: #999; } #bt { position: absolute; top: 179px; right: 84px; } </style> </head> <body> <p><strong>请输入插入的图书信息</strong></p> <hr size="10" noshade="noshade"/> </br> </br> </br> </br> <form method="post"> 输入书号：<input type="text" name="BookNO"><br> 输入书名：<input type="text" name="BookName"><br> 输入作者：<input type="text" name="Author"><br> 出版社为：<input type="text" name="Publish"><br> <input type="submit" value="添加"> </form> <% String BookNO=request.getParameter("BookNO"); String BookName=request.getParameter("BookName"); String Author=request.getParameter("Author"); String Publish=request.getParameter("Publish"); if(BookName!=null) { Class.forName("com.mysql.jdbc.Driver"); Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/book","root","root"); Statement stmt =conn.createStatement(); ResultSet rss=stmt.executeQuery("Select BookNO,BookName,Author,Publish from bookdb where BookNO='"+BookNO+"'"); if(!(rss.next())) { PreparedStatement ps=null; String sql="INSERT INTO bookdb(BookNO,BookName,Author,Publish) VALUES(?,?,?,?)"; ps=conn.prepareStatement(sql); ps.setString(1,BookNO); ps.setString(2,BookName); ps.setString(3,Author); ps.setString(4,Publish); ps.executeUpdate(); out.println("插入成功"); ps.close(); conn.close(); } else { out.println("图书编号不能重复"); } } %> <form name="reg" action="/Library/ManagementLibraryShowDAO.jsp" method="post"> <p> <input name="ffff2" type="submit" id="bt" value="返回书库"/> </p> </form> </body> </html>