package?cn.itcast.jdbc;

import?java.io.InputStream;
import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.Properties;

import?javax.sql.DataSource;

import?org.apache.commons.dbcp.BasicDataSourceFactory;

import?cn.itcast.jdbc.datasource.MyDataSource2;


public?final?class?JdbcUtils?{
	private?static?DataSource?myDataSource?=?null;

	private?JdbcUtils（）?{
	}

	static?{
		try?{
			Properties?prop?=?new?Properties（）;
			InputStream?is?=?JdbcUtils.class.getClassLoader（）
					.getResourceAsStream（“dbcpconfig.properties“）;
			prop.load（is）;
			myDataSource?=?BasicDataSourceFactory.createDataSource（prop）;
		}?catch?（Exception?e）?{
			throw?new?ExceptionInInitializerError（e）;
		}
	}

	public?static?DataSource?getDataSource（）?{
		return?myDataSource;
	}

	public?static?Connection?getConnection（）?throws?SQLException?{
		//?return?DriverManager.getConnection（url?user?password）;
		return?myDataSource.getConnection（）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-06-25?12:02??gwap資料\
?????文件???????16714??2011-01-12?14:39??gwap資料\dangdang.sql
?????文件?????????914??2012-06-25?11:58??gwap資料\DangDang項目.txt
?????目錄???????????0??2012-06-25?12:01??gwap資料\dangJSP頁面\
?????目錄???????????0??2012-06-25?12:01??gwap資料\dangJSP頁面\WebRoot\
?????目錄???????????0??2012-06-25?12:01??gwap資料\dangJSP頁面\WebRoot\cart\
?????文件????????5330??2011-03-14?15:03??gwap資料\dangJSP頁面\WebRoot\cart\cart_list.jsp
?????目錄???????????0??2012-06-25?12:01??gwap資料\dangJSP頁面\WebRoot\common\
?????文件?????????527??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\common\foot.jsp
?????文件?????????648??2011-03-14?14:43??gwap資料\dangJSP頁面\WebRoot\common\foot1.jsp
?????文件????????1312??2011-03-14?14:57??gwap資料\dangJSP頁面\WebRoot\common\head.jsp
?????文件?????????169??2011-03-14?14:43??gwap資料\dangJSP頁面\WebRoot\common\head1.jsp
?????文件?????????600??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\common\introduce.jsp
?????目錄???????????0??2012-06-25?12:01??gwap資料\dangJSP頁面\WebRoot\css\
?????文件???????25119??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\book.css
?????文件????????4817??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\booksaleslist.css
?????文件???????13313??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\book_head090107.css
?????文件???????10329??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\list.css
?????文件???????12978??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\login.css
?????文件????????1072??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\navi.css
?????文件????????3246??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\page_bottom.css
?????文件????????1702??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\public_footer.css
?????文件?????????555??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\pubsug090107.css
?????文件???????14101??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\register_login.css
?????文件????????1140??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\secBook_Show.css
?????文件???????20184??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\second.css
?????文件????????5352??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\shopping_head.css
?????文件????????9395??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\css\shopping_vehicle.css
?????目錄???????????0??2012-06-25?12:01??gwap資料\dangJSP頁面\WebRoot\images\
?????目錄???????????0??2012-06-25?12:01??gwap資料\dangJSP頁面\WebRoot\images\07dq\
?????文件????????2621??2011-03-14?13:45??gwap資料\dangJSP頁面\WebRoot\images\07dq\dq.swf
............此處省略365個文件信息