SpringBoot2.2.2 使用 JdbcTemplate

/**
 * @author wf.zhang
 */
@RestController
public class HelloController {
    @Autowired
    JdbcTemplate jdbcTemplate;

    @GetMapping("/query")
    public Map<String, Object> map() {
        List<Map<String, Object>> list = jdbcTemplate.queryForList("select * from user ");
        return list.get(0);
    }
}

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/jdbc?useSSL=true&serverTimezone=UTC&characterEncoding=UTF8
    data-username: root
    data-password: root
    #initialization-mode: always
    #schema=classpath: schema.sql
    #schema=classpath: user.sql
    #data=classpath: data.sql

/**
 * @author wf.zhang
 */
@RestController
public class HelloController {
    @Autowired
    JdbcTemplate jdbcTemplate;

    @GetMapping("/query")
    public  List<Map<String, Object>> list() {
        List<Map<String, Object>> list = jdbcTemplate.queryForList("select * from user ");
        return list;
    }
}