如何添加数据唯一校验？

分为三种场景：

1. 多字段联合唯一校验；
2. 单字段个性化唯一校验；
3. 多字段唯一校验；

如何使用框架提供的唯一校验功能？

多字段联合唯一校验

以PartyLevel.java为例

• 创建唯一校验器

    DefaultColumn typeColumn = new DefaultColumn("type", "type_", "参与者类型");// 唯一字段
    DefaultColumn levelColumn = new DefaultColumn("level", "level_", "等级值");// 唯一字段
    UniquePropertyValidation validation // 唯一校验器
        = new UniquePropertyValidation(PartyLevel.class, typeColumn, levelColumn);

• 设置唯一校验器

    getDao().getUniquePropertyValidator().setValidation(validation);

• 设置仓库对象

    getDao().getUniquePropertyValidator().setRepository(partyLevelRepository);

• 完整代码

    @Override
    protected void init() {
        DefaultColumn typeColumn = new DefaultColumn("type", "type_", "参与者类型");
        DefaultColumn levelColumn = new DefaultColumn("level", "level_", "等级值");
        UniquePropertyValidation validation 
            = new UniquePropertyValidation(PartyLevel.class, typeColumn, levelColumn);
        getDao().getUniquePropertyValidator().setValidation(validation);
        getDao().getUniquePropertyValidator().setRepository(partyLevelRepository);
    }

单字段个性化唯一校验；

以BoDef.java为例

• 创建唯一校验器

    DefaultColumn codeColumn = new DefaultColumn("code", "code_", "编码");
    UniquePropertyValidation validation 
        = new UniquePropertyValidation(BoDef.class, codeColumn);

• 设置唯一校验器

    getDao().getUniquePropertyValidator().setValidation(validation);

• 设置仓库对象

    getDao().getUniquePropertyValidator().setRepository(boDefRepository);

• 创建新增数据唯一校验函数

    // 函数式校验数据库是否存在
    Function<Object, Boolean> existInDBExecution = (po) -> {
        if(BeanUtils.isEmpty(po)) {
            return false;
        }

        BoDefPo boDefPo = (BoDefPo) po;
        boDefRepository.setSkipCache("0");// 禁用缓存，否则出现数据冲突
        boolean succ = boDefRepository.isExists(boDefPo);
        boDefRepository.setSkipCache(null);
        return succ;
    };
    ((UniquePropertyValidator)(getDao().getUniquePropertyValidator())).setExistInDBExecutionForInsert(existInDBExecution);

• 创建更新数据唯一校验函数

    // 函数式校验数据库是否存在
    Function<Object, Boolean> existInDBExecution = (po) -> {
        if(BeanUtils.isEmpty(po)) {
            return false;
        }

        boDefRepository.setSkipCache("0");// 禁用缓存，否则出现数据冲突
        boolean succ = boDefRepository.isExists(boDefPo);
        boDefRepository.setSkipCache(null);
        return succ;
    };
    ((UniquePropertyValidator)(getDao().getUniquePropertyValidator())).setExistInDBExecutionForUpdate(existInDBExecution);

• 完整代码

    @Override
    protected void init() {
        DefaultColumn codeColumn = new DefaultColumn("code", "code_", "编码");
        UniquePropertyValidation validation 
            = new UniquePropertyValidation(BoDef.class, codeColumn);
        getDao().getUniquePropertyValidator().setValidation(validation);
        getDao().getUniquePropertyValidator().setRepository(boDefRepository);

        // 函数式校验数据库是否存在
        Function<Object, Boolean> existInDBExecution = (po) -> {
            if(BeanUtils.isEmpty(po)) {
                return false;
            }

            BoDefPo boDefPo = (BoDefPo) po;
            boDefRepository.setSkipCache("0");// 禁用缓存，否则出现数据冲突
            boolean succ = boDefRepository.isExists(boDefPo);
            boDefRepository.setSkipCache(null);
            return succ;
        };
        ((UniquePropertyValidator)(getDao().getUniquePropertyValidator())).setExistInDBExecutionForInsert(existInDBExecution);
        ((UniquePropertyValidator)(getDao().getUniquePropertyValidator())).setExistInDBExecutionForUpdate(existInDBExecution);
    }

多字段唯一校验；

以PartyEmployee.java为例

• 创建唯一校验器

    DefaultColumn accountColumn = new DefaultColumn("account", "ACCOUNT_", "账号");
    DefaultColumn wechatColumn = new DefaultColumn("wcAccount", "WC_ACCOUNT_", "微信号");
    DefaultColumn emailColumn = new DefaultColumn("email", "EMAIL_", "邮箱");
    DefaultColumn mobileColumn = new DefaultColumn("mobile", "MOBILE_", "手机号码");
    UniquePropertyValidation validation 
        = new UniquePropertyValidation(PartyLevel.class, accountColumn, wechatColumn, emailColumn, mobileColumn);

• 设置唯一校验器

    getDao().getUniquePropertyValidator().setValidation(validation);

• 设置仓库对象

    getDao().getUniquePropertyValidator().setRepository(partyEmployeeRepository);

• 设置多字段数据唯一校验属性

    ((UniquePropertyValidator)(getDao().getUniquePropertyValidator())).setSingleUniqueValue(true);

• 完整代码

    @Override
    protected void init() {
        DefaultColumn accountColumn = new DefaultColumn("account", "ACCOUNT_", "账号");
        DefaultColumn wechatColumn = new DefaultColumn("wcAccount", "WC_ACCOUNT_", "微信号");
        DefaultColumn emailColumn = new DefaultColumn("email", "EMAIL_", "邮箱");
        DefaultColumn mobileColumn = new DefaultColumn("mobile", "MOBILE_", "手机号码");
        UniquePropertyValidation validation 
            = new UniquePropertyValidation(PartyLevel.class, accountColumn, wechatColumn, emailColumn, mobileColumn);
        getDao().getUniquePropertyValidator().setValidation(validation);
        getDao().getUniquePropertyValidator().setRepository(partyEmployeeRepository);
        ((UniquePropertyValidator)(getDao().getUniquePropertyValidator())).setSingleUniqueValue(true);
    }

函数入参Object，返回值Boolean；
函数用法请自行查阅JDK1.8新特性Function编程；