public class Hello { public static void main(String[] args){ String[] fields = { "name", "position", "salary" }; String table = "employee"; String insert = buildInsertSql(table, fields); System.out.println(insert); String s = "INSERT INTO employee (name, position, salary) VALUES (?, ?, ?)"; System.out.println(s.equals(insert) ? "测试成功" : "测试失败"); } static String buildInsertSql(String table, String[] fields) { StringBuilder sb = new StringBuilder(1024); sb.append("INSERT INTO ").append(table).append(" "); for(var i = 0; i<fields.length;i++){ if(i == 0){ sb.append("("); } sb.append(fields[i]); if(i != fields.length -1){ sb.append(", "); }else{ sb.append(")"); } } sb.append(" VALUES (?, ?, ?)"); return sb.toString(); }};
Sign in to make a reply
人杰_小漫喵喵喵