MyBatis中模糊查询like的几种使用方式

String sname = "%张三%";
System.out.println(studentMapper.getStudent(sname));

<select id="getStudent" resultType="map" parameterType="String">
	SELECT sid,sname FROM student WHERE  sname like #{sname}
</select>

String sname = "张三";
System.out.println(studentMapper.getStudent(sname));

<select id="getStudent" resultType="map" parameterType="String">
	SELECT sid,sname FROM student WHERE  sname like CONCAT('%',#{sname},'%')
</select>

String sname = "张三";
System.out.println(studentMapper.getStudent(sname));

<select id="getStudent" resultType="map" parameterType="String">
	<bind name="tempStr" value="'%' + _parameter + '%'" />
	SELECT sid,sname FROM student WHERE  sname like #{tempStr}
</select>

<select id="getStudent" resultType="map">
	<bind name="tempStr" value="'%' + _parameter.get('sname') + '%'" />
	SELECT sid,sname FROM student WHERE  sname like #{tempStr}
</select>

<select id="getStudent" resultType="map" parameterType="com.buhe.co.entity.Student">
	<bind name="tempStr" value="'%' + _parameter.getSname() + '%'" />
	SELECT sid,sname FROM student WHERE  sname like #{tempStr}
</select>

String sname = "张三";
System.out.println(studentMapper.getStudent(sname));

<select id="getStudent" resultType="map" parameterType="String">
	SELECT sid,sname FROM student WHERE  sname like '%${sname}%'
</select>