public interface UserMapper {
List<User> getUserLike(String value);
}
<select id="getUserLike" resultType="com.study.pojo.User">
select * from mybatis.user where name like #{value}
</select>
@Test
public void getUserLike(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<User> userList = mapper.getUserLike("%xyf%");
for (User user : userList) {
System.out.println(user);
}
sqlSession.close();
}
10-19
1001
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
08-12