【MyBatis】关于模糊查询的两种处理方法

第一种:在要查的字段后面添加关键字

<!-- 通过姓名和地址查询:方法一 -->
<select id="findByNameAndAddress" resultType="Customer">
	select * from customer where name like #{name} and address like #{address}  	
</select>

测试:

List<Customer> customers = mapper.findByNameAndAddress("%evan%", "%湖南%");

第二种:通过映射

<!-- 通过姓名和地址查询:方法二 -->
<select id="findByNameAndAddress2" resultType="Customer">
<!--  name: c1, address: a1 =>  -->
<!-- namePattern: %c1%, addressPattern => %a1% -->
 	<bind name="namePattern" value="'%' + _parameter.name +'%'"/>
 	<bind name="addressPattern" value="'%' + _parameter.address +'%'"/>
	select * from customer where name like #{namePattern} and address like #{addressPattern}  	
</select>

测试:

List<Customer> customers = mapper.findByNameAndAddress2("evan", "湖南");