1.使用lambdaQuery()函数
/**
* 查询语句的新写法 ===> 自定义查询列和查询条件
* @return
*/
@Override
public List<User> listUser(Integer id){
List<User> list = this.list(Wrappers.<User>lambdaQuery()
.select(
User::getNickname,
User::getPhone,
User::getGender)
.eq(User::getId, id));
return list;
}
2.使用query()函数自定义sql
/**
* 查询语句的新写法 ===>自定义sql
* @return
*/
public List<User> listUserBySql(Integer id){
List<User> list = this.list(Wrappers.<User>query()
.select("username,password")
.eq("id", id));
return list;
}
3.使用lambdaQuery() 根据条件筛选
/**
* lambdaQuery() 根据条件筛选
* @param id
* @return
*/
public List<User> listUserByWrapper(Integer id){
List<User> list = this.list(Wrappers.lambdaQuery(User.class).eq(User::getId,id));
return list;
}
4.分页查询page
/**
* 测试分页查询page
* http://localhost:8500/shop/user/testQueryPageUser?pageNum=1&pageSize=10
* @param user
* @return
*/
@GetMapping({"/testQueryPageUser"})
public R testQueryPageUser(User user) {
Page<User> page = new Page<>(user.getPageNum(),user.getPageSize());
LambdaQueryWrapper<User> queryWrapper = Wrappers.lambdaQuery(User.class);
queryWrapper.eq(User::getGender,user.getGender());
IPage<User> userIPage = iUserService.page(page, queryWrapper);
return R.ok(userIPage.getRecords());
}