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 sb = new StringBuilder(1024);

sb.append("INSERT INTO ");

sb.append(table);

sb.append(" (");

for (int i=0;i<fields.length;i++) {

if (i != 0) {

sb.append(", "+fields[i]);

}else {

sb.append(fields[i]);

}

}

sb.append(") VALUES (?, ?, ?)");

        return sb.toString();

    }