1. 通过时间字段查询
select * from user where DATE_FORMAT(start_time,'%Y-%m-%d') > DATE_FORMAT(now(),'%Y-%m-%d ')
2. 模糊查询
select * from user where username like concat('%',#{username},'%')
3. <if>条件判断
<if test="flag != null and flag == 'sales'.toString()">
and saling = 1
</if>
4. mapper中的接口,参数使用@Param注解可以避免参数匹配不对的错误
searchByQuery(@Param("category") String category,
@Param("current") int current,
@Param("size") int size);