package?org.dao;

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

/**
?*?
?*?
?*?項目名稱：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?=?“com.mysql.jdbc.Driver“;

	//?連接字符串
	private?static?String?url?=?“jdbc:mysql://localhost:3306/facedb?characterEncoding=UTF-8“;

	//?數據庫用戶名
	private?static?String?user?=?“root“;

	//?密碼
	private?static?String?pwd?=?“root“;

	//?初始化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（url?user?pwd）;
		}
		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?sql?Listject>?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?sql?Listject>?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）?{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		if?（ps?!=?null）?{
			try?{
				ps.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
	

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-04-19?11:01??test_face_photo\
?????文件?????????834??2018-04-19?11:01??test_face_photo\.classpath
?????文件????????1048??2018-04-19?11:01??test_face_photo\.project
?????目錄???????????0??2018-04-19?11:01??test_face_photo\.settings\
?????文件?????????503??2018-04-19?11:01??test_face_photo\.settings\.jsdtscope
?????文件?????????364??2018-04-19?11:01??test_face_photo\.settings\org.eclipse.jdt.core.prefs
?????文件?????????497??2018-04-19?11:01??test_face_photo\.settings\org.eclipse.wst.common.component
?????文件?????????345??2018-04-19?11:01??test_face_photo\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-04-19?11:01??test_face_photo\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-04-19?11:01??test_face_photo\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-04-19?14:00??test_face_photo\WebContent\
?????目錄???????????0??2018-04-19?11:01??test_face_photo\WebContent\meta-INF\
?????文件??????????39??2018-04-19?11:01??test_face_photo\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-04-19?11:01??test_face_photo\WebContent\WEB-INF\
?????目錄???????????0??2018-04-19?11:28??test_face_photo\WebContent\WEB-INF\lib\
?????文件???????86366??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\aliyun-java-sdk-core-3.2.3.jar
?????文件???????10550??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\aliyun-java-sdk-dysmsapi-1.0.0-SNAPSHOT.jar
?????文件??????443432??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\antlr-2.7.6.jar
?????文件????????4467??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\aopalliance.jar
?????文件?????1828687??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\aspectjweaver.jar
?????文件??????322553??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\cglib-nodep-2.2.3.jar
?????文件??????188671??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\commons-beanutils-1.7.0.jar
?????文件???????91699??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\commons-chain-1.2.jar
?????文件??????232771??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\commons-codec-1.6.jar
?????文件??????575389??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\commons-collections-3.2.1.jar
?????文件??????160519??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\commons-dbcp-1.4.jar
?????文件??????148783??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\commons-digester-2.0.jar
?????文件???????57779??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\commons-fileupload-1.2.1.jar
?????文件??????305001??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\commons-httpclient-3.1.jar
?????文件??????185140??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\commons-io-2.4.jar
?????文件??????261809??2018-04-19?11:07??test_face_photo\WebContent\WEB-INF\lib\commons-lang-2.4.jar
............此處省略103個文件信息