<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><!--代理扫描 namespace属性表示当前代理的命名空间,属性值为mapper接口地址,相当于mapper接口实现类 --><mappernamespace="com.java.mapper.EmpMapper"><!--要查询的sql字段--><sqlid="empSQL">
number,name,job,mgr,hiredate,sal,comm,deptno
</sql><!--1、参数为String类型的模糊查询--><!--方法1--><selectid="selectLikeName"parameterType="string"resultType="EmpEntity">
SELECT <includerefid="empSQL"/> FROM emp WHERE name LIKE "%"#{name}"%"
</select><!--方法2:推荐使用--><selectid="selectLikeName"parameterType="string"resultType="EmpEntity">
SELECT <includerefid="empSQL"/> FROM emp WHERE name LIKE concat("%",#{name},"%")
</select><!--方法3,SQL语句:SELECT number,name,job,mgr,hiredate,sal,comm,deptno FROM emp WHERE name LIKE "%子%" --><selectid="selectLikeName"parameterType="string"resultType="EmpEntity">
SELECT <includerefid="empSQL"/> FROM emp WHERE name LIKE "%${value}%"
</select><!--2、参数为实体类对象的模糊查询--><!--方法1--><selectid="selectLikeEmpName"parameterType="EmpEntity"resultType="EmpEntity">
SELECT <includerefid="empSQL"/> FROM emp WHERE name LIKE concat("%",#{name},"%")
</select><!--方法2--><selectid="selectLikeEmpName"parameterType="EmpEntity"resultType="EmpEntity">
SELECT <includerefid="empSQL"/> FROM emp WHERE name LIKE "%"#{name}"%"
</select><!--方法3--><selectid="selectLikeEmpName"parameterType="EmpEntity"resultType="EmpEntity">
SELECT <includerefid="empSQL"/> FROM emp WHERE name LIKE '%${name}%'
</select><!--3、参数为map集合的模糊查询,#{}中参数为map的key值--><selectid="selectLikeEmpNameMap"parameterType="map"resultType="EmpEntity">
SELECT <includerefid="empSQL"/> FROM emp WHERE name LIKE "%"#{name}"%"
</select></mapper>