package?com.cbd.common.db;

import?java.io.IOException;
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;

public?class?JdbcUtils?{
	private?static?DataSource?dataSource;
	static?{
		try?{
			Properties?prop?=?new?Properties（）;
			InputStream?inStream?=?JdbcUtils.class.getClassLoader（）
					.getResourceAsStream（“/com/cbd/common/db/dbcpconfig.properties“）;
			prop.load（inStream）;
			inStream.close（）;
			dataSource?=?BasicDataSourceFactory.createDataSource（prop）;
		}?catch?（Exception?e）?{
			new?ExceptionInInitializerError（e）;
		}
	}

	public?static?Connection?g

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

????.CA....?????31744??2008-12-30?14:18??javaweb考試.doc

????.CA....???????633??2008-12-27?15:06??jdbc_wzg\.classpath

????.C.D...?????????0??2009-03-04?23:40??jdbc_wzg\.myeclipse

????.CA....???????297??2009-03-01?22:38??jdbc_wzg\.mymetadata

????.CA....??????1182??2008-12-22?16:35??jdbc_wzg\.project

????.CA....???????123??2009-01-01?09:14??jdbc_wzg\.settings\org.eclipse.core.resources.prefs

????.C.D...?????????0??2009-03-04?23:40??jdbc_wzg\.settings

????.CA....??????1038??2008-12-19?16:36??jdbc_wzg\database\database.properties

????.C.D...?????????0??2009-03-04?23:40??jdbc_wzg\database

????.CA....??????2850??2008-12-27?15:06??jdbc_wzg\lib\AbsoluteLayout.jar

????.CA....????118103??2008-12-27?15:06??jdbc_wzg\lib\swing-layout-1.0.3.jar

????.C.D...?????????0??2009-03-04?23:40??jdbc_wzg\lib

????.CA....??????2003??2009-03-04?23:39??jdbc_wzg\sql\stumanage.sql

????.C.D...?????????0??2009-03-04?23:40??jdbc_wzg\sql

????.CA....??????1061??2008-12-29?22:33??jdbc_wzg\src\com\cbd\common\db\dbcpconfig.properties

????.CA....??????1174??2009-03-02?00:15??jdbc_wzg\src\com\cbd\common\db\JdbcUtils.java

????.CA....??????2243??2009-01-01?09:14??jdbc_wzg\src\com\cbd\common\db\JdbcUtilsDemo.java

????.C.D...?????????0??2009-03-04?23:40??jdbc_wzg\src\com\cbd\common\db

????.C.D...?????????0??2009-03-04?23:40??jdbc_wzg\src\com\cbd\common

????.CA....???????511??2009-01-01?09:14??jdbc_wzg\src\com\cbd\dao\exception\DaoException.java

????.C.D...?????????0??2009-03-04?23:40??jdbc_wzg\src\com\cbd\dao\exception

????.CA....??????4206??2009-01-01?09:24??jdbc_wzg\src\com\cbd\dao\impl\UserDaoImpl.java

????.C.D...?????????0??2009-03-04?23:40??jdbc_wzg\src\com\cbd\dao\impl

????.CA....???????341??2009-01-01?09:24??jdbc_wzg\src\com\cbd\dao\UserDao.java

????.C.D...?????????0??2009-03-04?23:40??jdbc_wzg\src\com\cbd\dao

????.CA....???????636??2009-01-01?09:14??jdbc_wzg\src\com\cbd\domain\entity\User.java

????.C.D...?????????0??2009-03-04?23:40??jdbc_wzg\src\com\cbd\domain\entity

????.CA....??????1000??2009-01-01?09:26??jdbc_wzg\src\com\cbd\domain\logic\impl\UserManagerImpl.java

????.C.D...?????????0??2009-03-04?23:40??jdbc_wzg\src\com\cbd\domain\logic\impl

????.CA....???????427??2009-01-01?09:25??jdbc_wzg\src\com\cbd\domain\logic\UserManager.java

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