package?cn.itcast.bookStore.dao;

import?java.sql.SQLException;
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.itcast.bookStore.domain.Notice;
import?cn.itcast.bookStore.utils.DataSourceUtils;

public?class?NoticeDao?{
	//后臺系統，查詢所有的公告
	public?List?getAllNotices（）?throws?SQLException?{
		String?sql?=?“select?*?from?notice?order?by?n_time?desc?limit?010“;
		QueryRunner?runner?=?new?QueryRunner（DataSourceUtils.getDataSource（））;
		return?runner.query（sql?new?BeanListHandler（Notice.class））;
	}

	//后臺系統，添加公告
	public?void?addNotice（Notice?n）?throws?SQLException?{
		String?sql?=?“insert?into?notice（titledetailsn_time）?values（???）“;
		QueryRunner?runner?=?new?QueryRunner（DataSourceUtils.getDataSource（））;
		runner.update（sql?n.gettitle（）n.getDetails（）n.getN_time（））;
	}

	//后臺系統，根據id查找公告
	public?Notice?findNoticeById（String?n_id）?throws?SQLException?{
		String?sql?=?“select?*?from?notice?where?n_id?=??“;
		QueryRunner?runner?=?new?QueryRunner（DataSourceUtils.getDataSource（））;
		return?runner.query（sql?new?BeanHandler（Notice.class）n_id）;
	}

	//后臺系統，根據id修改單個公告
	public?void?updateNotice（Notice?n）?throws?SQLException?{
		String?sql?=?“update?notice?set?title=?details=?n_time=??where?n_id=?“;
		QueryRunner?runner?=?new?QueryRunner（DataSourceUtils.getDataSource（））;
		runner.update（sql?n.gettitle（）n.getDetails（）n.getN_time（）n.getN_id（））;
	}

	//后臺系統，根據id刪除公告
	public?void?deleteNotice（String?n_id）?throws?SQLException?{
		String?sql?=?“delete?from?notice?where?n_id?=??“;
		QueryRunner?runner?=?new?QueryRunner（DataSourceUtils.getDataSource（））;
		runner.update（sql?n_id）;
	}

	//前臺系統，查詢最新添加或修改的一條公告
	public?Notice?getRecentNotice（）?throws?SQLException?{
		String?sql?=?“select?*?from?notice?order?by?n_time?desc?limit?01“;
		QueryRunner?runner?=?new?QueryRunner（DataSourceUtils.getDataSource（））;
		return?runner.query（sql?new?BeanHandler（Notice.class））;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1590??2015-12-01?09:33??bookstore\.classpath

?????文件???????1042??2015-12-01?09:30??bookstore\.project

?????文件????????503??2015-12-01?09:30??bookstore\.settings\.jsdtscope

?????文件????????105??2015-12-01?09:30??bookstore\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2015-12-01?09:30??bookstore\.settings\org.eclipse.jdt.core.prefs

?????文件????????479??2015-12-01?09:30??bookstore\.settings\org.eclipse.wst.common.component

?????文件????????345??2015-12-01?09:30??bookstore\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-12-01?09:30??bookstore\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-12-01?09:30??bookstore\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2341??2015-12-01?09:30??bookstore\build\classes\bookstore.sql

?????文件????????328??2015-12-01?09:30??bookstore\build\classes\c3p0-config.xml

?????文件???????2890??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\dao\NoticeDao.class

?????文件???????2473??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\dao\OrderDao$1.class

?????文件???????2814??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\dao\OrderDao$2.class

?????文件???????3125??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\dao\OrderDao$3.class

?????文件???????3173??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\dao\OrderDao$4.class

?????文件???????4858??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\dao\OrderDao.class

?????文件???????2635??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\dao\OrderItemDao$1.class

?????文件???????2971??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\dao\OrderItemDao.class

?????文件???????9050??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\dao\ProductDao.class

?????文件???????2543??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\dao\UserDao.class

?????文件???????1128??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\domain\Notice.class

?????文件???????3342??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\domain\Order.class

?????文件???????1107??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\domain\OrderItem.class

?????文件???????2112??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\domain\PageBean.class

?????文件???????3212??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\domain\Product.class

?????文件???????3047??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\domain\User.class

?????文件????????777??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\exception\ActiveUserException.class

?????文件????????777??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\exception\AddProductException.class

?????文件????????792??2016-05-09?11:00??bookstore\build\classes\cn\itcast\bookStore\exception\FindProductByIdException.class

............此處省略499個文件信息