SSM项目使用mybatis实现增加、删除功能
时间: 2024-05-03 14:22:56 浏览: 6
1. 增加功能
(1)在mapper.xml文件中添加insert语句:
```
<insert id="addUser" parameterType="User">
insert into user(name, age, gender) values (#{name}, #{age}, #{gender})
</insert>
```
(2)在接口中定义方法:
```
public void addUser(User user);
```
(3)在Service层调用mapper中的方法:
```
public void addUser(User user) {
userDao.addUser(user);
}
```
(4)在Controller层中调用Service中的方法:
```
@RequestMapping(value = "/addUser", method = RequestMethod.POST)
public String addUser(@ModelAttribute("user") User user) {
userService.addUser(user);
return "redirect:/userList";
}
```
2. 删除功能
(1)在mapper.xml文件中添加delete语句:
```
<delete id="deleteUserById" parameterType="int">
delete from user where id = #{id}
</delete>
```
(2)在接口中定义方法:
```
public void deleteUserById(int id);
```
(3)在Service层调用mapper中的方法:
```
public void deleteUserById(int id) {
userDao.deleteUserById(id);
}
```
(4)在Controller层中调用Service中的方法:
```
@RequestMapping(value = "/deleteUserById/{id}", method = RequestMethod.GET)
public String deleteUserById(@PathVariable("id") int id) {
userService.deleteUserById(id);
return "redirect:/userList";
}
```