static String buildInsertSql(String table, String[] fields) { var tpl = new StringBuilder(1024); var v1 = new StringBuilder(1024); var v2 = new StringBuilder(1024); for (int i = 0; i < fields.length; i++) { String field = fields[i]; v1.append(field); v2.append("?"); if (i != fields.length - 1) { v1.append(", "); v2.append(", "); } } tpl.append("INSERT INTO") .append(" ").append(table).append(" ") .append("(").append(v1).append(")") .append(" VALUES ") .append("(").append(v2).append(")"); return tpl.toString();}
Sign in to make a reply
南墙小生