Mybatis多条件模糊查询占位
<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
原创
2020-08-10 17:24:52 ·
198 阅读 ·
0 评论