package?db;

import?java.beans.PropertyVetoException;
import?java.sql.Connection;
import?java.sql.SQLException;

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

public?final?class?ConnectionManager?{

	private?static?ConnectionManager?instance;
	private?static?ComboPooledDataSource?dataSource;

	private?ConnectionManager（）?throws?SQLException?PropertyVetoException?{
		dataSource?=?new?ComboPooledDataSource（）;

		dataSource.setUser（“root“）;
		dataSource.setPassword（“hhf“）;
		dataSource
				.setJdbcUrl（“jdbc:mysql://127.0.0.1:3306/course?useUnicode=true&characterEncoding=utf-8“）;
		dataSource.setDriverClass（“com.mysql.jdbc.Driver“）;
		dataSource.setInitialPoolSize（5）;
		dataSource.setMinPoolSize（1）;
		dataSource.setMaxPoolSize（20）;
		dataSource.setMaxStatements（50）;
		dataSource.setMaxIdleTime（600）;
	}

	public?static?final?ConnectionManager?getInstance（）?{
		if?（instance?==?null）?{
			try?{
				instance?=?new?ConnectionManager（）;
			}?catch?（Exception?e）?{
				e.printStackTrace（）;
			}
		}
		return?instance;
	}

	public?synchronized?final?Connection?getConnection（）?{
		Connection?conn?=?null;
		try?{
			conn?=?dataSource.getConnection（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?conn;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-08-21?11:01??course-v3.0\
?????文件?????????771??2012-08-20?20:26??course-v3.0\.classpath
?????文件????????1039??2012-08-20?20:26??course-v3.0\.project
?????目錄???????????0??2012-08-21?10:58??course-v3.0\.settings\
?????文件?????????503??2012-08-20?20:26??course-v3.0\.settings\.jsdtscope
?????文件??????????57??2012-08-20?20:26??course-v3.0\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2012-08-20?20:26??course-v3.0\.settings\org.eclipse.jdt.core.prefs
?????文件?????????472??2012-08-20?20:26??course-v3.0\.settings\org.eclipse.wst.common.component
?????文件?????????345??2012-08-20?20:26??course-v3.0\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2012-08-20?20:26??course-v3.0\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2012-08-20?20:26??course-v3.0\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2012-08-21?10:58??course-v3.0\WebContent\
?????目錄???????????0??2012-08-21?10:58??course-v3.0\WebContent\meta-INF\
?????文件??????????39??2012-08-20?20:26??course-v3.0\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2012-08-21?10:58??course-v3.0\WebContent\WEB-INF\
?????目錄???????????0??2012-08-21?10:58??course-v3.0\WebContent\WEB-INF\lib\
?????文件??????611562??2012-08-20?20:26??course-v3.0\WebContent\WEB-INF\lib\c3p0-0.9.1.2.jar
?????文件??????322178??2012-08-20?20:26??course-v3.0\WebContent\WEB-INF\lib\fastjson-1.1.17.jar
?????文件??????180110??2012-08-20?20:26??course-v3.0\WebContent\WEB-INF\lib\gson-2.1.jar
?????文件??????709922??2012-08-20?20:26??course-v3.0\WebContent\WEB-INF\lib\mysql-connector-java-5.1.7-bin.jar
?????文件??????461068??2012-08-20?20:26??course-v3.0\WebContent\WEB-INF\lib\quartz-all-1.8.4.jar
?????文件???????88210??2012-08-20?20:26??course-v3.0\WebContent\WEB-INF\lib\servlet-api.jar
?????文件????????2164??2012-08-20?20:26??course-v3.0\WebContent\WEB-INF\web.xml
?????文件?????????991??2012-08-20?20:26??course-v3.0\WebContent\error400.jsp
?????文件?????????991??2012-08-20?20:26??course-v3.0\WebContent\error404.jsp
?????文件?????????991??2012-08-20?20:26??course-v3.0\WebContent\error500.jsp
?????文件?????????695??2012-08-20?20:26??course-v3.0\WebContent\exit.jsp
?????文件????????3211??2012-08-20?20:26??course-v3.0\WebContent\jumpto.jsp
?????文件????????1295??2012-08-20?20:26??course-v3.0\WebContent\login.html
?????文件????????1986??2012-08-20?20:26??course-v3.0\WebContent\login.jsp
?????文件?????????797??2012-08-20?20:26??course-v3.0\WebContent\main.html
............此處省略176個文件信息