Discuss / Java / 作业打卡

作业打卡

Topic source
public class Main {

	public static void main(String[] args) {
		String[] fields = { "name", "position", "salary" };
		String table = "employee";
		String insert = buildInsertSql(table, fields);
		System.out.println(insert);
		System.out.println(
				"INSERT INTO employee (name, position, salary) VALUES (?, ?, ?)".equals(insert) ? "测试成功" : "测试失败");
	}

	static String buildInsertSql(String table, String[] fields) {
		// TODO:
		var s = new StringBuilder(1024);
		String field = String.join(", ", fields);
		String[] values = new String[fields.length];
		for (var i = 0; i < fields.length; i++) {
			values[i] = "?";
		}
		String value = String.join(", ", values);
		
		s.append("INSERT INTO ")
		.append(table)
		.append(" (")
		.append(field)
		.append(") VALUES (")
		.append(value)
		.append(")");
		
		return s.toString();
	}
}

  • 1

Reply