Dúvidas em preencher rich:dataTable com DataModel

0 respostas
W

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);
    }
    }
Criado 17 de janeiro de 2011
Respostas 0
Participantes 1