static String buildInsertSql(String table, String[] fields) {
// TODO:
StringBuilder sb = new StringBuilder();
sb.append("INSERT INTO ").append(table).append(" (");
for(int i=0;i<fields.length;i++) {
if(i == fields.length - 1) {
sb.append(fields[i]);
} else {
sb.append(fields[i]+", ");
}
sb.append(") VALUES (?, ?, ?)");
return sb.toString();
Sign in to make a reply
卖西瓜的猪八戒
static String buildInsertSql(String table, String[] fields) {
// TODO:
StringBuilder sb = new StringBuilder();
sb.append("INSERT INTO ").append(table).append(" (");
for(int i=0;i<fields.length;i++) {
if(i == fields.length - 1) {
sb.append(fields[i]);
} else {
sb.append(fields[i]+", ");
}
}
sb.append(") VALUES (?, ?, ?)");
return sb.toString();
}