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:
		StringBuilder sb = new StringBuilder(1024);
		sb.append("INSERT INTO ").append(table).append(" (");
		for (int i = 0; i < fields.length; i++) {
			if(i< fields.length-1) {
				sb.append(fields[i]).append(", ");
			} else if (i == fields.length-1) {
				sb.append(fields[i]).append(")");
			}
		}
		sb.append(" VALUES (?, ?, ?)");



		return ""+sb;
	}

}

  • 1

Reply