jdbc.properties文件中的配置需要加上" jdbc."的前綴
在配置數據庫連接信息(jdbc.properties文件)時跟著老師的編碼走的,如下:
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/seckill?useUnicode=true&characterEncoding=utf8
username=root
password=464648
但是居然報錯了:
### Error querying database. ?Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root '@'localhost' (using password: YES))
### The error may exist in mapper/CustomerMapper.xml
### The error may involve com.zhexiang.mybatis_springmvc.model.selectCustomerByID
### The error occurred while executing a query
后來百度了一下,在以上的配置中需要寫成如下形式,有哪位同學知道具體原因么?
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/seckill?useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=
2017-06-12
-jdbc.properties 里面 username 必須用 jdbc.username. 否則username就變成了系統管理員的名字。
2017-06-12
好的,謝謝。