第三章 SpringBoot 整合JDBC

一、引入jdbc启动器和mysql驱动

<dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>8.0.25</version>
</dependency>

二 通用配置

spring.profiles.active=uat
spring.datasource.username=root
spring.datasource.password=12345678
#mysql8的驱动包
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/nacos?serverTimeZone=UTC&useUnicode=true&characterEncoding=utf8

三 测试

如果只是导入了mysql驱动和jdbc依赖 并且只做了通用配置 那么默认会使用HikariDataSource来操作数据库

//数据库实体
@Data
public class ConfigInfo implements Serializable {
    private static final long serialVersionUID = 6337622087324151434L;
    private Long id;
    private String dataId;
    private String groupId;
    private String content;
    private String md5;
    private Date gmtCreate;
    private Date gmtModified;
    private String srcUser;
    private String srcIp;
    private String appName;
    private String tenantId;
}

//测试类
@RestController
public class JdbcController {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @RequestMapping(path = "/test/jdbc", method = RequestMethod.GET)
    public List<ConfigInfo> testJdbc() {
        String sql = "select * from config_info";
        List<ConfigInfo> list = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(ConfigInfo.class));
        return list;
    }
}