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（titledetailsn_time）?values（???）“;
		QueryRunner?runner?=?new?QueryRunner（DataSourceUtils.getDataSource（））;
		runner.update（sql?n.gettitle（）n.getDetails（）n.getN_time（））;
	}

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

	//后臺系統(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ǒ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））;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-06-12?17:27??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\
?????目錄???????????0??2018-06-12?17:27??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\
?????文件????????1546??2016-02-19?17:12??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\.classpath
?????文件????????1044??2016-02-16?10:03??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\.project
?????目錄???????????0??2018-06-12?17:27??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\.settings\
?????文件?????????503??2016-02-16?10:03??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\.settings\.jsdtscope
?????文件?????????364??2016-02-16?10:03??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\.settings\org.eclipse.jdt.core.prefs
?????文件?????????485??2016-02-16?10:03??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\.settings\org.eclipse.wst.common.component
?????文件?????????305??2016-02-19?16:53??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-02-16?10:03??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-02-16?10:03??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-06-12?17:27??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\
?????目錄???????????0??2018-06-12?17:27??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\meta-INF\
?????文件??????????39??2016-02-16?10:03??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-06-12?17:27??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\
?????目錄???????????0??2018-06-12?17:27??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\lib\
?????文件??????610790??2016-01-25?10:35??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\lib\c3p0-0.9.1.2.jar
?????文件??????232019??2016-01-25?10:35??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\lib\commons-beanutils-1.8.3.jar
?????文件???????49572??2016-01-25?10:35??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\lib\commons-dbutils-1.4.jar
?????文件???????57779??2016-01-25?10:35??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\lib\commons-fileupload-1.2.1.jar
?????文件??????109043??2016-01-25?10:35??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\lib\commons-io-1.4.jar
?????文件???????60841??2016-01-25?10:35??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\lib\commons-logging-1.1.1.jar
?????文件???????20682??2016-01-25?10:35??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\lib\jstl.jar
?????文件??????494975??2016-01-25?10:35??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\lib\mail.jar
?????文件??????540852??2016-01-25?10:35??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\lib\mysql-connector-java-5.0.8-bin.jar
?????文件??????393259??2016-01-25?10:35??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\lib\standard.jar
?????文件????????9042??2016-01-25?10:35??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\new_words.txt
?????文件?????????558??2016-05-17?15:35??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\userPrivilegeTag.tld
?????文件???????11548??2016-04-11?16:45??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\WEB-INF\web.xml
?????目錄???????????0??2018-06-12?17:27??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\admin\
?????目錄???????????0??2018-06-12?17:27??javaweb網(wǎng)上書城源碼（包含數(shù)據(jù)庫）\itcaststore\WebContent\admin\css\
............此處省略555個文件信息