1. mybatis “like” 使用
1) bind
<bind name="pattern" value="'%' + _parameter.company + '%'" />
<select id="searchGroupCompany" parameterType="com.niding.userservice.io.SearchGroupCompanyIO"
resultMap="SearchReusltMap">
select uuid,groupcompanyname from user_groupcompany
<where>
isdel=0
<if test="company!='' and company!=null"> <bind name="pattern" value="'%' + _parameter.company + '%'" /> and groupcompanyname like #{pattern} </if></where> </select>
2) concat
where groupcompanyname LIKE concat(cancat('%',#{company}),'%')
3)参数中直接加入%%