java实现sql语句中 准确替换某个字符串

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;
    // 1*2 -2=0  2*2-2=2  3*2-2=4  4*2-2=6  5*2 -2=7  6*2-2=10 7*2-2=12   长度为14/2=7  计算出相应的值
    // [0,62, 341, 345, 384, 396, 402, 413, 419, 434, 439, 440, 459, 474, 479]
    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