<select id="queryPage" parameterType="***" resultType="java.util.Map"> SELECT * FROM news WHERE del=0 AND uid=#{param1} <if test="param2.title != null"> AND title like CONCAT('%',#{param2.title},'%' ) </if> <if test="param2.classify != null"> AND classify = #{param2.classify } </if> <if test="param2.sub_classify != null"> AND sub_classify = #{param2.sub_classify } </if> <if test="param2.status != null"> AND status = #{param2.status} </if> <if test="param2.pop != null"> AND pop = #{param2.pop} </if> <if test="param2.recommend != null"> AND recommend = #{param2.recommend} </if> </select>
不输入条件直接查询集合只显示status为0的数据,添加条件进行查询可以正确显示集合
根据 tilte/classify/sub_classify/status/recommend/pop 条件查询,去掉
<if test="param2.status != null"> AND status = #{param2.status} </if>
数据显示 正常,还没找到原因