1、pom.xml

       
     
      org.springframework.boot
        
     
      spring-boot-starter-jdbc
     
    
       
     
      mysql
        
     
      mysql-connector-java
        
     
      8.0.13
     
    

2、application.properties

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driverspring.datasource.url=jdbc:mysql://10.24.73.247:5002/waimai?characterEncoding=utf8spring.datasource.username=spring.datasource.password=

3、JdbcTemplate

@RestControllerpublic class DBController {    @Autowired    private JdbcTemplate jdbcTemplate;    @GetMapping("/query")    public Object load() {        String sql = "select * from wm_act_poi_v2 where wm_poi_id = 515";        List