findall.java

    public List<Book> findAll() throws SQLException {
        PreparedStatement preparedStatement = database.getConnection().prepareStatement("select * from books");

        List<Book> books = new ArrayList<>();

        preparedStatement.execute();

        ResultSet rs = preparedStatement.getResultSet();

        while (rs.next()) {
            Book book = new Book();

            book.setId(rs.getInt("id"));
            book.setTitle(rs.getString("title"));
            book.setDescription(rs.getString("description"));

            books.add(book);
        }

        return books;
    }