static String buildInsertSql(String table, String[] fields) { StringBuilder fieldNames = new StringBuilder(" (") .append(String.join(", ", fields)) .append(") "); StringBuilder values = new StringBuilder(" ("); for (int i = 0; i < fields.length; i++) { if (i == fields.length - 1) { values.append("?") .append(")"); } else { values.append("?, "); } } StringBuilder sql = new StringBuilder() .append("INSERT INTO ") .append(table) .append(fieldNames) .append("VALUES") .append(values); return sql.toString();}
Sign in to make a reply
保持热爱