1.sql 相联
mysql
where name like concat('%',#{selectword},'%')
oracle
where name like '%'||#{selectword}||'%'
2. bind标签
<select id="selectPersons" resultType="person" parameterType="person">
<bind name="_name" value="'%' + queryVO.name + '%'" />
select id,name
from user
where name LIKE #{_name}
</select>