Spring学习-07 Spring+SpringMVC+Druid+jdbcTemplate(注解方式)
注意: 是在05(Spring+SpringMVC)完成后的的基础上操作,
07.01 导入依赖(pom.xml
)
- mysql数据库依赖
- jdbctTemplate依赖
- druid依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
</dependency>
07.02 增加数据库配置文件(jdbc.properties
)
# JDBC
# MySQL 8.x: com.mysql.cj.jdbc.Driver
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.connectionURL=jdbc:mysql://127.0.0.1:3306/2019springtest?useUnicode=true&characterEncoding=utf-8&useSSL=false
jdbc.username=root
jdbc.password=root
# JDBC Pool
jdbc.pool.init=1
jdbc.pool.minIdle=3
jdbc.pool.maxActive=20
# JDBC Test
jdbc.testSql=SELECT 'x' FROM DUAL
07.03 druid配置文件(DruidDatasourceConfig.java
)
- 配置datasource
- 数据源配置
com.alibaba.druid.pool.DruidDataSource
- 配置监控统计拦截的filters,不写的话无法监控sql执行
- 数据源配置
- 配置jdbcTemplate
@Configuration //表示配置文件类
@PropertySource(value = {
"classpath:jdbc.properties",},ignoreResourceNotFound=true) //添加配置文件
public class DruidDatasourceConfig {
// 参考链接 https://github.com/alibaba/druid/wiki/DruidDataSource%E9%85%8D%E7%BD%AE
@Value("${jdbc.driverClass}")
private String jdbc_driverClassName ;