mybatis-plus条件构造器简介

/**
 * 查找薪水大于3500 名字里有“小”的 员工
 * sql： select * from t_employee where salary>3500 and name like ‘%小%‘
 */
@Test
public void selectByQueryWrapper(){
    QueryWrapper<Employee> queryWrapper=new QueryWrapper();
    // QueryWrapper<Employee> queryWrapper2=Wrappers.<Employee>query();
    queryWrapper.gt("salary",3500).like("name","小");
    List<Employee> employeeList = employeeMapper.selectList(queryWrapper);
    System.out.println(employeeList);
}
 
/**
 * 查找薪水范围【3500，5000】，名字里有“小”以及email不为空 的员工
 * sql： select * from t_employee where between 3500 and 5000 and name like ‘%小%‘ and email is not null
 */
@Test
public void selectByQueryWrapper2(){
    QueryWrapper<Employee> queryWrapper=new QueryWrapper();
    // QueryWrapper<Employee> queryWrapper2=Wrappers.<Employee>query();
    queryWrapper.like("name","小").between("salary",3500,5000).isNotNull("email");
    List<Employee> employeeList = employeeMapper.selectList(queryWrapper);
    System.out.println(employeeList);
}