Discuss / Java / public class StringBuilderInsert

public class StringBuilderInsert

Topic source

#1 Created at ... [Delete] [Delete and Lock User]
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();    }}

  • 1

Reply