package labsis.financeiro.dao;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import labsis.DataBase;
import labsis.financeiro.model.FluxoDeCaixa;
public class DaoFluxo {
private Connection conn;
public DaoFluxo() throws SQLException {
DataBase db = DataBase.getDb();
conn = db.getConnection();
}
public ArrayList<FluxoDeCaixa> listarFluxo() {
CallableStatement cstmt = null;
ArrayList<FluxoDeCaixa> lista = new ArrayList<FluxoDeCaixa>();
try {
cstmt = conn.prepareCall("exec listarFluxo");
ResultSet rs = cstmt.executeQuery();
while(rs.next()){
FluxoDeCaixa c = new FluxoDeCaixa();
c.setCodigo(rs.getInt(1));
c.setContasPagarId(rs.getInt(2));
c.setContasReceberId(rs.getInt(3));;
c.setDataDeMovimentacao(rs.getDate(4));
c.setStatus(rs.getString(5));
c.setValorAtual(rs.getFloat(6));
lista.add(c);
}
cstmt.close();
}
catch (SQLException e) {
e.printStackTrace();
}
return lista;
}
}