promotionlistmanager.java

来自「一个简单的网上订书系统 java的课程设计」· Java 代码 · 共 53 行

package proxy;

import java.sql.*;
public class PromotionListManager {
	
	private static ExecutorProxy e = new ExecutorProxy();

	public static int[] insertPromotionLists(Statement stmt)
			throws SQLException, BatchUpdateException {

/*		for (int i = 0; i < 20; i++) {
 			insert("Pn"+i%5, "BID"+i);
		} */
		
		insert("Pno001","BID00001");
		insert("Pno004","BID00001");
		insert("Pno003","BID00003");
		insert("Pno005","BID00004");
		insert("Pno002","BID00009");
		insert("Pno006","BID00012");
		
		return null;
	}

	public static int insert(String[] args) {
		if (args.length != 2) {
			System.err.print("PromotionListManeger arguments input error.");
			return -1;
		}
		String query = "insert into PromotionList values(";
		return e.execute(Checker.argsInsert(query, args));
	}

	public static int insert(String Pno, String BID) {
		String query = "insert into PromotionList values("
				+ Checker.checkNull(Pno) + "," + Checker.checkNull(BID) + ");";
		return e.execute(query);

	}

	public static int deleteByBID(String BID) {
		String query = "delete from PromotionList where BID ="
				+ Checker.checkNull(BID) + ";";
		return e.execute(query);
	}

	public static int deleteByPno(String Pno) {
		String query = "delete from PromotionList where Pno ="
				+ Checker.checkNull(Pno) + ";";
		return e.execute(query);
	}
}