private String getSqlString(String string) {
String[] split = string.split(",");
String newStr = "";
for (String str : split) {
newStr += ",";
if (countStr(str, "'") % 2 == 1) {
if (str.startsWith("''")) {
str = str.substring(1);
str = "'\\" + str;
} else if (str.endsWith("''")) {
String s = str.replaceAll("'", "");
String s2 = s+"\\";
str = str.replace(s,s2);
}
newStr += str;
} else {
newStr += str;
}
}
newStr = newStr.substring(1);
return newStr;
}
功能概述:
传入一个字符串,自动将头尾单数引号( ' )加上反斜杠转义( \ )
例:
//头部加引号
String str = "'111','222',''333'";
String s = getSqlString(str);
//s输出:"'111','222','\'333'"
//尾部加引号
String str2 = "'444','555','666''";
String s2 = getSqlString(str2);
//s2输出:"'444','555','666\''"