tenho o bin (omiti os getters e setters pra não ficar imenso)
public class ProspectBin {
private String Prospectcod;
private String Prospectloja;
private String Prospectnome;
private String Prospectnreduz;
private String Prospectnvend;
public ProspectBin() {
this.Prospectcod = "";
this.Prospectloja = "";
this.Prospectnome = "";
this.Prospectnreduz = "";
this.Prospectnvend = "";
}
}
tenho o dao
public class ProspectDao {
private static Connection con;
private static Statement stm;
private static String sql;
private static ResultSet rs;
public static ArrayList <ProspectBin> ProspectQry(String codvend) throws SQLException {
//Definindo as variaveis do DAO
ArrayList <ProspectBin> prosplist = new ArrayList();
Statement stm;
ResultSet rs;
String sql;
//Conectando à base de dados
Connection con = FabricaConexao.getConTST();
//Definindo a query a ser executada
sql = "SELECT US_COD, US_LOJA, US_NOME, US_NREDUZ, US_VEND " +
"FROM SUS010 WHERE US_VEND ='" + codvend + "' AND D_E_L_E_T_ <> '*' AND US_STATUS = '1'";
// executando a query
stm = con.createStatement();
rs = stm.executeQuery(sql);
while (rs.next()) {
ProspectBin prospect = new ProspectBin();
prospect.setProspectcod(rs.getString(1));
prospect.setProspectloja(rs.getString(2));
prospect.setProspectnome(rs.getString(3));
prospect.setProspectnreduz(rs.getString(4));
prospect.setProspectvend(rs.getString(5));
prosplist.add(prospect);
}
con.close();
return prosplist;
}
}
Tenho o controler
public class Prospectini extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
doGet(request, response);
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
HttpSession secao = request.getSession();
String codVend = secao.getAttribute("codVendedor").toString();
String operacao = request.getParameter("op");
String codprosp = request.getParameter("codprosp");
if (operacao.equals("1"))
{
response.sendRedirect("prospectinc.jsp");
}
else
{
if (operacao.equals("2"))
{
try
{
ProspectDao prospect = new ProspectDao();
ProspectBin locprospect = prospect.locProspect(codprosp);
request.setAttribute("codprospect", locprospect);
RequestDispatcher rd = request.getRequestDispatcher("prospectview.jsp");
rd.forward(request, response);
}
catch (SQLException e)
{
e.printStackTrace();
}
}
else
{
try
{
ProspectDao prospect = new ProspectDao();
ArrayList qryprospect = prospect.ProspectQry(codVend);
//********************************************************************************
// não sei se estou fazendo correto, mas estou jogando o resultado para 1 seção e dando 1 requestDispatcher
//********************************************************************************
secao.setAttribute("qryprospect", qryprospect);
RequestDispatcher rd = request.getRequestDispatcher("prospectini.jsp");
rd.forward(request, response);
}
catch (SQLException e)
{
e.printStackTrace();
}
}
}
}
}
no jsp
<!-- Include(s) Java -->
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!-- End Include(s) Java -->
<fieldset>
<legend><a href="<%= path %>representante.jsp" class="submenu">Representante</a> :: <a href="prospectini.jsp" class="submenu">Prospect</a></legend>
<div id="prospview">
<form action="Prospectini" method="post" >
<table border="0" cellpadding="0" cellspacing="0" class="corpo" width="100%">
<tr height="20">
<td width="15%"></td>
<td width="85%"></td>
</tr>
<tr height="20" bgcolor="#487393" >
<td colspan="2">
<table cellpadding="0" cellspacing="0" width="100%" class="corpo">
<tr>
<td width="80%" >
<font style="font-size:13px" color="#FFFFFF"><b> Cadastro de Prospect</b></font>
</td>
<td width="20%" align="right">
<input class="input" type="button" value="Incluir Prospect" onclick="gerenciarProspect(this.id,'1')">
</td>
</tr>
</table>
</td>
</tr>
<tr height="20" bgcolor="#CCCCCC" >
<td colspan="2">
<table cellpadding="0" cellspacing="1" width="100%" class="corpo" bgcolor="#000000">
<tr>
<td align="center" class="titulo_prateado" width="7%">
Codigo
</td>
<td align="center" class="titulo_prateado" width="38%">
Nome
</td>
<td align="center" class="titulo_prateado" width="12%">
C.G.C.
</td>
<td align="center" class="titulo_prateado" width="31%">
Endereço
</td>
<td align="center" class="titulo_prateado" width="12%">
(DDD) Telefone
</td>
</tr>
<c:set var="bgclass" value ="linha_cinza" scope="page" />
<!-- ************************************************************************************************
Não está achando Prospectcod na minha class ProspectBin
erro do console abaixo
05/11/2008 11:05:07 org.apache.catalina.core.ApplicationDispatcher invoke
SEVERE: Servlet.service() for servlet jsp threw exception
javax.el.PropertyNotFoundException: Property 'Prospectcod' not found on type representante.modulo.cadastro.ProspectBin
-->
<c:forEach var="prospect" items="qryprospect">
<tr height="20" onMouseOver="bgColorLn(this,'over')" onMouseOut="bgColorLn(this, 'out')" class="${bgclass}" id="${qryprospect.Prospectcod}" onclick="gerenciarProspect(this.id,'2')">
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td align="center">
</td>
</tr>
</c:forEach>
</table>
</td>
</tr>
</table>
</Form>
</div>
</fieldset>
Estou quase ficando careca tentando entender jstl, alguém pode me dar 1 ajuda.
Desde já agradeço antecipadamente
Christian