Java --- springboot2整合数据源的自动配置-HikariDataSource（JDBC）

一、数据源的自动配置-HikariDataSource

导入pom

   <!--jdbc-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jdbc</artifactId>
        </dependency>

导入MySQL的驱动

 数据库版本和驱动版本对应

  <!--mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.49</version>
        </dependency>

修改配置文件 

spring:
  datasource:
    url: jdbc:mysql://localhost:3307/boot2test?useSSL=false
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver

测试代码

@SpringBootTest
@Slf4j
@RunWith(SpringRunner.class)
public class JDBCTest1 {
    @Autowired
    //这里如果jdbcTemplate =null，添加@RunWith(SpringRunner.class)
    JdbcTemplate jdbcTemplate;
    @Test
    public void jdbcTest1(){
//        jdbcTemplate.queryForObject("select * from t_user");
//        jdbcTemplate.queryForList("select * from t_user");
        Long aLong = jdbcTemplate.queryForObject("select count(*) from t_user",Long.class);
        log.info("查询数据为:{}",aLong);
    }
}