Discuss / Java / buildInsertSql练习
Back

buildInsertSql练习

Topic source

scutbeyond

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

scutbeyond

#2 Created at ... [Delete] [Delete and Lock User] 
static String buildInsertSql(String table, String[] fields) {
    StringBuilder sb = new StringBuilder();
    sb.append("INSERT INTO ").append(table).append(" (");

    for (int i = 0; i < fields.length; i++) {
        sb.append(fields[i]);
        if (i < fields.length-1) {
            sb.append(", ");
        }
    }

    sb.append(") VALUES (");

    for (int i = 0; i < fields.length; i++) {
        sb.append("?");
        if (i < fields.length-1) {
            sb.append(", ");
        }
    }
    sb.append(")");

    return sb.toString();
}
  • 1

Reply