场景:
代码中一段生成创建临时表的sql,会将number类型的创建成超过38位最大值,比如number(39,4)。问题原因无法找到,估计是跟数据库有关系,所以现在通过正则查,一但发现有违规数据,就改变。
测试代码:
package snippet;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
public class Snippet {
public static void main(String[] args) {
//错误sql
String a = "create table RepSysNav006_zhangsh(FDETAIL NUMBER(68,2112),FDETAILORSUM NUMBER(40),FKEYCODE CHAR(4))";
//Pattern pattern = Pattern.compile("(NUMBER[(](39|[4-9][0-9]|\\d{3,})(,\\d+)?[)])");
//Pattern pattern = Pattern.compile("(NUMBER[(](39|[4-9][0-9]|\\d{3,})(,\\d+)?[)])|(NUMBER[(]\\d+,(39|[4-9][0-9]|\\d{3,})[)])");
Pattern pattern = Pattern.compile("NUMBER[(]((39|[4-9][0-9]|\\d{3,})(,\\d+)?|\\d+,(39|[4-9][0-9]|\\d{3,}))[)]");
Matcher matcher = pattern.matcher(a);
StringBuffer sb = new StringBuffer();
while(matcher.find()){
String d= matcher.group().replaceAll("39|[4-9][0-9]|\\d{3,}", "38");
matcher.appendReplacement(sb, d);
}
matcher.appendTail(sb);
System.out.println(sb.toString());
}
}
最终代码: