 |
Calendar |
 |
|
|
Click here
to view employees on leave
|
|
|
|
|
|
UPCOMING ROOM BOOKING |
|
|
 |
<%java.util.Properties parms = new java.util.Properties();
parms.setProperty(Context.INITIAL_CONTEXT_FACTORY,"com.ibm.websphere.naming.WsnInitialContextFactory");
Context ctx = new javax.naming.InitialContext(parms);
DataSource ds = (javax.sql.DataSource) ctx.lookup("jdbc/STAFFDBS");
Connection con = ds.getConnection();
Statement stmt = con.createStatement();
String sql = "select a.date,b.name,a.purpose,a.status,a.emid,c.time from room_booking a, room b, time_slot c where a.rid = b.rid and a.rbid=c.rbid and status = 'Taken' order by date asc ";
ResultSet rs = stmt.executeQuery(sql);
String date;
String name;
String purpose;
String status;
String emid;
//int rid;
String time;
Vector records = new Vector();
while (rs.next()){
date = rs.getString("date");
name = rs.getString("name");
purpose = rs.getString("purpose");
status = rs.getString("status");
emid = rs.getString("emid");
time = rs.getString("time");
try{
if(eform.util.Util.getCompareResult1 (date )> 0 ){
//we are only adding to the records if date equal to today
JoRoomBookingBean bean = new JoRoomBookingBean();
bean.setDate(date);
bean.setName(name);
bean.setPurpose(purpose);
bean.setStatus(status);
bean.setEmid(emid);
bean.setTime(time);
records.addElement(bean);
}
}catch(Exception e){
System.out.println("An exception occured :"+e.getMessage());
e.printStackTrace();
}
}
%>
| DATE |
NAME |
PURPOSE |
STATUS |
BOOKED BY |
TIME |
<%for (int i = 0; i < records.size(); i++) {
JoRoomBookingBean bean = (JoRoomBookingBean) records.elementAt(i);%>
| <%=bean.getDate()%> |
<%=bean.getName()%> |
<%=bean.getPurpose()%> |
<%=bean.getStatus()%> |
<%=bean.getEmid()%> |
<%=bean.getTime()%> |
<%}%>
|
|
|
|
