package?com.itheima.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?org.apache.commons.dbutils.handlers.ScalarHandler;

import?com.itheima.domain.Category;
import?com.itheima.domain.Product;
import?com.itheima.utils.DataSourceUtils;

public?class?ProductDao?{
//獲得最熱商品
	
	public?List?findHotProductList（）?throws?SQLException?{
		QueryRunner?runner=new?QueryRunner（DataSourceUtils.getDataSource（））;
		String?sql=“select?*?from?product?where?is_hot=1?limit???“;
		List?listHotProduct?=?runner.query（sql?new?BeanListHandler（Product.class）09）;
		
		return?listHotProduct;
	}
//獲得最新的商品
	
	public?List?findNewProductList（）?throws?SQLException?{
		QueryRunner?runner=new?QueryRunner（DataSourceUtils.getDataSource（））;
		String?sql=“select?*?from?product?order?by?pdate?desc?limit???“;
		List?listNewProduct?=?runner.query（sql?new?BeanListHandler（Product.class）09）;
		return?listNewProduct;
	}
//獲得分類數據
	public?List?findAllCategory（）?throws?SQLException?{
		QueryRunner?runner=new?QueryRunner（DataSourceUtils.getDataSource（））;
		String?sql=“select?*?from?category“;
		List?listCategory?=?runner.query（sql?new?BeanListHandler（Category.class））;
		return?listCategory;
	}
//獲取到分頁操作中商品的總條數
	
	public?int?getTotalCount（String?cid）?throws?SQLException?{
		QueryRunner?runner=new?QueryRunner（DataSourceUtils.getDataSource（））;
		String?sql=“select?count（*）?from?product?where?cid=?“;
		Long?TotalCount?=?（Long）runner.query（sqlnew?ScalarHandler（）cid）;
		return?TotalCount.intValue（）;
	}
//顯示每一頁的數據

	public?List?findCurrentPageProductByPage（String?cid?int?index
			int?currentCount）?throws?SQLException?{
		QueryRunner?runner=new?QueryRunner（DataSourceUtils.getDataSource（））;
		String?sql=“select?*?from?product?where?cid=??limit???“;
		List?list?=?runner.query（sql?new?BeanListHandler（Product.class）cidindexcurrentCount）;
		return?list;
	}
//獲取商品的詳細信息；
	public?Product?findProductByPid（String?pid）?throws?SQLException?{
		QueryRunner?runner=new?QueryRunner（DataSourceUtils.getDataSource（））;
		String?sql=“select?*?from?product?where?pid=?“;
		Product?product?=?runner.query（sql?new?BeanHandler（Product.class）pid）;
		return?product;
	}

}

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

?????文件????????834??2017-11-18?20:50??Shop\.classpath

?????文件???????1037??2017-11-18?20:50??Shop\.project

?????文件????????503??2017-11-18?20:50??Shop\.settings\.jsdtscope

?????文件????????145??2017-11-18?20:59??Shop\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2017-11-18?20:50??Shop\.settings\org.eclipse.jdt.core.prefs

?????文件????????464??2017-11-18?20:50??Shop\.settings\org.eclipse.wst.common.component

?????文件????????345??2017-11-18?20:50??Shop\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-11-18?20:50??Shop\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-11-18?20:50??Shop\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????336??2017-11-18?20:57??Shop\build\classes\c3p0-config.xml

?????文件???????3331??2017-12-19?14:28??Shop\build\classes\com\itheima\dao\ProductDao.class

?????文件???????2114??2017-12-19?10:09??Shop\build\classes\com\itheima\dao\UserDao.class

?????文件???????1065??2017-12-20?15:12??Shop\build\classes\com\itheima\domain\Cart.class

?????文件????????992??2017-12-20?16:36??Shop\build\classes\com\itheima\domain\CartItem.class

?????文件????????719??2017-12-19?10:09??Shop\build\classes\com\itheima\domain\Category.class

?????文件???????1788??2017-12-19?10:09??Shop\build\classes\com\itheima\domain\pageBean.class

?????文件???????2438??2017-12-19?10:09??Shop\build\classes\com\itheima\domain\Product.class

?????文件???????2293??2017-12-19?10:09??Shop\build\classes\com\itheima\domain\User.class

?????文件???????2977??2017-12-19?14:29??Shop\build\classes\com\itheima\service\ProductService.class

?????文件???????1487??2017-12-19?10:09??Shop\build\classes\com\itheima\service\UserService.class

?????文件???????4581??2017-12-19?10:09??Shop\build\classes\com\itheima\utils\CheckImgServlet.class

?????文件????????465??2017-12-19?10:09??Shop\build\classes\com\itheima\utils\CommonUtils.class

?????文件???????2143??2017-12-19?10:09??Shop\build\classes\com\itheima\utils\DataSourceUtils.class

?????文件???????2231??2017-12-19?10:09??Shop\build\classes\com\itheima\utils\JedisPoolUtils.class

?????文件????????686??2017-12-19?10:09??Shop\build\classes\com\itheima\utils\MailUtils$1.class

?????文件???????1998??2017-12-19?10:09??Shop\build\classes\com\itheima\utils\MailUtils.class

?????文件???????1572??2017-12-19?10:09??Shop\build\classes\com\itheima\utils\MD5Utils.class

?????文件???????1905??2017-12-19?10:09??Shop\build\classes\com\itheima\web\ActiveServlet.class

?????文件???????1632??2017-12-20?16:14??Shop\build\classes\com\itheima\web\baseServlet.class

?????文件???????1792??2017-12-19?10:09??Shop\build\classes\com\itheima\web\CheckUsernameServlet.class

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