xml代码笔记(无废话，直接cv)

select * from category and name like concat('%',#{name},'%') and type = #{type} order by sort asc , create_time desc

update category


type = #{type},


name = #{name},


sort = #{sort},


status = #{status},


update_time = #{updateTime},


update_user = #{updateUser}


where id = #{id}

select * from category where status = 1 and type = #{type} order by sort asc,create_time desc