mybatisPlus——LambdaQueryWrapper常用方法

最新推荐文章于 2024-06-13 11:50:22 发布

待我学业归来。

最新推荐文章于 2024-06-13 11:50:22 发布

阅读量773

点赞数 7

文章标签： java

本文链接：https://blog.csdn.net/qq_44859586/article/details/136674457

版权

在这里插入图片描述

1.Service继承 IService

public interface WritCoercivedecisionProperService extends IService<WritCoercivedecisionProper>

在这里插入图片描述

2.ServiceImpl继承ServiceImpl

public class WritCoercivedecisionProperServiceImpl extends ServiceImpl<WritCoercivedecisionProperMapper, WritCoercivedecisionProper>  implements WritCoercivedecisionProperService

在这里插入图片描述

3.Mapper继承BaseMapper

public interface WritCoercivedecisionProperMapper extends BaseMapper<WritCoercivedecisionProper>

在这里插入图片描述

4.基础用法

方法一：使用LambdaUpdateWrapper
        LambdaUpdateWrapper<WritCoercivedecisionProper> wrapper = new LambdaUpdateWrapper<>();
        wrapper.eq(WritCoercivedecisionProper::getCoercivedecision, writCoercivedecisionProper.getCoercivedecision());

方法二:使用QueryWrapper
        QueryWrapper<WritCoercivedecisionProper> wrapper = new QueryWrapper<>();
        wrapper.eq("coercivedecision", writCoercivedecisionProper.getCoercivedecision());

4.1修改

//使用service
        writCoercivedecisionProperService.update(new LambdaUpdateWrapper<WritCoercivedecisionProper>()
                .eq(WritCoercivedecisionProper::getId, writCoercivedecisionProper.getCoercivedecision())
                .set(WritCoercivedecisionProper::getIdentity,writCoercivedecisionProper.getIdentity()));

//使用mapper（方法一）
        UpdateWrapper<WritCoercivedecisionProper> wrapper = new UpdateWrapper<>();
        wrapper.set("coercivedecision", writCoercivedecisionProper.getCoercivedecision());
        wrapper.eq("ID",writCoercivedecisionProper.getId());
        int flag = writCoercivedecisionProperMapper.update(writCoercivedecisionProper,wrapper);   
            
//		   （方法二：如果第一个参数为null，代表仅根据UpdateWrapper中指定的条件和字段进行更新；如果有传入实体类，会根据实体对象的非空字段更新数据库中对应记录，并且会结合UpdateWrapper中指定的条件和字段进行更新）
        int flag = writCoercivedecisionProperMapper.update(null, Wrappers.<WritCoercivedecisionProper>update()
                .set("coercivedecision", writCoercivedecisionProper.getCoercivedecision())
                .eq("ID", writCoercivedecisionProper.getId()));

4.2查询

//使用service     
        List<WritCoercivedecisionProper> writCoercivedecisionProperList=writCoercivedecisionProperService.list(
                new LambdaQueryWrapper<WritCoercivedecisionProper>()
                        .eq(WritCoercivedecisionProper::getCoercivedecision, writCoercivedecisionProper.getCoercivedecision()));
        

//使用mapper（方法一）
        QueryWrapper<WritCoercivedecisionProper> queryWrapper = new QueryWrapper<WritCoercivedecisionProper>();
        queryWrapper.eq("id",writCoercivedecisionProper.getId());
        List<WritCoercivedecisionProper> userInfoList = writCoercivedecisionProperMapper.selectList(queryWrapper);

//		   （方法二）
        List<WritCoercivedecisionProper> list = writCoercivedecisionProperMapper.selectList(Wrappers.<WritCoercivedecisionProper>lambdaQuery()
                        .eq(WritCoercivedecisionProper::getCoercivedecision, writCoercivedecisionProper.getCoercivedecision())
                        .eq(WritCoercivedecisionProper::getName,writCoercivedecisionProper.getName()));