<%@page import="java.util.*"%>
<%@page import="java.sql.*"%>
<%@page import="java.sql.Statement"%>
<%@page import="javax.sql.DataSource"%>
<%@page import="javax.naming.*"%>
<%@page import="eform.beans.*"%>
<%@page import="java.text.*"%>
<%@page import="java.util.Calendar"%>
<%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 date,purpose,status,rid from room_booking ";
ResultSet rs = stmt.executeQuery(sql);
String date;
String purpose;
String status;
int rid;
Vector records = new Vector();
while (rs.next()){
date = rs.getString("DATE");
purpose = rs.getString("PURPOSE");
status = rs.getString("STATUS");
rid = rs.getInt("RID");
JoRoomBookingBean bean = new JoRoomBookingBean();
bean.setDate(date);
bean.setPurpose(purpose);
bean.setStatus(status);
bean.setRid(rid);
records.addElement(bean);
}
%>
<%
public class StringToDate
{
public static void main(String[] args)
{
DateFormat df = new SimpleDateFormat("dd/mm/yyyy");
%>
ROOM BOOKING LIST
| date |
purpose |
status |
rid |
<%for (int i = 0; i < records.size(); i++) {
JoRoomBookingBean bean = (JoRoomBookingBean) records.elementAt(i);%>
| <%=bean.getDate()%> |
<%=bean.getPurpose()%> |
<%=bean.getStatus()%> |
<%=bean.getRid()%> |
<%}%>
Total Records:
<%=records.size()%>