package?com.daguanjia.dao;

import?java.awt.print.Book;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

import?com.daguanjia.entity.Booking;
import?com.daguanjia.entity.Goods;
/**
?*?訪問(wèn)訂房表
?*?@author?Jack?Lei
?*?
?*/
public?class?BookingDao?{
	public?static?BookingDao?bookingDao=null;
	public?static?ResultSet?rSet?=?null;
	public?static?List?bookingsList?=?null;
	?
	public?static??object[][]?objects?=?null;
	public?static??int?rowsCount=0;
	public?static?int?colunmCount=0;
	
	public?static?BookingDao?instance（）?{
		if?（bookingDao?==?null）?{
			bookingDao?=?new?BookingDao（）;
		}
		return?bookingDao;
	}
	
	public?static?List?getbookList（）?{
		
		try?{
			JdbcUtil.openConnection（）;
			rSet?=?JdbcUtil.select（“select?*?from?Booking“）;
			rowsCount?=?0;
			while?（rSet.next（））?{
				rowsCount++;
			}
			
			ResultSetmetaData?rData?=?rSet.getmetaData（）;
			colunmCount?=?rData.getColumnCount（）;
			
			bookingsList?=?new?ArrayList（）;
			objects?=?new?object[rowsCount][colunmCount];
			
			JdbcUtil.openConnection（）;
			rSet?=?JdbcUtil.select（“select?*?from?Booking“）;
			
			while?（rSet.next（））?{
				Booking?booking?=?new?Booking（rSet.getString（1）?rSet.getString（2）?rSet.getString（3）?rSet.getString（4）?rSet.getString（5）?rSet.getString（6）?
						rSet.getString（7）?rSet.getString（8）?rSet.getString（9）?rSet.getString（10）?rSet.getString（11））;
				addBooking（booking）;
			}
			
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?bookingsList;
	}
	
	public?static?object[][]?getBookingobjects（）?{
		List?list?=?instance（）.getbookList（）;
		for?（int?i?=?0;?i?			objects[i][0]?=?list.get（i）.getBookingId（）;
			objects[i][1]?=?list.get（i）.getBookingModel（）;
			objects[i][2]?=?list.get（i）.getBookingRoomId（）;
			objects[i][3]?=?list.get（i）.getBookingPeopleCnt（）;
			objects[i][4]?=?list.get（i）.getBookingSex（）;
			objects[i][5]?=?list.get（i）.getBookingCustomerName（）;
			objects[i][6]?=?list.get（i）.getBookingPersonId（）;
			objects[i][7]?=?list.get（i）.getBookingTel（）;
			objects[i][8]?=?list.get（i）.getBookingAddr（）;
			objects[i][9]?=?list.get（i）.getBookingTime（）;
			objects[i][10]?=?list.get（i）.getBookingEmp（）;
		}
		return?objects;
	}
?	
	public?static?void?addBooking（Booking?booking）?{
		bookingsList.add（booking）;
	}
	
}

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----

?????文件??????16169??2012-12-21?01:03??JAVA?SWING?賓館系統(tǒng)\hotel12-19.sql

?????文件????????520??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\.classpath

?????文件????????386??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\.project

?????文件?????????87??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\.settings\org.eclipse.core.resources.prefs

?????文件????????598??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\.settings\org.eclipse.jdt.core.prefs

?????文件???????3323??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\BookingDao.class

?????文件????????874??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\ConfigDao.class

?????文件????????680??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\DataToExcel$1.class

?????文件????????687??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\DataToExcel$2.class

?????文件???????5004??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\DataToExcel.class

?????文件???????4283??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\DisPlayAllRoomDao.class

?????文件???????4196??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\DisplayOkStayDao.class

?????文件???????4543??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\DisplayStayDao.class

?????文件???????6175??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\EmployeeDao.class

?????文件???????4043??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\FoodDao.class

?????文件???????5616??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\GoodsDao.class

?????文件???????5518??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\GriphicsDao.class

?????文件???????1963??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\IdDao.class

?????文件???????2562??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\InsertStayDao.class

?????文件???????5845??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\JdbcUtil.class

?????文件???????6304??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\MemberDao.class

?????文件???????4146??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\PayBillDao.class

?????文件???????2611??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\dao\SqlHelp.class

?????文件????????828??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\entity\Account.class

?????文件???????3228??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\entity\Booking.class

?????文件???????3116??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\entity\Config.class

?????文件???????2590??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\entity\Employee.class

?????文件???????1796??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\entity\Food.class

?????文件???????2050??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\entity\Goods.class

?????文件???????2726??2012-12-21?01:01??JAVA?SWING?賓館系統(tǒng)\Hotel12-20\bin\com\daguanjia\entity\Memder.class

............此處省略431個(gè)文件信息