package?cn.itcast.itcaststore.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.itcaststore.domain.Notice;
import?cn.itcast.itcaststore.utils.DataSourceUtils;

public?class?NoticeDao?{
	//后臺系統(tǒng)，查詢所有的公告
	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））;
	}

	//后臺系統(tǒng)，添加公告
	public?void?addNotice（Notice?n）?throws?SQLException?{
		String?sql?=?“insert?into?notice（title

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

?????文件???????1546??2016-02-19?17:12??傳智書城\itcaststore\.classpath

?????文件???????1044??2016-02-16?10:03??傳智書城\itcaststore\.project

?????文件????????503??2016-02-16?10:03??傳智書城\itcaststore\.settings\.jsdtscope

?????文件????????364??2016-02-16?10:03??傳智書城\itcaststore\.settings\org.eclipse.jdt.core.prefs

?????文件????????485??2016-02-16?10:03??傳智書城\itcaststore\.settings\org.eclipse.wst.common.component

?????文件????????305??2016-02-19?16:53??傳智書城\itcaststore\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2016-02-16?10:03??傳智書城\itcaststore\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2016-02-16?10:03??傳智書城\itcaststore\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????330??2016-02-16?10:15??傳智書城\itcaststore\build\classes\c3p0-config.xml

?????文件???????2908??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\dao\NoticeDao.class

?????文件???????2501??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderDao$1.class

?????文件???????2832??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderDao$2.class

?????文件???????3143??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderDao$3.class

?????文件???????3199??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderDao$4.class

?????文件???????5032??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderDao.class

?????文件???????2669??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderItemDao$1.class

?????文件???????3005??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderItemDao.class

?????文件???????9090??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\dao\ProductDao.class

?????文件???????2559??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\dao\UserDao.class

?????文件???????1132??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\domain\Notice.class

?????文件???????3358??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\domain\Order.class

?????文件???????1123??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\domain\OrderItem.class

?????文件???????2186??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\domain\PageBean.class

?????文件???????3280??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\domain\Product.class

?????文件???????3115??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\domain\User.class

?????文件????????845??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\exception\ActiveUserException.class

?????文件????????845??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\exception\AddProductException.class

?????文件????????860??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\exception\FindProductByIdException.class

?????文件????????848??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\exception\ListProductException.class

?????文件????????830??2019-10-31?11:01??傳智書城\itcaststore\build\classes\cn\itcast\itcaststore\exception\LoginException.class

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