db.properties文件中:key前面加上前缀吗,有前缀的情况下能访问数据库查询到信息。
但是把前缀取消了就查询不到了,application.xml文件里面有获取db.properties的key,而且能点过去。
不加前缀配置::
db.properties文件配置:
url=jdbc:mysql://localhost:3306/school?characterEncoding=utf8&useUnicode=true&serverTimezone=GMT
driver=com.mysql.cj.jdbc.Driver
username=root
password=5201314
application.xml文件配置:
<!--加载数据源-->
<context:property-placeholder location="classpath*:db.properties"/>
<!--启用druid数据库连接池并注入数据-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
<property name="driverClassName" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
<property name="initialSize" value="1"/>
<property name="maxActive" value="100"/>
<property name="minIdle" value="1"/>
<property name="maxWait" value="10000"/>
</bean>
以上配置会报错:按住Ctrl也能跳转过去
错误信息:
Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Access denied for user '54436'@'localhost' (using password: YES),
加前缀配置:::
db.properties配置文件
jdbc.url=jdbc:mysql://localhost:3306/school?characterEncoding=utf8&useUnicode=true&serverTimezone=GMT
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.username=root
jdbc.password=5201314
applicaltion.xml配置如下:
<!--加载数据源-->
<context:property-placeholder location="classpath*:db.properties"/>
<!--启用druid数据库连接池并注入数据-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<property name="initialSize" value="1"/>
<property name="maxActive" value="100"/>
<property name="minIdle" value="1"/>
<property name="maxWait" value="10000"/>
</bean>
加了前缀的就能查到信息,没加前缀的就报错,是我哪里没写对吗?