subcatagorymanager.java

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

package proxy;

import java.sql.*;

import connector.Searcher;

public class SubCatagoryManager {

	private static Searcher s = new Searcher();
	private static ExecutorProxy e = new ExecutorProxy();
	
	public static int[] insertSubCategories(Statement stmt)
			throws SQLException, BatchUpdateException {
/*		String insert = "";
		for (int i = 0; i < 20; i++, insert = "") {
			insert += "insert into subCategory values ('S" + i + "','SCname"
					+ i + "','C" + (i % 5) + "'); ";
			stmt.addBatch(insert);
		}
		return stmt.executeBatch();*/
		insert("SCno001","art","Cno05");
		insert("SCno002","literature","Cno05");
		insert("SCno003","cartoon","Cno05");
		insert("SCno004","photography","Cno05");
		insert("SCno005","all-pervading-education","Cno03");
		insert("SCno006","enlighten","Cno03");
		insert("SCno007","psychics","Cno04");
		insert("SCno008","politics","Cno04");
		insert("SCno009","law","Cno04");
		insert("SCno010","education","Cno04");
		insert("SCno011","manage","Cno04");
		insert("SCno012","economics","Cno04");
		insert("SCno013","cate","Cno01");
		insert("SCno014","map","Cno01");
		insert("SCno015","healthy","Cno01");
		insert("SCno016","tour","Cno01");
		insert("SCno017","others","Cno01");
		insert("SCno018","love","Cno06");
		insert("SCno019","swordsmen","Cno06");
		insert("SCno020","history","Cno06");
		insert("SCno021","cliffhang","Cno06");
		insert("SCno022","machine","Cno02");
		insert("SCno023","medicine","Cno02");
		insert("SCno024","agriculture","Cno02");
		insert("SCno025","basic sinence","Cno02");
		insert("SCno026","computer","Cno02");
		
		return null;
	}

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

	public static int insert(String SCno, String Cno, String BID) {
		String query = "insert into SubCategory values("
				+ Checker.checkNull(SCno) + "," + Checker.checkNull(Cno)
				+ "," + Checker.checkNull(BID) + ");";
		return e.execute(query);
	}

	public static int deleteBySCno(String SCno) {
		String query = "delete from SubCategory where SCno ="
				+ Checker.checkNull(SCno) + ";";
		return e.execute(query);
	}

	public static String getNewSubCategoryID(){

		String ID = pre;
		String last = s.getLastID(TablesManager.subCategory);
		if(last == null) return "SCno000";
 		int num = Integer.parseInt(last.substring(4));
		num++;
		last = String.valueOf(num);
		for(int i = last.length() ;i< 3;i++)
			ID = ID.concat("0");
		ID = ID.concat(last);
		return ID;

	}
	private static final String pre = "SCno";
		
}