@Controller @RequestMapping("/") public class TkController { @Autowired private TkDao tkDao; @RequestMapping("/getList") public @ResponseBody List<TkBean> getTkList(HttpSession session)throws Exception{ QueryWrapper<TkBean> wrapper=new QueryWrapper<TkBean>(); wrapper.eq("id","151");//id =151 wrapper.eq("name","151");//查询名称为151的数据 wrapper.isNotNull("name");//名称不为空 wrapper.isNull("name");//名称为空 wrapper.ge("id","151");//查询id大于等于151,id>=151 wrapper.gt("id","151");//查询id小于等于151,id<>>=151 wrapper.between("id","100","150");//查询id为100到150之间的数据 wrapper.like("name","151");//查询name里含有151的数据,相等于%151% wrapper.notLike("name","151");//查询name里不含有151的数据 wrapper.likeLeft("name","100");//查询名称开头为100的数据,相等于100% wrapper.likeRight("name","100");//查询名称结尾为100的数据,相等于%100 wrapper.orderByDesc("id");//降序 wrapper.orderByAsc("id");//升序 wrapper.inSql("id","select id from user where sid=20"); //一个SQL语句写的子查询 List<TkBean> list=tkDao.selectList(wrapper); return list; }
条件参数说明
查询方式 | 说明 |
---|---|
setSqlSelect | 设置 SELECT 查询字段 |
where | WHERE 语句,拼接 + WHERE 条件 |
and | AND 语句,拼接 + AND 字段=值 |
andNew | AND 语句,拼接 + AND (字段=值) |
or | OR 语句,拼接 + OR 字段=值 |
orNew | OR 语句,拼接 + OR (字段=值) |
eq | 等于= |
allEq | 基于 map 内容等于= |
ne | 不等于<> |
gt | 大于> |
ge | 大于等于>= |
lt | 小于< |
le | 小于等于<= |
like | 模糊查询 LIKE |
notLike | 模糊查询 NOT LIKE |
in | IN 查询 |
notIn | NOT IN 查询 |
isNull | NULL 值查询 |
isNotNull | IS NOT NULL |
groupBy | 分组 GROUP BY |
having | HAVING 关键词 |
orderBy | 排序 ORDER BY |
orderAsc | ASC 排序 ORDER BY |
orderDesc | DESC 排序 ORDER BY |
exists | EXISTS 条件语句 |
notExists | NOT EXISTS 条件语句 |
between | BETWEEN 条件语句 |
notBetween | NOT BETWEEN 条件语句 |
addFilter | 自由拼接 SQL |
last | 拼接在最后,例如:last("LIMIT 1") |