package bookshop.run;
/**
 * <p>Title: </p>
 */
import java.util.*;
import bookshop.util.*;
import bookshop.book.*;
import java.sql.*;
import java.lang.String;
import javax.servlet.http.HttpServletRequest;

public class op_bookclass extends DataBase{
  public op_bookclass() {
  }
  private bookclass bookclass = new bookclass(); //新的圖書分類
  private javax.servlet.http.HttpServletRequest request; //建立頁面請求
  private Vector classlist;		//圖書類別向量數組
  public Vector getClasslist() {
		return classlist;
		  }
  public String getBookClassSql() {
				  sqlStr = "select Id,ClassName from bookclass order by Id";
				  return sqlStr;
		  }
		  //查詢圖書分類
  public boolean seachBookClass() throws Exception {
				  int id = 0;
				  String classname = "";
				  int rscount = 0;
				  try {
				  DataBase db = new DataBase();
				  db.connect();
				  stmt = db.conn.createStatement ();
				  rs = stmt.executeQuery(getBookClassSql());
				  rscount = stmt.getMaxRows();
				  classlist = new Vector(rscount+1);
				  classlist.clear();
				  while (rs.next()){
								  id = rs.getInt("Id");
								  classname = rs.getString("ClassName");
								  bookclass bc = new bookclass(id,classname);
								  classlist.addElement(bc);
						  }
						  rs.close();
						  return true;
				  }
				  catch (SQLException sqle){
						  System.out.println(sqle);
			  return false;
				  }
		  }
		  //添加新圖書分類時獲得頁面轉遞的分類名稱
public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) {
	 boolean flag = false;
	 try{
		 request = newrequest;
		 String classname = request.getParameter("bookclassname");
		 String bookclassname = new String(classname.getBytes("ISO8859-1"));
		  if (bookclassname==null || bookclassname.equals("")){
			  bookclassname = "";
			  flag = false;
			  }
			  bookclass.setClassName(bookclassname);
		   String bookclassid = request.getParameter("bookclassid");
				  if (bookclassid==null || bookclassid.equals("")){
					  bookclassid = "";
					  flag = false;
					  }
					  bookclass.setId(Integer.parseInt(bookclassid));
			  System.out.println("bookclassname="+bookclassname);
			  return true;
		  }catch (Exception e){
			return false;
			}
	}
	//添加新的圖書分類
		public boolean insert() throws Exception {
		   sqlStr = "insert into bookclass ( Id,ClassName) values ('";
		   sqlStr = sqlStr + bookclass.getId() + "','";
		   sqlStr = sqlStr + dataFormat.toSql(bookclass.getClassName()) + "')";
					  try
					  {      System.out.print("book class sqlStr="+sqlStr);
						DataBase db = new DataBase();
							 // db.connect();
							 // stmt =db.conn.createStatement ();
							  stmt.execute(sqlStr);
							  return true;
					  }
					  catch (SQLException sqle)
					  {        System.out.print(sqle.getMessage());
							  return false;
					  }
			  }
		  //刪除圖書分類
		  public boolean delete( int aid ) throws Exception {
			   sqlStr = "delete from bookclass where Id = "  + aid ;
			   try
			   {         DataBase db = new DataBase();
						  db.connect();
						  stmt =db.conn.createStatement ();
					   stmt.execute(sqlStr);
					   return true;
			   }
			   catch (SQLException e)
			   {
					   System.out.println(e);
					   return false;
			   }
	   }
  };