package?call;
import?java.sql.*;
public?class?Hotelcall?{
		/*?定義driverurluserpwd等?*/
		private?static?String?driver?=?“sun.jdbc.odbc.JdbcOdbcDriver“;
		private?static?String?url?=?“jdbc:odbc:Hotel“;
	???????/*?mydb為數據源名稱，可以在控制面板--管理工具--odbc數據源設置?*/
		private?static?String?user?=?“sa“?pwd?=?“1234“;
		private?static?Connection?con=?null;
		/*?加載驅動程序?*/
	
		static?{
			try?{
				Class.forName（driver）;
			}?catch?（Exception?ex）?{
				System.out.println（“Drivers?can?not?be?found!“）;
			}
		}

		public?static?ResultSet?executeQuery（String?sql）?{
			ResultSet?rs?=?null;
			try?{
				con?=?DriverManager.getConnection（url?user?pwd）;
				Statement?cmd?=?con.createStatement（）;
				rs?=?cmd.executeQuery（sql）;
			}?catch?（Exception?ex）?{
				ex.printStackTrace（）;
			}
			return?rs;
		}
		public?static?void?executeUpdate（String?sql）?{
			try?{
				Connection?con?=?DriverManager.getConnection（url?user?pwd）;
				System.out.println（“Drivers?can??be?find1!“）;
				Statement?cmd?=?con.createStatement（）;
				cmd.executeUpdate（sql）;
				con.close（）;
			}?catch?（Exception?ex）?{
				ex.printStackTrace（）;
			}
		}

		public?static?void?closeConnection（）?{
			try?{
				if?（con?!=?null?&&?!con.isClosed（））
					con.close（）;
			}?catch?（Exception?ex）?{
			}
		}
		}

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

?????文件????????595??2011-01-12?11:22??Hotel1\.classpath

?????文件????????382??2011-01-12?11:11??Hotel1\.project

?????文件???????1915??2011-01-12?14:40??Hotel1\bin\call\Hotelcall.class

?????文件???????3552??2011-01-14?15:45??Hotel1\bin\Fram\choose.class

?????文件???????3540??2011-01-15?23:36??Hotel1\bin\Fram\Customerinfo.class

?????文件???????3064??2011-01-14?19:38??Hotel1\bin\Fram\Fram.class

?????文件???????6597??2011-01-16?15:14??Hotel1\bin\Fram\insert.class

?????文件???????7098??2011-01-16?15:48??Hotel1\bin\Fram\Minmenu.class

?????文件???????4717??2011-01-15?23:36??Hotel1\bin\Fram\Quit.class

?????文件???????3224??2011-01-16?14:19??Hotel1\bin\Fram\Statmoney.class

?????文件???????3220??2011-01-15?16:24??Hotel1\bin\Fram\Statrate.class

?????文件???????2988??2011-01-14?15:48??Hotel1\bin\Fram\Statroom.class

?????文件???????2852??2011-01-15?23:36??Hotel1\bin\Fram\Timeout.class

?????文件???????1346??2011-01-12?14:40??Hotel1\src\call\Hotelcall.java

?????文件???????2344??2011-01-14?15:45??Hotel1\src\Fram\choose.java

?????文件???????2475??2011-01-15?23:36??Hotel1\src\Fram\Customerinfo.java

?????文件???????1996??2011-01-14?19:38??Hotel1\src\Fram\Fram.java

?????文件???????5506??2011-01-16?15:14??Hotel1\src\Fram\insert.java

?????文件???????6780??2011-01-16?15:48??Hotel1\src\Fram\Minmenu.java

?????文件???????3838??2011-01-15?23:36??Hotel1\src\Fram\Quit.java

?????文件???????1859??2011-01-16?14:19??Hotel1\src\Fram\Statmoney.java

?????文件???????2079??2011-01-15?16:24??Hotel1\src\Fram\Statrate.java

?????文件???????1719??2011-01-14?15:48??Hotel1\src\Fram\Statroom.java

?????文件???????1785??2011-01-15?23:36??Hotel1\src\Fram\Timeout.java

?????文件?????286907??2007-12-14?19:13??驅動\msbase.jar

?????文件??????67228??2007-12-14?19:13??驅動\mssqlserver.jar

?????文件??????59074??2007-12-14?19:13??驅動\msutil.jar

?????目錄??????????0??2011-03-25?16:15??Hotel1\bin\call

?????目錄??????????0??2011-03-25?16:15??Hotel1\bin\Fram

?????目錄??????????0??2011-03-25?16:15??Hotel1\src\call

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