【配置】SpringBoot2.3.0配置JdbcTemplate

前言：

• SpringBoot版本：2.3.0
• MySQL版本：8.0.18

---

依赖

• MySQL驱动和JDBC

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

application.yml配置

• 到这步就完成了，剩下的SpringBoot会自动配置JdbcTemplate

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/spring_boot?serverTimezone=GMT%2B8
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

Java

• POJO

  @Data
  public class User {
  
      private Integer id;
      private String username;
      private String password;
  
  }
  

• 引入

   @Autowired
   private JdbcTemplate jdbcTemplate;
  

• 测试

  @SpringBootTest
  class DataApplicationTests {
  
      @Autowired
      private JdbcTemplate jdbcTemplate;
  
      @Test
      void contextLoads() {
          String sql = "SELECT * FROM jdbc_test WHERE id = ?";
          User user = jdbcTemplate.queryForObject(sql,new BeanPropertyRowMapper<>(User.class),2);
          System.out.println(user);
      }
  
  }
  

• 结果(成功)

  User(id=2, username=spring-boot-jdbc-test2, password=123456)