package?cn.buy.dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;



public?class?baseDao?{
	//?定義四個靜態常量，保存數據連接信息
	private?static?final?String?driver?=?“com.mysql.jdbc.Driver“;
	private?static?final?String?url?=?“jdbc:mysql:///Orange_buy“;
	//private?static?final?String?url?=?“jdbc:mysql://192.168.19.72/Orange_buy“;
	private?static?final?String?username?=?“root“;
	private?static?final?String?pwd?=?“root“;

	//?三個接口
	private?Connection?con;
	private?PreparedStatement?ps;
	private?ResultSet?rs;

	//?1.寫一個返回連接的方法
	public?Connection?getConnection（）?throws?Exception?{
		Class.forName（driver）;
		if?（con?==?null?||?con.isClosed（））?{
			con?=?DriverManager.getConnection（url?username?pwd）;
		}
		return?con;
	}

	//?2.修改操作
	public?int?executeUpdate（String?sql?object...?object）?{
		int?count?=?0;
		try?{
			getConnection（）;
			ps?=?con.prepareStatement（sql）;
			for?（int?i?=?0;?i?ject.length;?i++）?{
				ps.setobject（i?+?1?object[i]）;
			}
			count?=?ps.executeUpdate（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}

		return?count;
	}

	//?3.查詢操作
	public?ResultSet?executeQuery（String?sql?object...?object）?throws?Exception?{
		getConnection（）;
		ps?=?con.prepareStatement（sql）;
		for?（int?i?=?0;?i?ject.length;?i++）?{
			ps.setobject（i?+?1?object[i]）;
		}
		rs?=?ps.executeQuery（）;
		return?rs;
	}

	//?4.寫一個回收資源的方法
	public?void?closeResource（）?{
		try?{
			if?（rs?!=?null）?{
				rs.close（）;
			}
			if?（ps?!=?null）?{
				ps.close（）;
			}
			if?（con?!=?null）?{
				con.close（）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}

	}

	
}

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

?????文件???????1753??2018-09-08?09:15??楊常帥組\Orange_buy?_95?（3）\.classpath

?????文件????????910??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\.project

?????文件????????567??2018-09-04?14:35??楊常帥組\Orange_buy?_95?（3）\.settings\.jsdtscope

?????文件????????193??2018-09-08?20:10??楊常帥組\Orange_buy?_95?（3）\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2018-09-04?14:35??楊常帥組\Orange_buy?_95?（3）\.settings\org.eclipse.jdt.core.prefs

?????文件????????482??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\.settings\org.eclipse.wst.common.component

?????文件????????345??2018-09-04?14:35??楊常帥組\Orange_buy?_95?（3）\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-09-04?14:35??楊常帥組\Orange_buy?_95?（3）\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-09-04?14:35??楊常帥組\Orange_buy?_95?（3）\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2348??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\baseDao.class

?????文件????????280??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\IcategoryDao.class

?????文件????????705??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\IcommentDao.class

?????文件????????743??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\IConditionDao.class

?????文件????????488??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\IintroductionDao.class

?????文件???????1687??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\impl\IcategoryDaoImpl.class

?????文件???????4213??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\impl\IcommentImpl.class

?????文件???????4025??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\impl\IConditiondaoImpl.class

?????文件???????3781??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\impl\IintrodutionImpl.class

?????文件???????6509??2018-09-09?09:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\impl\IoederdaoImpl.class

?????文件???????6444??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\impl\IProductDaoimpl.class

?????文件???????4210??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\impl\IsearchImpl.class

?????文件???????4917??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\impl\IUserDaoImpl.class

?????文件????????962??2018-09-09?09:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\IorderDao.class

?????文件????????656??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\IProductDao.class

?????文件????????730??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\IsearchDao.class

?????文件????????556??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\dao\IUserDao.class

?????文件????????978??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\entity\CartItems.class

?????文件???????2017??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\entity\Category.class

?????文件???????2778??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\entity\DtArea.class

?????文件???????1621??2018-09-09?08:56??楊常帥組\Orange_buy?_95?（3）\build\classes\cn\buy\entity\EasybuyComment.class

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