public void modifyBook(Book book) {
        Connection con = null;
        PreparedStatement pstmt = null;
        try {
            DBconnection dbCon = new DBconnection();
            Class.forName(dbCon.getJDBC_DRIVER());

            con = DriverManager.getConnection(dbCon.getDATABASE_URL(),
                    dbCon.getDB_USERNAME(), dbCon.getDB_PASSWORD());

            pstmt = con.prepareStatement("Update book Set bok_title=?, bok_subtitle=?, bok_isbn=?,"
                    + "bok_publisher=?,bok_publisherdate=?,"
                    + "bok_nbpages=?,bookCategory_id=?,"
                    + "bookLanguage_id=?,BookAuthor_id=?,item_id=?,"
                    + "bookstatus_id=? Where bok_id=?");
           
            pstmt.setString(1, book.getTitle());
            pstmt.setString(2, book.getSubtitle());
            pstmt.setString(3, book.getIsbn());
            pstmt.setString(4, book.getPublisher());
            pstmt.setDate(5, (Date) book.getPublishDate());
            pstmt.setInt(6, book.getPagesNb());
            pstmt.setLong(7, book.getBookCategory_id());
            pstmt.setLong(8, book.getLanguage_id());
            pstmt.setLong(9, book.getAuthor_id());
            pstmt.setLong(10, book.getItem_id());
            pstmt.setLong(11, book.getBookStatus_id());
            pstmt.setLong(12, book.getId());
            
            
             
            
            pstmt.executeUpdate();
        } catch (SQLException | ClassNotFoundException ex) {
            System.err.println("Caught Exception: " + ex.getMessage());
        } finally {
            try {
                if (pstmt != null) {
                    pstmt.close();
                }
                if (con != null) {
                    con.close();
                }
            } catch (SQLException ex) {
                System.err.println("Caught Exception: " + ex.getMessage());
            }
        }
    }