spring jdbc test

 

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

 

JdbcTemplate jdbcTemplate;
List<Map<String, Object>> list = jdbcTemplate.queryForList(sql);

 

 

#########################