模糊匹配并替换

//将所有类似NUMBER(9,0)的字段类型改成Memo

  String tag = "NUMBER\\(([\\w\\W\\s]*?)\\)";

  Pattern ptag = Pattern.compile(tag);

  Matcher mtag = ptag.matcher(createTableSql);

  while (mtag.find()) {

  createTableSql=createTableSql.replace(mtag.group(0).trim(), "Memo");

  }