springboot mybatis增删改查
时间: 2023-08-31 07:12:41 浏览: 52
Spring Boot是一个快速开发框架,MyBatis是一种持久层框架,二者的结合可以帮助我们快速开发增删改查接口。以下是示例代码:
1. 增加数据
```
@Autowired
private UserMapper userMapper;
@PostMapping("/users")
public User addUser(@RequestBody User user) {
userMapper.addUser(user);
return user;
}
```
2. 删除数据
```
@Autowired
private UserMapper userMapper;
@DeleteMapping("/users/{id}")
public String deleteUser(@PathVariable("id") Integer id) {
userMapper.deleteUser(id);
return "success";
}
```
3. 修改数据
```
@Autowired
private UserMapper userMapper;
@PutMapping("/users/{id}")
public User updateUser(@PathVariable("id") Integer id, @RequestBody User user) {
user.setId(id);
userMapper.updateUser(user);
return user;
}
```
4. 查询数据
```
@Autowired
private UserMapper userMapper;
@GetMapping("/users")
public List<User> getUsers() {
return userMapper.getUsers();
}
@GetMapping("/users/{id}")
public User getUserById(@PathVariable("id") Integer id) {
return userMapper.getUserById(id);
}
```
其中,UserMapper是一个MyBatis的Mapper接口,通过@Mapper注解标记为MyBatis的Mapper接口,实现增删改查方法。以上示例中,假设User是一个实体类,包含用户信息。