public List<Payment> retreiveALL() {
String sql =
"SELECT id_payment, id_transaction, lens_price, frame_price, amount, dp, agency, variance FROM payment ";
PreparedStatement statement = null;
List<Payment> listpaPayments = new ArrayList<>();
try {
statement = (PreparedStatement) connection.prepareStatement(sql);
rs = statement.executeQuery();
while (rs.next()) {
Payment payment = new Payment();
payment.setIdPayment(rs.getInt(1));
payment.setIdTransaction(rs.getInt(2));
payment.setLensPrice(rs.getBigDecimal(3));
payment.setFramePrice(rs.getBigDecimal(4));
payment.setAmount(rs.getBigDecimal(5));
payment.setDp(rs.getBigDecimal(6));
payment.setAgency(rs.getBigDecimal(7));
payment.setVariance(rs.getBigDecimal(8));
listpaPayments.add(payment);
}
rs.close();
} catch (SQLException ex) {
System.out.println("SQL Execption :" + ex.getMessage());
} finally {
if (statement != null) {
try {
statement.close();
} catch (SQLException exception) {
exception.printStackTrace();
}
}
}
return listpaPayments;
}
