Mybatis-plus Wrapper

最新推荐文章于 2024-03-06 16:57:24 发布

DCLe

最新推荐文章于 2024-03-06 16:57:24 发布

阅读量161

点赞数

CC 4.0 BY-SA版权

分类专栏： Spring Java 文章标签： java springboot mybatisplus

本文链接：https://blog.csdn.net/qq_45298704/article/details/123251136

Java 同时被 2 个专栏收录

43 篇文章

订阅专栏

Spring

10 篇文章

订阅专栏

本文详细介绍了SpringBoot中使用JPA的QueryWrapper进行数据查询、更新操作的方法，包括like、or、and等条件组合，以及Lambda表达式的使用，展示了如何构建灵活的查询和更新条件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

@SpringBootTest
public class WrapperTest {

    @Autowired
    private UserDao userDao;

    @Test
    void test01(){
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        queryWrapper.like("name","e").like("address","a");
        userDao.selectList(queryWrapper);
    }
    @Test
    void test02(){
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        queryWrapper.like("name","e").or().isNotNull("address").gt("id",10);
        User user = new User();
        user.setAddress("Beijing");
        userDao.update(user,queryWrapper);
    }

    @Test
    void test03(){
        //Lambda表达式中的条件先执行
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        queryWrapper.like("name","e").and(i->i.gt("id",10).or().likeLeft("address","B"));
        userDao.selectList(queryWrapper);
    }

    @Test
    void test04(){

        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        queryWrapper.select("name","address");
        userDao.selectMaps(queryWrapper);
    }

    @Test
    void test05(){
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        queryWrapper.inSql("name","select name from user where id > 9");
        userDao.selectList(queryWrapper);
    }

    @Test
    void test06(){
        UpdateWrapper<User> userUpdateWrapper = new UpdateWrapper<>();
        userUpdateWrapper.like("name","e").and(i -> i.like("address","a").or().gt("id",9));
        userUpdateWrapper.set("address","shanghai").set("phone_number","15285742566");
        userDao.update(null,userUpdateWrapper);
    }

    @Test
    void test07(){
        String name = "";
        String address = "shanghai";
        //创建条件构造器
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        if(StringUtils.isNotBlank(name)){
            queryWrapper.like("name",name);
        }
    }

    @Test
    void test08(){
        String name = "a";
        String address = "America";
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        queryWrapper.like(StringUtils.isNotBlank(name),"name",name)
                .likeLeft(StringUtils.isNotBlank(address),"address",address);
        userDao.selectList(queryWrapper);
    }


    //Lambda表达式解决字段名易写错
    @Test
    void test09(){
        String name = "a";
        String address = "America";
        LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        lambdaQueryWrapper.like(StringUtils.isNotBlank(name),User::getName,name).like(StringUtils.isNotBlank(address),User::getAddress,address);
        userDao.selectList(lambdaQueryWrapper);
    }

    @Test
    void test10(){
        LambdaUpdateWrapper<User> userUpdateWrapper = new LambdaUpdateWrapper<>();
        userUpdateWrapper.like(User::getName,"e").and(i -> i.like(User::getAddress,"a").or().gt(User::getId,9));
        userUpdateWrapper.set(User::getAddress,"shanghai").set(User::getPhoneNumber,"15285742566");
        userDao.update(null,userUpdateWrapper);
    }
}