在MySQL concat里面使用多個(gè)單引號(hào),三引號(hào)的問題

mysql> select concat('drop user ''''@', '''', @@hostname, '''');
+----------------------------------------------------+
| concat('drop user ''''@', '''', @@hostname, '''') |
+----------------------------------------------------+
| drop user ''@'bei-f0q5bc2.gemalto.com'       |
+----------------------------------------------------+
1 row in set (0.00 sec)

String needInsertStr= 單雙引號(hào)的字符串;

String finalStr = needInsertStr.replaceAll("'", "\\\\\'"); //作用等于在單引號(hào)前面加上轉(zhuǎn)義符號(hào)\
//對(duì)于其他特殊字符也是一樣

long dateMillions = System.currentTimeMillis();

StringBuilder stringBuilder = new StringBuilder();
stringBuilder.append("insert into ");
stringBuilder.append(tableName);
stringBuilder.append("(uuid,name,metric_id,service_id,script,deleted,created,updated) ");
stringBuilder.append("values(uuid(),'");
stringBuilder.append(name);
stringBuilder.append("','");
stringBuilder.append(name);
stringBuilder.append("','");
stringBuilder.append(serviceId);
stringBuilder.append("','");
stringBuilder.append(finalStr);
stringBuilder.append("',0,");
stringBuilder.append(dateMillions);
stringBuilder.append(",");
stringBuilder.append(dateMillions);
stringBuilder.append(")");

return stringBuilder.toString();

// script字段即是帶單雙引號(hào)的字符串