Mybatis--->模糊查询 

  <select id="queryBookByName" resultType="Books">
        select * from ssmbuild.books where bookName like CONCAT('%',#{bookName},'%')
    </select>

CONCAT('%',#{bookName},'%'     推荐

posted @ 2020-09-29 19:43  Spring_Xian  阅读(187)  评论(0)  编辑  收藏  举报