static String buildInsertSql(String table, String[] fields) {
StringBuilder sb = new StringBuilder();
sb = sb.append("INSERT INTO employee () VALUES ()");
for(int i = 0;i<fields.length;i++) {
if(i==0) {
sb.insert(sb.indexOf(")"), fields[i]);
sb.insert(sb.indexOf(")", sb.indexOf(")")+1), "?");
}else {
sb.insert(sb.indexOf(")"), ", "+fields[i]);
sb.insert(sb.indexOf(")", sb.indexOf(")")+1), ", ?");
}
return sb.toString();
Sign in to make a reply
杨森-ys
static String buildInsertSql(String table, String[] fields) {
StringBuilder sb = new StringBuilder();
sb = sb.append("INSERT INTO employee () VALUES ()");
for(int i = 0;i<fields.length;i++) {
if(i==0) {
sb.insert(sb.indexOf(")"), fields[i]);
sb.insert(sb.indexOf(")", sb.indexOf(")")+1), "?");
}else {
sb.insert(sb.indexOf(")"), ", "+fields[i]);
sb.insert(sb.indexOf(")", sb.indexOf(")")+1), ", ?");
}
}
return sb.toString();
}