static String buildInsertSql(String table, String[] fields) {
// TODO:
int len=fields.length;
var sb = new StringBuilder(1024);
sb.append(" (");
for(int i = 0; i<len; i++){
sb.append(fields[i])
.append(", ");
if(i==len-2){
break;
}
sb.append(fields[len-1])
.append(") VALUES (?, ?, ?)")
.insert(0,"INSERT INTO ")
.insert(12,table);
return sb.toString();
Sign in to make a reply
荒天雷
static String buildInsertSql(String table, String[] fields) {
// TODO:
int len=fields.length;
var sb = new StringBuilder(1024);
sb.append(" (");
for(int i = 0; i<len; i++){
sb.append(fields[i])
.append(", ");
if(i==len-2){
break;
}
}
sb.append(fields[len-1])
.append(") VALUES (?, ?, ?)")
.insert(0,"INSERT INTO ")
.insert(12,table);
return sb.toString();
}