package proxy;

import java.sql.*;

import connector.Searcher;

public class CategoryManager {

	private static Searcher s = new Searcher();
	private static ExecutorProxy e = new ExecutorProxy();
	
	public static int[] insertCategories(Statement stmt) throws SQLException,
			BatchUpdateException {
/*		String insert = "";
		for (int i = 0; i < 9; i++, insert = "") {
			insert += "insert into category values ('C" + i + "','Cname" + i
					+ "'); ";
			stmt.addBatch(insert);
		}
		return stmt.executeBatch();*/
		insert("Cno01","Life");
		insert("Cno02","Sinence");
		insert("Cno03","Children");
		insert("Cno04","Literate");
		insert("Cno05","Literature");
		insert("Cno06","Novel");

		return null;
	}

	public static int insert(String Cno, String Cname) {

		String query = "insert into Category values(" + Checker.checkNull(Cno)
				+ "," + Checker.checkNull(Cname) + ");";
		return e.execute(query);
	}

	public static int insert(String[] args) {
		if (args.length != 2) {
			System.err.print("CategoryManeger arguments input error.");
			return -1;
		}

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

	public static int deleteByCno(String Cno) {
		String query = "delete from Category where Cno =" + Checker.checkNull(Cno)
				+ ";";
		return e.execute(query);
	}
	
	public static String getNewCategoryID(){

		String ID = pre;
		String last = s.getLastID(TablesManager.category);
		if(last == null) return "Cno00";
 		int num = Integer.parseInt(last.substring(3));
		num++;
		last = String.valueOf(num);
		for(int i = last.length() ;i< 2;i++)
			ID = ID.concat("0");
		ID = ID.concat(last);
		return ID;
	}
	private static final String pre = "Cno";
}