SpringBoot整合--JDCB(Mysql)

SpringBoot整合--JDCB(Mysql) 1.导入依赖

    
    
        org.springframework.boot
        spring-boot-starter-jdbc
    
    
    
        mysql
        mysql-connector-java
        runtime
    
    
    
        org.projectlombok
        lombok
        true
    
    
    
        org.springframework.boot
        spring-boot-starter-test
        test
    

---

2.编写yaml配置文件连接数据库

spring:
  datasource:
    #?serverTimezone=UTC解决时区的报错
    url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
    username: root
    password: 123
    driver-class-name: com.mysql.cj.jdbc.Driver
    hikari:
      auto-commit: false

---

3.测试

@SpringBootTest
class SpringBootDemo02JdbcApplicationTests {

    @Autowired
    DataSource dataSource;

    @Test
    void contextLoads() throws Exception{
        //默认数据源：class com.zaxxer.hikari.HikariDataSource
        System.out.println(dataSource.getClass());
        //获取数据库连接
        Connection connection = dataSource.getConnection();
        //是否自动提交事务
        boolean autoCommit = connection.getAutoCommit();
        System.out.println(autoCommit);
        connection.commit();
    }

}

---