mybatis框架中使用like模糊查询

mapper api接口中

List<Map> getUnderRegionList(@Param("regicode")String regicode);

mapper api接口所对应的xml

<select id="getUnderRegionList" parameterType="java.util.Map" resultType="java.util.Map">
  select IN_CODE id, P_IN_CODE pid, DISP_NAME realname, concat('[', IN_CODE, ']', DISP_NAME) name
  from xt_region where IN_CODE like  CONCAT('%',#{regicode},'%')
</select>

动态sql

mapper api接口中

List<Map> getXtUserInfoByUseStatus(@Param("usestatus")String usestatus,@Param("name")String name,@Param("code")String code);

mapper api接口所对应的xml

<select id="getXtUserInfoByUseStatus" parameterType="java.util.Map" resultType="java.util.Map">
  select u.ID id, u.NAME name,u.CODE code,u.PHONENO phoneno,u.ENTENAME entename, u.entetype, u.REGICODE regicode, r.DISP_NAME reginame, u.usestatus from xt_user u
  left join xt_region r on r.DISP_CODE = u.REGICODE
  where u.usestatus = #{usestatus}
  <if test="name != ''">
    and u.NAME = #{name}
  </if>
  <if test="code != ''">
    and u.CODE = #{code}
  </if>
  order by u.ID
</select>