codingxiaxw / customermanagement Goto Github PK

slight bugs, classes relation not working properly

新手很抓狂呀

29-Sep-2017 11:38:30.215 WARNING [C3P0PooledConnectionPoolManager[identityToken->8lf1qf9q1kitqc11p55jv7|609fb345]-HelperThread-#1] com.mchange.v2.resourcepool.BasicResourcePool. com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@543ddc65 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775) at com.mysql.jdbc.Connection.<init>(Connection.java:1555) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125) at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44) at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Hello！最近拿你的代码练手。添加客户的时候，连接出现了问题。不知道从何入手解决。
配置都没有任何问题的，因为在的Demo里数据是可以成功插入的，可到了servlet就连接不上了，

我觉得不应该把out放进来，导致整个项目太大了，难以复制。还是说我的理解有问题？

请问你自己写的那个itcast包在哪里可以找到？

群号: 659957958，赶快上车！

编辑后无论男女都显示 女。
可能问题如下：edt.jsp 32行

<input type="radio" name="gender" value="male" id="male" <c:if test="${customer.gender eq 'male'}"/>checked="checked"/>
男
<input type="radio" name="gender" value="female" id="female" <c:if test="${customer.gender eq 'female'}"/> checked="checked"/>
女
改为
<input type="radio" name="gender" value="male" id="male" <c:if test="${customer.gender eq 'male'}">checked="checked"</c:if>/>
男
<input type="radio" name="gender" value="female" id="female" <c:if test="${customer.gender eq 'female'}">checked="checked"</c:if> />
女
后正常，
谷歌浏览器 ，win764位。

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES).....
jdbc连上MySQL了，应该不是MySQL和root密码的问题

包管理工具用的是什么？我导入maven导入不成功

感谢您的分享，我才刚开始接触servlet，关于您将servlet的转发、重定向及方法进行封装这里，我源代码看的不是很清晰，是在BaseServlet将servlet的转发、重定向及方法进行封装的么？是否是根据jsp的名字来跳转到子类servlet的相应方法，但是这里子类servlet的方法都报黄色警告说没有被用到，所以提交表单的操作会抛出异常，因为我刚接触并且我也是用的mac+IDEA开发，一些配置我都还没有弄懂。所以还希望能够指正一些我的错误，谢谢。

而且我在添加用户的时候，添加后的用户id会是一大串英文

c3p0-config.xml 文件要做下面的修改（因为版本的问题）
jdbc:mysql://localhost:3306/customer?serverTimezone=UTC
com.mysql.cj.jdbc.Driver
然后修改自己的密码就可以了