package?wyf.wyy;
import?javax.naming.*;
import?java.sql.*;
import?javax.sql.*;
import?java.util.*;
public?class?DB
{
	private?static?Connection?con=null;//聲明Connection引用
	private?static?Statement?stat=null;//聲明Statement引用
	private?static?ResultSet?rs=null;//聲明ResultSet引用
//*****************************數據庫連接和關閉操作*************************
	public?static?Connection?getCon（）{//得到數據庫連接的方法	
		try{			
			?Context?initial?=?new?InitialContext（）;//得到上下文引用
			?DataSource?ds?=?//得到DataSource引用
				????（DataSource）initial.lookup（“java:comp/env/jdbc/jiudian“）;
			?con?=?ds.getConnection（）;//得到數據庫連接
		}
		catch（Exception?e）
		{e.printStackTrace（）;}
		return?con;//返回數據庫連接
		
		/*try{
		Class.forName（“com.mysql.jdbc.Driver“）;
		String?url=“jdbc:mysql://localhost/test“;
		con?=?Dri

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-01-10?12:45??Android酒店應用源碼\
?????目錄???????????0??2013-01-10?12:45??Android酒店應用源碼\jiudian\
?????文件????????1988??2008-08-05?07:51??Android酒店應用源碼\jiudian\addAdmin.jsp
?????文件????????2265??2011-03-16?09:10??Android酒店應用源碼\jiudian\addGroup.jsp
?????文件????????2668??2011-03-16?08:11??Android酒店應用源碼\jiudian\addRes.jsp
?????文件????????1532??2008-08-15?09:55??Android酒店應用源碼\jiudian\adindex.jsp
?????文件?????????552??2008-08-12?17:00??Android酒店應用源碼\jiudian\adinfo.jsp
?????文件????????2182??2008-08-05?08:16??Android酒店應用源碼\jiudian\adminChangePwd.jsp
?????文件????????1844??2011-03-16?09:30??Android酒店應用源碼\jiudian\adminFenYe.jsp
?????文件????????1242??2011-03-16?09:08??Android酒店應用源碼\jiudian\adminGroup.jsp
?????文件????????1432??2011-03-16?09:05??Android酒店應用源碼\jiudian\adminManage.jsp
?????文件????????3020??2011-03-16?09:44??Android酒店應用源碼\jiudian\adminOrders.jsp
?????文件?????????773??2011-03-16?09:20??Android酒店應用源碼\jiudian\adminResource.jsp
?????文件????????1309??2011-03-16?09:28??Android酒店應用源碼\jiudian\adminRestop.jsp
?????文件????????1051??2011-03-16?22:20??Android酒店應用源碼\jiudian\admintop.jsp
?????文件????????1992??2008-08-05?08:00??Android酒店應用源碼\jiudian\adResetPwd.jsp
?????目錄???????????0??2013-01-10?12:45??Android酒店應用源碼\jiudian\css\
?????文件?????????376??2008-07-24?15:32??Android酒店應用源碼\jiudian\css\generalstyle.css
?????文件??????????69??2008-07-24?15:04??Android酒店應用源碼\jiudian\css\新建?文本文檔.txt
?????文件?????????443??2011-03-14?23:11??Android酒店應用源碼\jiudian\DeleteOlist.jsp
?????文件????????1081??2008-08-12?19:57??Android酒店應用源碼\jiudian\detail.jsp
?????文件?????????436??2011-03-14?14:58??Android酒店應用源碼\jiudian\getAllResources.jsp
?????文件????????2552??2008-07-31?19:05??Android酒店應用源碼\jiudian\GroupInfo.jsp
?????目錄???????????0??2013-01-10?12:45??Android酒店應用源碼\jiudian\img\
?????文件???????17803??2007-08-03?08:22??Android酒店應用源碼\jiudian\img\fail.gif
?????文件???????20154??2011-03-09?11:25??Android酒店應用源碼\jiudian\img\meal.bmp
?????文件???????29360??2011-03-11?12:44??Android酒店應用源碼\jiudian\img\meeting.jpg
?????文件???????34254??2011-03-11?12:42??Android酒店應用源碼\jiudian\img\room.bmp
?????文件???????28308??2007-08-03?08:22??Android酒店應用源碼\jiudian\img\success.gif
?????文件?????????472??2011-03-17?14:52??Android酒店應用源碼\jiudian\main.jsp
?????文件????????1219??2011-03-17?14:52??Android酒店應用源碼\jiudian\modifyInfo.jsp
............此處省略224個文件信息