Discuss / Java / StringBuilder 练习
Back

StringBuilder 练习

Topic source

秦文轩Vincent

#1 Created at ... [Delete] [Delete and Lock User]

SQL 插入语句拼接：

static String buildInsertSql(String table, String[] fields) {    var sb = new StringBuilder();    sb.append("INSERT INTO ");    sb.append(table);    sb.append(" (");    sb.append(String.join(", ", fields));    sb.append(") VALUES (");    sb.append(String.join(", ", java.util.Collections.nCopies(fields.length, "?")));    sb.append(")");    return sb.toString();}

秦文轩Vincent

#2 Created at ... [Delete] [Delete and Lock User] 
    static String buildInsertSql(String table, String[] fields) {
        var sb = new StringBuilder();
        sb.append("INSERT INTO ");
        sb.append(table);
        sb.append(" (");
        sb.append(String.join(", ", fields));
        sb.append(") VALUES (");
        sb.append(String.join(", ", java.util.Collections.nCopies(fields.length, "?")));
        sb.append(")");
        return sb.toString();
    }
  • 1

Reply