- setSqlSelect                 设置 SELECT 查询字段
- where                          WHERE 语句,拼接 + WHERE 条件
- and                              AND 语句,拼接 + AND 字段=值
- and                              New 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”)
 
             
            posted @ 
2021-12-14 17:06 
johnson8888 
阅读(
4370) 
评论() 
 
收藏 
举报