Mybatis-plus构造器使用

查询

 @Test
    public void test(){
        // 查询用户名包含a,年龄在20-30之间,邮箱信息不为null的用户信息
        //  SELECT id,name,age,email FROM user WHERE (name LIKE ? AND age BETWEEN ? AND ? AND email IS NOT NULL)
        //==> Parameters: %a%(String), 20(Integer), 30(Integer)
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.like("name","a")
                .between("age",20,30)
                .isNotNull("email");
        List<User> users = userMapper.selectList(wrapper);
        users.forEach(System.out::println);
    }

排序

 @Test
    public  void test01(){
        // 查询用户信息,按照年龄的降序排序,若年龄相同,则按照id升序排序
        //SELECT id,name,age,email FROM user ORDER BY age DESC,id ASC
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        QueryWrapper<User> wrapper1 = wrapper.orderByDesc("age")
                .orderByAsc("id");
      List<User> list = userMapper.selectList(wrapper1);
            list.forEach(System.out::println);
    }

删除

  @Test
    public void test02(){
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.isNull("email");
        int list =  userMapper.delete(wrapper);
        System.out.println("result"+list);
    }

优先级

    @Test
    public void test03(){
        // (年龄大于20并且用户名包含a) 或者邮箱为null 的用户信息修改
        // UPDATE user SET name=?, age=? WHERE is_deleted=0 AND (age > ? AND name LIKE ? OR email IS NULL)
        UpdateWrapper<User> wrapper = new UpdateWrapper<>();
        wrapper.gt("age",20)
                .like("name","a")
                .or()
                .isNull("email");
        User user = new User();
        user.setName("白毛");
        user.setAge(66);
        int update = userMapper.update(user, wrapper);
        System.out.println("result"+update);
    }
 @Test
    public void test04(){
        // 将用户名中包含有a并且(年龄大于20或者邮箱为null)的信息修改
        // lambda中条件优先执行
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.like("name","a")
                .and(i->i.gt("age",20).or().isNull("email"));
        User user = new User();
        user.setName("小红果");
        int update = userMapper.update(user, wrapper);
        System.out.println(update);

    }

修改

    @Test
    public void test05(){
        // 将用户名中包含有a并且(年龄大于20或者邮箱为null)的信息修改
        UpdateWrapper<User> wrapper = new UpdateWrapper<>();
        wrapper.like("name","a")
                .and(i->i.gt("age",20).or().isNull("email"));
        wrapper.set("name","小黑").set("email","hanhan@123.com");
        int update = userMapper.update(null, wrapper);
        System.out.println("result:"+update);
    }

查询

        @Test
    public void test06(){
        String name = "a";
        Integer ageBegin = null;
        Integer ageEnd = 30;
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.like(StringUtils.isNotBlank(name),"name",name)
                .ge(ageBegin != null,"age",ageBegin)
                .le(ageEnd!=null,"age",ageEnd);
            List<User> users = userMapper.selectList(wrapper);
            users.forEach(System.out::println);
        }
 @Test
        public void test07(){
            String name = "a";
            Integer ageBegin = null;
            Integer ageEnd = 30;
            LambdaQueryWrapper<User> wrapper = new LambdaQueryWrapper<>();
            wrapper.like(StringUtils.isNotBlank(name),User::getName,name)
                    .ge(ageBegin !=null,User::getAge,ageBegin)
                    .le(ageEnd != null,User::getAge,ageEnd);
            List<User> list = userMapper.selectList(wrapper);
            list.forEach(System.out::println);
        }
  @Test
        public void test08(){
            // 将用户名中包含有a并且(年龄大于20或者邮箱为null)的信息修改
            LambdaUpdateWrapper<User> wrapper = new LambdaUpdateWrapper<>();
            wrapper.like(User::getName,"a")
                    .and(i->i.gt(User::getAge,20).or().isNull(User::getEmail));
            wrapper.set(User::getName,"小黑").set(User::getEmail,"hanhan@123.com");
            int update = userMapper.update(null, wrapper);
            System.out.println("result:"+update);
        }

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值