package?com.itheima.dao;

import?java.sql.SQLException;
import?java.util.ArrayList;
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?com.itheima.domain.Category;
import?com.itheima.domain.Product;
import?com.itheima.utils.DataSourceUtils;
import?com.itheima.vo.Condition;

public?class?AdminProductDao?{

	public?List?findAllProduct（）?throws?SQLException?{
		QueryRunner?runner?=?new?QueryRunner（DataSourceUtils.getDataSource（））;
		String?sql?=?“select?*?from?product“;
		List?productList?=?runner.query（sql?new?BeanListHandler（Product.class））;
		return?productList;
	}

	public?List?findAllCategory（）?throws?SQLException?{
		QueryRunner?runner?=?new?QueryRunner（DataSourceUtils.getDataSource（））;
		String?sql?=?“select?*?from?category“;
		List?categoryList?=?runner.query（sql?new?BeanListHandler（Category.class））;
		return?categoryList;
	}

	public?void?addProduct（Product?product）?throws?SQLException?{
		QueryRunner?runner?=?new?QueryRunner（DataSourceUtils.getDataSource（））;
		String?sql?=?“insert?into?product?values（?????????）“;
		runner.update（sql?product.getPid（）product.getPname（）product.getMarket_price（）
					product.getShop_price（）product.getPdate（）product.getIs_hot（）
					product.getPdesc（）product.getPflag（）product.getCid（））;
		
	}

	public?void?delProductByPid（String?pid）?throws?SQLException?{
		QueryRunner?runner?=?new?QueryRunner（DataSourceUtils.getDataSource（））;
		String?sql?=?“delete?from?product?where?pid=?“;
		runner.update（sql?pid）;
		
	}

	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;
	}
	public?List?findProductListByCondition（Condition?condition）?throws?SQLException?{
		QueryRunner?runner?=?new?QueryRunner（DataSourceUtils.getDataSource（））;
		//定義一個存儲實際參數(shù)的容器
		List?list?=?new?ArrayList（）;
		String?sql?=?“select?*?from?product?where?1=1“;
		if（condition.getPname（）!=null&&!condition.getPname（）.trim（）.equals（““））{
			sql+=“?and?pname?like???“;
			list.add（“%“+condition.getPname（）.trim（）+“%“）;
		}
		if（condition.getIsHot（）!=null&&!condition.getIsHot（）.trim（）.equals（““））{
			sql+=“?and?is_hot=??“;
			list.add（condition.getIsHot（）.trim（））;
		}
		if（condition.getCid（）!=null&&!condition.getCid（）.trim（）.equals（““））{
			sql+=“?and?cid=??“;
			list.add（condition.getCid（）.trim（））;
		}
List?productList?=?runner.query（sql?new?BeanListHandler（Product.class）??list.toArray（））;
		
		return?productList;
	}

	public?void?updateProduct（Product?product）?throws?SQLException?{
		QueryRu

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-11-22?19:48??AddProduct\
?????文件????????1399??2018-11-19?10:06??AddProduct\.classpath
?????文件?????????910??2018-06-10?11:11??AddProduct\.project
?????目錄???????????0??2018-11-22?19:48??AddProduct\.settings\
?????文件?????????567??2018-06-10?11:11??AddProduct\.settings\.jsdtscope
?????文件??????????96??2018-06-10?11:51??AddProduct\.settings\org.eclipse.core.resources.prefs
?????文件????????7200??2018-06-10?20:10??AddProduct\.settings\org.eclipse.jdt.core.prefs
?????文件?????????482??2018-11-22?10:08??AddProduct\.settings\org.eclipse.wst.common.component
?????文件?????????345??2018-06-10?11:11??AddProduct\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-06-10?11:11??AddProduct\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-06-10?11:11??AddProduct\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-11-22?19:48??AddProduct\build\
?????目錄???????????0??2018-11-22?19:48??AddProduct\build\classes\
?????文件?????????321??2018-06-14?09:52??AddProduct\build\classes\c3p0-config.xml
?????目錄???????????0??2018-11-22?19:48??AddProduct\build\classes\com\
?????目錄???????????0??2018-11-22?19:48??AddProduct\build\classes\com\itheima\
?????目錄???????????0??2018-11-22?19:48??AddProduct\build\classes\com\itheima\dao\
?????文件????????4702??2018-11-20?10:05??AddProduct\build\classes\com\itheima\dao\AdminProductDao.class
?????文件????????2629??2018-11-20?10:05??AddProduct\build\classes\com\itheima\dao\ProductDao.class
?????文件????????1121??2018-11-20?10:05??AddProduct\build\classes\com\itheima\dao\UserDao.class
?????目錄???????????0??2018-11-22?19:48??AddProduct\build\classes\com\itheima\domain\
?????文件?????????719??2018-11-20?10:05??AddProduct\build\classes\com\itheima\domain\Category.class
?????文件????????2266??2018-11-20?10:05??AddProduct\build\classes\com\itheima\domain\Product.class
?????文件?????????924??2018-11-20?10:05??AddProduct\build\classes\com\itheima\domain\User.class
?????目錄???????????0??2018-11-22?19:48??AddProduct\build\classes\com\itheima\service\
?????文件????????1866??2018-11-20?10:05??AddProduct\build\classes\com\itheima\service\AdminProductService.class
?????文件????????1791??2018-11-20?10:05??AddProduct\build\classes\com\itheima\service\ProductService.class
?????文件?????????648??2018-11-20?10:05??AddProduct\build\classes\com\itheima\service\UserService.class
?????目錄???????????0??2018-11-20?10:05??AddProduct\build\classes\com\itheima\utils\
?????文件????????2236??2018-11-20?10:05??AddProduct\build\classes\com\itheima\utils\DataSourceUtils.class
?????目錄???????????0??2018-11-22?19:48??AddProduct\build\classes\com\itheima\vo\
............此處省略458個文件信息