package?cn.product.dao;

import?java.sql.Connection;
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?cn.product.domain.Product;
import?cn.product.utils.JDBCUtils;


public?class?ProductDao?{

	public?List?findAll（）?throws?SQLException?{
		QueryRunner?queryRunner?=?new?QueryRunner（JDBCUtils.getDataSource（））;
		String?sql=“select?*?from?product??order?by?pdate?desc“;
		List?list?=?queryRunner.query（sql?new?BeanListHandler（Product.class））;
		
		return?list;
	}

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

	public?void?deleteProduct（String?productID）?throws?SQLException?{
		QueryRunner?queryRunner?=?new?QueryRunner（JDBCUtils.getDataSource（））;
		String?sql?=?“delete?from?product?where?pid?=??“;
		queryRunner.update（sql?productID）;
	}

	public?Product?findProductById（String?productID）?throws?SQLException?{
		QueryRunner?queryRunner?=?new?QueryRunner（JDBCUtils.getDataSource（））;
		String?sql?=?“select?*?from?product?where?pid?=??“;
		Product?product?=?queryRunner.query（sql??new?BeanHandler（Product.class）productID）;
		return?product;
	}

	public?void?updateProduct（Product?product）?throws?SQLException?{
		
		QueryRunner?queryRunner?=?new?QueryRunner（JDBCUtils.getDataSource（））;
		String?sql?=?“update?product?set?pname=?market_price=?shop_price=?pdate=?is_hot=?pdesc=?pflag=??where?pid=?“;
		queryRunner.update（sqlproduct.getPname（）product.getMarket_price（）product.getShop_price（）product.getPdate（）product.getIs_hot（）product.getPdesc（）product.getPflag（）product.getPid（））;
		
	}

	public?List?selectByProudctName（String?pname）?throws?SQLException?{
		QueryRunner?queryRunner?=?new?QueryRunner（JDBCUtils.getDataSource（））;
	
		String?sql?=?“select?*?from?product?where?pname?like??“;
		List?list?=?queryRunner.query（sql?new?BeanListHandler（Product.class）“%“+pname+“%“）;
		
		
		return?list;
	}

	public?void?deleteAllProduct（Connection?conn?String?pid）?throws?SQLException?{
		QueryRunner?queryRunner?=?new?QueryRunner（）;
		String?sql?=?“delete?from?product?where?pid?=??“;
		
		queryRunner.update（connsqlpid）;
	}

	public?List?findByPage（String?pageNo）?throws?NumberFormatException?SQLException?{
		QueryRunner?queryRunner?=?new?QueryRunner（JDBCUtils.getDataSource（））;
		String

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

?????文件????????661??2017-11-11?14:02??web_product\.classpath

?????文件???????1044??2017-11-11?14:02??web_product\.project

?????文件????????567??2017-11-11?14:02??web_product\.settings\.jsdtscope

?????文件????????539??2017-11-11?14:02??web_product\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2017-11-11?14:02??web_product\.settings\org.eclipse.jdt.core.prefs

?????文件????????485??2017-11-11?14:02??web_product\.settings\org.eclipse.wst.common.component

?????文件????????345??2017-11-11?14:02??web_product\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-11-11?14:02??web_product\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-11-11?14:02??web_product\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????461??2017-11-11?14:02??web_product\build\classes\c3p0-config.xml

?????文件???????4641??2017-11-11?14:02??web_product\build\classes\cn\product\dao\ProductDao.class

?????文件???????1616??2017-11-11?14:02??web_product\build\classes\cn\product\domain\PageBean.class

?????文件???????2181??2017-11-11?14:02??web_product\build\classes\cn\product\domain\Product.class

?????文件???????3517??2017-11-11?14:02??web_product\build\classes\cn\product\service\ProductService.class

?????文件???????2894??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductAddServlet.class

?????文件???????1763??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductDeleteAllServlet.class

?????文件???????1670??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductDeleteServlet.class

?????文件???????1721??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductfindAllServlet.class

?????文件???????1870??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductfindByPageServlet.class

?????文件???????2862??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductToUpdateServlet.class

?????文件???????1763??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductUpdateServlet.class

?????文件???????1921??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\SelectByProudctNameServlet.class

?????文件????????738??2017-11-11?14:02??web_product\build\classes\cn\product\utils\JDBCUtils.class

?????文件????????634??2017-11-11?14:02??web_product\build\classes\cn\product\utils\UUIDUtils.class

?????文件????????461??2017-11-11?14:02??web_product\src\c3p0-config.xml

?????文件???????3521??2017-11-11?14:02??web_product\src\cn\product\dao\ProductDao.java

?????文件???????1052??2017-11-11?14:02??web_product\src\cn\product\domain\PageBean.java

?????文件???????1435??2017-11-11?14:02??web_product\src\cn\product\domain\Product.java

?????文件???????2599??2017-11-11?14:02??web_product\src\cn\product\service\ProductService.java

?????文件???????2392??2017-11-11?14:02??web_product\src\cn\product\servlet\ProductAddServlet.java

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