优化Oracle大额IN查询：1000条以上处理策略

oracle  in 查询条件只能小于等于1000条 本人qq2627244788，欢迎咨询

//该方法已经过公司项目实测，提供2种方式供选择
public List<Map<String, String>> txUpdPlanFromAps(List<Map<String, String>> wbjhList) {
List<Map<String, String>> resultList = null;
List<Map<String, String>> temptList = new ArrayList<Map<String, String>>();
List<Map<String, String>> updList = new ArrayList<Map<String,String>>();
Map<String, String> resultMap  = new HashMap<String, String>();

Map<String, String> listMap  = new HashMap<String, String>();
String hyhhh = "";

// int k = 0;
        StringBuffer sb = new StringBuffer();  
        sb.append("("); 

//这种方法是拼接成 a.hyh in ('1','2','3',……) or a.hyh in ('4','5','6',……) or a.hyh in ('7','8','9',……) ……这种形式
       if(!wbjhList.isEmpty()&& null != wbjhList){ 
 
            if(wbjhList.size()>1000){  
                for(int i=0;i<wbjhList.size();i++){  
                    if((i+1)%1000 == 0){  
                        String temp = sb.substring(0, sb.length()-1);  
                        sb.delete(0, sb.length());  //左闭右开(既包含左,不包含右)
                        sb.append(temp);  

//在中间拼接特殊字符方式防止出现传入a =12 b=345，而数据库有a=123 b=45,拼接后都为12345
                        sb.append(") or a.hyh||'**'||a.hh in (");  
                        sb.append("'"+wbjhList.get(i).get("HYH")+"**"+wbjhList.get(i).get("HH")+"',");  
                    }else{