Untitled

public void showBooks() throws SQLException {
        String query = "SELECT * FROM books";
        Statement statement = connection.createStatement();
        ResultSet resultSet = statement.executeQuery(query);
        while (resultSet.next()) {
            System.out.println((resultSet.getInt("id") + " - " +
                    resultSet.getString("title") + " by " +
                    resultSet.getString("author") + " (" +
                    resultSet.getInt("year") + ")"));
        }
    }