1.java 代码实现
public static void main(String[] args) {
String sqls = "select pk_marbasclass from marbasclass where 11=11 and (enablestate = 2) and ((pk_org = '0001A210000000000EO5')) and code in(123) and ( marbasclass.inner like 'ULX1%' or marbasclass.inner like '8FYZ%' or marbasclass.inner like 'VVWF%' or marbasclass.inner like 'OHQR%' or marbasclass.inner like '4Q6G%' or marbasclass.inner like 'BMKG%' or marbasclass.inner like 'KAGS%' )";
List<Integer> locations = new ArrayList<Integer>();
List<Integer> sqlInnerBacketLocation = getSqlInnerBacketLocation(sqls, (ArrayList<Integer>) locations);
String replaceSql = getReplaceSql(sqls, locations.toArray(new Integer[locations.size()]));
}
private static String getReplaceSql(String whereSql, Integer[] blacketLocations) {
String renewStr =whereSql;
int startOffset=0;
int endOffsetChip =0;
for(int i=1; i<= blacketLocations.length>>1 ;i++) {
if(i==1){
startOffset=0 ;
endOffsetChip=blacketLocations[i-1];
}else{
startOffset=blacketLocations[i*2-3];
endOffsetChip=blacketLocations[i*2-2];
}
String subWheresql =whereSql.substring(startOffset, endOffsetChip);
boolean hasC