Discuss / Java / 原生实现

原生实现

Topic source

bang

#1 Created at ... [Delete] [Delete and Lock User]

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();

}


  • 1

Reply