I would like to split generated data from db into several tables in servlet and DISPLAY IT. The table is organized using presentation ID. For example, I have 10 people. I need to assign supervisor and examiner with the same availableID
. My system will identify if they have similar availableID
.
I would like to display it using servlet TEMPORARILY before the admin click on SAVE button and insert it into db.
for (int i=0; i<studentID.length ; i++) {
FreeBean free = new FreeBean();
free = GenerateScheduleDAO.getFree(supervisorID[i],examinerID[i]);
String SVavailableID = free.getAvailableID();
String EXavailableID = free.getAvailableID();
Date FreeDate = free.getFreeDate();
System.out.println("sv: "+ supervisorID[i] + SVavailableID + " ev: "+ examinerID[i] + EXavailableID);
if (SVavailableID.equals(EXavailableID))
{
if(SVavailableID.equals("2")&& EXavailableID.equals("2")){
out.println("<br><center><table><tr>"
+ "<th>Name</th>"
+ "<th>Title</th>"
+ "<th>Supervisor</th>"
+ "<th>Examiner Name</th>"
+ "<th>availableID</th>"
+ "<th>Time </th>"
+ "</tr>");
out.println("<tr>");
out.println("<tr>");
out.println("<td>"+ studentID[i]+"</td>");
out.println("<td> Hello </td>");
out.println("<td>"+ supervisorID[i] +"</td>");
out.println("<td>"+ examinerID[i] +"</td>");
out.println("<td>"+ SVavailableID+"</td>");
out.println("<td>"+ FreeDate+"</td>");
out.println("</tr><br>");
out.println("</center></table>");
}//2
if(SVavailableID.equals("7")&& EXavailableID.equals("7")){
out.println("<br><center><table><tr>"
+ "<th>Name</th>"
+ "<th>Title</th>"
+ "<th>Supervisor</th>"
+ "<th>Examiner</th>"
+ "<th>availableID </th>"
+ "<th>Time</th>"
+ "</tr>");
out.println("<tr>");
out.println("<tr>");
out.println("<td>"+ studentID[i]+"</td>");
out.println("<td> Hello </td>");
out.println("<td>"+ supervisorID[i] +"</td>");
out.println("<td>"+ SVavailableID+"</td>");
out.println("<td>"+ FreeDate+"</td>");
out.println("</tr><br>");
out.println("</center></table>");
}//7
if(SVavailableID.equals("10")&& EXavailableID.equals("10")){
out.println("<br><center><table><tr>"
+ "<th> Name</th>"
+ "<th> Title</th>"
+ "<th>Supervisor</th>"
+ "<th>Examiner</th>"
+ "<th>availableID </th>"
+ "<th>Time </th>"
+ "</tr>");
out.println("<tr>");
out.println("<tr>");
out.println("<td>"+ studentID[i]+"</td>");
out.println("<td> Hello </td>");
out.println("<td>"+ supervisorID[i] +"</td>");
out.println("<td>"+ examinerID[i] +"</td>");
out.println("<td>"+ SVavailableID+"</td>");
out.println("<td>"+ FreeDate+"</td>");
out.println("</tr><br>");
out.println("</center></table>");
}
if(SVavailableID.equals("16")&& EXavailableID.equals("16")){
out.println("<br><center><table><tr>"
+ "<th>Name</th>"
+ "<th>Title</th>"
+ "<th>Supervisor</th>"
+ "<th>Examiner</th>"
+ "<th>availableID </th>"
+ "<th>Time </th>"
+ "</tr>");
out.println("<tr>");
out.println("<tr>");
out.println("<td>"+ studentID[i]+"</td>");
out.println("<td> Hello </td>");
out.println("<td>"+ supervisorID[i] +"</td>");
out.println("<td>"+ examinerID[i] +"</td>");
out.println("<td>"+ SVavailableID+"</td>");
out.println("<td>"+ FreeDate+"</td>");
out.println("</tr><br>");
out.println("</center></table>");
}
}
The result displays like this :
Name Title Supervisor Examiner availableID Time
abc Hello 1024 1001 7 null
Name Title Supervisor Examiner availableID Time
abc Hello 1024 1001 7 null
Name Title Supervisor Examiner availableID Time
abc Hello 1024 1001 8 null
Name Title Supervisor Examiner availableID Time
abc Hello 1024 1001 8 null (so on..)
expected outcome :
able availableID = 7:
Name Title Supervisor Examiner availableID Time
abc Hello 1024 1001 7 null
def Hi 1024 1001 7 null
ghi Hey 1002 1004 7 null
jkl hhh 1027 1011 7 null
mno 123 1014 1034 7 null
Table availableID = 10:
Name Title Supervisor Examiner availableID Time
pqr 3333 1026 1021 10 null
stu 4444 1023 1001 10 null
vwx 5555 1002 1002 10 null
yz1 6666 1027 1031 10 null
234 7777 1034 1004 10 null
Since the outcome has not been added in db, i cant use WHERE
to get the ID. So i tried to split using IF statement but I didnt work out.