wrapper.groupBy(columns) //对应sql中分组
wrapper.eq(column, params) //相当于where条件
wrapper.in(column, value) //sql中in
wrapper.notIn(column, value) //sql中 not in
wrapper.orderBy(columns, isAsc) //排序
wrapper.exists(value) //相对于sql中exists查询
wrapper.notExists(value) //相当于sql中not exists查询
wrapper.notBetween(column, val1, val2) //相当于sql中在某个范围内使用的between
wrapper.ge(column, params) //大于等于
wrapper.le(column, params) //小于等于
wrapper.like(column, value) //模糊查询
wrapper.having(sqlHaving, params) //条件过滤
@RequestMapping("user-list")
public String pageListUsers(Model model,
@RequestParam(value = "pageNo",required = false) Integer pageNo,
@RequestParam(value = "keySelect",required = false) String keySelect){
User user=new User();
if(pageNo == null){
pageNo = 1;
}
IPage<User> page = new Page<>();
page.setCurrent(pageNo);
page.setSize(15);
IPage<User> page1 = null;
if(keySelect.length()>0){
page1= service.page(page,
new QueryWrapper<User>()
.like("user_name",keySelect)
.or().like("account",keySelect)
.or().like("password",keySelect)
.or().like("user_type",keySelect)
.or().like("role_id",keySelect)
);
}else{
page1=service.page(page);
}
List<Role> roles = serviceRole.list();
model.addAttribute("page",page1);
model.addAttribute("roles" ,roles);
return "user-list";
————————————————
版权声明:本文为CSDN博主「**瑱」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/CDZAllier/article/details/105297483