customermanager.java

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

package proxy;

import java.sql.*;

import connector.Searcher;

public class CustomerManager {
	private static Searcher s = new Searcher();
	private static ExecutorProxy e = new ExecutorProxy();
	
	public static int[] insertCustomers(Statement stmt) throws SQLException,
			BatchUpdateException {
/*		for (int i = 0; i < 5; i++) {
			insert("CID" + i, "Cname" + i, "Cpassword" + i, "RealName" + i,
					"MailingAddr" + i, "creNum" + i, "2007-09-" + i,
					"EMailAddr" + i);
		}*/
		
		insert("CID0001","Apple","banana","Newton","Oxford No18 in Landon","4571546746","2006-03-12","[e-mail]");
		insert("CID0002","Andy","andy2005","Andy Lua","Tongluo No12 in Hongkong in China","1654168441","2006-02-14","[e-mail]");
		insert("CID0003","Luck Dog","luck8888","Lily","Changan street No12  Haiding Beijing in China","5565554313","2007-02-15","[e-mail]");
		insert("CID0004","RoseMM","loverose","Snow Zhang","Pinan Street No18 Lu City in Sichuan of China","7416574554","2006-06-12","[e-mail]");
		insert("CID0005","Cat","mycat","Yong Liu","Jiefang Street No23 in Changsha Hunan","7684568764","2006-07-12","[e-mail]");
		insert("CID0006","Nicke","nickesheng","Sheng Zhong","ISS Wuhan university in Wuhan of China","7454165745","2007-03-12","[e-mail]");
		insert("CID0007","Wonder","tobeawonder","Steve Li","Zhonghuan No111 in Hongkong China","8754875146","2005-12-04","[e-mail]");
		insert("CID0008","SetName","getName","Tom","Jiefang street No12 In Wuhan City Hubei","8946548846","2007-03-02","[e-mail]");
		insert("CID0009","Dreamer","likelove","Lu Li","Hangkong street No34 Nanjing in Jiangsu","5465465765","2007-01-06","[e-mail]");
		insert("CID0010","Printer.Li","fuwehsw","Deve","Wall street No56 in N.Y The USA","8465498458","2006-08-09","[e-mail]");
		insert("CID0011","Pet","999125","Xing Li","Heping street No43 in Changsha Hunan","5654575425","2007-02-14","[e-mail]");
		insert("CID0012","GreatWall","changcheng","Yingxiong Hua","Hangkong street No23  Guangshui in hubei","8546546546","2006-11-12","[e-mail]");
		insert("CID0013","Jack","211jeck63jean","Jack Smith","Slenp street No18 Washington in the USA","8745648974","2007-02-03","[e-mail]");
		insert("CID0014","Big Tree","263niceman","Mical John","Stone stree No23 Landon in England","8454864514","2006-10-23","[e-mail]");
		insert("CID0015","GoldFish","fish263473","Xing Li","Yongqing street No76 Beijing in China","8458945687","2005-12-25","[e-mail]");
		insert("CID0016","Andy","fuwei2001","Andy Fu","Chengjiao county No12 Guangshui In Hubei","8646548941","2005-10-10","[e-mail]");
		insert("CID0017","Xiao Gou","windowsanddos","Jing Gou","Xiangyang people street No42 in Hubei In China","8454854548","2007-01-04","[e-mail]");
		insert("CID0018","Xiao Huang","javaandjsp","Rong Huang","Xiangyang people street No42 in Hubei In china","5643254845","2006-02-03","[e-mail]");
		insert("CID0019","Bing Mao","fengyatou","Bingyi Liu","Changan street No1 Beijing In China","8764165745","2007-05-21","[e-mail]");
		insert("CID0020","Twins","19911004","Fen u","Chengjiao county Guangshui In China","8415489465","2006-12-18","[e-mail]");
		
		return null;// stmt.executeBatch();
	}

	public static int insert(String[] args) {

		if (args.length != 8) {
			System.err.print("CustomerManeger arguments input error.");
			return -1;
		}

		String query = "insert into Customer values(";
		return e.execute(Checker.argsInsert(query, args));
	}

	public static int insert(String CID, String Cname, String Cpassword,
			String RealName, String MailingAddr, String creditCardNum,
			String ExpirationDate, String EMailAddr) {
		String query = "insert into customer values(" + Checker.checkNull(CID)
				+ "," + Checker.checkNull(Cname) + ","
				+ Checker.checkNull(Cpassword) + ","
				+ Checker.checkNull(RealName) + ","
				+ Checker.checkNull(MailingAddr) + ","
				+ Checker.checkNull(creditCardNum) + ","
				+ Checker.isDate(ExpirationDate) + ","
				+ Checker.checkNull(EMailAddr) + ");";
		return e.execute(query);
	}

	public static int deleteByCID(String CID) {
		String query = "delete from Customer where CID = "
				+ Checker.checkNull(CID) + ";";
		return e.execute(query);
	}

	private static boolean stillTrue(int i, boolean result) {
		if (i > -1)
			result = result && true;
		else
			result = result && false;
		return result;
	}

	public static int update(String CID, String Cpassword, String RealName,
			String MailingAddr, String creditCardNum, String ExpirationDate,
			String EMailAddr) {

		String s1 = Checker.checkNull(CID);
		if (s1 == Checker.nullStr) {
			System.err
					.println("CustomerManager update error: Customer ID is null");
			return -1;
		}

		String s2 = Checker.checkNull(Cpassword);
		String s3 = Checker.checkNull(RealName);
		String s4 = Checker.checkNull(MailingAddr);
		String s5 = Checker.checkNull(creditCardNum);
		String s6 = Checker.checkNull(ExpirationDate);
		String s7 = Checker.checkNull(EMailAddr);
		// String s8= Checker.checkNull();

		if (s2 == Checker.nullStr && s3 == Checker.nullStr
				&& s4 == Checker.nullStr && s5 == Checker.nullStr
				&& s6 == Checker.nullStr && s7 == Checker.nullStr) {
			System.err
					.println("CustomerManager update error: Don't update any date.");
			return -1;
		}

		String query = "";
		boolean result = true;
		int i = 0;

		if (s2 != Checker.nullStr) {
			query = "update customer set" + " Cpassword = "
					+ Checker.updateOnNull(Cpassword) + " where CID = " + s1
					+ ";";
			System.out.println(query);
			i = e.execute(query);
			result = stillTrue(i, result);
			System.out.println(result);
		}

		if (s3 != Checker.nullStr) {
			query = "update customer set" + " RealName = "
					+ Checker.updateOnNull(RealName) + " where CID = " + s1
					+ ";";
			System.out.println(query);
			i = e.execute(query);
			result = stillTrue(i, result);
			System.out.println(result);
		}

		if (s4 != Checker.nullStr) {
			query = "update customer set" + " MailingAddr = "
					+ Checker.updateOnNull(MailingAddr) + " where CID = " + s1
					+ ";";
			System.out.println(query);
			i = e.execute(query);
			result = stillTrue(i, result);
			System.out.println(result);
		}

		if (s5 != Checker.nullStr) {
			query = "update customer set" + " creditCardNum = "
					+ Checker.updateOnNull(creditCardNum) + " where CID = "
					+ s1 + ";";
			System.out.println(query);
			i = e.execute(query);
			result = stillTrue(i, result);
			System.out.println(result);
		}

		if (s6 != Checker.nullStr) {
			query = "update customer set" + " ExpirationDate = "
					+ Checker.updateOnNull(ExpirationDate) + " where CID = "
					+ s1 + ";";
			System.out.println(query);
			i = e.execute(query);
			result = stillTrue(i, result);
			System.out.println(result);
		}

		if (s7 != Checker.nullStr) {
			query = "update customer set" + " EMailAddr = "
					+ Checker.updateOnNull(EMailAddr) + " where CID = " + s1
					+ ";";
			System.out.println(query);
			i = e.execute(query);
			result = stillTrue(i, result);
			System.out.println(result);
		}

		if (result == true)
			return 1;
		return 0;
		
	}
	
	
	public static String getNewCustomerID(){
		
		String ID = pre;
		String last = s.getLastID(TablesManager.customer);
		if(last == null) return "CID0000";
		System.out.println(last);
 		int num = Integer.parseInt(last.substring(3));
		num++;
		last = String.valueOf(num);
		for(int i = last.length() ;i<4;i++)
			ID = ID.concat("0");
		ID = ID.concat(last);
		System.out.println(ID);
		return ID;
	}

	private static final String pre = "CID";
}