首页上一页 1 下一页尾页 6 条记录 1/1页
《JSP项目开发案例全程实录》(第二版)中CD内图书管理信息系统的问题
发表在JavaWeb图书答疑
2012-04-18
是否精华
是
否
版块置顶:
是
否
明日科技你好,我之前买了你们编辑的《JSP项目开发案例全程实录》(第二版)一书来学习JSP项目开发,但在打开你们的第二个开发项目例子图书管理系统时,在数据库连接正常和网页能照常显示系统时,在删除书架功能和添加读者功能那里出现问题。
当删除书架时,页面显示删除失败,同事TOMCAT显示:
bookCase*********************action=bookCaseDel
Unknown column 'bookcase' in 'where clause'
java.sql.SQLException: Operation not allowed after ResultSet closed
at com.mysql.jdbc.ResultSet.checkClosed(ResultSet.java:3599)
at com.mysql.jdbc.ResultSet.next(ResultSet.java:2464)
at com.dao.BookCaseDAO.delete(BookCaseDAO.java:86)
at com.action.BookCase.bookCaseDel(BookCase.java:94)
at com.action.BookCase.execute(BookCase.java:33)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
但我看代码好像没什么问题。而且我没改过代码。
另外当我想添加读者时,页面也显示添加信息失败,请问这是为什么呢?
谢谢!
当删除书架时,页面显示删除失败,同事TOMCAT显示:
bookCase*********************action=bookCaseDel
Unknown column 'bookcase' in 'where clause'
java.sql.SQLException: Operation not allowed after ResultSet closed
at com.mysql.jdbc.ResultSet.checkClosed(ResultSet.java:3599)
at com.mysql.jdbc.ResultSet.next(ResultSet.java:2464)
at com.dao.BookCaseDAO.delete(BookCaseDAO.java:86)
at com.action.BookCase.bookCaseDel(BookCase.java:94)
at com.action.BookCase.execute(BookCase.java:33)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
但我看代码好像没什么问题。而且我没改过代码。
另外当我想添加读者时,页面也显示添加信息失败,请问这是为什么呢?
谢谢!