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