| 查询方式 |
说明 |
| 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") |