package proxy;

import java.sql.*;
import connector.Searcher;

public class PublisherManager {
	private static Searcher s = new Searcher();
	private static ExecutorProxy e = new ExecutorProxy();

	public static int[] insertPublishers(Statement stmt) throws SQLException,
			BatchUpdateException {
/*		String insert = "";
		for (int i = 0; i < 4; i++, insert = "") {
			insert += "insert into publisher values ('P" + i + "','Pname" + i
					+ "','address" + i + "'); ";
			stmt.addBatch(insert);
		}
		return stmt.executeBatch();*/
		
		insert("PID001","Wuhan University Press","Wuhan University");
		insert("PID010","Life Feeling Press","Japan");
		insert("PID011","Foreign Press","Sichuan Chengdu");
		insert("PID012","Friend Press","Hunan Changsha");
		insert("PID013","Great Speaker Press","Jiangsu Nanjing");
		insert("PID014","Times Press","The USA");
		insert("PID015","Guangshui Press","Hubei Guangshui");
		insert("PID002","Tsinghua University Press","TSinghua University");
		insert("PID003","PeK University Press","Beijing University");
		insert("PID004","People Press","Beijng");
		insert("PID005","Education Press","Shanghai");
		insert("PID006","Fudan Press","Shanghai");
		insert("PID007","Hubei Press","Hubei Wuhan");
		insert("PID008","Person Press","England");
		insert("PID009","World Press","The USA");
		
		return null;
	}

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

	public static int insert(String PID, String name, String address) {

		String query = "insert into Publisher values(" + Checker.checkNull(PID)
				+ "," + Checker.checkNull(name) + ","
				+ Checker.checkNull(address) + ");";
		return e.execute(query);
	}

	public static int deleteByPID(String PID) {
		String query = "delete from Publisher where PID = "
				+ Checker.checkNull(PID) + ";";
		return e.execute(query);
	}

	public static int update(String PID, String name, String address) {

		String s1 = Checker.checkNull(PID);

		if (s1 == Checker.nullStr) {
			System.err
					.println("PublisherManger update error: Publisher ID is null");
			return -1;
		}

		String s2 = Checker.checkNull(name);
		String s3 = Checker.checkNull(address);

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

		String tmp1 = "", tmp2 = "";

		if (s2 != Checker.nullStr)
			tmp1 = " name = " + s2;

		if (s3 != Checker.nullStr)
			tmp2 = " address = " + Checker.updateOnNull(address);

		String query = "update Publisher set" + tmp1
				+ Checker.addComma(name, address) + tmp2 + " where PID = "
				+ Checker.checkNull(PID) + ";";
		System.out.println(query);
		return e.execute(query);
	}
	
	public static String getNewPublisherID(){
		String ID = pre;
		String last = s.getLastID(TablesManager.publisher);
		if(last == null) return "PID000";
 		int num = Integer.parseInt(last.substring(3));
		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 = "PID";

}