testmanagers.java

一个简单的网上订书系统 java的课程设计

package proxy;

import java.sql.*;

public class TestManagers {

	public static void main(String[] args) throws SQLException {

		// try {

		// PublisherManager.update("P3", "af", null);
		// PromotionManager.update("Pn0", 0.0, "2007-5-9");
		// System.out.println(BookManager.update("BID0", " sd", 2));
		//System.out.println(CustomerManager.update("CID0", " 46546",
		//		"  ",null,null, "2008-5-8",
		//		"[e-mail]"));

		// String[] arg = {"Cno6", " "};
		// CategoryManeger.insert(arg);
		// CategoryManeger.insert("Cno5", "Cname5");
		// CategoryManeger.deleteByCno("Cno6");

		// CustomerManager.insert("CID1", "Cname1", "Cpassword1", null, null,"",
		// "", "", null, null);
		// String[] arg = {"CID1", "Cname1", "Cpass1", "fname1", "mi1","lname1",
		// "MAddr1", "credit1", "2001-02-09","EMail1"};
		// CustomerManager.insert(arg);
		// DBConnector.execute(query);
		// CustomerManager.deleteByCID("CID0000");
		// System.out.println(CustomerManager.insert("CID0000", "  ", "Cpassd3", "", null,
		//null, "2007-5-2",null));

		// String[] arg = {"Ono5", "", "","",null};
		// OrdersManager.insert(arg);
		// OrdersManager.insert("Ono1", "CID1", "next day
		// delivery","2001-01-01", "2001-01-01");
		// OrdersManager.deleteByOno("Ono0");

		// String[] arg = {"TraNum3", "Ono2", "2009-08-09", "2001-08-09"};
		// FulfilledOrderManeger.insert(arg);
		// FulfilledOrderManeger.insert("TraNum1", "Ono1", "2008-08-09",
		// "2008-08-09");
		// System.out.println(FulfilledOrderManeger.deleteByTrackNum("TraNum3"));

		// String[] arg = {"Pro3","9.99","2007-01-01"};
		// PromotionManeger.insert(arg);
		// PromotionManeger.insert("Pro3",0.0,null);
		// PromotionManeger.deleteByPno("P4");

		// String[] arg1 = {"P2", "BID3"};
		// PromotionListManeger.insert(arg1);
		// PromotionListManeger.insert("P1", "BID1");
		// PromotionListManeger.deleteByBID("BID3");
		// PromotionListManeger.deleteByPno("P2");

		// String[] arg = {"PID3", "name2", "address2"};
		// System.out.println(PublisherManager.insert(arg));
		// System.out.println( PublisherManager.insert("PID3", "null", null));
		// System.out.println( PublisherManager.deleteByPID("PID9"));

		// String[] arg = {"SCno20","SCname20","Cno0"};
		// SubCatagoryManager.insert(arg);
		// SubCatagoryManager.insert("S21","SCname21","C1");
		// SubCatagoryManager.deleteBySCno("SCno20");

		// String[] arg ={"BID20", null, null, " ", "PID2", " ", " ", "69.0",
		// "null", "SCno19"};
		// BookManeger.insert(arg);
		// BookManeger.insert("BID21", null, "", "", "PID2", "ed21",
		// "2007-06-09", 99, null, "SCno19");
		// BookManeger.deleteByBID("BID20");

		// String[] arg ={"Ono2", "BID4", "9", "8"};
		// InvoiceManeger.insert(arg);
		// InvoiceManeger.insert("Ono3", "BID18", 999999, 999.0);
		// InvoiceManeger.deleteByBID("BID1");
		// InvoiceManeger.deleteByOno("Ono2");

		// } catch (SQLException e) {
		// System.err.println("SQLException: "+ e.getLocalizedMessage()+"
		// "+e.getMessage());
		// e.printStackTrace();}
	}
}