谢了一个用c3p0从数据库中查出所有商品信息的小例子，报了一堆异常。用的idea，求大佬帮看看主要原因。

servlet查找之后跳转到jsp页面显示，jsp页面中只有表头显示。遍历的list为空。

/Users/liweikang/Documents/apache-tomcat-9.0.8/bin/catalina.sh run

[2018-06-11 08:36:44,537] Artifact curd:war exploded: Waiting for server connection to start artifact deployment...
11-Jun-2018 20:36:46.495 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/9.0.8
11-Jun-2018 20:36:46.507 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Apr 27 2018 19:32:00 UTC
11-Jun-2018 20:36:46.507 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         9.0.8.0
11-Jun-2018 20:36:46.507 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Mac OS X
11-Jun-2018 20:36:46.508 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            10.13.5
11-Jun-2018 20:36:46.508 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          x86_64
11-Jun-2018 20:36:46.509 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /Library/Java/JavaVirtualMachines/jdk1.8.0_171.jdk/Contents/Home/jre
11-Jun-2018 20:36:46.509 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_171-b11
11-Jun-2018 20:36:46.509 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
11-Jun-2018 20:36:46.509 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /Users/liweikang/Library/Caches/IntelliJIdea2018.1/tomcat/Unnamed_curd
11-Jun-2018 20:36:46.510 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /Users/liweikang/Documents/apache-tomcat-9.0.8
11-Jun-2018 20:36:46.511 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/Users/liweikang/Library/Caches/IntelliJIdea2018.1/tomcat/Unnamed_curd/conf/logging.properties
11-Jun-2018 20:36:46.512 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
11-Jun-2018 20:36:46.512 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote=
11-Jun-2018 20:36:46.514 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.port=1099
11-Jun-2018 20:36:46.514 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.ssl=false
11-Jun-2018 20:36:46.515 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.authenticate=false
11-Jun-2018 20:36:46.515 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.rmi.server.hostname=127.0.0.1
11-Jun-2018 20:36:46.516 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
11-Jun-2018 20:36:46.516 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
11-Jun-2018 20:36:46.517 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
11-Jun-2018 20:36:46.517 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
11-Jun-2018 20:36:46.517 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/Users/liweikang/Library/Caches/IntelliJIdea2018.1/tomcat/Unnamed_curd
11-Jun-2018 20:36:46.518 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/Users/liweikang/Documents/apache-tomcat-9.0.8
11-Jun-2018 20:36:46.518 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/Users/liweikang/Documents/apache-tomcat-9.0.8/temp
11-Jun-2018 20:36:46.518 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/Users/liweikang/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:.]
11-Jun-2018 20:36:46.836 信息 [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
11-Jun-2018 20:36:46.901 信息 [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
11-Jun-2018 20:36:46.919 信息 [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
11-Jun-2018 20:36:46.920 信息 [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
11-Jun-2018 20:36:46.923 信息 [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1246 ms
11-Jun-2018 20:36:47.030 信息 [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
11-Jun-2018 20:36:47.031 信息 [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/9.0.8
11-Jun-2018 20:36:47.045 信息 [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
11-Jun-2018 20:36:47.071 信息 [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
11-Jun-2018 20:36:47.075 信息 [main] org.apache.catalina.startup.Catalina.start Server startup in 152 ms
Connected to server
[2018-06-11 08:36:47,277] Artifact curd:war exploded: Artifact is being deployed, please wait...
11-Jun-2018 20:36:48.306 信息 [RMI TCP Connection(2)-127.0.0.1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
[2018-06-11 08:36:48,407] Artifact curd:war exploded: Artifact is deployed successfully
[2018-06-11 08:36:48,407] Artifact curd:war exploded: Deploy took 1,131 milliseconds
11-Jun-2018 20:36:57.053 信息 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/Users/liweikang/Documents/apache-tomcat-9.0.8/webapps/manager]
11-Jun-2018 20:36:57.102 信息 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/Users/liweikang/Documents/apache-tomcat-9.0.8/webapps/manager] has finished in [48] ms
11-Jun-2018 20:37:14.935 信息 [http-nio-8080-exec-2] com.mchange.v2.log.MLog.<clinit> MLog clients using java 1.4+ standard logging.
11-Jun-2018 20:37:15.002 信息 [http-nio-8080-exec-2] com.mchange.v2.c3p0.C3P0Registry.banner Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
11-Jun-2018 20:37:15.169 信息 [http-nio-8080-exec-2] com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getPoolManager Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 30000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1b612v99v1u9t5yb184l7ko|38f01387, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1b612v99v1u9t5yb184l7ko|38f01387, idleConnectionTestPeriod -> 30, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://127.0.0.1:3306/web14, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 30, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 100, maxStatements -> 200, maxStatementsPerConnection -> 0, minPoolSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
11-Jun-2018 20:37:35.123 警告 [Timer-0] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector.run com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@893a328 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
11-Jun-2018 20:37:35.126 警告 [Timer-0] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector.run com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@893a328 -- APPARENT DEADLOCK!!! Complete Status: 
Managed Threads: 3
Active Threads: 3
Active Tasks: 
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@47695671 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@52762757 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@76e4975f (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
Pending Tasks: 
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2a11b8d3
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2746a93e
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@44e97e1e
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@16e557b3
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@3115b29c
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2308f2d9
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2c9e7128
Pool thread stack traces:
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)