static String buildInsertSql(String table, String[] fields) {
var sb = new StringBuilder("INSERT INTO ");
sb.append(table).append(" (");
for (int i = 0;i < fields.length;i++){
if (i == 2){
sb.append(fields[i]);
}else{
sb.append(fields[i]).append(", ");
}
sb.append(") VALUES (?, ?, ?)");
return sb.toString();
Sign in to make a reply
长沙亚里士多德
static String buildInsertSql(String table, String[] fields) {
var sb = new StringBuilder("INSERT INTO ");
sb.append(table).append(" (");
for (int i = 0;i < fields.length;i++){
if (i == 2){
sb.append(fields[i]);
}else{
sb.append(fields[i]).append(", ");
}
}
sb.append(") VALUES (?, ?, ?)");
return sb.toString();
}