@Override
public ArrayList<Expense> getExpenses() throws SQLException {
selectAllStatement = connection.createStatement();
ArrayList<Expense> list = new ArrayList<Expense>();
ResultSet result = selectAllStatement.executeQuery(SELECT_ALL);
while (result.next()) {
Expense expense = new Expense();
expense.setNum(result.getInt("num"));
expense.setPaydate(result.getDate("paydate"));
expense.setReceiver(result.getInt("receiver"));
expense.setValue(result.getInt("value"));
list.add(expense);
}
return list;
}
