改进了一下前面老哥的版本
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 18.0px Menlo; color: #1290c3} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 18.0px Menlo; color: #d9e8f7} p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 18.0px Menlo; color: #17c6a3} p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; font: 18.0px Menlo; color: #808080} p.p5 {margin: 0.0px 0.0px 0.0px 0.0px; font: 18.0px Menlo; color: #f2f200} p.p6 {margin: 0.0px 0.0px 0.0px 0.0px; font: 18.0px Menlo; color: #f3ec79} span.s1 {color: #cc6c1d} span.s2 {color: #d9e8f7} span.s3 {color: #1eb540} span.s4 {color: #f9faf4} span.s5 {color: #79abff} span.s6 {color: #e6e6fa} span.s7 {color: #66e1f8} span.s8 {color: #6897bb} span.s9 {color: #1290c3} span.s10 {color: #96ec3f} span.s11 {color: #17c6a3} span.s12 {color: #808080} span.s13 {color: #f2f200} span.s14 {color: #a7ec21} span.s15 {color: #f3ec79} span.Apple-tab-span {white-space:pre} static String buildInsertSql(String table, String[] fields) { if (fields.length == 0) { return "没有给出数据库表的列名"; } else { // 将列表名称用逗号隔开 String fieldsContainer = String.join(", ", fields); // 创建问号 var qmark = new StringBuilder("("); for (int i=0; i<fields.length; i++) { qmark.append("?"); if (i < fields.length-1) { qmark.append(", "); } } // 组合整个语句 var sb = new StringBuilder("INSERT INTO "); sb.append(table+" (") .append(fieldsContainer) .append(") VALUES ") .append(qmark+")"); return sb.toString(); } }
Sign in to make a reply
東寶一童
改进了一下前面老哥的版本