String newst = "select substr(SIGNEDDATE,1,7) SIGNEDDATE, MANAGER MANAGER, sum(MONEY) MONEY from PJ_PROGRAM where 1=1 group by substr(SIGNEDDATE,1,7), MANAGER";
String rest = " substr(SIGNEDDATE,1,7) SIGNEDDATE,";//convert "(" and ")" to "\(" and "\)"
rest = rest.replaceAll("\\(","\\\\\\(");
rest = rest.replaceAll("\\)","\\\\\\)");String tmp = newst.replaceAll(rest, "");
String rest = " substr(SIGNEDDATE,1,7) SIGNEDDATE,";//convert "(" and ")" to "\(" and "\)"
rest = rest.replaceAll("\\(","\\\\\\(");
rest = rest.replaceAll("\\)","\\\\\\)");String tmp = newst.replaceAll(rest, "");
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货