static String buildInsertSql(String table, String[] fields) {
// TODO:
StringBuilder sb = new StringBuilder(1024);
sb.append("INSERT INTO ")
.append(table)
.append(" (");
int len = fields.length;
for(int i=0;i<len;i++){
if(i == len-1){
sb.append(fields[i]);
}else{
sb.append(fields[i])
.append(", ");
}
sb.append(") VALUES (");
sb.append("?");
sb.append("?, ");
sb.append(")");
return sb.toString();
Sign in to make a reply
施义煊
static String buildInsertSql(String table, String[] fields) {
// TODO:
StringBuilder sb = new StringBuilder(1024);
sb.append("INSERT INTO ")
.append(table)
.append(" (");
int len = fields.length;
for(int i=0;i<len;i++){
if(i == len-1){
sb.append(fields[i]);
}else{
sb.append(fields[i])
.append(", ");
}
}
sb.append(") VALUES (");
for(int i=0;i<len;i++){
if(i == len-1){
sb.append("?");
}else{
sb.append("?, ");
}
}
sb.append(")");
return sb.toString();
}