package?book.dao;

import?java.sql.SQLException;
import?java.util.List;
import?java.util.Map;

import?org.apache.commons.dbutils.QueryRunner;
import?org.apache.commons.dbutils.handlers.BeanListHandler;
import?org.apache.commons.dbutils.handlers.MapHandler;
import?org.apache.commons.dbutils.handlers.ScalarHandler;

import?book.domain.Book;
import?category.domain.Category;
import?cn.itcast.commons.CommonUtils;
import?cn.itcast.jdbc.TxQueryRunner;

import?database.dao.*;

public?class?BookDao?{
	private?QueryRunner?qr?=?new?TxQueryRunner（）;
	
	/**
	?*?查詢所有圖書
	?*?@return
	?*/
	public?List?findAll（）?{
		//DatabaseDao?databaseDao=new?DatabaseDao（）;
		try?{
			String?sql?=?“select?*?from?book“;
			return?qr.query（sql?new?BeanListHandler（Book.class））;
		}?catch（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}
	}

	/**
	?*?按分類查詢
	?*?@param?cid
	?*?@return
	?*/
	public?List?findByCategory（String?cid）?{
		try?{
			String?sql?=?“select?*?from?book?where?cid=?“;
			return?qr.query（sql?new?BeanListHandler（Book.class）?cid）;
		}?catch（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}
	}

	/**
	?*?加載方法
	?*?@param?bid
	?*?@return
	?*/
	public?Book?findByBid（String?bid）?{
		try?{
			/*
			?*?我們需要在Book對象中保存Category的信息
			?*/
			String?sql?=?“select?*?from?book?where?bid=?“;
			Mapject>?map?=?qr.query（sql?new?MapHandler（）?bid）;
			/*
			?*?使用一個Map，映射出兩個對象，再給這兩個對象建立關系！
			?*/
			Category?category?=?CommonUtils.toBean（map?Category.class）;
			Book?book?=?CommonUtils.toBean（map?Book.class）;
			book.setCategory（category）;
			return?book;
		}?catch（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}
	}

	/**
	?*?查詢指定分類下的圖書本數
	?*?@param?cid
	?*?@return
	?*/
	public?int?getCountByCid（String?cid）?{
		try?{
			String?sql?=?“select?count（*）?from?book?where?cid=?“;
			Number?cnt?=?（Number）qr.query（sql?new?ScalarHandler（）?cid）;
			return?cnt.intValue（）;
		}?catch（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}
	}

	/**
	?*?添加圖書
	?*?@param?book
	?*/
	public?void?add（Book?book）?{
		try?{
			String?sql?=?“insert?into?book?values（?????）“;
			object[]?params?=?{book.getBid（）?book.getBname（）?book.getPrice（）
					book.getAuthor（）?book.getCategory（）.getCid（）};
			qr.update（sql?params）;
		}?catch（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}
	}
	
	/**
	?*?刪除圖書
	?*?@param?bid
	?*/
	public?void?delete（String?bid）?{
		try?{
			String?sql?=?“delete?from?book?where?bid=?“;
			qr.update（sql?bid）;
		}?catch（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}
	}

	public?void?edit（Book?book）?{
		try?{
			String?sql?=?“update?book?set?bname=??price=?author=??cid=??where?bid=?“;
			object[]?params?=?{book.getBname（）?book.getPrice（）
					book.getAuthor（）?
					book.getCategory（）.getCid（）?book.getBid（）};
			qr.update（sql?params）;
		}?catch（SQLException?e）?{
			throw?new?RuntimeExc