package?cn.easybuy.dao;
import?java.sql.*;
import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;

import?org.apache.log4j.Logger;

import?cn.easybuy.entity.ProductCategory;
import?cn.easybuy.utils.EmptyUtils;
import?cn.easybuy.utils.Params;

/**
?*?基礎dao的實現類，實現最基本的增刪查改的方法
?*/
public?abstract??class?baseDaoImpl?implements?IbaseDao?{

	protected?Connection?connection;

	protected?PreparedStatement?pstm;
	
	static?Logger?logger=Logger.getLogger（baseDaoImpl.class）;
			
	public?baseDaoImpl（Connection?connection）?{
		this.connection?=?connection;
	}

	public?ResultSet?executeQuery（String?sqlobject[]?params）{
		ResultSet?rs=null;
		try?{
			pstm?=?connection.prepareStatement（sql）;
			for（int?i?=?0;?i?				pstm.setobject（i+1?params[i]）;
			}
			rs?=?pstm.executeQuery（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		
		return?rs;
	}
	
	//增刪改操作?delete?from?news_detail?where?id=??and?title=?
	public?int?executeUpdate（String?sqlobject[]?params）{
		int?updateRows?=?0;
		try?{
			pstm?=?connection.prepareStatement（sql）;
			for（int?i?=?0;?i?				pstm.setobject（i+1?params[i]）;
			}
			updateRows?=?pstm.executeUpdate（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			updateRows?=?-1;
		}
		
		return?updateRows;
	}
	
	public?int?executeInsert（String?sqlobject[]?params）{
		Long?id?=?0L;
		try?{
			pstm?=?connection.prepareStatement（sqlStatement.RETURN_GENERATED_KEYS）;
			for（int?i?=?0;?i?				pstm.setobject（i+1?params[i]）;
			}
			pstm.executeUpdate（）;
			ResultSet?rs?=?pstm.getGeneratedKeys（）;?
			if?（rs.next（））?{?
				id?=?rs.getLong（1）;
				System.out.println（“數據主鍵：“?+?id）;?
			}?
			
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			id?=null;
		}
		
		return?id.intValue（）;
	}
	
	
	//釋放資源
	public?boolean?closeResource（）{
		if（pstm?!=?null）{
			try?{
				pstm.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
				return?false;
			}
		}
		return?true;
	}
	
	public?boolean?closeResource（ResultSet?reSet）{
		if（reSet?!=?null）{
			try?{
				reSet.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				return?false;
			}
		}
		return?true;
	}
	/**
	?*?需要重寫的方法
	?*
	?*?@param?rs
	?*?@return
	?*?@throws?Exception
	?*/
	public?abstract?object?tableToClass（ResultSet?rs）?throws?Exception;
	
}

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

?????文件????????961??2018-06-24?22:31??EasyBuy\EasyBuy\.classpath

?????文件????????294??2016-10-21?17:48??EasyBuy\EasyBuy\.mymetadata

?????文件???????1750??2016-05-31?09:04??EasyBuy\EasyBuy\.project

?????文件????????500??2016-05-31?09:01??EasyBuy\EasyBuy\.settings\.jsdtscope

?????文件????????174??2018-06-24?22:32??EasyBuy\EasyBuy\.settings\com.genuitec.eclipse.core.prefs

?????文件????????247??2018-06-24?22:31??EasyBuy\EasyBuy\.settings\com.genuitec.eclipse.migration.prefs

?????文件?????????57??2016-10-21?17:50??EasyBuy\EasyBuy\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2016-05-31?09:01??EasyBuy\EasyBuy\.settings\org.eclipse.jdt.core.prefs

?????文件????????627??2018-06-24?22:31??EasyBuy\EasyBuy\.settings\org.eclipse.wst.common.component

?????文件????????361??2018-06-24?22:31??EasyBuy\EasyBuy\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2016-05-31?09:01??EasyBuy\EasyBuy\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2016-05-31?09:01??EasyBuy\EasyBuy\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1177??2016-10-21?17:47??EasyBuy\EasyBuy\EasyBuy.iml

?????文件????????147??2018-06-24?23:09??EasyBuy\EasyBuy\resources\database.properties

?????文件???????2375??2016-06-02?15:07??EasyBuy\EasyBuy\resources\log4j.properties

?????文件???????2601??2016-09-02?14:10??EasyBuy\EasyBuy\src\cn\easybuy\dao\baseDaoImpl.java

?????文件???????1579??2016-08-30?14:17??EasyBuy\EasyBuy\src\cn\easybuy\dao\IbaseDao.java

?????文件???????1074??2016-10-24?13:10??EasyBuy\EasyBuy\src\cn\easybuy\dao\news\NewsDao.java

?????文件???????3843??2016-10-24?13:08??EasyBuy\EasyBuy\src\cn\easybuy\dao\news\NewsDaoImpl.java

?????文件????????703??2016-10-21?17:50??EasyBuy\EasyBuy\src\cn\easybuy\dao\order\OrderDao.java

?????文件???????4250??2016-10-21?16:44??EasyBuy\EasyBuy\src\cn\easybuy\dao\order\OrderDaoImpl.java

?????文件????????754??2016-10-21?17:51??EasyBuy\EasyBuy\src\cn\easybuy\dao\order\OrderDetailDao.java

?????文件???????4341??2016-10-21?16:46??EasyBuy\EasyBuy\src\cn\easybuy\dao\order\OrderDetailDaoImpl.java

?????文件????????528??2016-10-24?13:11??EasyBuy\EasyBuy\src\cn\easybuy\dao\order\UserAddressDao.java

?????文件???????3609??2016-10-24?13:12??EasyBuy\EasyBuy\src\cn\easybuy\dao\order\UserAddressDaoImpl.java

?????文件???????1392??2016-10-24?13:08??EasyBuy\EasyBuy\src\cn\easybuy\dao\product\ProductCategoryDao.java

?????文件???????6550??2016-10-24?14:01??EasyBuy\EasyBuy\src\cn\easybuy\dao\product\ProductCategoryDaoImpl.java

?????文件???????1000??2016-10-24?13:03??EasyBuy\EasyBuy\src\cn\easybuy\dao\product\ProductDao.java

?????文件???????6769??2016-10-21?17:09??EasyBuy\EasyBuy\src\cn\easybuy\dao\product\ProductDaoImpl.java

?????文件????????833??2016-10-21?17:52??EasyBuy\EasyBuy\src\cn\easybuy\dao\user\UserDao.java

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