static String buildInsertSql(String table, String[] fields) {
// TODO:
StringBuilder sb = new StringBuilder("INSERT INTO ");
StringBuilder fieldsStr = new StringBuilder();
StringBuilder valuesStr = new StringBuilder();
for (int i = 0; i < fields.length; i++) {
if (fields.length != (i + 1)) {
fieldsStr.append(fields[i]).append(", ");
valuesStr.append("?, ");
} else {
fieldsStr.append(fields[i]);
valuesStr.append("?");
}
sb.append(table)
.append(" (")
.append(fieldsStr)
.append(") VALUES (")
.append(valuesStr)
.append(")");
return sb.toString();
Sign in to make a reply
Hisen_Sun
static String buildInsertSql(String table, String[] fields) {
// TODO:
StringBuilder sb = new StringBuilder("INSERT INTO ");
StringBuilder fieldsStr = new StringBuilder();
StringBuilder valuesStr = new StringBuilder();
for (int i = 0; i < fields.length; i++) {
if (fields.length != (i + 1)) {
fieldsStr.append(fields[i]).append(", ");
valuesStr.append("?, ");
} else {
fieldsStr.append(fields[i]);
valuesStr.append("?");
}
}
sb.append(table)
.append(" (")
.append(fieldsStr)
.append(") VALUES (")
.append(valuesStr)
.append(")");
return sb.toString();
}