方法一:使用mysql的concat函数进行连接
<select id="queryBookByName" resultType="Books">
select bookID, bookName, bookCounts, detail
from ssmbook.books
where bookName like concat('%', #{bookName}, '%')
方法二:使用mybatis中的bind标签
<select id="queryBookByName" resultType="cn.kongwg.entity.Books">
<bind name="bookName" value="'%'+bookName+'%'"/>
select bookID, bookName, bookCounts, detail
from ssmbook.books
where bookName like #{bookName}
</select>