public class StringBuilderInsert { 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) { // TODO: StringBuilder fieldsb = new StringBuilder(); for (int i = 0; i < fields.length; i++) { fieldsb.append(fields[i]) .append(", "); } int index1 = fieldsb.lastIndexOf(","); int index2 = fieldsb.lastIndexOf(" "); String field = fieldsb.toString(); StringBuilder sb = new StringBuilder(); sb.append("INSERT INTO ") .append(table) .append(" (") .append(field) .deleteCharAt(sb.lastIndexOf(",")) .deleteCharAt(sb.lastIndexOf(" ")) .append(") ") .append("VALUES (?, ?, ?)"); return sb.toString(); }}
Sign in to make a reply
明