package?cn.ytu.dao;

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

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

import?cn.ytu.domain.Category;
import?cn.ytu.exception.DaoException;
import?cn.ytu.utils.JdbcUtils;

public?class?CategoryDao?{

	public?void?addCategory（Category?category）?{
		try?{
			QueryRunner?qr?=?new?QueryRunner（JdbcUtils.getDataSource（））;
			String?sql?=?“insert?into?tbl_category?（namedescriptionstatus）?values?（???）“;
			object?params[]?=?{?category.getName（）?category.getDescription（）category.getStatus（）};
			qr.update（sql?params）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			throw?new?DaoException（）;
		}

	}

	public?List?listCategory（）?{
		try?{
			QueryRunner?qr?=?new?QueryRunner（JdbcUtils.getDataSource（））;
			String?sql?=?“select?*?from?tbl_category?where?status=0“;

			List?list?=?（List）?qr.query（sql
					new?BeanListHandler（Category.class））;
			return?list;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			throw?new?DaoException（）;
		}
	}

	public?void?deleteCategory（int?id）?{
		try?{
			QueryRunner?qr?=?new?QueryRunner（JdbcUtils.getDataSource（））;
			String?sql?=?“update?tbl_category?set?status=??where?id=?“;
????????????object?[]?params?=?{-1id};
			qr.update（sql?params）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			throw?new?DaoException（）;
		}
	}

	public?Category?query（int?id）?{
		try?{
			QueryRunner?qr?=?new?QueryRunner（JdbcUtils.getDataSource（））;
			String?sql?=?“select?*?from?tbl_category?where?id=?“;
			
			return?（Category）?qr
					.query（sql?id?new?BeanHandler（Category.class））;
		}?catch?（Exception?e）?{
			throw?new?DaoException（e）;
		}
	}
	
	public?void?update（Category?category）{
		try?{
			QueryRunner?qr?=?new?QueryRunner（JdbcUtils.getDataSource（））;
			String?sql?=?“update?tbl_category?set?name=?description=??where?id=?“;
			object[]?params?=?{category.getName（）category.getDescription（）category.getId（）};
			qr.update（sql?params）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			throw?new?RuntimeException（e）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-07-22?09:13??源碼\
?????目錄???????????0??2015-07-22?09:13??源碼\newsPubSystem\
?????文件????????1154??2015-07-14?17:26??源碼\newsPubSystem\.classpath
?????目錄???????????0??2015-07-22?09:13??源碼\newsPubSystem\.externalToolBuilders\
?????文件?????????548??2015-07-14?17:26??源碼\newsPubSystem\.externalToolBuilders\org.eclipse.wst.jsdt.core.javascriptValidator.launch
?????目錄???????????0??2015-07-14?17:26??源碼\newsPubSystem\.myeclipse\
?????文件?????????312??2015-07-16?14:27??源碼\newsPubSystem\.mymetadata
?????文件????????1987??2015-07-14?17:26??源碼\newsPubSystem\.project
?????目錄???????????0??2015-07-22?09:13??源碼\newsPubSystem\.settings\
?????文件?????????500??2015-07-14?17:26??源碼\newsPubSystem\.settings\.jsdtscope
?????文件??????????88??2015-07-14?17:26??源碼\newsPubSystem\.settings\org.eclipse.core.resources.prefs
?????文件?????????395??2015-07-14?17:26??源碼\newsPubSystem\.settings\org.eclipse.jdt.core.prefs
?????文件?????????477??2015-07-14?17:26??源碼\newsPubSystem\.settings\org.eclipse.wst.common.component
?????文件?????????252??2015-07-14?17:26??源碼\newsPubSystem\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2015-07-14?17:26??源碼\newsPubSystem\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-07-14?17:26??源碼\newsPubSystem\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2015-07-22?09:13??源碼\newsPubSystem\src\
?????文件?????????634??2015-07-14?17:26??源碼\newsPubSystem\src\c3p0-config.xml
?????目錄???????????0??2015-07-22?09:13??源碼\newsPubSystem\src\cn\
?????目錄???????????0??2015-07-22?09:13??源碼\newsPubSystem\src\cn\ytu\
?????目錄???????????0??2015-07-22?09:13??源碼\newsPubSystem\src\cn\ytu\dao\
?????文件????????2343??2015-07-14?17:26??源碼\newsPubSystem\src\cn\ytu\dao\CategoryDao.java
?????文件????????2893??2015-07-14?17:26??源碼\newsPubSystem\src\cn\ytu\dao\NewsDao.java
?????文件?????????642??2015-07-14?17:26??源碼\newsPubSystem\src\cn\ytu\dao\UserDao.java
?????目錄???????????0??2015-07-22?09:13??源碼\newsPubSystem\src\cn\ytu\domain\
?????文件?????????626??2015-07-14?17:26??源碼\newsPubSystem\src\cn\ytu\domain\Category.java
?????文件????????1033??2015-07-14?17:26??源碼\newsPubSystem\src\cn\ytu\domain\News.java
?????文件????????2323??2015-07-14?17:26??源碼\newsPubSystem\src\cn\ytu\domain\Page.java
?????文件?????????565??2015-07-14?17:26??源碼\newsPubSystem\src\cn\ytu\domain\User.java
?????目錄???????????0??2015-07-22?09:13??源碼\newsPubSystem\src\cn\ytu\exception\
?????文件?????????508??2015-07-14?17:26??源碼\newsPubSystem\src\cn\ytu\exception\DaoException.java
............此處省略476個文件信息