1.多条件使用
1)查询
<select id="">
where 1 = 1
<if test="userName!=null and userName !="">
and userName like concat('%',#{userName},'%')
</if>
</select>
1.多条件使用
1)查询
<select id="">
where 1 = 1
<if test="userName!=null and userName !="">
and userName like concat('%',#{userName},'%')
</if>
</select>