场景:
找出两个有序队列的相同值与不同值,数据库中存在队列A,需要更新为队列B,队列A包含且队列B不包含的删除,队列A不包含且队列B包含的插入,队列A包含且队列B包含更新。以下以古代一夫多妻制为例:
public void update(Integer manId,List<Integer> paramList){
List<Integer> dbList = demoMapper.queryWomanList(manId);
Collections.sort(dbList);
Collections.sort(paramList);
int dbSize = null == dbList ? 0 : dbList.size();
int paramSize = null == paramList ? 0 : paramList.size();
int dbIter = 0;
int paramIter = 0;
while(dbIter < dbSize || paramIter < paramSize){
if(dbIter == dbSize){
demoMapper.insert(manId, paramList.get(paramIter));
paramIter += 1;
continue;
}
if(paramIter == paramSize){
demoMapper.delete(manId, dbList.get(dbIter));
dbIter += 1;
continue;
}
if(dbList.get(dbIter).intValue() == paramList.get(paramIter).intValue()){
//do update
dbIter += 1;
paramIter += 1;
}else if(dbList.get(dbIter).intValue() > paramList.get(paramIter).intValue()){
demoMapper.insert(manId, paramList.get(paramIter));
paramIter += 1;
}else{
demoMapper.delete(manId, dbList.get(dbIter));
dbIter += 1;
}
}
}