mybatis杂记

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);