Mabatis-Plus 条件构造器语法

朽唐

已于 2022-11-13 01:32:36 修改

阅读量229

点赞数

文章标签： java 数据库 sql

于 2022-11-12 22:14:14 首次发布

本文链接：https://blog.csdn.net/weixin_51938119/article/details/127826217

版权

//第1种方法 QueryWrapper

    String xiaotang="小唐"；

    QueryWrapper<User> queryWrapper1 = new QueryWrapper<>();
        queryWrapper1.eq("username", xiaotang);
        User user1 = userMapper.selectOne(queryWrapper1);//只查一条数据

    // selct * from User where username=xiaotang

	//或   可以使用lambda
     QueryWrapper<User> queryWrapper2 = new QueryWrapper<>();
      
     queryWrapper2.lambda().eq(User::getUsername, xiaotang);

     User user2 = userMapper.selectOne(queryWrapper2);


    // 第 2 种方法 LambdaQueryWrapper  该方法可以少写 lambda

     LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        lambdaQueryWrapper.eq(User::getUsername, xiaotang);
        User user3 = userMapper.selectOne(lambdaQueryWrapper);

	//或 
LambdaQueryWrapper<User> lb = Wrappers.<User>lambdaQuery().eq(User::getUsername, "小唐");
    User user4 = userMapper.selectOne(lambdaQueryWrapper);

    // 第 3 种方法 LambdaQueryChainWrapper  链式查询	
    User user5 = new LambdaQueryChainWrapper<>(userMapper)
                .eq(User::getUsername, xiaotang)
                .one(); // 这步骤是查询一条记录，查询列表用：.list()


    //降序
    LambdaQueryWrapper<实体类> queryWrapper = new LambdaQueryWrapper<>();

    queryWrapper.orderByAsc(实体类::需要排序的字段)
    
    //判断Name不为空时 执行
     queryWrapper.eq(User.getName() != null,User::getName,xiaotang);

    
    //更新
      LambdaUpdateWrapper<User> wrapper = new LambdaUpdateWrapper<>();
      wrapper.eq(User::getName, xiaotang);
      wrapper.set(User::getPassWord, 123456);

    //SQL:update User set passWord = 123456 where Name = xiaotang