Hi,
I have a problem with the results of a sql query. My code is the
following. I keep the results on a table and I want those results to
be available on another jsp file. I use the session.putValu e() method
by it holds only the last result of the table. How can I keep all the
values and link them to another jsp file ?
<% String t_exam_date, var2 ;
healthpack.Sear chClass search1 = new healthpack.Sear chClass();
Vector records1=search 1.getListExams( t_pa_ssn);
if (records1.size( )>0) {
for (int i=0;i<records1. size();i++){
java.util.HashM ap temp1=new java.util.HashM ap();
temp1=(java.uti l.HashMap) records1.elemen tAt(i);
t_exam_date=(St ring)temp1.get( "exam_date" );
out.println(t_e xam_date);
%>
<table width = "50%" border="2" align="center">
<tr>
<td colspan="2" bgcolor="#3399f f" height="1" nowrap><B>
<SPAN style="backgrou nd-color: #3399ff"><B>
<font color="#FFFF00" >EXAM_DATE:</font> </B>
<A href="List_exam s1.jsp"><font color="#0000CC" >
<%=temp1.get("e xam_date")%></SPAN></B></A>
</td>
<td colspan="2" bgcolor="#3399f f" height="1" nowrap><B>
<SPAN style="backgrou nd-color: #3399ff"><B>
<font color="#FFFF00" >NAME:</font> </B><font
color="#0000CC" >
<%=temp1.get("n ame")%>></SPAN></A></B>
</td>
</tr>
<tr>
<td bgcolor="#FFFFF F" height="0.5" colspan="5"></td>
</tr>
</table>
<%}
}
%>
I have a problem with the results of a sql query. My code is the
following. I keep the results on a table and I want those results to
be available on another jsp file. I use the session.putValu e() method
by it holds only the last result of the table. How can I keep all the
values and link them to another jsp file ?
<% String t_exam_date, var2 ;
healthpack.Sear chClass search1 = new healthpack.Sear chClass();
Vector records1=search 1.getListExams( t_pa_ssn);
if (records1.size( )>0) {
for (int i=0;i<records1. size();i++){
java.util.HashM ap temp1=new java.util.HashM ap();
temp1=(java.uti l.HashMap) records1.elemen tAt(i);
t_exam_date=(St ring)temp1.get( "exam_date" );
out.println(t_e xam_date);
%>
<table width = "50%" border="2" align="center">
<tr>
<td colspan="2" bgcolor="#3399f f" height="1" nowrap><B>
<SPAN style="backgrou nd-color: #3399ff"><B>
<font color="#FFFF00" >EXAM_DATE:</font> </B>
<A href="List_exam s1.jsp"><font color="#0000CC" >
<%=temp1.get("e xam_date")%></SPAN></B></A>
</td>
<td colspan="2" bgcolor="#3399f f" height="1" nowrap><B>
<SPAN style="backgrou nd-color: #3399ff"><B>
<font color="#FFFF00" >NAME:</font> </B><font
color="#0000CC" >
<%=temp1.get("n ame")%>></SPAN></A></B>
</td>
</tr>
<tr>
<td bgcolor="#FFFFF F" height="0.5" colspan="5"></td>
</tr>
</table>
<%}
}
%>
Comment