static String buildInsertSql(String table, String[] fields) {
// TODO:
var sb = new StringBuilder(1024);
sb.append("INSERT ")
.append("INTO ")
.append(table)
.append(" (");
for (String field:fields){
sb.append(field);
if(!field.equals("salary"))
sb.append(", ");
}
sb.append(") VALUES (?, ?, ?)");
System.out.println(sb.toString());
return sb.toString();
Sign in to make a reply
Carol-zyl
static String buildInsertSql(String table, String[] fields) {
// TODO:
var sb = new StringBuilder(1024);
sb.append("INSERT ")
.append("INTO ")
.append(table)
.append(" (");
for (String field:fields){
sb.append(field);
if(!field.equals("salary"))
sb.append(", ");
}
sb.append(") VALUES (?, ?, ?)");
System.out.println(sb.toString());
return sb.toString();
}