正则替换 sql语法 去掉字段中的引号，请大家帮帮我

Question

例如有一条插入语句
insert into table("id","name","remark") values ('1','test','[{"key1":"value1","key2":"value2"}]')
把字段中的引号去掉，替换后 （有多张表，表字段不固定有几个）
insert into table(id,name,remark) values ('1','test','[{"key1":"value1","key2":"value2"}]')

我的思路是 取 insert 和 values 之间的所有引号，但是这个不知道怎么写，有没有知道的

Answer 1

题主试试，测试正常。有帮助或启发麻烦点个采纳【本回答右上角】，谢谢~~

import java.util.regex.Pattern;
import java.util.regex.Matcher;
class t{
  public static void main(String[]args){
      String s="insert into table(\"id\",\"name\",\"remark\") values ('1','test','[{\"key1\":\"value1\",\"key2\":\"value2\"}]')\n"+
      "insert into table(\"id\",\"name\",\"remark\") values ('1','test','[{\"key1\":\"value1\",\"key2\":\"value2\"}]')\n"+
      "insert into table(\"id\",\"name\",\"remark\") values ('1','test','[{\"key1\":\"value1\",\"key2\":\"value2\"}]')\n";
      
      System.out.println(s);
      System.out.println("--------------------");

      String pattern = "\\([^\\)]+\\)\\s*values";
      Pattern p = Pattern.compile(pattern, Pattern.CASE_INSENSITIVE);
      Matcher m = p.matcher(s);
      StringBuffer sb = new StringBuffer();
      while (m.find())
      {
            String key = m.group(0);
            m.appendReplacement(sb, key.replace("\"",""));
      }
      m.appendTail(sb);
      s=sb.toString();
      System.out.println(sb.toString());
  }
}