roombookingbean.java

provide a room booking system

package Wearnes;
import java.sql.*; 
import java.util.*; 
import javax.faces.component.UIParameter;
import javax.faces.event.*;
import javax.faces.context.*;
public class RoomBookingBean implements ActionListener
{
	public void processAction(ActionEvent event)
    throws AbortProcessingException {
    
    String current = event.getComponent().getId();
    FacesContext context = FacesContext.getCurrentInstance();
   // context.getViewRoot().setLocale(Locale) ;

  }

	private String roomNo;
	private String date;


	private ArrayList rooms,requestors,froms,tos,status;

	public RoomBookingBean(String r,String d)
	{
		rooms=new ArrayList();
		requestors=new ArrayList();
		froms=new ArrayList();
		tos=new ArrayList();
		status=new ArrayList();	
		roomNo=r;
		date=d;
		getAll(r,d);
	}
	

	public String getRoomNo()
	{
		return roomNo;
	}

	public void setRoomNo(String myparam)
	{
	this.roomNo = myparam;
	}

	public void getAll(String r,String d)
	{
		String strDate="", strDate2="";
		if(r!=null&&d!=null)
		{
		  strDate=date.substring(6,10)+date.substring(3,5)+date.substring(0,2)+"000000";
		  int tmp=1+Integer.parseInt(date.substring(0,2));
		  String tmpDate2="";
		  if(tmp<10)
		 	tmpDate2="0"+new Integer(tmp).toString();
		  else
		 	 tmpDate2=new Integer(tmp).toString();
		 strDate2=date.substring(6,10)+date.substring(3,5)+tmpDate2+"000000";		
		//String r=(String)getRoomNo().getValue();
		}
		java.util.Date currdate=new java.util.Date();
		String dd="",mm="";
		if(new Integer(1+currdate.getMonth()).toString().length()==1)
			mm="0"+new Integer(1+currdate.getMonth()).toString();
		else
	       mm=new Integer(1+currdate.getMonth()).toString();
		if(new Integer(currdate.getDate()).toString().length()==1)
			dd="0"+new Integer(currdate.getDate()).toString();
		else
	       dd=new Integer(currdate.getDate()).toString();
		String strDate0=new Integer(1900+currdate.getYear()).toString()+mm+dd+"000000";
		
		ResultSet rs=null;
		WearnesDB db=new WearnesDB();
		String sql="";
		if(r!=null&&d!=null)
			sql="select roomNo,requestor,fromTime,toTime,status,substring(fromint,1,8) ff from roombooking where roomNo='"+r.trim()+"' and status='reserved' and fromint>='"+strDate.trim()+"' and fromint<'"+strDate2.trim()+"' order by bookid desc";
		else
			sql="select roomNo,requestor,fromTime,toTime,status from roombooking where  status='reserved' and fromint>='"+strDate0.trim()+"' order by bookid desc";

		try{
				rs =db.select(sql);	
				while(rs.next())
				{
					rooms.add(rs.getString("roomNo"));
					requestors.add(rs.getString("requestor"));
					froms.add(rs.getString("fromTime"));
					tos.add(rs.getString("toTime"));
					status.add(rs.getString("status"));
				}
			
		}catch(SQLException e)
			{
			System.out.println(" Database Err");
			}
		
		 
	}
	public ArrayList getRooms()
	{
		return rooms;
	}
	public ArrayList getRequestors()
	{	return requestors;
	}
	public ArrayList getFroms()
	{
		return froms;
	}
	public ArrayList getTos()
	{
		return tos;
	}
	public ArrayList getStatus()
	{
		return status;
	}

}