springboot整合JDBC

pom.xml

    org.springframework.boot
    spring-boot-starter-jdbc




    mysql
    mysql-connector-java
    runtime

application.yaml

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    url: jdbc:mysql://127.0.0.1:3306/song?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
    username: root
    password: root

JDBCController

@RestController
public class JDBCController {

    @Autowired
    JdbcTemplate jdbcTemplate;

    // 查询数据库的所有信息
    @GetMapping("/userList")
    public List> userList() {
        String sql = "select * from user";
        List> list_maps = jdbcTemplate.queryForList(sql);

        return list_maps;
    }

    @GetMapping("/addUser")
    public String addUser() {
        String sql = "insert into songyuming.user(id,name,pwd) values (4,'小强','123456')";
        jdbcTemplate.update(sql);
        return "update-ok";
    }

    @GetMapping("/updateUser/{id}")
    public String updateUser(@PathVariable("id") Integer id) {
        String sql = "update songyuming.user set name = ?,pwd=? where id=" + id;
        // 封装
        Object[] params = new Object[2];
        params[0] = "小黄";
        params[1] = "456789";
        jdbcTemplate.update(sql,params);
        return "update-ok";
    }

    @GetMapping("/deleteUser/{id}")
    public String deleteUser(@PathVariable("id") Integer id) {
        String sql = "delete from songyuming.user where id=?";
        jdbcTemplate.update(sql, id);
        return "update-ok";
    }

}