2-10的视频，验证Controller，在浏览器输url没返回json，而是404

Question

1.网页运行结果

2.controller好像也没写错

3.eclipse的控制台信息

我按照百度搜了博客，但是好像还是没解决，重点是不知道为啥会有这个问题，我好像都照着视频来配置文件了
4.各xml的配置，麻烦老师帮我看看是不是xml的问题
spring-dao.xml


spring-service.xml

spring-web.xml

前面验证dao和验证service的都没问题，就是验证controller这个404。麻烦老师尽快帮我看看，谢谢了~感谢

Answer 1

翔仔 2021-03-05 23:10:29

同学好，404主要就是找不到路由的问题，这里我看你spring-web.xml里面的配置controller所在的package是com.jq.web 这个错误很明显呀，我看类的截图应该是com.jq.o2o.web吧。。然后你的工程名字叫做o2o吗，如果不是的话url需要调整呢

• 提问者 慕仔4580619 #1

  老师，其实我是有发现这个问题，然后也改过，也update重启服务器，再在浏览器上试过，但是好像报错更多。放不了图片，我只能放一部分错
  具体如下：23:31:55.117 [C3P0PooledConnectionPoolManager[identityToken->2t282tagu4ec2e458gx|21114992]-HelperThread-#2] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - An exception occurred while acquiring a poolable resource. Will retry.
  com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  
  The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
  	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  	at java.lang.reflect.Constructor.newInstance(Unknown Source)
  	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
  	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:342)

• 提问者 慕仔4580619 #2

  上一条回复是黑色的报错，这里还有红色的
  Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
  ### The error may exist in file [C:\Users\JQ\eclipse-workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\o2o\WEB-INF\classes\mapper\AreaDao.xml]
  ### The error may involve com.jq.o2o.dao.AreaDao.queryArea
  ### The error occurred while executing a query
  ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
  	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
  	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
  	at com.sun.proxy.$Proxy17.selectList(Unknown Source)
  	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)

• 提问者 慕仔4580619 #3

  老师可以帮忙看看，很需要您的帮助，谢谢

点开查看后面1条评论