Mybatis-plus 条件构造器

Mybatis-plus 条件构造器

@SpringBootTest
@RunWith(SpringRunner.class)
public class WrapperTest {
   


    @Autowired
    private UserMapper userMapper;


    /**
     * 基础比较查询
     *
     * Wrapper:
     *  1.QueryWrapper
     *      LambdaQueryWrapper
     *  2.UpdateWrapper
     *      LambdaUpdateWrapper
     *
     */
    @Test
    public void testWrapper1(){
   
        //1.创建查询条件构建器
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        //2.设置条件
        wrapper.eq("user_name","lisi")
                .lt("age",23)
                .in("name","李四","王五");
        /*
            select * from tb_user where user_name = ? and age < ? and name in (?,?)
         */

        List<User> users = userMapper.selectList(wrapper);

        System.out.println(users);
    }


    @Test
    public void testWrapper2(){
   
        //1.创建查询条件构建器
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        //2.设置条件
        wrapper.eq("user_name","lisi")
                .or()
                .lt("age",23)
                .in("name&#