springboot项目+mysql 实现对表的增删改查(入门)_springboot 创建项目实现mysql数据表user的增删改查

1.前言

新手上路，通过相关要求简单的对mysql数据库进行增删改查操作，废话不多说，直接来代码

2.配置类文件

pom.xml: 

<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
         <dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>8.0.33</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
</dependencies>

application.yml(创建，或者直接改后缀)：

server:
  port: 3308
 
spring:
  datasource:
    url: jdbc:mysql://本地ip:3306/userbase
    username: root
    password: 1234

3.创建实体类

 
 
 
public class User {
    private int userid;
    private String username;
    private String gender;
    private int age;
 
 
    public User() {
 
    }
 
    public User(int userid, String username, String gender, int age) {
        this.userid = userid;
        this.username = username;
        this.gender = gender;
        this.age = age;
    }
 
    /**
     * 获取
     *
     * @return id
     */
    public int getUserid() {
        return userid;
    }
 
    /**
     * 设置
     *
     * @param id
     */
    public void setId(int id) {
        this.userid = id;
    }
 
    /**
     * 获取
     *
     * @return username
     */
    public String getUsername() {
        return username;
    }
 
    /**
     * 设置
     *
     * @param username
     */
    public void setUsername(String username) {
        this.username = username;
    }
 
    /**
     * 获取
     *
     * @return gender
     */
    public String getGender() {
        return gender;
    }
 
    /**
     * 设置
     *
     * @param gender
     */
    public void setGender(String gender) {
        this.gender = gender;
    }
 
    /**
     * 获取
     *
     * @return age
     */
    public int getAge() {
        return age;
    }
 
    /**
     * 设置
     *
     * @param age
     */
    public void setAge(int age) {
        this.age = age;
    }
 
    public String toString() {
        return "User{id = " + userid + ", username = " + username + ", gender = " + gender + ", age = " + age + "}";
    }
 
   
 
}

4.Controller类

 
@RestController
public class UserController {
    @Autowired
    private JdbcTemplate jdbcTemplate;
 
    @GetMapping("/getusers")
    public List<Map<String, Object>> getUsers() {
        String sql = "select * from userbase.memberlist";
        return jdbcTemplate.queryForList(sql);
    }
 
    @GetMapping("/getuser")
    public List<Map<String, Object>> getUser(@RequestParam("id1") int id1, @RequestParam("id2") int id2) {
        String sql = "select * from userbase.memberlist where id=? or id=?";
        return jdbcTemplate.queryForList(sql, id1, id2);
    }
 
    @PostMapping("/adduser")
    public String addUser(@RequestBody User user) {
        String sql = String.format("insert into userbase.memberlist(id,zonecode,name,nickname,age,gender,memo) values(%d,%d,'%s','%s',%d,'%s','%s')",
                user.getId(), user.getZonecode(), user.getName(), user.getNickname(), user.getAge(), user.getGender(), user.getMemo());
        jdbcTemplate.execute(sql);
        return "数据添加成功！";
    }
 
 
    @PutMapping("/updateuser")
    public String updateUser(@RequestBody User user) {
        String sql = String.format("update userbase.memberlist set zonecode=%d,name='%s',nickname='%s',age=%d,gender='%s',memo='%s' where id=%d",
                user.getZonecode(), user.getName(), user.getNickname(), user.getAge(), user.getGender(), user.getMemo(), user.getId());
        jdbcTemplate.execute(sql);
        return "数据修改成功！";
    }
 
 
    @DeleteMapping("/deleteuser")
    public String deleteUser(@RequestBody User user) {
        String sql = String.format("delete from userbase.memberlist where id=%d", user.getId());
        jdbcTemplate.execute(sql);
        return "id:" + user.getId() + " 的数据删除成功！";
    }
 
 
}

以上相关注解自行搜索百度

5.调试

下载postman，自行百度

以上为图片，仅供参考，若要进行调试请记得的选择请求方式（GET，POST，PUT，DELETE）

6.结言

根据以上代码就可以 简单的对mysql数据库里的数据库进行操作，如果有疑问的话请在评论区下进行留言，如果觉得对你有帮助，请为这篇文章点个赞，让它能够帮助更多人