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:
		String as=Arrays.toString(fields);//转化数组fields为字符串
		String bs=as.replace("["," (");//去掉"["
		String cs=bs.replace("]", ") ");//去掉"]"
		StringBuilder sBuilder=new StringBuilder();
		sBuilder.append("INSERT INTO ")
				.append(table)
				.append(cs)
				.append("VALUES (?, ?, ?)");
		return sBuilder.toString();
	}

}

  • 1

Reply