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; }