举例
QueryWrapper<IrTarget> queryWrapper = new QueryWrapper();
if(pageBaseBO.getTagName()!=null) queryWrapper.eq("tagName",pageBaseBO.getTagName());
if(pageBaseBO.getCenterId()!=null) queryWrapper.eq("centerId",pageBaseBO.getCenterId());
if(pageBaseBO.getNordNum()!=null) queryWrapper.eq("nordNum",pageBaseBO.getNordNum());
if(pageBaseBO.getTargetInfo()!=null) queryWrapper.eq("targetinfo",pageBaseBO.getTargetInfo());
if(pageBaseBO.getObservationType()!=null) queryWrapper.eq("nordNum",pageBaseBO.getObservationType());
if(pageBaseBO.getLoadFlag()!=null) queryWrapper.eq("loadFlag",pageBaseBO.getLoadFlag());
if (pageBaseBO.getBeginTime() != null) queryWrapper.apply("UNIX_TIMESTAMP(createtime) >= UNIX_TIMESTAMP('" + pageBaseBO.getBeginTime() + "')");
if (pageBaseBO.getEndTime() != null) queryWrapper.apply("UNIX_TIMESTAMP(createtime) < UNIX_TIMESTAMP('" + pageBaseBO.getEndTime() + "')");
queryWrapper.orderByDesc("UNIX_TIMESTAMP(createtime)");
List<IrTarget> listIr = irTargetMapper.selectList(queryWrapper);
常用方法参考
查询方式 | 说明 |
---|---|
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”) |
转载https://blog.csdn.net/w1911026171/article/details/109511011