public void loadReservation(){
	  if(this.resrvID != 0){//load reservation
		  System.out.println(resrvID);
		  
		  ResultSet rs = Reservation.getReservationInfo(resrvID);
		  try {
			  while(rs.next()){
				  this.custID = rs.getInt("customerID");
				  this.spNumOfAdult.setValue(rs.getInt("numberOfAdult"));
				  this.spNumOfChild.setValue(rs.getInt("numberOfChild"));
				  
				  
				  try {
					  String dStrCheckin = rs.getString("resDate");
					  DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//MM/dd/yyyy HH:mm:ss
					Date dayCheckin = df.parse(dStrCheckin);
					this.dateCheckin.setDate(dayCheckin);
					
					String dStrCheckout = rs.getString("resLeaveDate");
					  DateFormat dfout = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//MM/dd/yyyy HH:mm:ss
					Date dayCheckout = dfout.parse(dStrCheckout);
					this.dateCheckout.setDate(dayCheckout);
					
				} catch (ParseException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				  
				  //java.sql.Date dStr = rs.getDate("resDate");
				  //Date d = new Date(dStr);
				  
				  
				  this.txtTotalCost.setText(rs.getDouble("preTotalCost") + "");  
				  roomID = rs.getInt("roomID");
			  }
		
			  
			  //load customer
			  loadCustomer(custID);
			  
		  //load reservation detail room, service
			  loadRoomDetailOfRes(roomID);
			  loadExtraService(resrvID);
		  //load 
		  
		  } catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	  }
  }