这个网站中有很多方法。https://code.google.com/p/mybatis/issues/detail?id=85

自己试验了如下的方法。

 

1. 参数中直接加入%%

param.setUsername("%CD%");param.setPassword("%11%");

 

        select id,sex,age,username,password from person where true              AND username LIKE #{username}            AND password LIKE #{password}        

 

2. bind标签

    select id,sex,age,username,password   from person  where username LIKE #{pattern}

 

3. CONCAT

where username LIKE concat(cancat('%',#{username}),'%')

where username LIKE concat('%',#{username},'%')

 

http://www.cnblogs.com/cyttina/p/3894428.html