package?cn.ws.bookstore.dao;

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

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

import?cn.ws.bookstore.domin.Book;
import?cn.ws.bookstore.domin.Category;
import?cn.ws.jdbc.utils.JdbcUtils;

public?class?BookDao?{
	private?QueryRunner?qr?=?new?QueryRunner（）;

	public?List?query（）?throws?SQLException?{
		String?sql?=?“select?*?from?book?where?Bstate=?“;
		return?qr.query（JdbcUtils.getConnection（）?sql
				new?BeanListHandler（Book.class）?1）;
	}

	public?List?query（String?cid）?throws?SQLException?{
		String?sql?=?“select?*?from?book?where?cid=??and?Bstate=?“;
		return?qr.query（JdbcUtils.getConnection（）?sql
				new?BeanListHandler（Book.class）?cid?1）;
	}

	public?Book?findById（String?bid）?throws?SQLException?{
		String?sql?=?“select?*?from?book?where?bid=??and?Bstate=?“;
		return?qr.query（JdbcUtils.getConnection（）?sql?new?BeanHandler（
				Book.class）?bid?1）;
	}

	public?void?insertCategory（String?id?String?name）?throws?SQLException?{
		String?sql?=?“insert?into?category?values（??）“;
		qr.update（JdbcUtils.getConnection（）?sql?id?name）;
	}

	public?List?getCategory（）?throws?SQLException?{
		String?sql?=?“select?*?from?category“;
		return?qr.query（JdbcUtils.getConnection（）?sql
				new?BeanListHandler（Category.class））;
	}

	public?void?dele（String?id）?throws?SQLException?{
		String?sql1?=?“delete?from?book?where?cid=?“;
		String?sql?=?“delete?from?category?where?cid=?“;
		qr.update（JdbcUtils.getConnection（）?sql1?id）;
		qr.update（JdbcUtils.getConnection（）?sql?id）;

	}

	public?void?modifyprice（double?bprice?String?bid）?throws?SQLException?{
		String?sql?=?“update?book?set?bprice=??where?bid=?“;
		qr.update（JdbcUtils.getConnection（）?sql?bprice?bid）;
	}

	public?void?addbook（Book?book）?throws?SQLException?{
		String?sql?=?“insert?into?book（bidbnamebpriceauthorimagecidBstate）?values（???????）“;
		qr.update（JdbcUtils.getConnection（）?sql?book.getBid（）
				book.getBname（）?book.getBprice（）?book.getAuthor（）
				book.getImage（）?book.getCid（）?1）;
	}

	public?void?deleteBook（String?bid）?throws?SQLException?{
		String?sql?=?“update?book?set?Bstate=??where?bid=?“;
		qr.update（JdbcUtils.getConnection（）?sql?0?bid）;
	}

	public?List?index（String?bookName）?throws?SQLException?{
		String?sql?=?“select?*?from?book?where?bname?like??“;
		return?qr.query（JdbcUtils.getConnection（）?sql
				new?BeanListHandler（Book.class）?“%“?+?bookName?+?“%“）;
	}

	public?List?indexBookOfName（String?authorBookName）?throws?SQLException?{
		String?sql?=?“select?*?from?book?where?author=?“;
		return?qr.query（JdbcUtils.getConnection（）?sql
				new?BeanListHandler（Book.class）authorBookName）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-01-20?21:29??網上商城系統\
?????文件?????5789944??2015-12-30?22:37??網上商城系統\yygl.zip
?????文件?????1839901??2015-12-30?22:36??網上商城系統\醫院管理系統.pdf
?????目錄???????????0??2018-05-10?15:27??網上商城系統\網上商城系統\
?????目錄???????????0??2016-01-20?21:29??網上商城系統\網上商城系統\bookstore\
?????文件????????1786??2015-12-16?20:10??網上商城系統\網上商城系統\bookstore\.classpath
?????目錄???????????0??2016-08-05?18:37??網上商城系統\網上商城系統\bookstore\.myeclipse\
?????文件?????????300??2013-06-03?17:57??網上商城系統\網上商城系統\bookstore\.mymetadata
?????文件????????1752??2015-12-19?20:09??網上商城系統\網上商城系統\bookstore\.project
?????目錄???????????0??2016-01-20?21:29??網上商城系統\網上商城系統\bookstore\.settings\
?????文件?????????500??2013-05-22?19:51??網上商城系統\網上商城系統\bookstore\.settings\.jsdtscope
?????文件?????????238??2015-12-19?20:03??網上商城系統\網上商城系統\bookstore\.settings\com.genuitec.eclipse.core.prefs
?????文件????????1009??2015-12-19?20:09??網上商城系統\網上商城系統\bookstore\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????247??2015-12-14?09:06??網上商城系統\網上商城系統\bookstore\.settings\com.genuitec.eclipse.migration.prefs
?????文件??????????74??2015-12-19?23:11??網上商城系統\網上商城系統\bookstore\.settings\org.eclipse.core.resources.prefs
?????文件?????????395??2013-05-22?19:51??網上商城系統\網上商城系統\bookstore\.settings\org.eclipse.jdt.core.prefs
?????文件?????????553??2015-12-19?20:12??網上商城系統\網上商城系統\bookstore\.settings\org.eclipse.wst.common.component
?????文件?????????359??2015-12-14?09:06??網上商城系統\網上商城系統\bookstore\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2013-05-22?19:51??網上商城系統\網上商城系統\bookstore\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2013-05-22?19:51??網上商城系統\網上商城系統\bookstore\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2016-01-20?21:29??網上商城系統\網上商城系統\bookstore\sql\
?????文件???????10703??2013-05-31?10:27??網上商城系統\網上商城系統\bookstore\sql\bookstore.sql
?????目錄???????????0??2016-01-20?21:29??網上商城系統\網上商城系統\bookstore\src\
?????目錄???????????0??2016-01-20?21:29??網上商城系統\網上商城系統\bookstore\src\cn\
?????目錄???????????0??2016-01-20?21:29??網上商城系統\網上商城系統\bookstore\src\cn\ws\
?????目錄???????????0??2016-01-20?21:29??網上商城系統\網上商城系統\bookstore\src\cn\ws\bookstore\
?????目錄???????????0??2016-01-20?21:29??網上商城系統\網上商城系統\bookstore\src\cn\ws\bookstore\dao\
?????文件????????2992??2015-12-22?20:52??網上商城系統\網上商城系統\bookstore\src\cn\ws\bookstore\dao\BookDao.java
?????文件?????????555??2015-12-14?10:54??網上商城系統\網上商城系統\bookstore\src\cn\ws\bookstore\dao\CategoryDao.java
?????文件????????3365??2015-12-24?13:06??網上商城系統\網上商城系統\bookstore\src\cn\ws\bookstore\dao\OrderDao.java
?????文件????????2506??2015-12-21?21:11??網上商城系統\網上商城系統\bookstore\src\cn\ws\bookstore\dao\UserDao.java
............此處省略163個文件信息