在整合Spring 和mybatis 时,配置数据源时
properties属性文件上要加前缀,避免直接读取系统属性,否则会出:
access denied for user '17738'@'localhost' (using password: YES)
异常
jdbc.driverClassName=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm?serverTimezone=UTC&characterEncoding=utf-8&Unicode=true&useSSL=false
jdbc.username=root
jdbc.password=1208
jdbc.initialSize=5
jdbc.maxActive=10
jdbc.maxWait=3000
<!-- 数据源-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="initialSize" value="${jdbc.initialSize}"/>
<property name="maxActive" value="${jdbc.maxActive}"/>
<property name="maxWait" value="${jdbc.maxWait}"/>
</bean>