mybatis构造器QueryWrapper的常用方法

方法名	说明
`eq`	等于
`ne`	不等于
`gt`	大于
`ge`	大于等于
`lt`	小于
`le`	小于等于
`between`	BETWEEN 值1 AND 值2
`notBetween`	NOT BETWEEN 值1 AND 值2
`like`	LIKE ‘%值%’
`notLike`	NOT LIKE ‘%值%’
`likeLeft`	LIKE ‘%值’
`likeRight`	LIKE ‘值%’
`isNull`	IS NULL
`isNotNull`	IS NOT NULL
`in`	IN (值1,值2,值3)
`notIn`	NOT IN (值1,值2,值3)
`inSql`	字段 IN (sql语句)
`notInSql`	字段 NOT IN (sql语句)
`groupBy`	GROUP BY 字段
`orderByAsc`	GROUP BY 字段 ASC
`orderByDesc`	GROUP BY 字段 DESC
`orderBy`	ORDER BY 字段
`having`	HAVING(sql语句)
`or`	OR
`and`	AND
`apply`	拼接 sql
`last`	无视优化规则直接拼接到sql的最后
`exists`	EXISTS (sql语句)
`notExists`	NOT EXISTS (sql语句)