static String buildInsertSql(String table, String[] fields) {
if (fields.length==0||"".equals(table)) {
return "ERROR PARAMS!";
}
StringBuilder sql = new StringBuilder();
sql.append("INSERT INTO ")
.append(table).append(" ")
.append("(").append(String.join(", ", fields))
.append(") VALUES (");
for (int i=0;i<fields.length;i++) {
fields[i]="?";
sql.append(String.join(", ", fields)).append(")");
return sql.toString();
Sign in to make a reply
_崔先生_
static String buildInsertSql(String table, String[] fields) {
if (fields.length==0||"".equals(table)) {
return "ERROR PARAMS!";
}
StringBuilder sql = new StringBuilder();
sql.append("INSERT INTO ")
.append(table).append(" ")
.append("(").append(String.join(", ", fields))
.append(") VALUES (");
for (int i=0;i<fields.length;i++) {
fields[i]="?";
}
sql.append(String.join(", ", fields)).append(")");
return sql.toString();
}