public class StringBuilderTest { 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 fileds[]) { StringBuilder builder = new StringBuilder(100); String[] strings = new String[4]; int[] ints = new int[4]; builder.append(table); ints[0] = builder.length(); for (int i = 0; i < fileds.length; i++) { builder.append(fileds[i]); ints[i + 1] = builder.length(); } for (int i = 0; i < ints.length; i++) { if (i == 0) { strings[i] = builder.substring(0, ints[i]); } else { strings[i] = builder.substring(ints[i - 1], ints[i]); } } return String.format("INSERT INTO %s (%s, %s, %s) VALUES (?, ?, ?)", strings[0], strings[1], strings[2], strings[3]); }}
Sign in to make a reply
用户6522882218