向StringBuffer字符串中插入字符 无聊乱写
StringBuffer a = new StringBuffer();
a.append("select aaa from table group by id,name order by name");
int k = a.indexOf("group by");
a.insert(k+8, " department, ");
System.out.println("k="+k+" SQL="+a.toString());
//替换功能
StringBuffer a = new StringBuffer();
a.append("SELECT (SELECT SUMC(SS_AUTHENTICATION_ITEM.Qualification_Type) FROM SS_AUTHENTICATION_ITEM WHERE SS_AUTHENTICATION_ITEM.FIVE_ROLE_ID = SS_FIVE_ROLE.FIVE_ROLE_ID) QUALIFICATION_TYPE, (SELECT SUMC(DECODE(SS_AUTHENTICATION_ITEM.Qualification, '--请选择--', '', SS_AUTHENTICATION_ITEM.QUALIFICATION)) FROM SS_AUTHENTICATION_ITEM WHERE SS_AUTHENTICATION_ITEM.FIVE_ROLE_ID = SS_FIVE_ROLE.FIVE_ROLE_ID) QUALIFICATION_A, SS_FIVE_ROLE.FIVE_ROLE_ID, SS_FIVE_ROLE.USER_ID, SS_FIVE_ROLE.NAME, SS_FIVE_ROLE.DEPARTMENT_ID,SS_FIVE_ROLE.DEPARTMENT,SS_FIVE_ROLE.USER_CODE, SS_FIVE_ROLE.DUTY,SS_FIVE_ROLE.QUALIFICATION,SS_FIVE_ROLE.REMARK,SS_FIVE_ROLE.YEAR,SS_FIVE_ROLE.UNIT_TYPE,SS_FIVE_ROLE.ACCOUNT,SS_FIVE_ROLE.PASSWORD,SS_FIVE_ROLE.SUB_DEPARTMENT_ID,SS_FIVE_ROLE.SUB_DEPARTMENT_NAME,SS_FIVE_ROLE.BATCH,SS_FIVE_ROLE.PECCANCYRECORD,SS_FIVE_ROLE.GENDER,SS_FIVE_ROLE.START_YEAR,SS_FIVE_ROLE.END_YEAR,SS_FIVE_ROLE.TELEPHONE,SS_FIVE_ROLE.PERSON_AGE,SS_FIVE_ROLE.LENGTH_SERVICE,SS_FIVE_ROLE.TYPE_WORK,SS_FIVE_ROLE.KIND,SS_FIVE_ROLE.FROM_BUREAU_NO,SS_FIVE_ROLE.FROM_BUREAU_NAME FROM SS_FIVE_ROLE WHERE (UNIT_TYPE = 0) ORDER BY BATCH asc");
int k = a.indexOf("ORDER BY BATCH");
a.replace(k+8, k+14, " instr('第一批第二批第三批第四批第五批第六批第七批第八批第九批第十批',BATCH)");
System.out.println(a.toString());
