Discuss / Java / 忘了动态生成values了

忘了动态生成values了

Topic source

Angular2club

#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 (");

    String[] str=new String[fields.length];
  
    for (int i=0;i<fields.length;i++){
      str[i]="?";
    }
    sb.append(String.join(", ",str))
    .append(")");
    return sb.toString();
  }

  • 1

Reply