@Override
public Book mapRow(ResultSet rs, int rowNum) throws SQLException {
Book book = new Book();
book.setIsbn(rs.getString("ISBN"));
book.setTitle(rs.getString("title"));
book.setDescription(rs.getString("description"));
book.setPrice(rs.getDouble("price"));
book.setPublisher(rs.getString("publisher"));
book.setPubDate(rs.getDate("pubdate"));
book.setEdition(rs.getInt("edition"));
book.setPages(rs.getInt("pages"));
book.setStock(rs.getInt("stock"));
book.setCategories(getCategoriesbyIsbn(book.getIsbn()));
book.setAuthors(getAuthorsbyIsbn(book.getIsbn()));
return book;
}
