package guanli;
/**
 * 圖書類 
 */

import java.sql.*;
import java.util.Vector;
import beans.*;

public class op_book extends DataBase{
        private javax.servlet.http.HttpServletRequest request; //建立頁面請求
		private boolean sqlflag = true ;		    //對接收到的數據是否正確
		private Vector booklist;			    //顯示圖書列表向量數組
		String sqlStr="";
		public Vector getBooklist() {
				return booklist;
		}
		public boolean getSqlflag() {
				return sqlflag;
		}
		public String to_String( String str) {
				try
				{
						return new String(str.getBytes("ISO8859-1"));
				}
				catch (Exception e)
				{
						return str;
				}
		}
	    /**
			 * 獲得查詢圖書類別的sql語句
		*/
		public String getSql() {
			 sqlStr = "select Id,ClassName from book order by Id";
			 return sqlStr;
			}
		
		/**
	     * 圖書的單本查詢
		*/
  public boolean getOnebook(int newid ) throws Exception {
	 DataBase db = new DataBase();
	 db.connect();
	 stmt =db.conn.createStatement ();
	 try {
		sqlStr = "select   a.Id,a.BookName,a.BookClass,b.ClassName,"+
				   "a.Author,a.Publish,a.BookNo,a.Content,a.Price,a.Amount,"+
				   "a.Leav_number,a.RegTime,a.picture from book a,bookclass b"+
				  " where a.BookClass = b.Id  and a.Id = "+ newid;
						rs = stmt.executeQuery(sqlStr);
						if (rs.next())
						{	booklist = new Vector(1);
							book book = new book();
							book.setId(rs.getLong("Id"));
							book.setBookName(rs.getString("BookName"));
							book.setBookClass(rs.getInt("BookClass"));
							book.setClassname(rs.getString("ClassName"));
							book.setAuthor(rs.getString("Author"));
							book.setPublish(rs.getString("Publish"));
							book.setBookNo(rs.getString("BookNo"));
							book.setContent(rs.getString("Content"));
							book.setPrice(rs.getFloat("Price"));
							book.setAmount(rs.getInt("Amount"));
							book.setLeav_number(rs.getInt("Leav_number"));
							book.setRegTime(rs.getString("RegTime"));
							book.setPicture(rs.getString("picture"));
							booklist.addElement(book);
						} else {
								rs.close();
								return false;
						}
						rs.close();
						return true;
				}
				catch (SQLException e)
				{
						return false;
				}
		}
}