10.名字中包含雨并且年龄小于40(需求1加强版)
第一种情况:
select id,name from user where name like '%雨%' and age < 40
Java代码:
@Test
public void selectByWrapperSupper(){
QueryWrapper<User> queryWrapper = new QueryWrapper();
queryWrapper.select("id","name").like("name","雨").lt("age",40);
List<User> userList = userMapper.selectList(queryWrapper);
userList.forEach(System.out::println);
}
输出结果:
DEBUG==> Preparing: SELECT id,name FROM user WHERE (name LIKE ? AND age < ?)
DEBUG==> Parameters: %雨%(String), 40(Integer)
TRACE<== Columns: id, name
TRACE<== Row: 1094590409767661570, 张雨琪
TRACE<== Row: 1094592041087729666, 刘红雨
DEBUG<== Total: 2
User(id=1094590409767661570, name=张雨琪, age=null, email=null, managerId=null, createTime=null)
User(id=1094592041087729666, name=刘红雨, age=null, email=null, managerId=null, createTime=null)
第二种情况:
select id,name,age,email from user where name like '%雨% and age < 40'
Java代码:
@Test
public void selectByWrapperSupper2(){
QueryWrapper<User> queryWrapper = new QueryWrapper();
queryWrapper.select(User.class,info -> info.getColumn()
.equals("create_time")&&!info.getColumn().equals("manager_id")).like("name","雨")
.lt("age",40);
List<User> userList = userMapper.selectList(queryWrapper);
userList.forEach(System.out::println);
}
输出结果:
DEBUG==> Preparing: SELECT id,create_time FROM user WHERE (name LIKE ? AND age < ?)
DEBUG==> Parameters: %雨%(String), 40(Integer)
TRACE<== Columns: id, create_time
TRACE<== Row: 1094590409767661570, 2019-01-14 09:15:15.0
TRACE<== Row: 1094592041087729666, 2019-01-11 14:20:20.0
DEBUG<== Total: 2
User(id=1094590409767661570, name=null, age=null, email=null, managerId=null, createTime=2019-01-14T09:15:15)
User(id=1094592041087729666, name=null, age=null, email=null, managerId=null, createTime=2019-01-11T14:20:20)