package?com.sys.dao;

import?java.util.ArrayList;
import?java.util.List;

import?com.sys.entity.ProdeuctQueryObj;
import?com.sys.entity.Product;
import?com.sys.utils.JDBCUtils;
import?com.sys.utils.StringUtils;


public?class?ProductDao?{
	//?創(chuàng)建一個JDBC
	private?JDBCUtils?util?=?new?JDBCUtils（）;

	public?ProductDao（）?{
		util.getConnection（）;
	}

	//?查找?多個人
	public?List?queryAllproducts（）?throws?Exception?{
		String?sql?=?“SELECT?*?FROM?product“;
		List?list?=?util.findMoreRefResult（sql?null?Product.class）;
		util.releaseConn（）;
		return?list;

	}

	/**
	?*?高級查詢
	?*?
	?*?@param?po
	?*?@return
	?*?@throws?Exception
	?*/
	public?List?querryAll（ProdeuctQueryObj?po）?throws?Exception?{
		String?sql?=?“SELECT?*?FROM?product?“?+?po.getQuerySql（）;
		Listject>?params?=?po.getParams（）;

		List?list?=?util.findMoreRefResult（sql?params?Product.class）;
		util.releaseConn（）;
		return?list;
	}
	/**
	?*?通過ID查詢信息
	?*?@param?id
	?*?@return
	?*?@throws?Exception
	?*/
	public?List?querryAll（Long?id）?throws?Exception{
		String?sql?=?“SELECT?*?FROM?product?WHERE?dir_id?=??“;
		Listject>?params?=?new?ArrayListject>（）;
		params.add（id）;
		List?list?=?util.findMoreRefResult（sql?params?Product.class）;
		util.releaseConn（）;
		return?list;
	}
	
	
		
	//?---------------------------------------------------------------------------
	/**
	?*?高級查詢?查詢多條件
	?*?
	?*?@param?name
	?*?@param?pmin
	?*?@param?pmax
	?*?@return?查詢結果列表
	?*?@throws?Exception
	?*/
	public?List?queryAllproducts（String?name?Double?pmin?Double?pmax）
			throws?Exception?{

		StringBuilder?sql?=?new?StringBuilder（“SELECT?*?FROM?product“）;
		Listject>?params?=?new?ArrayListject>（）;
		Listject>?sqltemp?=?new?ArrayListject>（）;

		if?（StringUtils.hasLength（name））?{
			sqltemp.add（“productName?LIKE??“）;
			//?sql.append（“?AND?productName?LIKE??“）;
			params.add（“%“?+?name?+?“%“）;
		}
		if?（pmin?!=?null）?{
			sqltemp.add（“salePrice?>=??“）;
			//?sql.append（“?AND?salePrice?>=??“）;
			params.add（pmin）;
		}
		if?（pmax?!=?null）?{
			sqltemp.add（“salePrice?<=??“）;
			//?sql.append（“?AND?salePrice?<=??“）;
			params.add（pmax）;
		}

		/*
		?*?//方式一：?for（int?i=0;i		?*?sql.append（“?WHERE?“）;?}else{?//非第一項?sql.append（“?AND?“）;?}
		?*?sql.append（sqltemp.get（i））;?}
		?*/

		//?方式二：
		if?（sqltemp.size（）?>?0）?{
			sql.append（“?WHERE?“）;
			sql.append（org.apache.commons.lang3.StringUtils.join（sqltemp
					“?AND?“））;
		}
		List?list?=?util.findMoreRefResult（sql.toString（）?params
				Product.class）;
		util.releaseConn（）;
		return?list;
	}

}

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

?????文件????????841??2017-10-31?10:39??Querrymore\.classpath

?????文件????????303??2017-10-30?16:34??Querrymore\.mymetadata

?????文件???????1753??2017-10-30?18:03??Querrymore\.project

?????文件????????500??2017-10-30?16:34??Querrymore\.settings\.jsdtscope

?????文件????????364??2017-10-30?16:33??Querrymore\.settings\org.eclipse.jdt.core.prefs

?????文件????????468??2017-10-30?16:34??Querrymore\.settings\org.eclipse.wst.common.component

?????文件????????252??2017-10-30?16:34??Querrymore\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-10-30?16:34??Querrymore\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-10-30?16:34??Querrymore\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1123??2017-12-10?12:38??Querrymore\jdbc.sql

?????文件???????2844??2017-10-31?16:08??Querrymore\src\com\sys\dao\ProductDao.java

?????文件????????544??2017-10-31?16:39??Querrymore\src\com\sys\dao\ProductDirDao.java

?????文件????????887??2017-10-31?16:38??Querrymore\src\com\sys\entity\ProdectDir.java

?????文件???????1843??2017-10-31?18:29??Querrymore\src\com\sys\entity\ProdeuctQueryObj.java

?????文件???????2051??2017-10-30?17:58??Querrymore\src\com\sys\entity\Product.java

?????文件???????1109??2017-10-31?15:44??Querrymore\src\com\sys\entity\QueryObj.java

?????文件???????2903??2017-10-31?17:19??Querrymore\src\com\sys\servlet\ProductServlet.java

?????文件????????610??2017-10-31?15:54??Querrymore\src\com\sys\test\TestServlet.java

?????文件???????5723??2017-10-31?14:24??Querrymore\src\com\sys\utils\JDBCUtils.java

?????文件????????415??2017-10-31?14:22??Querrymore\src\com\sys\utils\StringUtils.java

?????文件????????829??2017-10-30?16:33??Querrymore\WebRoot\index.jsp

?????文件?????????36??2017-10-30?16:33??Querrymore\WebRoot\meta-INF\MANIFEST.MF

?????文件???????3282??2017-10-31?16:08??Querrymore\WebRoot\WEB-INF\classes\com\sys\dao\ProductDao.class

?????文件???????1059??2017-10-31?16:39??Querrymore\WebRoot\WEB-INF\classes\com\sys\dao\ProductDirDao.class

?????文件???????1521??2017-10-31?16:38??Querrymore\WebRoot\WEB-INF\classes\com\sys\entity\ProdectDir.class

?????文件???????2054??2017-10-31?18:29??Querrymore\WebRoot\WEB-INF\classes\com\sys\entity\ProdeuctQueryObj.class

?????文件???????2882??2017-10-31?10:39??Querrymore\WebRoot\WEB-INF\classes\com\sys\entity\Product.class

?????文件???????1530??2017-10-31?15:44??Querrymore\WebRoot\WEB-INF\classes\com\sys\entity\QueryObj.class

?????文件???????3362??2017-10-31?17:19??Querrymore\WebRoot\WEB-INF\classes\com\sys\servlet\ProductServlet.class

?????文件????????822??2017-10-31?15:54??Querrymore\WebRoot\WEB-INF\classes\com\sys\test\TestServlet.class

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