static String buildInsertSql(String table, String[] fields) {
StringBuilder sb = new StringBuilder(1024);
StringBuilder sb1 = new StringBuilder(128);
StringBuilder sb2 = new StringBuilder(128);
sb1.append(" (").append(fields[0]);
sb2.append(" (").append("?");
for(int i=1;i<fields.length;i++){
sb1.append(", ").append(fields[i]);
sb2.append(", ?");
}
sb1.append(")");
sb2.append(")");
sb.append("INSERT INTO ").append(table).append(sb1.toString()).append(" VALUES").append(sb2.toString()).toString();
String res = sb.toString();
System.out.printf("语句为:%s\n",res);
return res;
Sign in to make a reply
渡厄男神
static String buildInsertSql(String table, String[] fields) {
StringBuilder sb = new StringBuilder(1024);
StringBuilder sb1 = new StringBuilder(128);
StringBuilder sb2 = new StringBuilder(128);
sb1.append(" (").append(fields[0]);
sb2.append(" (").append("?");
for(int i=1;i<fields.length;i++){
sb1.append(", ").append(fields[i]);
sb2.append(", ?");
}
sb1.append(")");
sb2.append(")");
sb.append("INSERT INTO ").append(table).append(sb1.toString()).append(" VALUES").append(sb2.toString()).toString();
String res = sb.toString();
System.out.printf("语句为:%s\n",res);
return res;
}