后台订单页面不显示

毛血旺战士

3 回复19 浏览

来自课程:蛋糕店(Jsp、Servlet网上商城)

报错是这样的:

java.sql.SQLException: Table 'cakeshop.users' doesn't exist Query: SELECT o.id,o.total,o.amount,o.status,o.paytype,o.name,o.phone,o.address,o.datetime,u.username FROM `order` o,users u WHERE o.user_id = u.id ORDER BY datetime DESC LIMIT ?,?; Parameters: [0, 10]
    at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:527)
    at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:391)
    at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:329)
    at com.shop.dao.OrderDao.selectOrderList(OrderDao.java:75)
    at com.shop.service.OrderService.getOrderPage(OrderService.java:75)
    at com.shop.servlet.AdminOrderListServlet.doGet(AdminOrderListServlet.java:32)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at com.shop.filter.AdminFilter.doFilter(AdminFilter.java:32)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at com.shop.filter.EncodeFilter.doFilter(EncodeFilter.java:21)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
 

全部回复(3)

  • 老师_J 1 楼

     毛血旺战士 同学你好,我是J老师。一般咱们碰到这种问题可以看报错的提示,这个报错为SqlException。说明是跟sql有关系,而后面又详细的提示了是使用的查询两张关联表order,users,最后报错的原因为Table 'cakeshop.users' doesn't exist,这句话的意思为cakeshop.users不存在,那么我们可以大概率判断一下,我们的数据库中是否存在这张表,如果存在的话,是不是因为权限问题而没有读到这张表。所以同学,首先你登录一下数据库查看一下这张表是否跟我们提示的这张表保持一致,如果不一致,那改成一致即可。若一致,还是报这个错,那咱们再进一步排查。

  • 毛血旺战士 楼主 2 楼

    @老师_J 谢谢老师已经解决了

  • 老师_J 3 楼

发表回复

登录后可以回复