Discuss / Java / 练习

练习

Topic source

保持热爱

#1 Created at ... [Delete] [Delete and Lock User]
static String buildInsertSql(String table, String[] fields) {    StringBuilder fieldNames = new StringBuilder(" (")            .append(String.join(", ", fields))            .append(") ");    StringBuilder values = new StringBuilder(" (");    for (int i = 0; i < fields.length; i++) {        if (i == fields.length - 1) {            values.append("?")                    .append(")");        } else {            values.append("?, ");        }    }    StringBuilder sql = new StringBuilder()            .append("INSERT INTO ")            .append(table)            .append(fieldNames)            .append("VALUES")            .append(values);    return sql.toString();}

  • 1

Reply