/**
* 根据类型查询分类
* @param type
* @return
*/List<Category>list(Integer type);
5 动态sql,xml
<selectid="list"resultType="com.sky.entity.Category">
select * from category
where status = 1
<iftest="type != null">
and type = #{type}
</if>
order by sort asc, create_time desc
</select>