Spring Boot整合Mybatis对数据库实现增查删改（三）

Spring Boot整合Mybatis对数据库实现增查删改（三）

接着上一节的内容继续整理，这一节将会实现对数据库增查删改的操作，话不多说，直接开干！！！

首先是UserMapper里面的内容

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.example.demo.mapper.UserMapper">

    <resultMap id="BaseResultMap" type="com.example.demo.entity.User">
        <result column="id" jdbcType="INTEGER" property="id" />
        <result column="name" jdbcType="VARCHAR" property="name" />
        <result column="age" jdbcType="VARCHAR" property="age" />
    </resultMap>


    <!--查找所有数据-->
    <select id="findAllTheData" resultMap="BaseResultMap">
        select * from ser
    </select>
    <!--根据id查找数据-->
    <select id="findUserByName" resultMap="BaseResultMap" parameterType="com.example.demo.entity.User">
        select * from ser where id = #{id}
    </select>
    <!--添加数据-->
    <insert id="insert" parameterType="com.example.demo.entity.User">
        insert into ser (name,age) value (#{name},#{age})
    </insert>
    <!--删除数据-->
    <delete id="delete" parameterType="int">
        delete from ser where id = #{id}
    </delete>

    <!--修改数据-->
    <update id="upDate"  parameterType="com.example.demo.entity.User">
        update ser
        set
        ser.name=#{name},
        ser.age=#{age}
        where ser.id=#{id}
    </update>

</mapper>

UserController.java

package com.example.demo.controller;


import com.example.demo.entity.User;
import com.example.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@RequestMapping("/test")
public class UserController {

    @Autowired
    private UserService userService;

    //查找所有数据
    @RequestMapping("All")
    @ResponseBody
    public List<User> findAllTheData(){
        return userService.findAllTheData();
    }

    //根据id查找数据
    @RequestMapping("findUserByName/{id}")
    @ResponseBody
    public User findUserByName(@PathVariable int id){
        return userService.findUserByName(id);
    }

    //增加数据
    @RequestMapping(value = "/insert",method = RequestMethod.POST)
    public User insert(User user){
        return userService.insert(user);
    }

    //删除数据
    @RequestMapping(value = "delete/{id}",method = RequestMethod.GET)
    public String delete(@PathVariable int id){
        int result = userService.delete(id);
        if(result>=1){
            return "删除成功";
        }else {
            return "删除失败";
        }
    }

    //修改数据
    @RequestMapping(value = "/upDate",method = RequestMethod.POST)
    public String upDate(User user){
        int result2 = userService.upDate(user);
        if (result2>=1){
            return "修改成功";
        }else {
            return "修改失败";
        }
    }
}

实体类User.java 这里面没有改动

package com.example.demo.entity;


import javax.persistence.*;

@Table(name="stu")
@Entity
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    @Column
    private String name;
    @Column
    private int age;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }
}

UserMapper.java

package com.example.demo.mapper;

import com.example.demo.entity.User;

import java.util.List;

public interface UserMapper {

    List<User> findUserByName(int id);
    void insert(User user);
    int delete(int id);
    List<User> findAllTheData();
    int upDate(User user);
}

UserServiceImpl.java

package com.example.demo.service.impl;

import com.example.demo.entity.User;
import com.example.demo.mapper.UserMapper;
import com.example.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;


@Service
public class  UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;

    @Override
    public List<User> findAllTheData(){
        return userMapper.findAllTheData();
    }
    @Override
    public User findUserByName(int id) {
        return userMapper.findUserByName(id).size() <= 0 ? null : userMapper.findUserByName(id).get(0);
    }
    @Override
    public User insert(User user){
        userMapper.insert(user);
        return user;
    }
    @Override
    public int delete(int id){
        return userMapper.delete(id);
    }
    @Override
    public int upDate(User user){
        return userMapper.upDate(user);
    }
}

UserService.java

package com.example.demo.service;

import com.example.demo.entity.User;

import java.util.List;

public interface UserService {
    User findUserByName(int id);
    User insert(User user);
    int delete(int id);
    List<User> findAllTheData();
    int upDate(User user);
}

接下来，我们用一个工具postman来测试一下

查询所有数据http://localhost:8080/test/All

根据id查找数据http://localhost:8080/test/findUserByName/1

增加数据http://localhost:8080/test/insert?age=21&name=张三

删除数据http://localhost:8080/test/delete/1（这里注意类型修改为GET）

修改数据http://localhost:8080/test/upDate?id=2&name=赵四

以上就是spring boot整合mybatis对数据库单表实现的增查删改操作，大家有什么问题和疑问都可以在下方留言交流，谢谢大家的支持，让我们一起共同学习，共同进步，加油！！！