package?dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.text.ParseException;
import?java.util.ArrayList;

import?model.Guest;
import?util.JDBCUtil;

public?class?GuestDao?{
	
	public?ArrayList?guestInformation（int?countString?val）{
		ArrayList?guestList=new?ArrayList（）;
		PreparedStatement?psmt=null;
		ResultSet?rs=null;
		int?id=0;
		//定義sql
		String?sql?=?“select?*?from?guest?“;
		//獲取數據庫連接
		Connection?conn?=?JDBCUtil.getConnection（）;
		try?{
			//編譯sql
			if（count==1）{
				sql=sql+“where?state=0“;
			}else?if（count==2）{
				sql=sql+“where?state=1“;
			}else?if（count==3）{}
			else?if（count==4）{	
				id=Integer.parseInt（val）;
				sql=sql+“where?id=“+id;
			}else?if（count==5）{	
				id=Integer.parseInt（val）;
				sql=sql+“where?id=“+id+“?and?state=0“;
			}else?if（count==6）{	
				id=Integer.parseInt（val）;
				sql=sql+“where?room=“+Integer.parseInt（val）+“?and?state=0“;
			}
			
			psmt?=?conn.prepareStatement（sql）;
			//執行sql
			rs?=?psmt.executeQuery（）;
			while（rs.next（））{
				Guest?g=new?Guest（）;
				g.setId（rs.getInt（“id“））;
				g.setName（rs.getString（“name“））;
				g.setSex（rs.getInt（“sex“））;
				g.setIdentity（rs.getString（“identity“））;
				g.setPhone（rs.getString（“phone“））;
				g.setEntryTime（rs.getString（“entry_time“））;
				g.setDimissTime（rs.getString（“dimiss_time“））;
				g.setRoom（rs.getInt（“room“））;
				g.setType（rs.getString（“type“））;
				guestList.add（g）;
			}
			//獲取結果集
		}?catch?（SQLException?e）?{
				e.printStackTrace（）;
		}?finally?{
				//最后要關閉連接
			JDBCUtil.close（conn?null?psmt?rs）;
		}
		return?guestList;
	}
	
	public?int?checkIn（Guest?guest）{
		PreparedStatement?psmt=null;
		int?i=-1;
		//定義sql
		String?sql?=?“insert?into?guest（namesexidentityphoneentry_timeroomtypestate）?values?（????now（）??0）“;
		//獲取數據庫連接
		Connection?conn?=?JDBCUtil.getConnection（）;
		try?{
			//編譯sql
			psmt?=?conn.prepareStatement（sql）;
			psmt.setString（1guest.getName（））;
			psmt.setInt（2guest.getSex（））;
			psmt.setString（3guest.getIdentity（））;
			psmt.setString（4guest.getPhone（））;
			psmt.setInt（5guest.getRoom（））;
			psmt.setString（6guest.getType（））;
			//執行sql
			i?=?psmt.executeUpdate（）;
			//獲取結果集
		}?catch?（SQLException?e）?{
				e.printStackTrace（）;
		}?finally?{
				//最后要關閉連接
			JDBCUtil.close（conn?null?psmt?null）;
		}
		return?i;
	}
	
	public?ArrayList?findGuest（Guest?guest?String?entry?String?dimiss）?throws?ParseException?{
		ArrayList?guestList=new?ArrayList（）;
		PreparedStatement?psmt=null;
		ResultSet?rs=null;
		//定義sql
		String?sql?=?“select?*?from?guest?where?“;
		//獲取數據庫連接
		Connection?conn?=?JDBCUtil.getConnection（）;
		try?{		
			int?flag=0;
			
			if（!““.equals（guest.getName（）））{
				sql=sql+“name?like?‘%“+guest.getName（）+“%‘“;
				flag++;
			}
			if（!（guest.getSex（）==-1））{