mybatis-plus条件构造器整理及使用示例时间查询.docxVIP

mybatis-plus条件构造器整理及使??例时间查询 ?、条件构造器?览 构造器数据载?官?集中整理 1、常??法?例 条件构造器 构造?法 构造?例 eq 等于 = eq(“name”, “?王”)—name = ‘?王’ ne 不等于 ne(“name”, “?王”)—name ‘?王’ gt ?于 gt(“age”, 18)—age 18 ge ?于等于 = ge(“age”, 18)—age = 18 lt ?于 lt(“age”, 18)—age 18 le ?于等于 = le(“age”, 18)—age = 18 between BETWEEN 值1 AND 值2 between(“age”, 18, 30)—age between 18 and 30 like LIKE ‘%值%’ like(“name”, “王”)—name like ‘%王%’ in 字段 IN (value.get(0), value.get(1), …) in(“age”,{1,2,3})—age in (1,2,3) orderByAsc 排序：ORDER BY 字段, … ASC orderByAsc(“id”, “name”)—order by id ASC,name ASC orderByDesc 排序：ORDER BY 字段, … DESC orderByDesc(