package?com.devon.dao.db;

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

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

public?class?ConnOracle?{

	public?static?Connection?getConn（）?{
		Connection?conn?=?null;
		Context?context?=?null;
		try?{
			context?=?new?InitialContext（）;
			DataSource?ds?=?（DataSource）?context.lookup（“java:comp/env/jdbc/oracle“）;
			conn?=?ds.getConnection（）;
		}?catch?（NamingException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}

		return?conn;
	}

	public?static?void?tryClose（ResultSet?rs?Statement?st?Connection?conn）?{

		if?（rs?!=?null）?{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if?（st?!=?null）?{
			try?{
				st.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if?（conn?!=?null）?{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}

	}

}

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

????I.A....???6152363??2011-01-09?22:54??QQ93785732\應用程序\DevonShop.war

????I.A....???1600198??2010-10-18?20:31??QQ93785732\應用程序\JAR包\classes12.jar

????I.A....??????6949??2010-12-28?14:15??QQ93785732\應用程序\server.xml

????I.A....?????13733??2011-01-06?22:38??QQ93785732\數據庫\createtable.sql

????I.A....?????13505??2010-12-29?10:00??QQ93785732\數據庫\createtable.sql.bak

????I.A....???????327??2011-06-08?20:51??QQ93785732\數據庫\createuser.sql

????I.A....??????1941??2011-03-11?20:06??QQ93785732\數據庫\log.log

????I.A....??????1662??2011-03-11?20:05??QQ93785732\數據庫\sqlnet.log

????I.A....????????43??2010-11-05?18:36??QQ93785732\數據庫\start.bat

????I.A....??????8702??2010-12-28?14:11??QQ93785732\文檔\javadoc\allclasses-frame.html

????I.A....??????7502??2010-12-28?14:11??QQ93785732\文檔\javadoc\allclasses-noframe.html

????I.A....??????5874??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\db\class-use\ConnOracle.html

????I.A....?????10447??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\db\ConnOracle.html

????I.A....???????879??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\db\package-frame.html

????I.A....??????6098??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\db\package-summary.html

????I.A....??????5919??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\db\package-tree.html

????I.A....??????5567??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\db\package-use.html

????I.A....?????13661??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\class-use\Goods.html

????I.A....??????5984??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\class-use\GoodsSearchCondition.html

????I.A....?????13841??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\class-use\Mc.html

????I.A....?????14097??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\class-use\McType.html

????I.A....?????13781??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\class-use\Order.html

????I.A....??????9297??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\class-use\OrderItem.html

????I.A....??????5894??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\class-use\ShoppingCar.html

????I.A....?????15074??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\class-use\User.html

????I.A....?????15256??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\Goods.html

????I.A....?????12781??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\GoodsSearchCondition.html

????I.A....?????18765??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\Mc.html

????I.A....?????12367??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\McType.html

????I.A....?????27612??2010-12-28?14:11??QQ93785732\文檔\javadoc\com\devon\dao\dto\Order.html

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