findbyid.java

public Optional<Book> findById(int id) throws SQLException {
    PreparedStatement preparedStatement = database.getConnection().prepareStatement("select * from books where id = ?");

    preparedStatement.setInt(1, id);

    preparedStatement.execute();

    ResultSet rs = preparedStatement.getResultSet();

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

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


        return Optional.of(book);
    }

    return Optional.empty();
}