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