1.queryWrapper.lt()===>小于(<)
2.queryWrapper.gt()===>大于(>)
3.queryWrapr.eq()===>等于(=)
4.queryWrapr.ne()===>不等于(!=)
5.queryWrapr.le()==>小于等于(<=)
6.queryWrapr.ge()==>大于等于(>=)
7.queryWrapper.between("age",10,20)==>age在值10到20之间
8.queryWrapper.notbetween("age",10,20)==>age不在值10到20之间
9.queryWrapper.like("属性","值")==>模糊匹配查询%值%
10.queryWrapper.notlike("属性","值")==>模糊不匹配查询%值%
11.queryWrapper.likeLeft("属性","值")==>左模糊匹配查询%值
12.queryWrapper.likeRight("属性","值")==>右模糊匹配查询值%
13.queryWrapper.isNull()==>值为空或者为null
14.queryWrapper.isNotNull()==>值为不为空或者不为null
15.queryWrapper.in("属性",条件1,条件2)==>在条件1或者条件2的值
16.queryWrapper.notIn("属性",条件1,条件2)==>不在条件1或者条件2的值
17.queryWrapper.or()==>或者
18.queryWrapper.and()==>和
19.queryWrapper.orderByAsc("属性")==>根据属性升序
20.queryWrapper.orderByDesc("属性")==>根据属性降序
21.queryWrapper.apply("SQL语句","参数1","参数2")==>拼接SQL
22.queryWrapper.apply("boolean condition","SQL语句",,"参数1","参数2")==>拼接SQL
23.queryWrapper.last("SQL语句")==>在条件后面拼接SQL