package?com.hylc.dao;

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

//@SuppressWarnings（“static-access“）
public?class?JdbcUtils?{
	private?static?Connection?connection?=?null;
	private?static?DataSource?ds?=?null;

	static?{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
			Properties?properties?=?new?Properties（）;
//			InputStream?is?=?JdbcUtils.class.getClassLoader（）
//					.getSystemResourceAsStream（“dbcpconfig.properties“）;
			InputStream?is?=?new?FileInputStream（“./dbcpconfig.properties“）;
			properties.load（is）;
			ds?=?BasicDataSourceFactory.createDataSource（properties）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（IOException?e）?{
			e.printStackTrace（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}

	}

	public?static?Connection?getConnection（）{
		Connection?connection?=?null;
		try?{
			connection?=?ds.getConnection（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?connection;
	}

	public?static?Connection?getInstance（）?{
		if?（connection?==?null）?{
			synchronized?（JdbcUtils.class）?{
				if?（connection?==?null）?{
					try?{
						connection?=?ds.getConnection（）;
					}?catch?（SQLException?e）?{
						e.printStackTrace（）;
					}
					return?connection;
				}
			}
		}
		return?connection;
	}

	public?static?void?closeResource（Connection?connection
			Statement?statement?ResultSet?rs）?{
		if?（connection?!=?null）?{
			try?{
				connection.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}?finally?{
				if?（statement?!=?null）?{
					try?{
						statement.close（）;
					}?catch?（SQLException?e）?{
						e.printStackTrace（）;
					}?finally?{
						if?（rs?!=?null）?{
							try?{
								rs.close（）;
							}?catch?（SQLException?e）?{
								e.printStackTrace（）;
							}
						}
					}
				}
			}
		}
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-03-02?13:55??database\
?????文件?????????767??2017-02-21?17:42??database\.classpath
?????文件?????????384??2017-01-18?11:26??database\.project
?????目錄???????????0??2017-03-02?13:55??database\.settings\
?????文件?????????598??2017-01-18?11:26??database\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2017-03-02?13:55??database\bin\
?????目錄???????????0??2017-03-02?13:55??database\bin\com\
?????目錄???????????0??2017-03-02?13:55??database\bin\com\hylc\
?????目錄???????????0??2017-03-02?13:55??database\bin\com\hylc\dao\
?????文件????????3226??2017-02-24?10:28??database\bin\com\hylc\dao\JdbcUtils.class
?????文件????????1186??2017-02-24?10:28??database\bin\com\hylc\dao\JdbcUtilsOracle.class
?????文件???????10631??2017-02-24?10:28??database\bin\com\hylc\dao\SXJDaoImpl.class
?????目錄???????????0??2017-03-02?13:55??database\bin\com\hylc\mydao\
?????文件????????3230??2017-02-24?10:28??database\bin\com\hylc\mydao\JdbcUtils.class
?????文件????????1190??2017-02-24?10:28??database\bin\com\hylc\mydao\JdbcUtilsOracle.class
?????文件????????2070??2017-02-24?10:28??database\bin\com\hylc\mydao\JunitTest.class
?????文件???????11589??2017-02-24?10:28??database\bin\com\hylc\mydao\SXJDaoImpl.class
?????文件?????????686??2017-02-24?10:28??database\bin\com\hylc\mydao\TestConnection.class
?????文件?????????518??2017-02-21?16:42??database\dbcpconfig.properties
?????文件?????????371??2017-01-18?11:46??database\dbcpconfig2.properties
?????目錄???????????0??2017-03-02?13:55??database\lib\
?????文件??????232771??2016-03-01?12:42??database\lib\commons-codec-1.6.jar
?????文件??????121757??2016-03-01?12:42??database\lib\commons-dbcp-1.2.2.jar
?????文件???????61829??2016-03-01?12:42??database\lib\commons-logging-1.2.jar
?????文件???????87077??2016-03-01?12:42??database\lib\commons-pool-1.4.jar
?????文件??????540852??2016-03-01?12:42??database\lib\mysql-connector-java-5.0.8-bin.jar
?????文件?????1988051??2017-01-18?12:59??database\lib\ojdbc6.jar
?????目錄???????????0??2017-03-02?13:55??database\src\
?????目錄???????????0??2017-03-02?13:55??database\src\com\
?????目錄???????????0??2017-03-02?13:55??database\src\com\hylc\
?????目錄???????????0??2017-03-02?13:55??database\src\com\hylc\dao\
............此處省略9個文件信息