Java修改和删除表数据

package com.sdcet.controller;
import com.sdcet.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;

import java.util.List;

public class UserController {
    @Controller
    @ResponseBody
    public class UserControlle{
        @Autowired
        private UserMapper usermapper;

        @RequestMapping("/getName")
        public String getName(Long id){
            return usermapper.selectNameById(id);
        }
        @RequestMapping("/user")
        public User user(Long id){
            return usermapper.selectUserById(id);
        }
        @RequestMapping("/getUserByName")
        public List<User> getUserByName(String name){ return usermapper.selectUserByName(name); }
        @PostMapping("/save")
        public int save(@RequestBody User user){
            return usermapper.save(user);
        }
        @PutMapping("/update")
        public int update(@RequestBody User user){ return usermapper.update(user); }

    }

}

UserMapper.java

    @Insert("INSERT INTO user (name, sex, password, phone_num, create_time, update_time) VALUES (#{name}, #{sex}, #{password}, #{phoneNum}, #{createTime}, #{updateTime})")
    int save(User user);

    @Update("DELETE name = #{name},password = #{password},phone_num = #{phone_num}, sex = #{sex} create_time = #{createTime}, update_time = #{createTime},update_time = #{updateTime} WHERE id = #{id}")
    int update(User user);

    @Delete("DELETE FROM user WHERE id = #{id}")
    int delete(Long id);
}