Mybatis中的like查询
今天要做一个模糊查询用的Mybatis
开始写的是：
view plaincopy
[*]select id,bookName,author,publisher,donor,status,createDate,lastUpdate from book
[*] <where>
[*] <if test="bookName!=null">
[*] bookName like '%#{bookName}%'
[*] </if>
[*] <if test="author!=null">
[*] and author like '%#{author}%'
[*] </if>
最后改为：
view plaincopy
[*]select id,bookName,author,publisher,donor,status,createDate,lastUpdate from book
[*] <where>
[*] <if test="bookName!=null">
[*] bookName like CONCAT('%','${bookName}','%' )
[*] </if>
[*] <if test="author!=null">
[*] and author like CONCAT('%','${author}','%' )
[*] </if>
主要还是MyBatis传值的问题啊
如果不是字符串就没法替换了
本文来源于:http://blog.csdn.net/zhang98722/article/details/6956571
页:
[1]