模糊查询的写法:
<select id="test1" parameterType="java.util.Map" resultType="java.util.Map"> select * from e_user <where> <if test="user_name!=null and user_name!='' "> and user_name like CONCAT('%', #{user_name}, '%') </if> </where> </select>
模糊查询的写法:
<select id="test1" parameterType="java.util.Map" resultType="java.util.Map"> select * from e_user <where> <if test="user_name!=null and user_name!='' "> and user_name like CONCAT('%', #{user_name}, '%') </if> </where> </select>