package org.klss; import java.util.StringJoiner; /** * SelectBuilder * 使用StringJoiner构造一个SELECT语句 */ public class SelectBuilder { public static void main(String[] args) { String[] fields = { "name", "position", "salary" }; String table = "employee"; String select = buildSelectSql(table, fields); System.out.println(select); System.out.println("SELECT name, position, salary FROM employee".equals(select) ? "测试成功" : "测试失败"); } static String buildSelectSql(String table, String[] fields) { String s = ""; StringBuilder sb = new StringBuilder(); StringJoiner sj = new StringJoiner(", "); sb.append("SELECT "); for (String f : fields) { sj.add(f); } sb.append(sj.toString()); sb.append(" FROM ") .append(table); s = sb.toString(); return s; } }
Sign in to make a reply
还没想好叫啥暂时先用这个