我这里看见过一个简单的函数,是解决向HTML进行输入的: public static String toHTMLString(String in) { StringBuffer out = new StringBuffer(); for (int i = 0; in != null && i < in.length(); i++) { char c = in.charAt(i); if (c == '\'') { out.append("'"); } else if (c == '\"') { out.append("""); } else if (c == '<') { out.append("<"); } else if (c == '>') { out.append(">"); } else if (c == '&') { out.append("&"); } else { out.append(c); } } return out.toString(); }那位大侠能给我一个比较详细的对应表,类似于: ' : '' 将'换成'' -------------------------------- 万分感谢!!!
public static String toHTMLString(String in) { StringBuffer out = new StringBuffer(); for (int i = 0; in != null && i < in.length(); i++) { char c = in.charAt(i); if (c == '\'') { out.append("''"); } else { out.append(c); } } return out.toString(); } 试试!
达到:
select * from table1 where aa='aa''aaa'
就OK了!
public static String toHTMLString(String in) {
StringBuffer out = new StringBuffer();
for (int i = 0; in != null && i < in.length(); i++) {
char c = in.charAt(i);
if (c == '\'') {
out.append("'");
}
else if (c == '\"') {
out.append(""");
}
else if (c == '<') {
out.append("<");
}
else if (c == '>') {
out.append(">");
}
else if (c == '&') {
out.append("&");
}
else {
out.append(c);
}
}
return out.toString();
}那位大侠能给我一个比较详细的对应表,类似于:
' : '' 将'换成''
--------------------------------
万分感谢!!!
StringBuffer out = new StringBuffer();
for (int i = 0; in != null && i < in.length(); i++) {
char c = in.charAt(i);
if (c == '\'') {
out.append("''");
}
else {
out.append(c);
}
}
return out.toString();
}
试试!
String s="aaa'aaaa";
s.replace('\'','"');