Como mostrar valores retornados por un resultset en jsp
Hola a todos, espero puedan ayudarme, tengo una pagina jsp que no esta mostrando los valores retornados por una consulta que se encuentra en un metodo aparte en un .java, estoy llamando al metodo y pasandole los parametros, pero no me muestra los resultados...
Aqui les pongo mi codigo
<% if(mes!=""){ %>
<% if(anno!=""){ %>
<tr>
<td width="638" valign="bottom" bgcolor="#FFFFFF" class="pagetittle"><div align="center"> Periodo <%= mes %>-<%= anno %> </div></td>
</tr>
<tr>
<td valign = "center" bgcolor="#FFFFFF" ><table>
<form action="productividad" name="searchform" method="post">
<input name="action" type="hidden" value="getUnitMonthlyProductivity">
<tr>
<td><select name="cmbMonth">
<option value="01" <%= pMonth.equals("01") ? " selected " : "" %>>Enero</option>
<option value="02" <%= pMonth.equals("02") ? " selected " : "" %>>Febrero</option>
<option value="03" <%= pMonth.equals("03") ? " selected " : "" %>>Marzo</option>
<option value="04" <%= pMonth.equals("04") ? " selected " : "" %>>Abril</option>
<option value="05" <%= pMonth.equals("05") ? " selected " : "" %>>Mayo</option>
<option value="06" <%= pMonth.equals("06") ? " selected " : "" %>>Junio</option>
<option value="07" <%= pMonth.equals("07") ? " selected " : "" %>>Julio</option>
<option value="08" <%= pMonth.equals("08") ? " selected " : "" %>>Agosto</option>
<option value="09" <%= pMonth.equals("09") ? " selected " : "" %>>Septiembre</option>
<option value="10" <%= pMonth.equals("10") ? " selected " : "" %>>Octubre</option>
<option value="11" <%= pMonth.equals("11") ? " selected " : "" %>>Noviembre</option>
<option value="12" <%= pMonth.equals("12") ? " selected " : "" %>>Diciembre</option>
</select>
</td>
<td><select name="cmbYear" >
<option <%= pYear.equals("2000") ? " selected " : "" %>>2000</option>
<option <%= pYear.equals("2001") ? " selected " : "" %>>2001</option>
<option <%= pYear.equals("2002") ? " selected " : "" %>>2002</option>
<option <%= pYear.equals("2003") ? " selected " : "" %>>2003</option>
<option <%= pYear.equals("2004") ? " selected " : "" %>>2004</option>
<option <%= pYear.equals("2005") ? " selected " : "" %>>2005</option>
<option <%= pYear.equals("2006") ? " selected " : "" %>>2006</option>
<option <%= pYear.equals("2007") ? " selected " : "" %>>2007</option>
<option <%= pYear.equals("2008") ? " selected " : "" %>>2008</option>
<option <%= pYear.equals("2009") ? " selected " : "" %>>2009</option>
<option <%= pYear.equals("2010") ? " selected " : "" %>>2010</option>
<option <%= pYear.equals("2011") ? " selected " : "" %>>2011</option>
<option <%= pYear.equals("2012") ? " selected " : "" %>>2012</option>
<option <%= pYear.equals("2013") ? " selected " : "" %>>2013</option>
<option <%= pYear.equals("2014") ? " selected " : "" %>>2014</option>
<option <%= pYear.equals("2015") ? " selected " : "" %>>2015</option>
</select>
</td>
<td><input name="submit" type="submit" class="buttontext" value="Consultar">
</td>
</tr>
</form>
</table></td>
</tr>
<tr>
<td class="Tittle" style="font-size:14px">Productividad de Unidad</td>
</tr>
<tr>
<td height="14" valign = "center" bgcolor="#FFFFFF"><% if(unit_productivity != null){ %>
<pro:DisplayResults data="<%= unit_productivity %>" link="<%= "productividad?action=getSupervisorEmployeeDetail&cmbYear=" + pYear + "&cmbMonth=" + pMonth + "&employeeDocument=" + request.getParameter("employeeDocument") %>" style="tableText" stylealt="tabletitle" rowcolor="#dcdcdc" rowcoloralt="#ededfe" displaymode="table"/>
<% } %>
No entiendo por q no los muestra, de acuerdo a los parametros pasados, q son mes, año y un id
Aqui les pongo mi codigo
<% if(mes!=""){ %>
<% if(anno!=""){ %>
<tr>
<td width="638" valign="bottom" bgcolor="#FFFFFF" class="pagetittle"><div align="center"> Periodo <%= mes %>-<%= anno %> </div></td>
</tr>
<tr>
<td valign = "center" bgcolor="#FFFFFF" ><table>
<form action="productividad" name="searchform" method="post">
<input name="action" type="hidden" value="getUnitMonthlyProductivity">
<tr>
<td><select name="cmbMonth">
<option value="01" <%= pMonth.equals("01") ? " selected " : "" %>>Enero</option>
<option value="02" <%= pMonth.equals("02") ? " selected " : "" %>>Febrero</option>
<option value="03" <%= pMonth.equals("03") ? " selected " : "" %>>Marzo</option>
<option value="04" <%= pMonth.equals("04") ? " selected " : "" %>>Abril</option>
<option value="05" <%= pMonth.equals("05") ? " selected " : "" %>>Mayo</option>
<option value="06" <%= pMonth.equals("06") ? " selected " : "" %>>Junio</option>
<option value="07" <%= pMonth.equals("07") ? " selected " : "" %>>Julio</option>
<option value="08" <%= pMonth.equals("08") ? " selected " : "" %>>Agosto</option>
<option value="09" <%= pMonth.equals("09") ? " selected " : "" %>>Septiembre</option>
<option value="10" <%= pMonth.equals("10") ? " selected " : "" %>>Octubre</option>
<option value="11" <%= pMonth.equals("11") ? " selected " : "" %>>Noviembre</option>
<option value="12" <%= pMonth.equals("12") ? " selected " : "" %>>Diciembre</option>
</select>
</td>
<td><select name="cmbYear" >
<option <%= pYear.equals("2000") ? " selected " : "" %>>2000</option>
<option <%= pYear.equals("2001") ? " selected " : "" %>>2001</option>
<option <%= pYear.equals("2002") ? " selected " : "" %>>2002</option>
<option <%= pYear.equals("2003") ? " selected " : "" %>>2003</option>
<option <%= pYear.equals("2004") ? " selected " : "" %>>2004</option>
<option <%= pYear.equals("2005") ? " selected " : "" %>>2005</option>
<option <%= pYear.equals("2006") ? " selected " : "" %>>2006</option>
<option <%= pYear.equals("2007") ? " selected " : "" %>>2007</option>
<option <%= pYear.equals("2008") ? " selected " : "" %>>2008</option>
<option <%= pYear.equals("2009") ? " selected " : "" %>>2009</option>
<option <%= pYear.equals("2010") ? " selected " : "" %>>2010</option>
<option <%= pYear.equals("2011") ? " selected " : "" %>>2011</option>
<option <%= pYear.equals("2012") ? " selected " : "" %>>2012</option>
<option <%= pYear.equals("2013") ? " selected " : "" %>>2013</option>
<option <%= pYear.equals("2014") ? " selected " : "" %>>2014</option>
<option <%= pYear.equals("2015") ? " selected " : "" %>>2015</option>
</select>
</td>
<td><input name="submit" type="submit" class="buttontext" value="Consultar">
</td>
</tr>
</form>
</table></td>
</tr>
<tr>
<td class="Tittle" style="font-size:14px">Productividad de Unidad</td>
</tr>
<tr>
<td height="14" valign = "center" bgcolor="#FFFFFF"><% if(unit_productivity != null){ %>
<pro:DisplayResults data="<%= unit_productivity %>" link="<%= "productividad?action=getSupervisorEmployeeDetail&cmbYear=" + pYear + "&cmbMonth=" + pMonth + "&employeeDocument=" + request.getParameter("employeeDocument") %>" style="tableText" stylealt="tabletitle" rowcolor="#dcdcdc" rowcoloralt="#ededfe" displaymode="table"/>
<% } %>
No entiendo por q no los muestra, de acuerdo a los parametros pasados, q son mes, año y un id
