@ManagedBean @SessionScoped
public class CepControle {
private Ceps cep;
private DataModel lista_10;
public DataModel getListarCeps10() {
List<Ceps> lista = new CepDAOImp().findLimite();
lista_10 = new ListDataModel(lista);
return lista_10;
}
CepDAOImp.java
@Override
public List<Ceps> findLimite() {
Session session = HibernateUtil.getSessionFactory().openSession();
Transaction t = session.beginTransaction();
// List lista = sessao.createSQLQuery(“SELECT c.idcep,c.cidade FROM ceps c where c.uf = ‘ES’ limit 10”).list();
List lista = session.createSQLQuery(“SELECT * FROM ceps c where c.uf = ‘ES’”).list();
t.commit();
return lista;
}
Error
java.lang.NumberFormatException: For input string: “cep”
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:447)
at java.lang.Integer.parseInt(Integer.java:497)
at javax.el.ArrayELResolver.toInteger(ArrayELResolver.java:375)
at javax.el.ArrayELResolver.getValue(ArrayELResolver.java:195)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175)
at com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
at com.sun.el.parser.AstValue.getValue(AstValue.java:116)
at com.sun.el.parser.AstValue.getValue(AstValue.java:163)
at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:219)
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:102)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:190)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:178)
at javax.faces.component.UIOutput.getValue(UIOutput.java:168)
at com.sun.faces.renderkit.html_basic.HtmlBasicInputRenderer.getValue(HtmlBasicInputRenderer.java:205)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.getCurrentValue(HtmlBasicRenderer.java:338)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeEnd(HtmlBasicRenderer.java:164)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:878)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1620)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1616)
at org.primefaces.component.datatable.DataTableRenderer.encodeRegularCell(DataTableRenderer.java:570)
at org.primefaces.component.datatable.DataTableRenderer.encodeRow(DataTableRenderer.java:530)
at org.primefaces.component.datatable.DataTableRenderer.encodeTbody(DataTableRenderer.java:471)
at org.primefaces.component.datatable.DataTableRenderer.encodeRegularTable(DataTableRenderer.java:198)
at org.primefaces.component.datatable.DataTableRenderer.encodeMarkup(DataTableRenderer.java:177)
at org.primefaces.component.datatable.DataTableRenderer.encodeEnd(DataTableRenderer.java:82)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:878)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1620)
at javax.faces.render.Renderer.encodeChildren(Renderer.java:168)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:848)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1613)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1616)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1616)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1616)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1616)
at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:380)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:126)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:127)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:313)
at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1523)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:641)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:97)
at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:85)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:185)
at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:325)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:226)
at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:165)
at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:791)
at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:693)
at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:954)
at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:170)
at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:135)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:102)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:88)
at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:53)
at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:57)
at com.sun.grizzly.ContextTask.run(ContextTask.java:69)
at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:330)
at com.sun.grizzly.util.AbstractThreadPool$Wo
@Entity @Table(name = “ceps”)
// @NamedQuery(name = “ceps.FindLimite”, query = “SELECT c FROM Ceps c limit = :limit”) @NamedQueries({ @NamedQuery(name = “Ceps.findAll”, query = “SELECT c FROM Ceps c”), @NamedQuery(name = “Ceps.findByCep”, query = “SELECT c FROM Ceps c WHERE c.cep = :cep”), @NamedQuery(name = “Ceps.findByEndereco”, query = “SELECT c FROM Ceps c WHERE c.endereco = :endereco”), @NamedQuery(name = “Ceps.findByBairro”, query = “SELECT c FROM Ceps c WHERE c.bairro = :bairro”), @NamedQuery(name = “Ceps.findByCidade”, query = “SELECT c FROM Ceps c WHERE c.cidade = :cidade”), @NamedQuery(name = “Ceps.findBfindLimiteyUf”, query = “SELECT c FROM Ceps c WHERE c.uf = :uf”)})
public class Ceps implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Column(name = "idcep")
private long idcep;
@Column(name = "cep")
private String cep;
@Column(name = "endereco")
private String endereco;
@Column(name = "bairro")
private String bairro;
@Column(name = "cidade")
private String cidade;
@Column(name = "uf")
private String uf;
public Ceps() {
}
public Ceps(String cep) {
this.cep = cep;
}
public Ceps(Long idcep, String cep, String endereco, String bairro, String cidade, String uf) {
this.idcep = idcep;
this.cep = cep;
this.endereco = endereco;
this.bairro = bairro;
this.cidade = cidade;
this.uf = uf;
}
public Long getidcep() {
return idcep;
}
public void setidcep(Long idcep) {
this.idcep = idcep;
}
public String getCep() {
return cep;
}
public void setCep(String cep) {
this.cep = cep;
}
public String getEndereco() {
return endereco;
}
public void setEndereco(String endereco) {
this.endereco = endereco;
}
public String getBairro() {
return bairro;
}
public void setBairro(String bairro) {
this.bairro = bairro;
}
public String getCidade() {
return cidade;
}
public void setCidade(String cidade) {
this.cidade = cidade;
}
public String getUf() {
return uf;
}
public void setUf(String uf) {
this.uf = uf;
}
@Override
public int hashCode() {
int hash = 0;
hash += (cep != null ? cep.hashCode() : 0);
return hash;
}
@Override
public boolean equals(Object object) {
// TODO: Warning - this method won't work in the case the id fields are not set
if (!(object instanceof Ceps)) {
return false;
}
Ceps other = (Ceps) object;
if ((this.cep == null && other.cep != null) || (this.cep != null && !this.cep.equals(other.cep))) {
return false;
}
return true;
}
@Override
public String toString() {
return "br.com.clinica.model.Ceps[cep=" + cep + "]";
}