JDBC连接MYSQL老是报错

[满地韶华]

package com.shake.database.dao;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Connection;
public class DataSource {

private static String driver = "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql://localhost:3306/shake";
private static String userName = "root";
private static String passWord = "123456"; //密码
/**
* 获得数据库连接
*/
//这里获取数据库的链接
public static Connection getConnection(){
//加载驱动
try{
Class.forName(driver);
//打开并返回数据库连接
Connection connection = DriverManager.getConnection(url,userName,passWord);
return connection;
}catch(ClassNotFoundException e)
{
e.printStackTrace();
}catch(SQLException e)
{
e.printStackTrace();
}

return null;
}

}


这是报错
java.sql.SQLException
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:254)
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:699)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:631)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:485)
at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:143)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
at com.shake.database.dao.UserDao.queryUserList(UserDao.java:23)
at com.shake.servlet.UserServlet.userIsExist(UserServlet.java:56)
at com.shake.servlet.UserServlet.doPost(UserServlet.java:42)
at com.shake.servlet.UserServlet.doGet(UserServlet.java:31)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:246)
... 30 more



求帮助

[满地韶华]

自动import的包有问题 结贴

[姜小白-]

你是想通过jdbc 的方式获取数据库连接池吗？

代码看不出问题，写一个main方法测试一下getConnection方法，打断点
在 Connection connection = DriverManager.getConnection(url,userName,passWord); 跟一下
看这一行执行的过程中，各个参数情况，看connection 能否得到结果值

如果想配置数据库连接池的话，可以在tomcat里面直接配置，不要用jdbc的方式去获取，参考 http://blog.csdn.net/magi1201/article/details/38237707

[满地韶华]

引用 1 楼 magi1201 的回复:

你是想通过jdbc 的方式获取数据库连接池吗？ 代码看不出问题，写一个main方法测试一下getConnection方法，打断点 在 Connection connection = DriverManager.getConnection(url,userName,passWord); 跟一下 看这一行执行的过程中，各个参数情况，看connection 能否得到结果值 如果想配置数据库连接池的话，可以在tomcat里面直接配置，不要用jdbc的方式去获取，参考 http://blog.csdn.net/magi1201/article/details/38237707

主要是写了main方法就可以的 但是原来这样就不行