<select id="categoryGetFilm" resultType="com.TKW.pojo.Film">
select * from film_message where category = #{category}
<if test="param !=null and param !=''">
AND ${param} LIKE concat('%',#{search},'%')
</if>
<if test="sort !=null and sort !=''">
order by ${sort} desc
</if>
limit #{limit};
</select>
Mybatis多条件模糊查询占位
最新推荐文章于 2023-03-06 00:57:59 发布