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ái)系統(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ái)系統(tǒng)，添加公告
	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（））;
	}

	//后臺(tái)系統(tǒng)，根據(jù)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）;
	}

	//后臺(tái)系統(tǒng)，根據(jù)id修改單個(gè)公告
	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（））;
	}

	//后臺(tái)系統(tǒng)，根據(jù)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）;
	}

	//前臺(tái)系統(tǒng)，查詢最新添加或修改的一條公告
	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））;
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-04-20?16:22??第13-15章\
?????目錄???????????0??2017-04-20?16:22??第13-15章\itcaststore\
?????文件???????14326??2016-06-13?18:00??第13-15章\itcaststore.sql
?????文件????????1546??2016-02-19?17:12??第13-15章\itcaststore\.classpath
?????文件????????1044??2016-02-16?10:03??第13-15章\itcaststore\.project
?????目錄???????????0??2017-04-20?16:22??第13-15章\itcaststore\.settings\
?????文件?????????503??2016-02-16?10:03??第13-15章\itcaststore\.settings\.jsdtscope
?????文件?????????364??2016-02-16?10:03??第13-15章\itcaststore\.settings\org.eclipse.jdt.core.prefs
?????文件?????????485??2016-02-16?10:03??第13-15章\itcaststore\.settings\org.eclipse.wst.common.component
?????文件?????????305??2016-02-19?16:53??第13-15章\itcaststore\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-02-16?10:03??第13-15章\itcaststore\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-02-16?10:03??第13-15章\itcaststore\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-04-20?16:22??第13-15章\itcaststore\build\
?????目錄???????????0??2017-04-20?16:22??第13-15章\itcaststore\build\classes\
?????文件?????????330??2016-02-16?10:15??第13-15章\itcaststore\build\classes\c3p0-config.xml
?????目錄???????????0??2017-04-20?16:22??第13-15章\itcaststore\build\classes\cn\
?????目錄???????????0??2017-04-20?16:22??第13-15章\itcaststore\build\classes\cn\itcast\
?????目錄???????????0??2017-04-20?16:22??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\
?????目錄???????????0??2017-04-20?16:22??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\dao\
?????文件????????2908??2016-02-19?17:12??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\dao\NoticeDao.class
?????文件????????2501??2016-02-19?17:12??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderDao$1.class
?????文件????????2832??2016-02-19?17:12??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderDao$2.class
?????文件????????3143??2016-02-19?17:12??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderDao$3.class
?????文件????????3199??2016-02-19?17:12??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderDao$4.class
?????文件????????5032??2016-02-19?17:12??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderDao.class
?????文件????????2669??2016-02-19?17:12??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderItemDao$1.class
?????文件????????3005??2016-02-19?17:12??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\dao\OrderItemDao.class
?????文件????????9083??2016-02-19?17:12??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\dao\ProductDao.class
?????文件????????2559??2016-04-15?11:09??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\dao\UserDao.class
?????目錄???????????0??2017-04-20?16:22??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\domain\
?????文件????????1132??2016-02-19?17:12??第13-15章\itcaststore\build\classes\cn\itcast\itcaststore\domain\Notice.class
............此處省略555個(gè)文件信息