模糊查询以及去除查询条件两端的空格;
模糊查询:采用<bind>标签 或 concat函数;
去除查询条件两端空格:replace函数;
<!-- 查询:根据学生工号查询学生信息 -->
<select id="getStudentInfo" parameterType="map" resultType="map">
select * from Student_list_data
where 1 = 1
<!-- 模糊查询:bind标签 -->
<if test = "null != student_Number and '' != student_Number">
<bind name = "p_student_Number" value = " '%' + student_Number + '%' " />
and student_Number like #{p_student_Number}
</if>
<!-- 模糊查询:bind标签 和 去除查询条件两端空格 -->
<if test = "null != student_Number and '' != student_Number">
<bind name = "p_student_Number" value = " '%' + student_Number + '%' " />
and student_Number like replace(#{p_student_Number}," ","")
</if>
<!-- 模糊查询:concat函数 -->
<if test = "null != student_Number and '' != student_Number ">
and student_Number like concat('%',#{student_Number },'%')
</if>
<!-- 模糊查询:concat函数 和 去除查询条件两端空格 -->
<if test = "null != student_Number and '' != student_Number ">
and student_Number like replace(concat('%',#{student_Number },'%')," " ,"")
</if>
</select>