package?com.gyf.bookstore.utils;


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

import?javax.sql.DataSource;


import?com.mchange.v2.c3p0.ComboPooledDataSource;

public?class?C3P0Utils?{
	
	private?static?DataSource?ds??=?new?ComboPooledDataSource（）;
	
	public?static?DataSource?getDataSource（）{
		return?ds;
	}
	
	public?static?Connection?getConnection（）{
		try?{
			return?ds.getConnection（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			throw?new?RuntimeException（“服務(wù)器錯誤“）;
		}
	}
	
	public?static?void?closeAll（Connection?connStatement?statementResultSet?resultSet）{
		
		if（resultSet?!=?null）{
			try?{
				resultSet.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
			resultSet?=?null;
		}
		
		if（statement?!=?null）{
			try?{
				statement.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
			statement?=?null;
		}
		
		if（conn?!=?null）{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				conn?=?null;
			}
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-03-21?21:40??c3p0\
?????文件?????????533??2018-02-25?16:11??c3p0\c3p0-config.xml
?????文件????????1282??2018-02-25?16:11??c3p0\C3P0Utils.java
?????目錄???????????0??2020-04-01?08:28??備課代碼\
?????文件?????4987636??2018-03-20?15:34??備課代碼\bookstore-已優(yōu)化Servlet.zip
?????文件?????4987959??2018-03-20?11:31??備課代碼\bookstore-未優(yōu)化.zip
?????目錄???????????0??2020-04-01?08:28??備課代碼\bookstore\
?????文件?????????885??2018-02-25?10:01??備課代碼\bookstore\.classpath
?????文件?????????909??2018-02-25?09:58??備課代碼\bookstore\.project
?????目錄???????????0??2020-04-01?08:28??備課代碼\bookstore\.settings\
?????文件?????????567??2018-02-25?09:58??備課代碼\bookstore\.settings\.jsdtscope
?????文件??????????57??2018-02-25?10:16??備課代碼\bookstore\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2018-02-25?09:58??備課代碼\bookstore\.settings\org.eclipse.jdt.core.prefs
?????文件?????????479??2018-02-25?09:58??備課代碼\bookstore\.settings\org.eclipse.wst.common.component
?????文件?????????305??2018-02-25?09:58??備課代碼\bookstore\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-02-25?09:58??備課代碼\bookstore\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-02-25?09:58??備課代碼\bookstore\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2020-04-01?08:28??備課代碼\bookstore\build\
?????目錄???????????0??2020-04-01?08:28??備課代碼\bookstore\build\classes\
?????文件?????????533??2018-02-25?16:11??備課代碼\bookstore\build\classes\c3p0-config.xml
?????目錄???????????0??2020-04-01?08:28??備課代碼\bookstore\build\classes\com\
?????目錄???????????0??2020-04-01?08:28??備課代碼\bookstore\build\classes\com\gyf\
?????目錄???????????0??2020-04-01?08:28??備課代碼\bookstore\build\classes\com\gyf\bookstore\
?????目錄???????????0??2020-04-01?08:28??備課代碼\bookstore\build\classes\com\gyf\bookstore\dao\
?????文件????????2147??2018-03-20?11:06??備課代碼\bookstore\build\classes\com\gyf\bookstore\dao\OrderDao$1.class
?????文件????????3279??2018-03-20?11:06??備課代碼\bookstore\build\classes\com\gyf\bookstore\dao\OrderDao.class
?????文件????????2109??2018-03-19?20:21??備課代碼\bookstore\build\classes\com\gyf\bookstore\dao\OrderItemDao.class
?????文件????????3401??2018-03-17?19:34??備課代碼\bookstore\build\classes\com\gyf\bookstore\dao\ProductDao.class
?????文件????????3048??2018-03-16?23:22??備課代碼\bookstore\build\classes\com\gyf\bookstore\dao\UserDao.class
?????目錄???????????0??2020-04-01?08:28??備課代碼\bookstore\build\classes\com\gyf\bookstore\domain\
?????文件????????3269??2018-03-17?16:42??備課代碼\bookstore\build\classes\com\gyf\bookstore\domain\Order.class
............此處省略656個文件信息