Discuss / Java / 练习

练习

Topic source
//请使用StringBuilder构造一个INSERT语句:
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();
		sb.append("INSERT INTO ")
		.append(table)
		.append(" (");
		for(int i = 0; i < fields.length; i++){
			if(i>0) {
				sb.append(", ");
			}
			sb.append(fields[i]);
		}
		sb.append(") VALUES (?, ?, ?)");
		
		return sb.toString();
	}

}

  • 1

Reply