public class Main { public static void main(String[] args) { String[] fields = { "name", "position", "salary" }; String table = "employee"; String insert = buildInsertSql(table, fields); System.out.println(insert); System.out.println( "INSERT INTO employee (name, position, salary) VALUES (?, ?, ?)".equals(insert) ? "测试成功" : "测试失败"); } static String buildInsertSql(String table, String[] fields) { // TODO: String as=Arrays.toString(fields);//转化数组fields为字符串 String bs=as.replace("["," (");//去掉"[" String cs=bs.replace("]", ") ");//去掉"]" StringBuilder sBuilder=new StringBuilder(); sBuilder.append("INSERT INTO ") .append(table) .append(cs) .append("VALUES (?, ?, ?)"); return sBuilder.toString(); } }
Sign in to make a reply
✘不知该怎么€✔