SpringBoot 整合 JDBCtemplate

导入Maven依赖

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency

SpringBoot 配置文件

server:
  port: 8080
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.zaxxer.hikari.HikariDataSource
    username: root
    password: 1234
    url: jdbc:mysql://localhost:3306/love?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false

测试

@RestController
public class login {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    @RequestMapping("/login")
    public String test(){
        jdbcTemplate.update("insert into girl values(?,?,?)",1,"小花","北京");
        return "hello world";
    }
}

启动类

@SpringBootApplication
public class Boot {
    public static void main(String[] args) {
        SpringApplication.run(Boot.class);
    }
}