package?org.dao;

import?java.io.FileReader;
import?java.io.IOException;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.List;
import?java.util.Properties;


/**
?*?
*????
*?項目名稱：test_face_photo???
*?類名稱：baseDao???
*?類描述：???數據庫連接共用類
*?創建人：Mu?Xiongxiong??
*?創建時間：2017-9-22?下午6:56:18???
*?修改人：Mu?Xiongxiong???
*?修改時間：2017-9-22?下午6:56:18???
*?修改備注：???
*?@version????
*
?*/
public?class?baseDao?{

	private?static?			Connection?								con							=					null;

	//數據庫驅動
	private?static?			String?									driver						=					“oracle.jdbc.driver.OracleDriver“;
	
	//連接字符串
	private?static?			String?									url							=					“jdbc:oracle:thin:@localhost:1521:orcl“;
	
	//數據庫用戶名
	private?static?			String?									user						=					“scott“;
	
	//密碼
	private?static	?		String?									pwd							=					“tiger“;
	
	//初始化PreparedStatement，編譯sql語句
	private?static?			PreparedStatement?						ps							=					null;
	
	//初始化ResultSet數據集
	private?static?			ResultSet?								rs							=					null;
	
	??

	/**
	?*?
	*?@Description:?該方法的主要作用：打開連接，連接數據庫
	*?@title:?getConnection
	*?@param??@return
	*?@param??@throws?ClassNotFoundException
	*?@param??@throws?SQLException?設定文件??
	*?@return??返回類型：Connection???
	*?@throws
	?*/
	public?static?Connection?getConnection（）?throws?ClassNotFoundException?SQLException{
		Class.forName（driver）;
		if（con==null）{
			con?=?DriverManager.getConnection（urluserpwd）;
		}
		return?con;
	}
	
	/**
	?*?
	*?@Description:?該方法的主要作用：增刪改通用的方法
	*?@title:?executeUpdate
	*?@param??@param?sql
	*?@param??@param?prams
	*?@param??@return
	*?@param??@throws?ClassNotFoundException
	*?@param??@throws?SQLException?設定文件??
	*?@return??返回類型：int???
	*?@throws
	?*/
	public?static?int?executeUpdate（String?sqlListject>?prams）?throws?ClassNotFoundException?SQLException{
		int?			rel			=			0;
						con?			=?			getConnection（）;
						ps			=			con.prepareStatement（sql）;
		if（prams!=null）{
			for?（int?i?=?0;?i?				ps.setobject（i+1?prams.get（i））;
			}
		}
						rel			=		ps.executeUpdate（）;	
		return?rel;
	}
	
	/**
	?*?
	*?@Description:?該方法的主要作用：查詢的通用方法
	*?@title:?executeQuery
	*?@param??@param?sql
	*?@param??@param?prams
	*?@param??@return?設定文件??
	*?@return??返回類型：ResultSet???
	*?@throws
	?*/
	public?static?ResultSet?executeQuery（String?sqlListject>prams）?throws?ClassNotFoundException?SQLException{
		con?		=			getConnection（）;
		ps?		=			con.prepareStatement（sql）;
		if（prams!=null）{
			for?（int?i?=?0;?i?				ps.setobject（i+1?prams.get（i））;
			}
		}
		rs			=		ps.executeQuery（）;
		return?rs;
	}
	
	/**
	?*?
	*?@Description:?該方法的主要作用：關閉資源
	*?@title:?closeConnnection
	*?@param???設定文件??
	*?@return??返回類型：void???
	*?@throws
	?*/
	public?static?void?closeConnnection（）{
	//關閉之前先判斷是否為null
		if（rs!=null）{

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-09-29?13:39??人臉識別（可用）\
?????文件????????7063??2017-09-29?14:17??人臉識別（可用）\.classpath
?????目錄???????????0??2017-09-22?17:14??人臉識別（可用）\.myeclipse\
?????文件?????????328??2017-09-30?18:59??人臉識別（可用）\.mymetadata
?????文件????????1763??2017-09-29?14:46??人臉識別（可用）\.project
?????目錄???????????0??2017-09-29?13:39??人臉識別（可用）\.settings\
?????文件?????????500??2017-09-22?17:14??人臉識別（可用）\.settings\.jsdtscope
?????文件?????????395??2017-09-29?14:17??人臉識別（可用）\.settings\org.eclipse.jdt.core.prefs
?????文件?????????483??2017-09-22?17:14??人臉識別（可用）\.settings\org.eclipse.wst.common.component
?????文件?????????252??2017-09-22?17:14??人臉識別（可用）\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-09-22?17:14??人臉識別（可用）\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-09-22?17:14??人臉識別（可用）\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-09-29?13:39??人臉識別（可用）\src\
?????目錄???????????0??2017-09-29?13:39??人臉識別（可用）\src\org\
?????目錄???????????0??2017-09-29?13:39??人臉識別（可用）\src\org\dao\
?????文件????????4137??2017-09-29?14:19??人臉識別（可用）\src\org\dao\baseDao.java
?????文件?????????864??2017-09-22?20:58??人臉識別（可用）\src\org\dao\IbaseDaoUtil.java
?????目錄???????????0??2017-09-29?13:39??人臉識別（可用）\src\org\dao\impl\
?????文件????????3288??2017-09-22?20:48??人臉識別（可用）\src\org\dao\impl\baseDaoUtilImpl.java
?????文件????????1267??2017-09-22?20:58??人臉識別（可用）\src\org\dao\impl\UserDaoImpl.java
?????文件?????????571??2017-09-22?20:52??人臉識別（可用）\src\org\dao\IUserDao.java
?????目錄???????????0??2017-09-29?13:39??人臉識別（可用）\src\org\entity\
?????文件????????1407??2017-09-22?19:03??人臉識別（可用）\src\org\entity\Users.java
?????目錄???????????0??2017-09-29?13:39??人臉識別（可用）\src\org\service\
?????目錄???????????0??2017-09-29?13:39??人臉識別（可用）\src\org\service\impl\
?????文件????????1373??2017-09-29?14:18??人臉識別（可用）\src\org\service\impl\UserServiceImpl.java
?????文件????????1027??2017-09-22?20:57??人臉識別（可用）\src\org\service\IUserService.java
?????目錄???????????0??2017-09-29?13:39??人臉識別（可用）\src\org\utils\
?????文件????????9970??2017-08-03?21:31??人臉識別（可用）\src\org\utils\HttpUtil.java
?????目錄???????????0??2017-09-29?13:39??人臉識別（可用）\src\org\web\
?????文件????????6918??2017-09-30?09:20??人臉識別（可用）\src\org\web\FaceServlet.java
............此處省略111個文件信息