static String buildInsertSql(String table, String[] fields) { String sqlBegin = "INSERT INTO " + table + " ("; String sqlMiddle = ") VALUES ("; String sqlEnd = ")"; StringBuffer sb1 = new StringBuffer(sqlBegin); StringBuffer sb2 = new StringBuffer(sqlMiddle); for(int i = 0; i < fields.length; i++) { sb1.append(fields[i]); sb2.append("?"); if (i != fields.length - 1) { sb1.append(", "); sb2.append(", "); } } return sb1.toString() + sb2.toString() + sqlEnd; }
Sign in to make a reply
迦梨罩我来学习