實(shí)戰(zhàn):第三章:更新數(shù)據(jù)只能是下月修改,當(dāng)月不能修改

第一種:可以利用緩存,commissionMerchantsBean是傳入的參數(shù)對(duì)象

               //將合作對(duì)象更改后,應(yīng)該在下個(gè)月份才生效
                //根據(jù)merchants_id查詢tst_commission_merchants表獲取import_partner_employee_id
                CommissionMerchantsBean merchantsBean = commissionDaoC.getCommissionMerchants(commissionMerchantsBean);
                //獲取緩存中的生效時(shí)間
                String effectTimeImport = RedisUtils.getKey("effectTimeImport:" + commissionMerchants.getCommission_merchants_id());
                String effectTimeRelation = RedisUtils.getKey("effectTimeRelation:" + commissionMerchants.getCommission_merchants_id());
                if(tst.project.utils.StringUtils.isEmpty(effectTimeImport)){
                    //如果為空,設(shè)置緩存
                    RedisUtils.setKey("effectTimeImport:" + commissionMerchants.getCommission_merchants_id(),String.valueOf(TimeUtils.dateToStr(nextMonthStartTimes,"yyyy-MM")));
                }
                //重新獲取
                String effectTimeImport2 = RedisUtils.getKey("effectTimeImport:" + commissionMerchants.getCommission_merchants_id());
                //導(dǎo)入的生效日期不等于當(dāng)月的則將傳入的import_partner_employee_id設(shè)置為庫(kù)中原來(lái)的數(shù)據(jù)
                if(effectTimeImport2.compareTo(TimeUtils.dateToStr(new Date(),"yyyy-MM")) != 0){
                    //如果不為空,且緩存中的日期是幾個(gè)月前的設(shè)置下月為生效日期
                    RedisUtils.setKey("effectTimeImport:" + commissionMerchants.getCommission_merchants_id(),String.valueOf(TimeUtils.dateToStr(nextMonthStartTimes,"yyyy-MM")));
                    //設(shè)置導(dǎo)入合作對(duì)象員工id為原來(lái)的數(shù)據(jù)
                    String importPartnerEmployeeId = merchantsBean.getImport_partner_employee_id();
                    commissionMerchantsBean.setImport_partner_employee_id(importPartnerEmployeeId);
                }
                if(tst.project.utils.StringUtils.isEmpty(effectTimeRelation)){
                    //如果為空,設(shè)置緩存
                    RedisUtils.setKey("effectTimeRelation:" + commissionMerchants.getCommission_merchants_id(),String.valueOf(TimeUtils.dateToStr(nextMonthStartTimes,"yyyy-MM")));
                }
                //重新獲取
                String effectTimeRelation2 = RedisUtils.getKey("effectTimeRelation:" + commissionMerchants.getCommission_merchants_id());
                //關(guān)聯(lián)的生效日期不等于當(dāng)月的則將傳入的relation_partner_employee_id設(shè)置為庫(kù)中原來(lái)的數(shù)據(jù)
                if(effectTimeRelation2.compareTo(TimeUtils.dateToStr(new Date(),"yyyy-MM")) != 0){
                    //如果不為空,且緩存中的日期是幾個(gè)月前的設(shè)置下月為生效日期
                    RedisUtils.setKey("effectTimeRelation:" + commissionMerchants.getCommission_merchants_id(),String.valueOf(TimeUtils.dateToStr(nextMonthStartTimes,"yyyy-MM")));
                    //設(shè)置關(guān)聯(lián)合作對(duì)象員工id為原來(lái)的數(shù)據(jù)
                    String relationPartnerEmployeeId = merchantsBean.getRelation_partner_employee_id();
                    commissionMerchantsBean.setRelation_partner_employee_id(relationPartnerEmployeeId);
                }
                //設(shè)置生效時(shí)間為下個(gè)月
                int num=commissionDaoC.updateCommissionMerchants(commissionMerchantsBean);
                if(num<=0){
                    throw new AppException("更新失敗!");
                }

第二種:可以利用定時(shí)任務(wù)

第三種:可以使用信息隊(duì)列