mybatis的模糊查询的实现方式

一、比较灵活
1：xml的配置

select * from user where username like #{username}

2：测试
@Test
public void selectUserByUsername1() {
List userList = userMapper.selectUserByUsername1("%小%");
for (User user : userList) {
System.out.println(user);
}
}

二、
1：xml的配置

select * from user where username like '%${value}%'

2：测试
@Test
public void selectUserByUsername2() {
List userList = userMapper.selectUserByUsername2("王");
for (User user : userList) {
System.out.println(user);
}
}