package?common;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

import?javax.naming.Context;
import?javax.naming.InitialContext;
import?javax.naming.NamingException;
import?javax.sql.DataSource;

/**
?*?數(shù)據(jù)庫連接池
?*?
?*?@author?class8sunjinlan
?*?
?*/
public?class?ConnectionPool?{
	private?static?DataSource?ds;

	//?得到數(shù)據(jù)源
	public?static?DataSource?getDataSource（）?{
		try?{
			Context?ctx?=?new?InitialContext（）;
			ds?=?（DataSource）?ctx.lookup（“java:comp/env/wuyeDB“）;
		}?catch?（NamingException?e）?{
			e.printStackTrace（）;
		}
		return?ds;
	}

	//?得到數(shù)據(jù)庫連接對象
	public?Connection?getConnection（）?{
		Connection?conn?=?null;
		ds?=?getDataSource（）;
		try?{
			if?（ds?!=?null）?{
				conn?=?ds.getConnection（）;
			}
		}?catch?（SQLException?e）?{

			e.printStackTrace（）;
		}finally{
			//如果找不到數(shù)據(jù)連接池；增加程序的健壯性
			if（ds==null）{

				try?{
					Class.forName（“oracle.jdbc.driver.OracleDriver“）;
					conn?=?DriverManager.getConnection（
							“jdbc:oracle:thin:@localhost:1521:teach“?“wuye““wuye“）;
				}?catch?（ClassNotFoundException?e）?{
					e.printStackTrace（）;
				}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				}			
			}
		}
		return?conn;
	}

	//?各種資源關(guān)閉，檢索
	public?static?void?close（Connection?conn?PreparedStatement?pstmt?ResultSet?rs）?{
		try?{
			if?（rs?!=?null）?{
				rs.close（）;
				rs?=?null;
			}
			if?（pstmt?!=?null）?{
				pstmt.close（）;
				pstmt?=?null;
			}
			if?（conn?!=?null）?{
				conn.close（）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}

	//?各種資源關(guān)閉，更新
	public?static?void?close（Connection?conn??PreparedStatement?pstmt）?{
		try?{
			if?（pstmt?!=?null）?{
				pstmt.close（）;
				pstmt?=?null;
			}
			if?（conn?!=?null）?{
				conn.close（）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件??????18203??2012-05-01?23:57??js日期控件（wuye）和數(shù)據(jù)庫文件\data（Oracle）\wuye.sql

?????文件??????28672??2012-05-02?09:30??js日期控件（wuye）和數(shù)據(jù)庫文件\data（Oracle）\wuyeData.dmp

?????文件??????20297??2010-07-05?22:55??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\calendar.js

?????文件????????221??2010-07-05?22:55??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\config.js

?????文件????????644??2009-07-01?15:20??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\lang\en.js

?????文件???????1089??2010-04-12?10:33??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\lang\zh-cn.js

?????文件???????1088??2010-04-12?10:34??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\lang\zh-tw.js

?????文件???????1328??2010-07-05?22:51??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\My97DatePicker.htm

?????文件???????1043??2006-12-25?22:29??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\skin\datePicker.gif

?????文件???????3624??2010-07-05?22:58??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\skin\default\datepicker.css

?????文件???????1578??2008-10-21?11:31??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\skin\default\img.gif

????..A.SH.??????7168??2010-07-05?22:57??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\skin\default\Thumbs.db

????..A.SH.??????3072??2010-07-05?22:55??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\skin\Thumbs.db

?????文件????????156??2010-07-05?22:55??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\skin\WdatePicker.css

?????文件????????307??2007-01-05?22:44??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\skin\whyGreen\bg.jpg

?????文件???????3820??2010-07-05?22:57??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\skin\whyGreen\datepicker.css

?????文件???????1679??2008-10-21?11:20??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\skin\whyGreen\img.gif

????..A.SH.??????8704??2010-07-05?22:55??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\skin\whyGreen\Thumbs.db

?????文件???????8291??2010-07-05?22:54??js日期控件（wuye）和數(shù)據(jù)庫文件\My97DatePicker\WdatePicker.js

?????文件????????137??2010-07-05?23:02??js日期控件（wuye）和數(shù)據(jù)庫文件\例子.html

?????文件????????450??2012-05-23?16:51??js日期控件（wuye）和數(shù)據(jù)庫文件\引用日期\例子1.htm

?????文件????????484??2012-05-03?13:41??wuYeSystem\.classpath

?????文件????????386??2012-05-02?10:38??wuYeSystem\.project

?????文件???????2008??2012-05-03?16:57??wuYeSystem\src\common\ConnectionPool.java

?????文件???????1264??2012-05-17?14:04??wuYeSystem\src\common\FieldCheck.java

?????文件????????136??2012-05-07?15:47??wuYeSystem\src\common\PageSize.java

?????文件????????799??2012-05-11?10:57??wuYeSystem\src\control\BuildMsgListServlet.java

?????文件??????10121??2012-05-18?09:10??wuYeSystem\src\control\BuildServlet.java

?????文件????????706??2012-05-03?16:54??wuYeSystem\src\control\ClearSessionServlet.java

?????文件???????2028??2012-05-19?20:45??wuYeSystem\src\control\LoginServlet.java

............此處省略298個(gè)文件信息