Discuss / Java / buildInsertSql

buildInsertSql

Topic source
static String buildInsertSql(String table, String[] fields) {
    // TODO:    StringBuilder sql=new StringBuilder();    sql.append("INSERT INTO ")
            .append(table)
            .append(" (");    String valueStr=String.join(", ", fields);    String fieldStr=valueStr;    for (String field:fields){
        valueStr=valueStr.replace(field,"?");    }
    sql.append(fieldStr)
    .append(") VALUES ")
    .append("(")
    .append(valueStr)
    .append(")");    return sql.toString();}

  • 1

Reply