public TO consultaID(String id) throws Exception {
Connection con = new Conexao().getConexao(dbf.getArquivo().getPath());
ResultSet rs;
PreparedStatement ps = con.prepareStatement("SELECT * FROM GERNFEIT WHERE NUMR_NFE = ?");
ps.setString(1, id);
rs = ps.executeQuery();
TO to2 = new TO();
if (rs.next()) {
to2.setNum_nfe(rs.getString("NUMR_NFE"));
to2.setMod_nfece(rs.getString("MODL_NFECE"));
to2.setDes_prod(rs.getString("DESC_PROD"));
to2.setQtde_prod(rs.getInt("QTDE_PRODT"));
to2.setVal_unit(rs.getDouble("VALR_UNITT"));
to2.setVal_desc(rs.getDouble("VALR_DESCN"));
to2.setVal_total(rs.getDouble("VALR_TOTAL"));
}
con.close();
return to2;
}
public ArrayList<TO> consultarTodos(TO to) throws Exception {
ArrayList gern = new ArrayList();
Connection con = new Conexao().getConexao(dbf.getArquivo().getPath());
ResultSet rs;
PreparedStatement ps = con.prepareStatement("SELECT * FROM GERNFEIT ORDER BY NUMR_NFE");
rs = ps.executeQuery();
while (rs.next()) {
TO to2 = new TO();
to2.setNum_nfe(rs.getString("NUMR_NFE"));
to2.setMod_nfece(rs.getString("MODL_NFECE"));
to2.setDes_prod(rs.getString("DESC_PROD"));
to2.setQtde_prod(rs.getInt("QTDE_PRODT"));
to2.setVal_unit(rs.getDouble("VALR_UNITT"));
to2.setVal_desc(rs.getDouble("VALR_DESCN"));
to2.setVal_total(rs.getDouble("VALR_TOTAL"));
gern.add(to2);
}
con.close();
return gern;
}