É um problema simples, mas minha pouca experiência com java não me permitiu resolver.
Tenho um selectonemmenu e gostaria de trazer a consulta de uma tabela já filtrada. Das linhas
da minha tabela “quadro_programa”, gostaria de trazer apenas aquelas que a coluna "qp_tipoatd"
seja igual a “PROMOCAO”. Agradeço as contribuições.
Segue XHTML:
<h:selectOneMenu id="inputPrograma" value="#{atendimentoController.nomeouv}" class="form-control" style="width: 50%;">
<f:selectItem itemLabel="-Selecione-" itemValue=""/>
<f:selectItems value="#{quadroProgramaController.items}" var="item" itemValue="#{item.qpPrograma}" itemLabel="#{item.qpPrograma}"/>
</h:selectOneMenu>
Segue Classe QuadroPrograma:
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package pacote_jangadeiro;
import com.sun.xml.xsom.impl.RestrictionSimpleTypeImpl;
import java.io.Serializable;
import javax.faces.event.AjaxBehaviorEvent;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.validation.constraints.Size;
import javax.xml.bind.annotation.XmlRootElement;
/**
*
* @author vai
*/
@Entity
@Table(name = "quadro_programa")
@XmlRootElement
@NamedQueries({
@NamedQuery(name = "QuadroPrograma.findAll", query = "SELECT q FROM QuadroPrograma q")})
public class QuadroPrograma implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Basic(optional = false)
@Column(name = "qp_id")
private Integer qpId;
@Size(max = 45)
@Column(name = "qp_nome_quadro")
private String qpNomeQuadro;
@Size(max = 30)
@Column(name = "qp_programa")
private String qpPrograma;
@Size(max = 15)
@Column(name = "qp_tipoatd")
private String qpTipoatd;
@Column(name = "pgr_id")
private Integer pgrId;
public QuadroPrograma() {
}
public QuadroPrograma(Integer qpId) {
this.qpId = qpId;
}
public Integer getQpId() {
return qpId;
}
public void setQpId(Integer qpId) {
this.qpId = qpId;
}
public String getQpNomeQuadro() {
return qpNomeQuadro;
}
public void setQpNomeQuadro(String qpNomeQuadro) {
this.qpNomeQuadro = qpNomeQuadro;
}
public String getqpPrograma() {
return qpPrograma;
}
public void setqpPrograma(String qpPrograma) {
this.qpPrograma = qpPrograma;
}
public Integer getPgrId() {
return pgrId;
}
public void setPgrId(Integer pgrId) {
this.pgrId = pgrId;
}
public String getqpTipoatd() {
return qpTipoatd;
}
public void setqpTipoatd(String qpTipoatd) {
this.qpTipoatd = qpTipoatd;
}
@Override
public int hashCode() {
int hash = 0;
hash += (qpId != null ? qpId.hashCode() : 0);
return hash;
}
public boolean equals(Object object) {
// TODO: Warning - this method won't work in the case the id fields are not set
if (!(object instanceof QuadroPrograma)) {
return false;
}
QuadroPrograma other = (QuadroPrograma) object;
if ((this.qpId == null && other.qpId != null) || (this.qpId != null && !this.qpId.equals(other.qpId))) {
return false;
}
return true;
}
@Override
public String toString() {
return "pacote_jangadeiro.QuadroPrograma[ qpId=" + qpId + " ]";
}
}