SpringBoot整合JDBC

SpringBoot整合JDBC

1、新建一个 jdbccontroller.java

@RestController
public class JDBCController {

    @Autowired
    JdbcTemplate jdbcTemplate;

    //查询数据库的所有信息
    //没有实体类，数据库中的东西，怎么获取？ Map
    @GetMapping("/userList")
    public List<Map<String,Object>> userList(){
        String sql="select * from user";
        return jdbcTemplate.queryForList(sql);
    }

    @GetMapping("/add")
    public ModelAndView addUser(){
        String sql="insert into mybatis.user(id, name, pwd) VALUE (10,'malongfei','123456')";
        jdbcTemplate.update(sql);
        System.out.println("添加成功！");
        return new ModelAndView("redirect:/userList");
    }

    @GetMapping("/update/{id}")
    public ModelAndView updateUser(@PathVariable("id") int id){
        String sql="update mybatis.user set name=?,pwd=? where id="+id;
        Object[] obj= new Object[]{"小米米","fdhsajkhfd"};
        jdbcTemplate.update(sql, obj);
        System.out.println("更新成功！");
        return new ModelAndView("redirect:/userList");
    }

    @GetMapping("/delete/{id}")
    public ModelAndView deleteUser(@PathVariable("id") int id){
        String sql="delete from user where id=?";
        jdbcTemplate.update(sql, id);
        System.out.println("刪除成功！");
        return new ModelAndView("redirect:/userList");
    }
}

分别实现了增删改查！

2、数据库如：

3、application.yml配置文件：

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUncode=true&characterEncoding=utf-8
    driver-class-name: com.mysql.cj.jdbc.Driver