package?com.connection;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
/**
?*?定義一個(gè)數(shù)據(jù)庫的連接及關(guān)閉資源的類
?*?@author?Administrator
?*
?*/
public?class?DBConnection?{
	/**
	?*?創(chuàng)建數(shù)據(jù)庫的鏈接
	?*?@return??返回一個(gè)數(shù)據(jù)庫的鏈接
	?*/
	public?static?Connection?getConnection（）{
		Connection?conn?=?null;
		
		try?{
			Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）;??//加載數(shù)據(jù)庫驅(qū)動(dòng)
			
			String?url?=?“jdbc:microsoft:sqlserver://localhost:1433;databaseName=account“;?
			String?username?=?“sa“;????//數(shù)據(jù)庫用戶名
			String?password?=?“1126“;????//數(shù)據(jù)庫密碼
			
			conn?=?DriverManager.getConnection（urlusernamepassword）;???//獲得數(shù)據(jù)庫的鏈接
????????????
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}??catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}

		return?conn;

	}
	
	/**
	?*?關(guān)閉數(shù)據(jù)庫資源
	?*?@param?obj??數(shù)據(jù)庫打開的資源對象（在此處用object，因?yàn)殒溄訑?shù)據(jù)庫是會(huì)打開多個(gè)資源）
	?*/
	public?static?void?closeobject（object?obj）{
		if（obj?!=?null）{
			if（obj?instanceof?ResultSet）{
				try?{
					（（ResultSet）?obj）.close（）;
				}?catch?（SQLException?e）?{
					//?TODO?Auto-generated?catch?block
					e.printStackTrace（）;
				}
			}
			
			if（obj?instanceof?PreparedStatement）{
				try?{
					（（PreparedStatement）?obj）.close（）;
				}?catch?（SQLException?e）?{
					//?TODO?Auto-generated?catch?block
					e.printStackTrace（）;
				}
			}
			
			if（obj?instanceof?Connection）{
				try?{
					（（Connection）?obj）.close（）;
				}?catch?（SQLException?e）?{
					//?TODO?Auto-generated?catch?block
					e.printStackTrace（）;
				}
			}
		}
	}

}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-06-13?21:39??銀行賬戶管理系統(tǒng)\
?????文件?????????598??2012-01-02?21:52??銀行賬戶管理系統(tǒng)\.classpath
?????文件?????????400??2012-01-02?21:52??銀行賬戶管理系統(tǒng)\.project
?????目錄???????????0??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\
?????目錄???????????0??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\
?????目錄???????????0??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\connection\
?????文件????????1595??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\connection\DBConnection.class
?????目錄???????????0??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dao\
?????文件????????2268??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dao\AdminDao.class
?????文件????????3310??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dao\AllInfoDao.class
?????文件????????2485??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dao\ATMDao.class
?????文件????????6510??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dao\ATMOutInDao.class
?????文件????????3838??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dao\BankOutInDao.class
?????文件????????6582??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dao\CardDao.class
?????文件????????9413??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dao\UsersDao.class
?????目錄???????????0??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dto\
?????文件????????1124??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dto\Admin.class
?????文件????????1609??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dto\AllInfo.class
?????文件?????????937??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dto\ATM.class
?????文件????????1603??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dto\ATMOutIn.class
?????文件????????1628??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dto\BankOutIn.class
?????文件????????1103??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dto\Card.class
?????文件????????1967??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\dto\Users.class
?????目錄???????????0??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\frame\
?????文件????????4592??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\frame\AdminLoginJframe$Adminframe$CunKuan.class
?????文件????????4135??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\frame\AdminLoginJframe$Adminframe$KaiHu.class
?????文件????????4903??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\frame\AdminLoginJframe$Adminframe$QuKuan.class
?????文件????????3597??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\frame\AdminLoginJframe$Adminframe$XiaoHu.class
?????文件????????4022??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\frame\AdminLoginJframe$Adminframe.class
?????文件????????3360??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\frame\AdminLoginJframe$BanKa.class
?????文件????????3069??2017-06-20?09:55??銀行賬戶管理系統(tǒng)\bin\com\frame\AdminLoginJframe$ChaXun$ChaXunCaoZuo.class
............此處省略74個(gè)文件信息