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						=					“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	
	//連接字符串
	private?static?			String?									url							=					“jdbc:sqlserver://localhost:1433;?DatabaseName=facedb“;
	
	//數據庫用戶名
	private?static?			String?									user						=					“sa“;
	
	//密碼
	private?static	?		String?									pwd							=					“171268“;
	
	//初始化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（）{
	//關閉之前先判

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

?????文件???????6960??2017-09-22?18:55??test_face_photo\.classpath

?????文件????????318??2017-09-22?17:14??test_face_photo\.mymetadata

?????文件???????1758??2017-09-22?21:33??test_face_photo\.project

?????文件????????500??2017-09-22?17:14??test_face_photo\.settings\.jsdtscope

?????文件????????364??2017-09-22?17:14??test_face_photo\.settings\org.eclipse.jdt.core.prefs

?????文件????????483??2017-09-22?17:14??test_face_photo\.settings\org.eclipse.wst.common.component

?????文件????????252??2017-09-22?17:14??test_face_photo\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-09-22?17:14??test_face_photo\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-09-22?17:14??test_face_photo\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????4163??2017-09-22?21:50??test_face_photo\src\org\dao\baseDao.java

?????文件????????864??2017-09-22?20:58??test_face_photo\src\org\dao\IbaseDaoUtil.java

?????文件???????3288??2017-09-22?20:48??test_face_photo\src\org\dao\impl\baseDaoUtilImpl.java

?????文件???????1267??2017-09-22?20:58??test_face_photo\src\org\dao\impl\UserDaoImpl.java

?????文件????????571??2017-09-22?20:52??test_face_photo\src\org\dao\IUserDao.java

?????文件???????1407??2017-09-22?19:03??test_face_photo\src\org\entity\Users.java

?????文件???????1397??2017-09-22?20:58??test_face_photo\src\org\service\impl\UserServiceImpl.java

?????文件???????1027??2017-09-22?20:57??test_face_photo\src\org\service\IUserService.java

?????文件???????9970??2017-08-03?21:31??test_face_photo\src\org\utils\HttpUtil.java

?????文件???????7052??2017-09-22?22:00??test_face_photo\src\org\web\FaceServlet.java

?????文件???????1863??2017-09-22?21:28??test_face_photo\WebRoot\index.jsp

?????文件???????1925??2017-06-27?21:33??test_face_photo\WebRoot\js\index.js

?????文件?????267775??2017-06-03?20:14??test_face_photo\WebRoot\js\jquery-1.8.3.js

?????文件??????13210??2017-06-25?00:17??test_face_photo\WebRoot\js\photobooth_min.js

?????文件???????2342??2017-09-22?21:28??test_face_photo\WebRoot\login.jsp

?????文件?????????36??2017-09-22?17:14??test_face_photo\WebRoot\meta-INF\MANIFEST.MF

?????文件????????638??2017-09-22?18:14??test_face_photo\WebRoot\readme

?????文件????????830??2017-06-27?22:44??test_face_photo\WebRoot\suc.jsp

?????文件???????3176??2017-09-22?21:50??test_face_photo\WebRoot\WEB-INF\classes\org\dao\baseDao.class

?????文件????????337??2017-09-22?20:58??test_face_photo\WebRoot\WEB-INF\classes\org\dao\IbaseDaoUtil.class

?????文件???????3517??2017-09-22?20:48??test_face_photo\WebRoot\WEB-INF\classes\org\dao\impl\baseDaoUtilImpl.class

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