package?com.dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

/**
?*?基礎數據庫訪問類

?*?提供了打開與關閉連接，執行更新式的sql語句，等方法
?*?
?*?@author
?*
?*/
public?class?baseDao?{
	
	/**
	?*?驅動器類名
	?*/
	private?static?final?String?CLASS_NAME?=?“com.mysql.jdbc.Driver“;
	
	/**
	?*?連接字符串

	?*?這里的3306是mysql的端口號，news是數據庫名
	?*/
	private?static?final?String?CONN_URL?=?“jdbc:mysql://localhost:3306/shortrentnetwork“;
	
	/**
	?*?數據庫用戶名

	?*?數據庫默認用戶名為root
	?*/
	private?static?final?String?DATAbase_USERNAME?=?“root“;
	
	/**
	?*?數據庫密碼

	?*?數據庫默認密碼為root
	?*/
	private?static?final?String?DATAbase_PASSWORD?=?“root“;

	/**
	?*?打開一個連接
	?*?
	?*?@return?數據庫連接
	?*/
	protected?Connection?getConnection（）?{
		try?{
			Class.forName（CLASS_NAME）;
			return?DriverManager.getConnection（CONN_URL?DATAbase_USERNAME?DATAbase_PASSWORD）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?null;
	}
	
	/**
	?*?關閉全部
	?*?
	?*?@param?connection
	?*?				連接對象
	?*?@param?statement
	?*?				執行對象
	?*?@param?resultSet
	?*?				結果集
	?*/
	protected?void?closeAll（Connection?connection?Statement?statement?ResultSet?resultSet）?{
		try?{
			if?（resultSet?!=?null?&&?!resultSet.isClosed（））?{
				resultSet.close（）;
			}
			if?（statement?!=?null?&&?!statement.isClosed（））{
				statement.close（）;
			}
			if?（connection?!=?null?&&?!connection.isClosed（））?{
				connection.close（）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	
	/**
	?*?執行一個無返回值的更新型操作

	?*?注意執行本方法無需提前得到連接，事后也無需關閉連接
	?*?
	?*?@param?sql
	?*?			sql語句，必須是insert?update?delete之一
	?*/
	protected?void?executeUpdate（String?sql）?{
		
		//得到連接
		Connection?connection?=?getConnection（）;
		
		Statement?statement?=?null;
		try?{
			//創建一個執行對象
			statement?=?connection.createStatement（）;
			
			//執行sql語句
			statement.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		
		//關閉所有
		closeAll（connection?statement?null）;
	}
	
	
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-10-11?09:14??ShortRentNetWork\
?????文件?????????529??2013-09-17?09:56??ShortRentNetWork\.classpath
?????目錄???????????0??2013-09-17?15:55??ShortRentNetWork\.myeclipse\
?????文件?????????321??2013-09-17?09:56??ShortRentNetWork\.mymetadata
?????文件????????1234??2013-09-17?09:56??ShortRentNetWork\.project
?????目錄???????????0??2013-10-11?09:13??ShortRentNetWork\src\
?????目錄???????????0??2013-10-11?09:14??ShortRentNetWork\src\com\
?????目錄???????????0??2013-10-11?09:14??ShortRentNetWork\src\com\dao\
?????文件????????2380??2013-09-17?09:56??ShortRentNetWork\src\com\dao\baseDao.java
?????文件????????4646??2013-09-17?09:56??ShortRentNetWork\src\com\dao\DealorderDao.java
?????文件???????21188??2013-09-17?09:56??ShortRentNetWork\src\com\dao\HouseDao.java
?????文件????????1104??2013-09-17?09:56??ShortRentNetWork\src\com\dao\ManagerDao.java
?????文件????????8280??2013-09-17?09:56??ShortRentNetWork\src\com\dao\OrdersDao.java
?????文件????????3558??2013-09-17?09:56??ShortRentNetWork\src\com\dao\RentLockDao.java
?????文件????????4134??2013-09-17?09:56??ShortRentNetWork\src\com\dao\UsersDao.java
?????目錄???????????0??2013-10-11?09:14??ShortRentNetWork\src\com\entity\
?????文件????????1750??2013-09-17?09:56??ShortRentNetWork\src\com\entity\Dealorder.java
?????文件????????4165??2013-09-17?09:56??ShortRentNetWork\src\com\entity\House.java
?????文件?????????487??2013-09-17?09:56??ShortRentNetWork\src\com\entity\Manager.java
?????文件????????1580??2013-09-17?09:56??ShortRentNetWork\src\com\entity\Orders.java
?????文件?????????768??2013-09-17?09:56??ShortRentNetWork\src\com\entity\RentLock.java
?????文件?????????749??2013-09-17?09:56??ShortRentNetWork\src\com\entity\Users.java
?????目錄???????????0??2013-10-11?09:14??ShortRentNetWork\src\com\service\
?????文件??????????62??2013-09-17?09:56??ShortRentNetWork\src\com\service\DealorderService.java
?????文件????????1327??2013-09-17?09:56??ShortRentNetWork\src\com\service\HouseService.java
?????文件?????????259??2013-09-17?09:56??ShortRentNetWork\src\com\service\ManagerService.java
?????文件????????1119??2013-09-17?09:56??ShortRentNetWork\src\com\service\OrdersService.java
?????文件?????????225??2013-09-17?09:56??ShortRentNetWork\src\com\service\RentLockService.java
?????文件?????????758??2013-09-17?09:56??ShortRentNetWork\src\com\service\UsersService.java
?????目錄???????????0??2013-10-11?09:14??ShortRentNetWork\src\com\servlet\
?????文件????????6027??2013-09-17?09:56??ShortRentNetWork\src\com\servlet\CreateHouseServlet.java
............此處省略568個文件信息