Java优学网SpringBoot MyBatisPlus CRUD教程：快速上手企业级数据操作

mybatis-plus: configuration:

map-underscore-to-camel-case: true

global-config:

db-config:
  id-type: auto
  logic-delete-field: deleted

public interface UserMapper extends BaseMapper {

// 不需要编写基础CRUD方法

}

User user = new User(); user.setUsername("张三"); user.setEmail("zhangsan@example.com"); user.setAge(25);

int result = userMapper.insert(user);

QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("age", 25)

       .ne("status", 0)
       .like("username", "张");

List users = userMapper.selectList(queryWrapper);

public interface UserService extends IService {

// 自定义业务方法
UserVO getUserDetail(Long userId);
Page<UserVO> listUsersByCondition(UserQuery query);

}

@Service public class UserServiceImpl extends ServiceImpl<UserMapper, User>

implements UserService {

@Override
public UserVO getUserDetail(Long userId) {
    // 具体实现
}

}

@RestController @RequestMapping("/api/user") public class UserController {

@Autowired
private UserService userService;

@GetMapping("/list")
public R<Page<UserVO>> listUsers(UserQuery query) {
    return R.ok(userService.listUsersByCondition(query));
}

@GetMapping("/{userId}")
public R<UserVO> getUserDetail(@PathVariable Long userId) {
    return R.ok(userService.getUserDetail(userId));
}

@PostMapping
public R<Boolean> createUser(@RequestBody @Valid UserCreateDTO userDTO) {
    return R.ok(userService.createUser(userDTO));
}

@PutMapping
public R<Boolean> updateUser(@RequestBody @Valid UserUpdateDTO userDTO) {
    return R.ok(userService.updateUser(userDTO));
}

@DeleteMapping("/{userId}")
public R<Boolean> deleteUser(@PathVariable Long userId) {
    return R.ok(userService.removeById(userId));
}

}