dbconnectortest.java

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

package connector;
import java.util.ArrayList;
import java.sql.*;

import proxy.*;

import beans.*;
import items.*;
import funcBeans.*;
public class DBConnectorTest {
	
	public static void main(String[] args) throws ClassNotFoundException,SQLException{

		//DBConnector.getSingletonInstance();
/*		String query = "title19";
 		FindBooksBeans fb = new FindBooksBeans();
		fb.setMethod("title");
		fb.setContext(query);
		System.out.println("Title Querying>>>>>");*/
//		ArrayList<Book> books = t.searchBookByTitle(query);
//		ArrayList<Book> books = fb.getBooks();
//		for (Book b : books) System.out.println(b);		
		
//		System.out.println("last row ID: "+DBConnector.getLastID("publisher"));
//		CustomerManager.getNewCustomerID();
//		 BookManager.insert("BID00095", null, "", "", "PID002", "ed21",
//		 "2007-06-09", 99, null, "SCno019");
//	 		System.out.println(BookManager.getNewBookID());
			
// 		SubCatagoryManager.insert("SCno028","sdf","Cno01");
// 		System.out.println(SubCatagoryManager.getNewSubCategoryID());
		
//		PublisherManager.insert("PID009", "null", null);
//		System.out.println(PublisherManager.getNewPublisherID());
//		PromotionManager.insert("Pno003",0.0,null);		
//		System.out.println(PromotionManager.getNewPromotionID());
		
//		CategoryManager.insert("Cno05", "Cname5");
//		System.out.println(CategoryManager.getNewCategoryID());
		
//		FulfilledOrderManager.insert("Tno00100", "Ono00001", "2008-08-09",
//		 "2008-08-09");
//		System.out.println(FulfilledOrderManager.getNewFulfilledOrderID());
		
//		 OrdersManager.insert("Ono00189", "CID0001", "next day delivery","2001-01-01", "2001-01-01");
//		System.out.println(OrdersManager.getNewOrderID());
		
//		ArrayList<BookItem> books = DBConnector.getBookByType("literature");
// 		for (BookItem b : books) System.out.println(b);		
		
// 		ArrayList<Book> books = DBConnector.
//  		for (Book b : books) System.out.println(b);	
  		
//  		ArrayList<OrderItem> books = DBConnector.getPlaOrder("Andy");
// 		for (OrderItem b : books) System.out.println(b);			
		
 //		ArrayList<CustomerItem> cs = DBConnector.cusInf("Andy");
//		for(CustomerItem c: cs) System.out.println(c);	
		
/*		
		query="author3";
 		fb.setMethod("author");
		fb.setContext(query);
		System.out.println("Author Querying>>>>>");
//		books= t.searchBookByAuthor(query);		
		books = fb.getBooks();
		for (Book b : books) System.out.println(b);
		
 		FindTypeBean ftb= new FindTypeBean();
		System.out.println("Category Querying>>>>>");
 		String[] categories = ftb.getTypes();
//		ArrayList<Category> categories = t.getSingletonInstance().listAllCategories();		
//		for(Category c : categories)  System.out.println(c);
 		for(int i=0;i<categories.length;i++)
 			System.out.println(categories[i]);
		
 		ftb.setSubType(categories[3]);// categories[0]
		System.out.println("SubCategory Querying>>>>>");
 		String[] scategories = ftb.getTypes();
//		ArrayList<SubCategory> subCategories =t.getSingletonInstance().listSubCategories(categories.get(1).getCname());
//		for(SubCategory c : subCategories)  System.out.println(c);
 		for(int i=0;i<scategories.length;i++)
 			System.out.println(scategories[i]);
 		
// 		query ="BID0";
// 		System.out.println("Querying getBookByID()>>>>>"+query);
// 		System.out.println(DBConnector.getBookByID(query));
 		
 		System.out.println("Querying top10BySale>>>>>");
 		books = DBConnector.top10BySale();
 		for (Book b : books) System.out.println(b);
 		
 		BookManager.insert("BID00109","Longping Yuan","The cross rice","84572654","PID010","2","2006-12-12",18.99,"You see if there is no Dr.Yuan maybe we don\\'t enough food to eat. This book is just tell you about the cross rice and Yuan himself.","SCno003");
*/		
		//CustomerManager.deleteByCID("CID0000");
		//DBConnector.handleReg("dsfasd", "dsfs", "dfs ");
		
		//ArrayList<Book> books = DBConnector.recommendedBooks();
		//for (Book b : books) System.out.println(b);	
// 		boolean t = "2007-01-01".matches("[0-9]{4}-[0-9]{2}-[0-9]{2}");
// 		System.out.println(t);
		
		//CustomerManager.deleteByCID("CID0000");
		//DBConnector.handleReg("dsfasd", "dsfs", "dfs ");
		/*System.out.println("testing updatebook()");
		Book b=DBConnector.getBookByID("bid00001");
		System.out.println("book with id bid00001   "+b.toString());
		b.setDescription("description2");
		b.setPrice(28.0);
		b.setBID("bid00001");
		DBConnector.updateBook(b);
		Book a=DBConnector.getBookByID("bid00001");
		System.out.println("book with id bid00001   "+a.toString());*/
		
		
		/*System.out.println("testing isAddable()");
		Book b=DBConnector.getBookByID("bid00001");
		//System.out.println("book with id bid00001   "+b.toString());
		//b.setDescription("description2");
		//b.setPrice(28.0);
		//b.setBID("bid00001");
		System.out.println(DBConnector.isAddable(b));
		//Book a=DBConnector.getBookByID("bid00001");
		//System.out.println("book with id bid00001   "+a.toString());
		b.setBID("bid00100");
		System.out.println(DBConnector.isAddable(b));*/
		
		/*ArrayList<OrderItem> o=DBConnector.getOrderItemByOrderID("ono00111");
		for(OrderItem a:o) System.out.println(a.toString());*/
		
//		DBConnector.handleOrder("ono00007");
//		ArrayList<Orders> o=DBConnector.getHandledOrders();
//		for(Orders a:o) System.out.println(a.toString());
	}
}