// CategoryMapper.xml
<selectid="pageQuery"resultType="com.sky.entity.Category">
select * from category
<where><iftest="name != null and name != ''">
and name like concat('%',#{name},'%')
</if><iftest="type != null">
and type = #{type}
</if></where>
order by sort asc , create_time desc
</select>