1. 参数中直接加入%%
1
2
3
4
5
6
7
|
param.setUsername( "%CD%" ); param.setPassword( "%11%" ); <select id= "selectPersons" resultType= "person" parameterType= "person" > select id,sex,age,username,password from person where true < if test= "username!=null" > AND username LIKE #{username}</ if > < if test= "password!=null" >AND password LIKE #{password}</ if > </select> |
2. bind标签
1
2
3
4
5
6
|
<select id= "selectPersons" resultType= "person" parameterType= "person" > <bind name= "pattern" value= "'%' + _parameter.username + '%'" /> select id,sex,age,username,password from person where username LIKE #{pattern} </select> |
3. CONCAT
1
|
where username LIKE concat(concat( '%' ,#{username}), '%' ) |
以上所述是小编给大家介绍的Mybatis中的like模糊查询功能,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持!
原文链接:http://blog.csdn.net/wuyongde_0922/article/details/55515307