【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", "湖南");