package?org.lql.dao;

import?java.sql.Connection;
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;

public?class?ConnectionManagerJNDI?{
	Connection?conn?=?null;
	PreparedStatement?pstmt=?null;
	ResultSet?rs?=?null;
	public?Connection?getConnection（）?throws?NamingException?SQLException{
		
		Context?context?=new?InitialContext（）;
		DataSource?source?=?（DataSource）?context.lookup（“java:comp/env/jdbc/restrant“）;
		conn=source.getConnection（）;				
		return?conn;
	}
	
	public?void?closeAll（）?throws?SQLException{
		if（rs?!=?null）{
			rs.close（）;
			rs?=?null;
		}
		if（pstmt?!=?null）{
			pstmt.close（）;
			pstmt?=?null;
		}
		if（conn?!=?null）{
			conn.close（）;
		}
	}
}

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

?????文件????????738??2012-04-03?22:20??訂餐系統\restrant\.classpath

?????文件????????297??2012-04-06?18:08??訂餐系統\restrant\.mymetadata

?????文件???????1467??2012-04-03?22:20??訂餐系統\restrant\.project

?????文件????????109??2012-04-03?22:31??訂餐系統\restrant\.settings\com.genuitec.eclipse.ws.prefs

?????文件????????145??2012-04-03?22:20??訂餐系統\restrant\.settings\com.genuitec.eclipse.ws.xfire.prefs

?????文件????????330??2012-03-29?16:00??訂餐系統\restrant\.settings\org.eclipse.jdt.core.prefs

?????文件????????885??2012-04-03?22:10??訂餐系統\restrant\src\org\lql\dao\ConnectionManagerJNDI.java

?????文件???????3729??2012-04-11?11:27??訂餐系統\restrant\src\org\lql\dao\FoodDao.java

?????文件???????1084??2012-04-03?22:10??訂餐系統\restrant\src\org\lql\dao\OrderDao.java

?????文件????????918??2012-04-03?22:10??訂餐系統\restrant\src\org\lql\dao\UserDao.java

?????文件????????450??2012-04-03?22:10??訂餐系統\restrant\src\org\lql\entity\CartItem.java

?????文件???????1130??2012-04-11?10:44??訂餐系統\restrant\src\org\lql\entity\FoodInfo.java

?????文件???????1384??2012-04-03?22:10??訂餐系統\restrant\src\org\lql\entity\OrderBean.java

?????文件????????556??2012-04-03?22:10??訂餐系統\restrant\src\org\lql\entity\UserInfo.java

?????文件???????1003??2012-04-03?22:10??訂餐系統\restrant\src\org\lql\filter\CharacterFilter.java

?????文件???????1270??2012-04-05?16:12??訂餐系統\restrant\src\org\lql\filter\LoginFilter.java

?????文件???????1655??2012-04-10?22:33??訂餐系統\restrant\src\org\lql\servlet\AdminLoginServlet.java

?????文件???????1144??2012-04-11?12:58??訂餐系統\restrant\src\org\lql\servlet\CancelAdminServlet.java

?????文件???????1949??2012-04-03?22:10??訂餐系統\restrant\src\org\lql\servlet\CartServlet.java

?????文件???????1443??2012-04-11?10:47??訂餐系統\restrant\src\org\lql\servlet\DeleteFoodServlet.java

?????文件???????1731??2012-04-10?22:39??訂餐系統\restrant\src\org\lql\servlet\FoodServlet.java

?????文件???????1559??2012-04-11?11:28??訂餐系統\restrant\src\org\lql\servlet\GetOneFoodServlet.java

?????文件???????1765??2012-04-11?09:52??訂餐系統\restrant\src\org\lql\servlet\InsertCLServlet.java

?????文件???????1668??2012-04-03?22:10??訂餐系統\restrant\src\org\lql\servlet\LoginServlet.java

?????文件???????2255??2012-04-05?16:54??訂餐系統\restrant\src\org\lql\servlet\OrderServlet.java

?????文件???????1775??2012-04-11?11:56??訂餐系統\restrant\src\org\lql\servlet\UpdateCLServlet.java

?????文件????????744??2012-04-03?22:35??訂餐系統\restrant\src\org\lql\ws\GetWeather.java

?????文件???????1216??2012-04-03?22:35??訂餐系統\restrant\src\org\lql\ws\GetWeatherResponse.java

?????文件??????11909??2012-04-06?18:18??訂餐系統\restrant\src\org\lql\ws\GoogleWeather.java

?????文件???????1246??2012-04-03?22:35??訂餐系統\restrant\src\org\lql\ws\objectFactory.java

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