package?Test;

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



public?class?DB?{
	private?static?String?className=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private?static?String?uri=“jdbc:sqlserver://localhost:1433;DatabaseName=fenye“;
	private?static?String?username=“sa“;
	private?static?String?pwd=“123456“;
	
	private?static?Connection?con;
	private?static?PreparedStatement?pst?;
	
	/**
	?*?創建數據庫連接
	?*?@return
	?*?@throws?ClassNotFoundException?
	?*?@throws?ClassNotFoundException?
	?*?@throws?SQLException?
	?*/
	public?static?void?createConnection（）?throws?ClassNotFoundException?SQLException{
	
			Class.forName（className）;
			con?=?DriverManager.getConnection（uri?usernamepwd）;
	
	}
	
	/**
	?*?通用的增刪改方法
	?*?@param?sql
	?*?@param?objects
	?*?@return
	?*?@throws?SQLException?
	?*?@throws?DatabaseException
	?*/
	public?static?int?executeUpdate（String?sqlobject...objects）?throws?SQLException?{
		int?row?=?0;

			try?{
				if（con?==?null）
				createConnection（）;
				
				pst?=?con.prepareStatement（sql）;
				setParamters（pst?objects）;
				row?=?pst.executeUpdate（）;
			}?catch?（ClassNotFoundException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}finally{
				release（）;
			}
			return?row;
	}
	
	/**
	?*?通用的查詢方法
	?*?@param?sql
	?*?@param?objects
	?*?@return
	?*?@throws?SQLException?
	?*?@throws?ClassNotFoundException?
	?*?@throws?DatabaseException
	?*/
	public?static?ResultSet?executeQuery（String?sqlobject...objects）?throws?ClassNotFoundException?SQLException?{
		ResultSet?rs?=?null;
		
		if（con?==?null）
			createConnection（）;
		
			pst?=?con.prepareStatement（sql）;
			setParamters（pst?objects）;
			rs?=?pst.executeQuery（）;
		
			return?rs;
	}
	
	/**
	?*?動態設置SQL語句中的參數值
	?*?@param?pst?
	?*?@param?objects?要設置的參數值
	?*?@throws?SQLException?
	?*/
	public?static?void?setParamters（PreparedStatement?pstobject...objects）?throws?SQLException{
		if（objects?==?null）
			return?;
		int?index?=?1;

		for（object?o?:?objects）{
			if（o?==?null）{
				pst.setNull（index++?Types.VARCHAR）;
			}else?if（o?instanceof?java.util.Date）{
				java.util.Date?oldDate?=（java.util.Date）?o;
				java.sql.Date?newDate?=?new?java.sql.Date（oldDate.getTime（））;
				pst.setDate（index++?newDate）;
			}else{
				pst.setobject（index++?o）;
			}
		}
		
		
	}
	
	
	/**
	?*?釋放查詢資源
	?*?@param?rs
	?*?@throws?SQLException?
	?*?@throws?DatabaseException
	?*/
	public?static?void?release（ResultSet?rs）?throws?SQLException?{
			
				if（rs?!=?null）
					rs.close（）;
				if（pst??!=?null）
					pst.close（）;
				if（con?!=?null?&&?!con.isClosed（））
					con.close（）;
				
				rs=null;
				pst=null;
				con=null;
				
	}
	
	/**
	?*?釋放增刪改資源方法
	?*?@throws?SQLException?
	?*?@throws?DatabaseException
	?*/
	public?static?void

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-03-02?08:41??fenye\
?????文件?????????432??2012-03-01?18:07??fenye\.classpath
?????目錄???????????0??2012-03-02?08:41??fenye\.myeclipse\
?????文件?????????288??2012-03-01?20:50??fenye\.mymetadata
?????文件????????1411??2012-03-01?18:07??fenye\.project
?????目錄???????????0??2012-03-02?08:41??fenye\.settings\
?????文件?????????500??2012-03-01?18:07??fenye\.settings\.jsdtscope
?????文件?????????330??2012-03-01?18:07??fenye\.settings\org.eclipse.jdt.core.prefs
?????文件??????????49??2012-03-01?18:07??fenye\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2012-03-01?18:07??fenye\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2012-03-02?08:41??fenye\src\
?????目錄???????????0??2012-03-02?08:41??fenye\src\Test\
?????文件????????3117??2012-03-01?21:48??fenye\src\Test\DB.java
?????文件????????1476??2012-03-01?18:07??fenye\src\Test\Pager.java
?????文件????????1788??2012-03-01?21:45??fenye\src\Test\UserDao.java
?????文件?????????536??2012-03-01?18:07??fenye\src\Test\UserInfo.java
?????目錄???????????0??2012-03-02?08:41??fenye\WebRoot\
?????文件????????2501??2012-03-01?18:07??fenye\WebRoot\css.css
?????文件????????1642??2012-03-01?18:07??fenye\WebRoot\index.jsp
?????目錄???????????0??2012-03-02?08:41??fenye\WebRoot\meta-INF\
?????文件??????????36??2012-03-01?18:07??fenye\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2012-03-02?08:41??fenye\WebRoot\WEB-INF\
?????目錄???????????0??2012-03-02?08:41??fenye\WebRoot\WEB-INF\classes\
?????目錄???????????0??2012-03-02?08:41??fenye\WebRoot\WEB-INF\classes\Test\
?????文件????????2957??2012-03-01?21:48??fenye\WebRoot\WEB-INF\classes\Test\DB.class
?????文件????????1584??2012-03-01?21:29??fenye\WebRoot\WEB-INF\classes\Test\Pager.class
?????文件????????2249??2012-03-01?21:45??fenye\WebRoot\WEB-INF\classes\Test\UserDao.class
?????文件?????????881??2012-03-01?21:29??fenye\WebRoot\WEB-INF\classes\Test\UserInfo.class
?????目錄???????????0??2012-03-02?08:41??fenye\WebRoot\WEB-INF\lib\
?????文件??????253247??2011-08-24?17:27??fenye\WebRoot\WEB-INF\lib\sqljdbc.jar
?????文件?????????371??2012-03-01?18:07??fenye\WebRoot\WEB-INF\web.xml
............此處省略0個文件信息