<a4j:form>
<a4j:region >
<h:panelGrid columns="3">
<h:outputText value="Name:" />
<h:inputText value="#{detalhaVotacaoBean.ordenacao}" />
<a4j:commandLink reRender="carList" action="#{detalhaVotacaoBean.votacao}">
<h:outputText value="Say Hello" />
</a4j:commandLink>
</h:panelGrid>
.......
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package br.com.dnasolution.bean;
import br.com.dnasolution.db.Conexao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Collection;
import javax.faces.model.SelectItem;
import javax.servlet.jsp.jstl.sql.Result;
import javax.servlet.jsp.jstl.sql.ResultSupport;
/**
*
* @author Administrador
*/
public class DetalhaVotacaoBean {
/** Creates a new instance of detalhaVotacaoBean */
public DetalhaVotacaoBean() {
ordenacao = "nm_pessoa";
}
private String ordenacao = null;
public ArrayList getCampos() {
ArrayList toReturn = new ArrayList();
try {
toReturn.add("nm_pessoa");
toReturn.add("nm_bairro");
toReturn.add("nr_zona");
toReturn.add("nm_vila_jardim");
toReturn.add( "vl_votacao_candidato");
} catch (Exception e) {
}
return toReturn;
}
public Result getVotacao() {
Collection toReturn = new ArrayList();
ResultSet rs = null;
try {
Connection conexao = Conexao.getInstancia().conectarDb();
PreparedStatement st = conexao.prepareStatement("SELECT tb_pessoa.nm_pessoa, tb_bairro.nm_bairro, tb_zona.nr_zona, tb_vila_jardim_bairro.nm_vila_jardim, vl_votacao_candidato FROM tb_votacao JOIN tb_pessoa ON tb_pessoa.cd_pessoa = tb_votacao.cd_pessoa JOIN tb_vila_jardim_bairro ON tb_vila_jardim_bairro.cd_vila_jardim = tb_votacao.cd_vila_jardim JOIN tb_bairro ON tb_bairro.cd_bairro = tb_vila_jardim_bairro.cd_bairro JOIN tb_zona ON tb_zona.cd_zona = tb_bairro.cd_zona ORDER BY ?");
st.setString(1, ordenacao);
rs = st.executeQuery();
} catch (Exception e) {
System.out.println(e.getMessage());
}
return ResultSupport.toResult(rs);
}
public void setOrdenacao(String ordenacao) {
this.ordenacao = ordenacao;
}
public String getOrdenacao() {
return ordenacao;
}
public String foi(){
return "foi";
}
}
segue o erro:
HTTP Status 500 -type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: #{detalhaVotacaoBean.votacao}: javax.el.MethodNotFoundException: Method not found: [email removido]()
javax.faces.webapp.FacesServlet.service(FacesServlet.java:256)
org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)
org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)root cause
javax.faces.FacesException: #{detalhaVotacaoBean.votacao}: javax.el.MethodNotFoundException: Method not found: [email removido]()
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:99)
javax.faces.component.UICommand.broadcast(UICommand.java:383)
org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:61)
org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:184)
org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:162)
org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:350)
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)
org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)root cause
javax.faces.el.MethodNotFoundException: javax.el.MethodNotFoundException: Method not found: [email removido]()
com.sun.faces.application.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:81)
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
javax.faces.component.UICommand.broadcast(UICommand.java:383)
org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:61)
org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:184)
org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:162)
org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:350)
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)
org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)root cause
javax.el.MethodNotFoundException: Method not found: [email removido]()
org.apache.el.util.ReflectionUtil.getMethod(ReflectionUtil.java:138)
org.apache.el.parser.AstValue.invoke(AstValue.java:128)
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
com.sun.faces.application.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
javax.faces.component.UICommand.broadcast(UICommand.java:383)
org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:61)
org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:184)
org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:162)
org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:350)
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)
org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)note The full stack trace of the root cause is available in the Apache Tomcat/6.0.14 logs.
Apache Tomcat/6.0.14
ele fala q nao acha o metodo que eu coloquei.. mas ja chamei todos os metodos da minha classe. retornando parametro, nao retornando, e da na mesma.. alguem pode me ajudar por favor??
valeus