Springboot配置JDBC Template

1在pom.xml中添加一下依赖

<!-- HikariCP数据源依赖 -->
<dependency>
   <groupId>com.zaxxer</groupId>
   <artifactId>HikariCP</artifactId>
   <version>2.6.1</version>
</dependency>
<!-- mysql驱动依赖 -->
<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
</dependency>

2.application.properties中添加一下配置

# mysql驱动
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
# 数据库url地址
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/dbgirl
# 用户名
spring.datasource.username=root
# 密码

spring.datasource.password=123456

3.创建dataSource的数据源类

@Configuration
public class DataSourceConfig {

    @Bean(name="dataSource")
    public DataSource dataSource(Environment env){
        HikariDataSource ds = new HikariDataSource();
        ds.setJdbcUrl(env.getProperty("spring.datasource.url"));
        ds.setUsername(env.getProperty("spring.datasource.username"));
        ds.setPassword(env.getProperty("spring.datasource.password"));
        ds.setDriverClassName(env.getProperty("spring.datasource.driver-class-name"));
        return ds;
    }
}