SpringBoot整合JDBC
1、新建一个 jdbccontroller.java
@RestController
public class JDBCController {
@Autowired
JdbcTemplate jdbcTemplate;
//查询数据库的所有信息
//没有实体类，数据库中的东西，怎么获取？ Map
@GetMapping("/userList")
public List> 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
Original: https://www.cnblogs.com/malongfeistudy/p/16052745.html
Author: 有点小白的菜鸟
Title: SpringBoot整合JDBC
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/580511/
转载文章受原作者版权保护。转载请注明原作者出处！