/**
* 查询名字中包含'牛'并且年龄小于28
* where name like '%牛%' and age < 28
*/
@Test
public void selectByWrapper(){
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.like("name","牛").lt("age",28);
List<User> userList = userMapper.selectList(queryWrapper);
userList.forEach(System.out::println);
}
2.嵌套查询
/**
* 创建日期为2020年1月14日并且姓名为王姓
* date_format(create_time,'%Y-%m-%d') and manager_id in (select id from user where name like '王%')
*/
@Test
public void selectByWrapper2(){
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.apply("date_format(create_time,'%Y-%m-%d')={0}","2020-01-14")
.inSql("manager_id","selec