StringBuilder s = new StringBuilder("INSERT INTO VALUES (?, ?, ?)");
s.insert(11, " " + table);
StringBuilder s2 = new StringBuilder();
s2.insert(0,"(");
for (int i = 0; i < fields.length; i++) {
s2.append(fields[i]);
if (i < fields.length - 1) {
s2.append(", ");
}
s2.insert(s2.lastIndexOf("y")+1,")" );
s.insert(20," "+ s2);
return s.toString();
Sign in to make a reply
不晓
StringBuilder s = new StringBuilder("INSERT INTO VALUES (?, ?, ?)");
s.insert(11, " " + table);
StringBuilder s2 = new StringBuilder();
s2.insert(0,"(");
for (int i = 0; i < fields.length; i++) {
s2.append(fields[i]);
if (i < fields.length - 1) {
s2.append(", ");
}
}
s2.insert(s2.lastIndexOf("y")+1,")" );
s.insert(20," "+ s2);
return s.toString();