static String buildInsertSql(String table, String[] fields){
StringBuilder sb = new StringBuilder(1024); sb.append("INSERT INTO "); sb.append(table); sb.append(" ("); for(int i=0;i<fields.length-1;i++){ sb.append(fields[i]); sb.append(", "); } sb.append(fields[fields.length-1]); sb.append(")"); sb.append(" VALUES (?, ?, ?)"); System.out.println(sb.toString()); return sb.toString(); }
Sign in to make a reply
lookphp
static String buildInsertSql(String table, String[] fields){
StringBuilder sb = new StringBuilder(1024);
sb.append("INSERT INTO ");
sb.append(table);
sb.append(" (");
for(int i=0;i<fields.length-1;i++){
sb.append(fields[i]);
sb.append(", ");
}
sb.append(fields[fields.length-1]);
sb.append(")");
sb.append(" VALUES (?, ?, ?)");
System.out.println(sb.toString());
return sb.toString();
}