mybatis实现模糊查询

name作为参数传递到mapper文件

<!-- 3.根据名字查找用户 -->
<select id="peopleSearch" resultMap="peopleRM">
  select * from tb_people where people_name like CONCAT('%',#{name},'%')
</select>

posted @ 2020-08-19 15:34  Curedfisher  阅读(581)  评论(0编辑  收藏  举报