* 更新BookType信息
	 * 
	 * @param btb
	 * @return
	 */
	public boolean updateBookType(BookTypeBean btb) {
		try {
			// 創建在Type表中更新BookType記錄的Statement對象
			preparedStatement = connection
					.prepareStatement("update Type set Display=? where TypeId=?");
			// 設置Statement對象的第一個參數
			preparedStatement.setString(1, btb.getDisplay());
			// 設置Statement對象的第二個參數
			preparedStatement.setInt(2, btb.getTypeId());
			// 執行更新操作
			int flag = preparedStatement.executeUpdate();
			if (flag == 0) {
				return false;
			}
		} catch (SQLException ex) {
			ex.printStackTrace();
			return false;
		}
		return true;
	}

	/**
	 * 增加圖書信息
	 * 
	 * @param bb
	 * @return
	 */
	public boolean insertBooks(BookBean bb) {
		try {
			// 創建插入圖書信息的Statement對象
			preparedStatement = connection
					.prepareStatement("insert into information (BookName,BookPenster,BookCompany,BookSynopsis,BookStorage,BookSell,BookDate,BookPrice,BookType,bookImage,BookStep) values(?,?,?,?,?,?,?,?,?,?,?)");
			// 設置Statement對象的第一個參數
			preparedStatement.setString(1, bb.getBookName());
			// 設置Statement對象的第二個參數
			preparedStatement.setString(2, bb.getBookPenster());
			// 設置Statement對象的第三個參數
			preparedStatement.setString(3, bb.getBookCompany());
			// 設置Statement對象的第四個參數
			preparedStatement.setString(4, bb.getBookSynopsis());
			// 設置Statement對象的第五個參數
			preparedStatement.setInt(5, bb.getBookStorage());
			// 設置Statement對象的第六個參數
			preparedStatement.setInt(6, bb.getBookSell());
			// 設置Statement對象的第七個參數
			preparedStatement.setDate(7, new java.sql.Date(new java.util.Date()
					.getTime()));
			// 設置Statement對象的第八個參數
			preparedStatement.setInt(8, bb.getBookPrice());
			// 設置Statement對象的第九個參數
			preparedStatement.setInt(9, Integer.parseInt(bb.getBookType()));
			// 設置Statement對象的第十個參數
			preparedStatement.setString(10, bb.getBookImage());
			// 設置Statement對象的第十一個參數
			preparedStatement.setInt(11, bb.getBookStep());
			// 執行更新操作
			int flag = preparedStatement.executeUpdate();
			if (flag == 0) {
				return false;
			}
		} catch (SQLException ex) {
			ex.printStackTrace();
			return false;
		}
		return true;
	}

	/**
	 * 取得某條圖書信息
	 * 
	 * @param bookId
	 * @return
	 */
	public BookBean getBookBean(int bookId) {
		BookBean bbean = new BookBean();
		// 查詢某條圖書信息的SQL語句
		String sql = "select * from information where BookId=?";
		try {
			// 創建preparedStatement對象
			preparedStatement = connection.prepareStatement(sql);
			// 設置Statement對象的第一個參數的值
			preparedStatement.setInt(1, bookId);
			// 執行查詢
			resultSet = preparedStatement.executeQuery();
			// 根據查詢結果封裝成BookBean對象
			while (resultSet.next()) {
				bbean.setBookCompany(resultSet.getString("BookCompany"));
				bbean.setBookCount(1);
				bbean.setBookData(resultSet.getDate("BookDate"));
				bbean.setBookId(bookId);
				bbean.setBookImage(resultSet.getString("BookImage"));
				bbean.setBookName(resultSet.getString("BookName"));
				bbean.setBookPenster(resultSet.getString("BookPenster"));
				bbean.setBookPrice(resultSet.getInt("BookPrice"));
				bbean.setBookSell(resultSet.getInt("BookSell"));
				bbean.setBookStep(resultSet.getInt("BookStep"));
				bbean.setBookStorage(resultSet.getInt("BookStorage"));
				bbean.setBookSynopsis(resultSet.getString("BookSynopsis"));
				bbean.setBookType(this.queryType(""
						+ resultSet.getInt("BookType")));
				bbean.setBookAllPrice(bbean.getBookPrice());
			}
		}

		catch (SQLException ex) {
			ex.printStackTrace();
			return null;
		}
		return bbean;
	}

	/**
	 * 根據typeID查詢其對應的類型值
	 * 
	 * @param typeId
	 * @return
	 */
	public String queryType(String typeId) {
		try {
			// 創建相應的Statement對象
			java.sql.PreparedStatement prepar1 = connection
					.prepareStatement("select Display from Type where TypeId=?");
			// 設置Statement對象的第一個參數
			prepar1.setInt(1, Integer.parseInt(typeId));
			// 執行查詢取得查詢結果
			ResultSet res1 = prepar1.executeQuery();
			res1.next();
			return res1.getString("Display");
		} catch (SQLException ex) {

			return null;
		}
	}

	/**
	 * 返回書籍信息列表
	 * 
	 * @param count
	 * @param page
	 * @return
	 */
	public ArrayList getBooksList(int count, int page) {
		ArrayList list = new ArrayList();
		try {
			// 調用查詢書籍的存儲過程
			callableStatement = connection
					.prepareCall("{call proc_books_page (?,?,?)}");
			// 設置Statement對象的相關參數
			callableStatement.setInt(1, page);
			callableStatement.setInt(2, count);
			// 設置Statement對象的輸入參數類型
			callableStatement.registerOutParameter(3, Types.INTEGER);
			// 執行查詢
			resultSet = callableStatement.executeQuery();
			// 將查詢結果放置到一個鏈表中保存
			while (resultSet.next()) {
				BookBean kb = new BookBean();
				kb.setBookId(resultSet.getInt(1));
				kb.setBookName(resultSet.getString(2));
				kb.setBookPenster(resultSet.getString(3));
				kb.setBookCompany(resultSet.getString(4));
				kb.setBookSynopsis(resultSet.getString(5));
				kb.setBookStorage(resultSet.getInt(6));
				kb.setBookSell(resultSet.getInt(7));
				kb.setBookData(resultSet.getDate(8));
				kb.setBookPrice(resultSet.getInt(9));
				kb.setBookType(resultSet.getInt(10) + "");
				kb.setBookImage(resultSet.getString(11));
				kb.setBookStep(resultSet.getInt(12));
				list.add(kb);
			}
			pagecount = callableStatement.getInt(3);
		} catch (SQLException ex) {
			System.out.println("服務器異常發生在 getBooksList()");
			ex.printStackTrace();
		}
		return list;
	}

	/**
	 * 取得定單列表
	 * 
	 * @param count
	 * @param page
	 * @return
	 */
	public ArrayList getOrderList(int count, int page) {
		ArrayList list = new ArrayList();
		try {
			// 調用查詢所有定單的存儲過程
			callableStatement = connection
					.prepareCall("{call proc_order_page (?,?,?)}");
			// 設置存儲過程的相應參數
			callableStatement.setInt(1, page);
			callableStatement.setInt(2, count);
			// 設置存儲過程輸出參數的類型
			callableStatement.registerOutParameter(3, Types.INTEGER);
			// 執行查詢
			resultSet = callableStatement.executeQuery();
			// 處理查詢結果
			while (resultSet.next()) {
				OrderFormBean ob = new OrderFormBean();
				ob.setOrderId(resultSet.getInt(1));
				ob.setUserId(resultSet.getInt(2));
				ob.setBookId(resultSet.getInt(3));
				ob.setAmount(resultSet.getInt(4));
				ob.setOrderData(resultSet.getString(5));
				ob.setMoney(resultSet.getInt(6));
				list.add(ob);
			}
			pagecount = callableStatement.getInt(3);
		} catch (SQLException ex) {
			System.out.println("服務器異常發生在 getBooksList()");
			ex.printStackTrace();
		}
		return list;
	}

	/**
	 * 改變Admin的密碼信息
	 * 
	 * @param admin
	 * @return
	 */
	public boolean changeAdminPwd(AdminBean admin) {
		try {
			// 創建更新admin密碼的Statement對象
			preparedStatement = connection
					.prepareStatement("update admin set UserPwd=? where userId=?");
			// 設置其相應的參數
			preparedStatement.setString(1, admin.getUserPwd());
			preparedStatement.setInt(2, admin.getUserId());
			// 執行更新操作
			int flag = preparedStatement.executeUpdate();
			if (flag == 0) {
				return false;
			}
		} catch (SQLException ex) {
			ex.printStackTrace();
			return false;
		}
		return true;
	}

	/**
	 * 關閉與數據庫的所有連接
	 */
	public void Close() {
		try {
			if (resultSet != null) {
				// 關閉ResultSet對象
				resultSet.close();
			}
			if (preparedStatement != null) {
				// 關閉PreparedStatemnt對象
				preparedStatement.close();
			}
			if (connection != null) {
				// 關閉Connection對象
				connection.close();
			}
		} catch (SQLException ex) {
			ex.printStackTrace();
		}

	}

}