<select id="getUserLike" resultType="com.zhan.pojo.User">
select * from student.student where name like "%"#{value}"%"
</select>
测试:
public void getUserLike(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<User> userList = mapper.getUserLike("李");
for (User user : userList) {
System.out.println(user);
}
sqlSession.close();
}
或者
<select id="getUserLike" resultType="com.zhan.pojo.User">
select * from student.student where name like #{value}
</select>
List<User> userList = mapper.getUserLike("%李%");