Java项目实战-新增/编辑/删除/查询功能实现

新增用户

    @RequestMapping(value = "/addUser", method = RequestMethod.POST)
    public String addUser(@RequestBody User user) {
        return userService.addUser(user);
    }

//定义一个新增用户的方法，返回空
    void addUser(User user);

    <insert id="addUser" parameterType="User">
        insert into monkey.monkey_user (user_name,user_sex) VALUES (#{user_name},#{user_sex})
    </insert>

public String addUser(User user){
        System.out.println("user = " + user);
        userMapper.addUser(user);
        return "新增成功";
    }

删除用户

@GetMapping("/deleteUserById")
    public String deleteUserById(int user_id){
        return userService.deleteUserById(user_id);
    }

//定义一个根据user_id删除用户的方法，返回空
    void deleteUserById(int user_id);

<delete id="deleteUserById">
        DELETE FROM monkey.monkey_user WHERE user_id=#{user_id}
    </delete>

public String deleteUserById(int user_id){
        userMapper.deleteUserById(user_id);
        return "删除成功";
    }

编辑用户

@PostMapping("/updateUser")
    public String updateUser(@RequestBody User user){
        return userService.updateUser(user);
    }

//定义一个根据user_id编辑用户的方法
    void updateUser(User user);

<update id="updateUser" parameterType="User">
        UPDATE monkey.monkey_user SET user_name=#{user_name},user_sex=#{user_sex} WHERE user_id=#{user_id}
    </update>

public String updateUser(User user){
        System.out.println("user = " + user);
        userMapper.updateUser(user);
        return "更新成功";
    }

查询单个用户

    @GetMapping("/queryUserById")
    public User queryUserById(int user_id) {
        return userService.queryUserById(user_id);
    }

//定义一个根据user_id查询用户的方法，返回对象类型
    User queryUserById(int user_id);

 <select id="queryUserById" resultType="User">
        select * from monkey.monkey_user where user_id=#{user_id}
    </select>

public User queryUserById(int user_id){
        return userMapper.queryUserById(user_id);
    }