package?soft;
import?java.sql.*;
import?java.util.*;

class?DatabaseOperation
{
	private?Connection?connection;
	public?DatabaseOperation（String?driverString?urlString?userString?password）throws?ClassNotFoundExceptionSQLException
	{
		this.connection=null;
		Class.forName（driver）;
		this.connection=DriverManager.getConnection（urluserpassword）;
	}
	public?void?finalize（）throws?SQLException
	{
		this.connection.close（）;
	}
	public?int?dataUpdate（String?sql）throws?SQLException
	{
		Statement?statement=this.connection.createStatement（）;
		int?result=statement.executeUpdate（sql）;
		statement.close（）;
		return?result;
	}
	public?void?roomSelect（String?sqlobject[][]?dataint?num）throws?SQLException{
		Statement?statement=this.connection.createStatement（）;
		ResultSet?rs=statement.executeQuery（sql）;
		int?i=0;
		while（rs.next（））{			
			if（num==1）{
				data[i][0]=rs.getString（“RoomNo“）;
				data[i][1]=rs.getString（“RoomType“）;
				data[i][2]=String.valueOf（rs.getInt（“RoomPrice“））;
				data[i][3]=rs.getString（“Status“）;
				data[i][4]=String.valueOf（rs.getInt（“Deposit“））;
				i++;
			}
			if（num==2）{
				data[i][0]=rs.getString（“RoomNo“）;
				data[i][1]=rs.getString（“RoomType“）;
				data[i][2]=String.valueOf（rs.getInt（“RoomPrice“））;
				data[i][3]=String.valueOf（rs.getInt（“Deposit“））;
				i++;
			}
			if（num==3）{
				data[i][0]=rs.getString（“RoomNo“）;
				data[i][1]=rs.getDate（“InDate“）;
				data[i][2]=rs.getDate（“CheckDate“）;
				data[i][3]=String.valueOf（rs.getInt（“Deposit“））;
				data[i][4]=String.valueOf（rs.getInt（“Payment“））;
				i++;
			}
			
		}
		statement.close（）;
	}
	public?long?DateCount（String?roomno）throws?SQLException{
		Statement?statement=this.connection.createStatement（）;
		ResultSet?rs=statement.executeQuery（“SELECT?*?FROM?BookInfo?where?RoomNo=‘“+roomno+“‘“）;
		long?day=0;
		while（rs.next（））{
		long?in=?rs.getDate（“InDate“）.getTime（）;?
		long?out=rs.getDate（“CheckDate“）.getTime（）;
		day=（out-in）/24/60/60/1000;
		}
		return?day;
???}
	public?String?getStrItem（String?sqlString?item）throws?SQLException{
		Statement?statement=this.connection.createStatement（）;
		ResultSet?rs=statement.executeQuery（sql）;
		String?str=new?String（）;
		while（rs.next（））{
			str=rs.getString（item）;
		}
		return?str;
	}
	public?int?getIntItem（String?sqlString?item）throws?SQLException{
		Statement?statement=this.connection.createStatement（）;
		ResultSet?rs=statement.executeQuery（sql）;
		int?num=0;
		while（rs.next（））{
			num=rs.getInt（item）;
		}
		return?num;
	}
	
	
}

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

?????文件?????232076??2009-01-11?22:52??軟工\Hotel.mdl

?????文件?????456704??2010-06-07?17:47??軟工\軟件工程課程設計報告（賓館管理系統）.doc

?????文件????1048576??2009-01-14?19:55??軟工\數據庫\hotel2_Data.MDF

?????文件????1048576??2009-01-14?19:55??軟工\數據庫\hotel2_Log.LDF

?????文件????????573??2009-01-10?21:50??軟工\程序\Hotel\.classpath

?????文件????????381??2009-01-09?15:38??軟工\程序\Hotel\.project

?????文件???????3552??2009-01-11?21:57??軟工\程序\Hotel\bin\soft\DatabaseOperation.class

?????文件????????590??2009-01-11?22:55??軟工\程序\Hotel\bin\soft\frame$1.class

?????文件???????3302??2009-01-11?22:55??軟工\程序\Hotel\bin\soft\frame.class

?????文件????????595??2009-01-11?23:11??軟工\程序\Hotel\bin\soft\frame1$1.class

?????文件???????8246??2009-01-11?23:11??軟工\程序\Hotel\bin\soft\frame1.class

?????文件???????2377??2009-01-11?23:11??軟工\程序\Hotel\bin\soft\frame1Layout.class

?????文件????????595??2009-01-11?23:12??軟工\程序\Hotel\bin\soft\frame2$1.class

?????文件??????10702??2009-01-11?23:12??軟工\程序\Hotel\bin\soft\frame2.class

?????文件???????2698??2009-01-11?23:12??軟工\程序\Hotel\bin\soft\frame2Layout.class

?????文件????????595??2009-01-11?23:12??軟工\程序\Hotel\bin\soft\frame3$1.class

?????文件???????6592??2009-01-11?23:12??軟工\程序\Hotel\bin\soft\frame3.class

?????文件???????1950??2009-01-11?23:12??軟工\程序\Hotel\bin\soft\frame3Layout.class

?????文件????????595??2009-01-11?23:11??軟工\程序\Hotel\bin\soft\frame4$1.class

?????文件???????5188??2009-01-11?23:11??軟工\程序\Hotel\bin\soft\frame4.class

?????文件???????1786??2009-01-11?23:11??軟工\程序\Hotel\bin\soft\frame4Layout.class

?????文件???????1747??2009-01-11?22:55??軟工\程序\Hotel\bin\soft\frameLayout.class

?????文件????????575??2009-01-10?22:15??軟工\程序\Hotel\bin\soft\Hotel.class

?????文件???????2589??2009-01-11?21:57??軟工\程序\Hotel\src\soft\DatabaseOperation.java

?????文件???????3213??2009-01-11?22:55??軟工\程序\Hotel\src\soft\frame.java

?????文件??????10441??2009-01-11?23:11??軟工\程序\Hotel\src\soft\frame1.java

?????文件??????14544??2009-01-11?23:12??軟工\程序\Hotel\src\soft\frame2.java

?????文件???????6893??2009-01-11?23:12??軟工\程序\Hotel\src\soft\frame3.java

?????文件???????5282??2009-01-11?23:11??軟工\程序\Hotel\src\soft\frame4.java

?????文件????????258??2009-01-10?22:14??軟工\程序\Hotel\src\soft\Hotel.java

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