Java 新增修改的时候数据和数据库已有的数据做对比，限制某些数据不重复

本文链接：https://blog.csdn.net/zheshihuahua/article/details/138073976

新增的时候，数据和数据库已有的数据做对比，如果有相同的就新增失败！！！

 @ApiOperation("添加")
    @PostMapping()
    public ApiResult<?> save(@RequestBody EmerResource emerResource) {
        List<EmerResource> emerList = emerResourceService.list(new QueryWrapper<EmerResource>().eq("emer_resource_code",emerResource.getEmerResourceCode()));
        if(emerList.size()>0)
            return fail("添加失败，应急资源编号已存在");

        List<EmerResource> emerList1 = emerResourceService.list(new QueryWrapper<EmerResource>().eq("emer_resource_name",emerResource.getEmerResourceName()));
        if(emerList1.size()>0)
            return fail("添加失败，应急资源名称已存在");
        User user = getLoginUser();
        LocalDateTime localDateTime = LocalDateTime.now();
        emerResource.setCreateTime(localDateTime);
        emerResource.setCreUserId(Long.valueOf(user.getUserId()));
        emerResource.setCreUserName(user.getUsername());
        if (emerResourceService.save(emerResource)) {
            return success("添加成功");
        }
        return fail("添加失败");
    }

修改的时候，数据和数据库已有的数据做对比，如果有相同的就修改失败！！！

 @ApiOperation("修改")
    @PutMapping()
    public ApiResult<?> update(@RequestBody EmerResource emerResource) {
        List<EmerResource> emerList = emerResourceService.list(new QueryWrapper<EmerResource>().eq("emer_resource_code",emerResource.getEmerResourceCode()).ne("emer_resource_id",emerResource.getEmerResourceId()));
        if(emerList.size()>0)
            return fail("修改失败，应急资源编号已存在");

        List<EmerResource> emerList1 = emerResourceService.list(new QueryWrapper<EmerResource>().eq("emer_resource_name",emerResource.getEmerResourceName()).ne("emer_resource_id",emerResource.getEmerResourceId()));
        if(emerList1.size()>0)
            return fail("修改失败，应急资源名称已存在");

        User user = getLoginUser();
        LocalDateTime localDateTime = LocalDateTime.now();
        emerResource.setUpdateTime(localDateTime);
        emerResource.setUpdUserName(user.getUsername());
        emerResource.setUpdUserId(Long.valueOf(user.getUserId()));
        if (emerResourceService.updateById(emerResource)) {
            return success("修改成功");
        }
        return fail("修改失败");
    }