哪位大神能帮我解决下这个问题

[libinhong1016]

C:\Java\jdk1.8.0_144\bin\java.exe "-javaagent:F:\idea 2019\IntelliJ IDEA 2018.3.5\lib\idea_rt.jar=57590:F:\idea 2019\IntelliJ IDEA 2018.3.5\bin" -Dfile.encoding=UTF-8 -classpath C:\Java\jdk1.8.0_144\jre\lib\charsets.jar;C:\Java\jdk1.8.0_144\jre\lib\deploy.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\access-bridge-64.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\cldrdata.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\dnsns.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\jaccess.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\jfxrt.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\localedata.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\nashorn.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\sqljdbc41.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\sunec.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\sunjce_provider.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\sunmscapi.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\sunpkcs11.jar;C:\Java\jdk1.8.0_144\jre\lib\ext\zipfs.jar;C:\Java\jdk1.8.0_144\jre\lib\javaws.jar;C:\Java\jdk1.8.0_144\jre\lib\jce.jar;C:\Java\jdk1.8.0_144\jre\lib\jfr.jar;C:\Java\jdk1.8.0_144\jre\lib\jfxswt.jar;C:\Java\jdk1.8.0_144\jre\lib\jsoup-1.11.3.jar;C:\Java\jdk1.8.0_144\jre\lib\jsse.jar;C:\Java\jdk1.8.0_144\jre\lib\lombok-1.18.6.jar;C:\Java\jdk1.8.0_144\jre\lib\management-agent.jar;C:\Java\jdk1.8.0_144\jre\lib\plugin.jar;C:\Java\jdk1.8.0_144\jre\lib\resources.jar;C:\Java\jdk1.8.0_144\jre\lib\rt.jar;C:\Java\jdk1.8.0_144\jre\lib\spring-boot-autoconfigure-2.1.1.RELEASE.jar;F:\周志\n\n\FoursquareSpider\target\classes;C:\Users\LBH\.m2\repository\mysql\mysql-connector-java\5.1.41\mysql-connector-java-5.1.41.jar;C:\Users\LBH\.m2\repository\us\codecraft\webmagic-core\0.7.3\webmagic-core-0.7.3.jar;C:\Users\LBH\.m2\repository\org\apache\httpcomponents\httpclient\4.5.2\httpclient-4.5.2.jar;C:\Users\LBH\.m2\repository\org\apache\httpcomponents\httpcore\4.4.4\httpcore-4.4.4.jar;C:\Users\LBH\.m2\repository\commons-logging\commons-logging\1.2\commons-logging-1.2.jar;C:\Users\LBH\.m2\repository\commons-codec\commons-codec\1.9\commons-codec-1.9.jar;C:\Users\LBH\.m2\repository\org\apache\commons\commons-lang3\3.1\commons-lang3-3.1.jar;C:\Users\LBH\.m2\repository\us\codecraft\xsoup\0.3.1\xsoup-0.3.1.jar;C:\Users\LBH\.m2\repository\org\assertj\assertj-core\1.5.0\assertj-core-1.5.0.jar;C:\Users\LBH\.m2\repository\org\slf4j\slf4j-log4j12\1.7.6\slf4j-log4j12-1.7.6.jar;C:\Users\LBH\.m2\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;C:\Users\LBH\.m2\repository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;C:\Users\LBH\.m2\repository\org\jsoup\jsoup\1.10.3\jsoup-1.10.3.jar;C:\Users\LBH\.m2\repository\commons-io\commons-io\1.3.2\commons-io-1.3.2.jar;C:\Users\LBH\.m2\repository\com\jayway\jsonpath\json-path\2.4.0\json-path-2.4.0.jar;C:\Users\LBH\.m2\repository\net\minidev\json-smart\2.3\json-smart-2.3.jar;C:\Users\LBH\.m2\repository\net\minidev\accessors-smart\1.2\accessors-smart-1.2.jar;C:\Users\LBH\.m2\repository\org\ow2\asm\asm\5.0.4\asm-5.0.4.jar;C:\Users\LBH\.m2\repository\us\codecraft\webmagic-extension\0.7.3\webmagic-extension-0.7.3.jar;C:\Users\LBH\.m2\repository\redis\clients\jedis\2.9.0\jedis-2.9.0.jar;C:\Users\LBH\.m2\repository\org\apache\commons\commons-pool2\2.4.2\commons-pool2-2.4.2.jar;C:\Users\LBH\.m2\repository\com\baomidou\mybatis-plus\2.1-gamma\mybatis-plus-2.1-gamma.jar;C:\Users\LBH\.m2\repository\org\mybatis\mybatis-spring\1.3.1\mybatis-spring-1.3.1.jar;C:\Users\LBH\.m2\repository\org\mybatis\mybatis\3.4.4\mybatis-3.4.4.jar;C:\Users\LBH\.m2\repository\com\github\jsqlparser\jsqlparser\1.0\jsqlparser-1.0.jar;C:\Users\LBH\.m2\repository\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;C:\Users\LBH\.m2\repository\com\alibaba\fastjson\1.2.58\fastjson-1.2.58.jar;C:\Users\LBH\.m2\repository\org\projectlombok\lombok\1.18.6\lombok-1.18.6.jar com.foursquare.modular.MainGetFriendsUrl
爬取开始...
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2115)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2040)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at com.foursquare.modular.dao.MySqlDao.<init>(MySqlDao.java:25)
at com.foursquare.modular.spider.GetFriendsUrlProcessor.spider(GetFriendsUrlProcessor.java:31)
at com.foursquare.modular.MainGetFriendsUrl.main(MainGetFriendsUrl.java:12)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2205)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2056)
... 15 more
Exception in thread "main" java.lang.RuntimeException: java.lang.NullPointerException
at com.foursquare.modular.dao.MySqlDao.selectFromTask(MySqlDao.java:76)
at com.foursquare.modular.spider.GetFriendsUrlProcessor.spider(GetFriendsUrlProcessor.java:31)
at com.foursquare.modular.MainGetFriendsUrl.main(MainGetFriendsUrl.java:12)
Caused by: java.lang.NullPointerException
at com.foursquare.modular.dao.MySqlDao.selectFromTask(MySqlDao.java:64)
... 2 more

Process finished with exit code 1

[libinhong1016]

刚发错了，是这个com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860) at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2115) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2040) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor16.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:270) at com.foursquare.modular.dao.MySqlDao.<init>(MySqlDao.java:25) at com.foursquare.modular.spider.GetUserInfoProcessor.spider(GetUserInfoProcessor.java:47) at com.foursquare.modular.spider.GetUserInfoProcessor.spiderw(GetUserInfoProcessor.java:31) at com.foursquare.modular.MainGetUserInfo.main(MainGetUserInfo.java:12) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections" at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2205) at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2056) ... 15 more java.lang.RuntimeException: java.lang.NullPointerException at com.foursquare.modular.dao.MySqlDao.selectOneFromInfo(MySqlDao.java:113) at com.foursquare.modular.spider.GetUserInfoProcessor.spider(GetUserInfoProcessor.java:47) at com.foursquare.modular.spider.GetUserInfoProcessor.spiderw(GetUserInfoProcessor.java:31) at com.foursquare.modular.MainGetUserInfo.main(MainGetUserInfo.java:12) Caused by: java.lang.NullPointerException at com.foursquare.modular.dao.MySqlDao.selectOneFromInfo(MySqlDao.java:93) ... 3 more

[文弱书生_艾]

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections" 表明数据库连接池满了。减少连接/重启数据库等可以解决