package?bookstore.book.dao;

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

import?javax.management.RuntimeErrorException;

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

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

public?class?BookDao?{
	private?QueryRunner?qr?=?new?TxQueryRunner（）;
	/**
	?*?查詢所有圖書
	?*/
	public?List?findAll（）{
		String?sql?=?“select?*?from?book?where?del=false“;
		try?{
			return?qr.query（sql?new?BeanListHandler（Book.class））;
		}?catch?（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}
	}
	/**
	?*?按分類查詢圖書
	?*/
	public?List?findByCategory（String?cid）{
		String?sql?=“select?*?from?book?where?cid=??and?del=false“;
		try?{
			return?qr.query（sql?new?BeanListHandler（Book.class）cid）;
		}?catch?（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}
	}
	
	/**
	?*?按bid查詢
	?*/
	public?Book?findByBid（String?bid）{
		String?sql?=?“select?*?from?book?where?bid=?“;
		try?{
			?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）;
		}
	}
	/**
	?*?按cid查詢圖書本數
	?*?@param?cid
	?*?@return
	?*/
	public?int?findByCid（String?cid）?{
		String?sql?=“select?count（*）?from?book?where?cid=??and?del=false“;
		try?{
			Number?num?=?（Number）?qr.query（sql?new?ScalarHandler（）?cid）;
			return?num.intValue（）;
		}?catch?（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}
	}
	/**
	?*?添加圖書
	?*?@param?book
	?*/
	public?void?add（Book?book）?{
		String?sql?=“insert?into?book?values（???????）“;
		try?{
			qr.update（sql?book.getBid（）book.getBname（）book.getPrice（）
						book.getAuthor（）book.getImage（）book.getCategory（）.getCid（）book.isDel（））;
		}?catch?（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}
		
	}
	/**
	?*?刪除圖書（假刪除）
	?*?@param?bid
	?*/
	public?void?delte（String?bid）{
		String?sql?=?“update?book?set?del=true?where?bid=?“;
		try?{
			qr.update（sql?bid）;
		}?catch?（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}
	}
	public?void?mod（Book?book）?{
		String?sql?=?“update?book?set?bname=?price=?author=?image=?cid=??where?bid=?“;
		object[]?params?={book.getBname（）book.getPrice（）book.getAuthor（）book.getImage（）
				book.getCategory（）.getCid（）book.getBid（）};
		try?{
			qr.update（sql?params）;
		}?catch?（SQLException?e）?{
			throw?new?RuntimeException（e）;
		}	
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-07-04?19:41??BookStore\
?????文件?????????661??2018-04-05?08:44??BookStore\.classpath
?????文件?????????909??2017-06-07?09:57??BookStore\.project
?????目錄???????????0??2017-07-04?19:41??BookStore\.settings\
?????文件?????????564??2017-06-07?09:57??BookStore\.settings\.jsdtscope
?????文件?????????364??2017-06-07?09:57??BookStore\.settings\org.eclipse.jdt.core.prefs
?????文件?????????476??2017-06-07?09:57??BookStore\.settings\org.eclipse.wst.common.component
?????文件?????????345??2017-06-07?09:57??BookStore\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-06-07?09:57??BookStore\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-06-07?09:57??BookStore\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-07-04?19:41??BookStore\WebRoot\
?????目錄???????????0??2017-07-04?19:41??BookStore\WebRoot\meta-INF\
?????文件??????????36??2017-06-07?09:58??BookStore\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2017-07-04?19:41??BookStore\WebRoot\WEB-INF\
?????目錄???????????0??2017-07-04?19:41??BookStore\WebRoot\WEB-INF\classes\
?????文件?????????526??2017-06-07?09:58??BookStore\WebRoot\WEB-INF\classes\c3p0-config.xml
?????目錄???????????0??2018-04-04?21:32??BookStore\WebRoot\WEB-INF\lib\
?????文件???????54665??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\activation.jar
?????文件??????423528??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\c3p0-0.9.2-pre1.jar
?????文件????????2675??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\c3p0-oracle-thin-extras-0.9.2-pre1.jar
?????文件??????521903??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\commons-beanutils-1.8.3.jar
?????文件??????575389??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\commons-collections-3.2.1.jar
?????文件???????97890??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\commons-dbutils-1.4.jar
?????文件??????129953??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\commons-fileupload-1.2.2.jar
?????文件??????266600??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\commons-io-1.4.jar
?????文件??????279193??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\commons-lang-2.5.jar
?????文件??????129506??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\commons-logging-1.1.1.jar
?????文件???????86487??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\ezmorph-1.0.6.jar
?????文件???????26960??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\itcast-tools-1.4.2.jar
?????文件??????159123??2017-06-07?10:13??BookStore\WebRoot\WEB-INF\lib\json-lib-2.4-jdk15.jar
?????文件???????23773??2017-04-12?10:14??BookStore\WebRoot\WEB-INF\lib\jstl.jar
............此處省略217個文件信息