数据库链接问题

[sevenHsu]

您好，首先非常感谢您的作品。在使用你的作品项目的时候，应该如何让数据库工作起来呢

[withstars]

1.启动数据库服务，导入项目根目录下library.sql文件，数据库创建完成。 2.修改src/main/resources/book-context.xml文件里的数据源配置。

[sevenHsu]

谢谢，问题解决了

Sent from my iPhone

On Apr 8, 2018, at 10:54, withstars [email protected] wrote:

1.启动数据库服务，导入项目根目录下library.sql文件，数据库创建完成。 2.修改src/main/resources/book-context.xml文件里的数据源配置。

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

[woodens]

数据库修改后登录还是会出现空指针的问题，不论是放到tomcat还是jetty启动 都会出现问题 <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" p:driverClassName="com.mysql.jdbc.Driver" p:url="jdbc:mysql://localhost:3306/library" p:username="root" p:password="root"/>

[ERROR] Nested in org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.): java.lang.NullPointerException at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding (ConnectionImpl.java:3303) at com.mysql.jdbc.MysqlIO.sendConnectionAttributes (MysqlIO.java:1987) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication (MysqlIO.java:1913) at com.mysql.jdbc.MysqlIO.doHandshake (MysqlIO.java:1290) at com.mysql.jdbc.ConnectionImpl.coreConnect (ConnectionImpl.java:2502) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly (ConnectionImpl.java:2535) at com.mysql.jdbc.ConnectionImpl.createNewIO (ConnectionImpl.java:2320) at com.mysql.jdbc.ConnectionImpl. (ConnectionImpl.java:834) at com.mysql.jdbc.JDBC4Connection. (JDBC4Connection.java:46) 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:411) at com.mysql.jdbc.ConnectionImpl.getInstance (ConnectionImpl.java:416) at com.mysql.jdbc.NonRegisteringDriver.connect (NonRegisteringDriver.java:347) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection (DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject (PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory (BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory (BasicDataSource.java:1545) at org.apache.commons.dbcp.BasicDataSource.createDataSource (BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection (BasicDataSource.java:1044) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection (DataSourceUtils.java:111) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection (DataSourceUtils.java:77) at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:615) at org.springframework.jdbc.core.JdbcTemplate.query (JdbcTemplate.java:680) at org.springframework.jdbc.core.JdbcTemplate.query (JdbcTemplate.java:712) at org.springframework.jdbc.core.JdbcTemplate.query (JdbcTemplate.java:722) at org.springframework.jdbc.core.JdbcTemplate.queryForObject (JdbcTemplate.java:790) at org.springframework.jdbc.core.JdbcTemplate.queryForObject (JdbcTemplate.java:809) at com.book.dao.ReaderCardDao.getMatchCount (ReaderCardDao.java:27) at com.book.service.LoginService.hasMatchReader (LoginService.java:33)

[cry2275]

1.启动数据库服务，导入项目根目录下library.sql文件，数据库创建完成。 2.修改src/main/resources/book-context.xml文件里的数据源配置。

请问下这个文件里要具体改哪些内容呢？？

[liuchongwei]

1.启动数据库服务，导入项目根目录下library.sql文件，数据库创建完成。 2.修改src/main/resources/book-context.xml文件里的数据源配置。

请问下这个文件里要具体改哪些内容呢？？

请问你的程序跑起来了么？