static String buildInsertSql(String table, String[] fields) { // TODO: String sb; StringBuilder parameter = new StringBuilder(); StringBuilder values = new StringBuilder(); parameter.append("("); values.append("("); for (int i = 0; i < fields.length; i++) { if (i == fields.length -1) { parameter.append(fields[i]).append(")"); values.append("?").append(")"); break; } else { parameter.append(fields[i]) .append(", "); values.append("?, "); } } sb = "INSERT INTO " + table + " " +parameter.toString() + " VALUES " + values.toString(); return sb; }
Sign in to make a reply
追风少年