1.环境:springboot + mybatis plus
2.构造器解析
1). QueryWrapper: Entity 对象封装操作类
2). UpdateWrapper : Update 条件封装,用于Entity对象更新操作
2). 条件构造器使用中的各个方法格式和说明
3.示例
1)UpdateWrapper 实例
UpdateWrapper<CarEntity> ew = new UpdateWrapper<>(); ew.lambda().set(CarEntity::getTerminalcode,null) .set(CarEntity::getTerminalid,null) .set(CarEntity::getModifiedon,LocalDateTime.now()) .eq(CarEntity::getCarid,cEntity.getCarid()); this.carMapper.update(null, ew); 2)QueryWrapper 实例一
CarEntity Entity = this.carMapper.selectOne(new QueryWrapper<CarEntity>().lambda().eq(CarEntity::getTerminalid, tEntity.getTerminalid()));
3)QueryWrapper 实例二
int count = this.baseMapper.selectCount(new QueryWrapper<DataprivilegeEntity>() .lambda() .eq(DataprivilegeEntity::getDataprivilegetype, 1) .eq(DataprivilegeEntity::getDataprivilegeid, car) .eq(DataprivilegeEntity::getPrincipalid, request.getStationid()));
4)QueryWrapper 实例二
QueryWrapper<CarEntity> queryWrapper = new QueryWrapper<>(); queryWrapper.lambda().select(CarEntity::getCarid) .notInSql(CarEntity::getCarid, "select dataprivilegeid from sysdataprivilege where principaltype = 1 and dataprivilegetype = 1 and datatype = 1 and principalid = '" + request.getStationid() + "'"); List<Object> list = carService.getBaseMapper().selectObjs(queryWrapper); list.forEach(p -> { DataprivilegeEntity entity = new DataprivilegeEntity(); entity.setDataprivilegetype(1); entity.setDatatype(1); entity.setPrincipaltype(1); entity.setPrincipalid(request.getStationid()); entity.setDataprivilegeid(p.toString()); entity.setSysdataprivilegeid(UUID.randomUUID().toString()); this.baseMapper.insert(entity);