Ruoyi Vue实现单表CURD

1.先在ruoyi的数据库中创建一个表

新建一个user表

同时设置一个deleteUser属性

2.在ruoyi vue中创建并且编写csdm文件

Controller层

package com.ruoyi.web.controller.system;
 
import com.ruoyi.system.domain.User;
import com.ruoyi.system.service.UserService;
import nonapi.io.github.classgraph.json.Id;
import org.apache.ibatis.annotations.Delete;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
 
import java.util.HashMap;
import java.util.List;
 
@RestController
public class HelloController {
    @Autowired
    private UserService userService;
 
    /**
     * 获取表单成员
     * @return
     */
    @GetMapping("/hello")
    public List<User> hello() {
        return userService.selectAllUser();
    }
 
    /**
     * 单个增加表单成员
     * @param user id
     * @return
     */
    @PostMapping("/hello")
    public int insertUser(@RequestBody User user) {
        return userService.insertUser(user);
    }
 
    /**
     * 更新单个表单成员
     * @param user id
     * @return
     */
    @PutMapping("/hello")
    public int updateUser(@RequestBody User user) {
        return userService.updateUser(user);
    }
 
    /**
     * 逻辑删除单个表单成员
     * @param user id
     * @return
     */
    @DeleteMapping("/hello")
    public int deleteUser(@RequestBody User user){
        return userService.deleteUser(user);
    }
}

Service层

package com.ruoyi.system.service;
 
import com.ruoyi.system.domain.User;
import com.ruoyi.system.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import javax.validation.constraints.NotNull;
import java.util.List;
 
@Service
public class UserService {
    @Autowired
    private UserMapper userMapper;
 
    /**
     * 获取表单成员
     * @return
     */
    public List<User> selectAllUser() {
        return userMapper.selectAllUser();
    }
 
    /**
     * 单个增加表单成员
     * @param user id
     * @return
     */
    public int insertUser(User user) {
        return userMapper.insertUser(user);
    }
 
    /**
     * 更新单个表单成员
     * @param user id
     * @return
     */
    public int updateUser(User user) {
        return userMapper.updateUser(user);
    }
 
    /**
     * 逻辑删除单个表单成员
     * @param user id
     * @return
     */
    public int deleteUser(User user){
        return  userMapper.deleteUser(user);
    }
}

Mapper层

package com.ruoyi.system.mapper;
 
import com.ruoyi.system.domain.User;
import org.springframework.stereotype.Repository;
 
import javax.validation.constraints.NotNull;
import java.util.List;
 
@Repository
public interface UserMapper {
    public List<User> selectAllUser();
 
    int insertUser(User user);
 
    int updateUser(User user);
 
    int deleteUser(User user);
 
 
}

Mapper.xml文件

<?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.ruoyi.system.mapper.UserMapper">
    <resultMap id="UserResult" type="User">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="age" column="age"/>
        <result property="sex" column="sex"/>
        <result property="createTime" column="create_time"/>
        <result property="deleteUser" column="deleteUser"/>
    </resultMap>
 
    <select id="selectAllUser" resultMap="UserResult">
        select *
        from user where deleteUser = 0;
    </select>
 
    <insert id="insertUser">
        insert into user
        values (null, #{name}, #{age}, #{sex}, #{createTime},#{deleteUser})
    </insert>
 
    <update id="updateUser">
        update user
        <set>
            <if test="name != null and name != ''">name = #{name},</if>
            <if test="age != null and age != ''">age = #{age},</if>
            <if test="sex != null and sex != ''">sex = #{sex},</if>
            <if test="createTime != null and createTime != ''">create_time = #{createTime}</if>
        </set>
        where id = #{id}
    </update>
 
    <delete id="deleteUser">
        update user
        set deleteUser = 1
        where id = #{id}
    </delete>
 
</mapper>

Domain层

package com.ruoyi.system.domain;
 
public class User {
    public int id;
    private String name;
    private int age;
    public int sex;
    public String createTime;
 
    public int getDeleteUser() {
        return deleteUser;
    }
 
    public void setDeleteUser(int deleteUser) {
        this.deleteUser = deleteUser;
    }
 
    public int deleteUser;
 
 
    public String getName() {
        return name;
    }
 
    public int getAge() {
        return age;
    }
 
    public void setAge(int age) {
        this.age = age;
    }
 
    public void setName(String name) {
        this.name = name;
    }
 
    public int getId() {
        return id;
    }
 
    public void setId(int id) {
        this.id = id;
    }
 
    public int getSex() {
        return sex;
    }
 
    public void setSex(int sex) {
        this.sex = sex;
    }
 
    public String getCreateTime() {
        return createTime;
    }
 
    public void setCreateTime(String createTime) {
        this.createTime = createTime;
    }
 
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                ", sex=" + sex +
                ", createTime='" + createTime + '\'' +
                ", delete=" + deleteUser +
                '}';
    }
}

3.在postman中测试

postman中进行四项测试

输入接口，send

 

 通过post向表中添加元素

通过put将id为3的对象的age属性改为10

 通过delete将id为4的对象删除

但是需要注意的是，id为4的对象并没有从表中消失，仅仅只是它的delete属性变成了1

 数据仍然存在，只是我们不再能查到它了。