實戰(zhàn):第三章:更新數(shù)據(jù)只能是下月修改,當月不能修改
第一種:可以利用緩存,commissionMerchantsBean是傳入的參數(shù)對象
//將合作對象更改后,應該在下個月份才生效
//根據(jù)merchants_id查詢tst_commission_merchants表獲取import_partner_employee_id
CommissionMerchantsBean merchantsBean = commissionDaoC.getCommissionMerchants(commissionMerchantsBean);
//獲取緩存中的生效時間
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());
//導入的生效日期不等于當月的則將傳入的import_partner_employee_id設(shè)置為庫中原來的數(shù)據(jù)
if(effectTimeImport2.compareTo(TimeUtils.dateToStr(new Date(),"yyyy-MM")) != 0){
//如果不為空,且緩存中的日期是幾個月前的設(shè)置下月為生效日期
RedisUtils.setKey("effectTimeImport:" + commissionMerchants.getCommission_merchants_id(),String.valueOf(TimeUtils.dateToStr(nextMonthStartTimes,"yyyy-MM")));
//設(shè)置導入合作對象員工id為原來的數(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)的生效日期不等于當月的則將傳入的relation_partner_employee_id設(shè)置為庫中原來的數(shù)據(jù)
if(effectTimeRelation2.compareTo(TimeUtils.dateToStr(new Date(),"yyyy-MM")) != 0){
//如果不為空,且緩存中的日期是幾個月前的設(shè)置下月為生效日期
RedisUtils.setKey("effectTimeRelation:" + commissionMerchants.getCommission_merchants_id(),String.valueOf(TimeUtils.dateToStr(nextMonthStartTimes,"yyyy-MM")));
//設(shè)置關(guān)聯(lián)合作對象員工id為原來的數(shù)據(jù)
String relationPartnerEmployeeId = merchantsBean.getRelation_partner_employee_id();
commissionMerchantsBean.setRelation_partner_employee_id(relationPartnerEmployeeId);
}
//設(shè)置生效時間為下個月
int num=commissionDaoC.updateCommissionMerchants(commissionMerchantsBean);
if(num<=0){
throw new AppException("更新失敗!");
}
第二種:可以利用定時任務
第三種:可以使用信息隊列