Olá, tudo bem?
Então pessoal não consigo popular meu dataTable vou mostrar meu código
Meu Bean
public DataModel getAllReciboMedico() {
try {
reciboMedico.setFuncionario(getFuncionarioSessao());
String crmString = reciboMedico.getFuncionario().getMatricula().substring(3);
int crmInt = Integer.parseInt(crmString);
return model = new ListDataModel(sysartDao.selectAllReciboMedico(crmInt));
} catch (Exception e) {
FacesContext.getCurrentInstance().addMessage(null,
new FacesMessage(FacesMessage.SEVERITY_ERROR, "Erro: " + e.getCause(), null));
}
return null;
}
Minha View
<rich:dataTable id="list1" styleClass="cadastro" rowClasses="odd-row,even-row"
value="#{reciboMedicoController.allReciboMedico}"
var="row" rows="05" >
<rich:column style="height:20px;">
<f:facet name="header">
<h:outputText value="CRM" styleClass="headerText" style="color:#FF6600" />
</f:facet>
<h:outputText styleClass="headerText" value="#{row.crm}" />
</rich:column>
<rich:column style="height:40px;">
<f:facet name="header">
<h:outputText styleClass="headerText" value="Valor" style="color:#FF6600"/>
</f:facet>
<h:outputText styleClass="headerText" value="#{row.valorRecibo}" />
</rich:column>
<rich:column style="height:60px;">
<f:facet name="header">
<h:outputText styleClass="headerText" value="Nº do Recibo" style="color:#FF6600" />
</f:facet>
<h:outputText styleClass="headerText" value="#{row.numeroCP}" />
</rich:column>
<rich:column style="height:40px;">
<f:facet name="header">
<h:outputText styleClass="headerText" value="CGC/CPF" style="color:#FF6600" />
</f:facet>
<h:outputText styleClass="headerText" value="#{row.cgcCpfRep}" />
</rich:column>
</rich:dataTable>
Meu DAO
public List selectAllReciboMedico(int crm) {
Date now = new Date();
int mes = now.getMonth();
int ano = now.getYear();
try {
this.sql = "SELECT cadrech.crm, cadrech.valor_recibo, cadrech.NumeroCP, cadrech.CgcCpfRep "
+ "FROM sysart1.dbo.cadrech "
+ "WHERE MONTH(dt_referencia)= "+mes+" and YEAR(dt_referencia)= "+ano+" and crm = ? ";
this.ps = con.prepareStatement(sql);
this.ps.setInt(1, crm);
rs = this.ps.executeQuery();
List<ReciboMedico> listaRecibos = new ArrayList<ReciboMedico>();
while (rs.next()) {
ReciboMedico reciboMedico = new ReciboMedico();
reciboMedico.setCrm(rs.getInt("crm"));
reciboMedico.setValorRecibo(rs.getDouble("valor_recibo"));
reciboMedico.setNumeroCP(rs.getString("NumeroCP"));
reciboMedico.setCgcCpfRep(rs.getString("CgcCpfRep"));
listaRecibos.add(reciboMedico);
}
return listaRecibos;
} catch (Exception e) {
System.out.println(e.getMessage());
return null;
} finally {
SysartCon.close(con, ps, rs);
}
}