package?com.ownHome.common;

import?java.sql.*;

import?javax.naming.Context;
import?javax.naming.InitialContext;
import?javax.naming.NamingException;
import?javax.sql.DataSource;

public?class?DBConnection?{
	/**
	?*?通過數據源獲取數據庫連接
	?*?@return?數據庫連接
	?*/
	public?static?Connection?getConnection（）{
		Connection?dbConnection?=?null;
		try?{
			Context?ic?=?new?InitialContext（）;
			DataSource?source?=?（DataSource）ic.lookup（“java:comp/env/jdbc/ownHome“）;
			dbConnection?=?source.getConnection（）;
		}?catch?（NamingException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?dbConnection;
	}
	
	/*通過配置文件獲取數據庫連接
	public?static?synchronized?Connection?getConnection（）{
		String?driverClassName?=?ProReader.getInstance（）.getProperty（“driver“）;
		String?url?=?ProReader.getInstance（）.getProperty（“url“）;
		String?user?=?ProReader.getInstance（）.getProperty（“user“）;
		String?password?=?ProReader.getInstance（）.getProperty（“password“）;
		Connection?dbConnection?=?null;
		try?{
			Class.forName（driverClassName）;
			dbConnection?=?DriverManager.getConnection（urluserpassword）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		return??dbConnection;
	}
	*/
	
	/**
	?*?釋放資源
	?*?@param?conn
	?*?@param?pstmt
	?*?@param?rs
	?*/
	public?static?void?closeAll（Connection?connPreparedStatement?pstmtResultSet?rs）{
		try?{
			if（rs?!=?null）{
				rs.close（）;
				rs?=?null;
			}
			if（pstmt?!=?null）{
				pstmt.close（）;
				rs?=?null;
			}
			if（conn?!=?null?&&?（!conn.isClosed（）））{
				conn.close（）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
}

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

?????文件????????784??2009-07-04?01:18??ownHome\.classpath

?????文件????????294??2009-07-04?01:18??ownHome\.mymetadata

?????文件???????1225??2009-07-16?12:44??ownHome\.project

?????文件????????875??2009-07-16?14:45??ownHome\context.xml

?????文件????3145728??2009-07-04?01:39??ownHome\Database\ownHome.mdf

?????文件???????3581??2008-01-03?13:53??ownHome\Database\ownHome.sql

?????文件????1048576??2009-07-04?01:39??ownHome\Database\ownHome_log.ldf

?????文件???????1707??2009-06-24?07:53??ownHome\src\com\ownHome\common\DBConnection.java

?????文件????????135??2009-07-16?13:10??ownHome\src\com\ownHome\common\dbInfo.properties

?????文件????????711??2009-07-16?13:24??ownHome\src\com\ownHome\common\ProReader.java

?????文件???????1004??2009-07-16?13:02??ownHome\src\com\ownHome\entity\Article.java

?????文件????????851??2009-07-16?12:58??ownHome\src\com\ownHome\entity\Users.java

?????文件???????3618??2009-07-03?23:02??ownHome\src\com\ownHome\operation\ArticleBo.java

?????文件???????1515??2009-07-02?06:34??ownHome\src\com\ownHome\operation\UsersBo.java

?????文件???????3838??2009-07-03?23:46??ownHome\src\com\ownHome\servlet\AddBookServlet.java

?????文件???????2290??2009-07-01?12:26??ownHome\src\com\ownHome\servlet\DetailArticleServlet.java

?????文件???????2085??2009-07-02?10:52??ownHome\src\com\ownHome\servlet\InvalidateServlet.java

?????文件???????2474??2009-07-02?06:41??ownHome\src\com\ownHome\servlet\LoginServlet.java

?????文件???????2681??2009-07-03?22:20??ownHome\src\com\ownHome\servlet\RegisterServlet.java

?????文件???????2395??2009-07-03?23:05??ownHome\src\com\ownHome\servlet\SearchServlet.java

?????文件???????3052??2009-07-02?06:23??ownHome\src\com\ownHome\servlet\SelectArticleServlet.java

?????文件???????6098??2009-07-04?00:15??ownHome\WebRoot\addBook.jsp

?????文件???????1513??2007-09-25?11:55??ownHome\WebRoot\banner.jsp

?????文件???????2083??2004-06-28?17:14??ownHome\WebRoot\css.css

?????文件???????3054??2009-07-16?16:51??ownHome\WebRoot\detailArticle.jsp

?????文件??????30641??2004-06-28?17:17??ownHome\WebRoot\images\banner.gif

?????文件??????31540??2007-09-27?13:47??ownHome\WebRoot\images\banner.swf

?????文件????????128??2004-06-28?17:17??ownHome\WebRoot\images\bg01.gif

?????文件?????????96??2004-06-28?17:17??ownHome\WebRoot\images\bg02.gif

?????文件????????275??2004-06-28?17:17??ownHome\WebRoot\images\bg03.gif

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