public Book getBook(long id) {
        Book book = null;
        Connection con = null;
        Statement stmt = null;
        try {
            DBconnection dbCon = new DBconnection();
            Class.forName(dbCon.getJDBC_DRIVER());

            con = DriverManager.getConnection(dbCon.getDATABASE_URL(),
                    dbCon.getDB_USERNAME(), dbCon.getDB_PASSWORD());
            stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("Select * From Book Where bok_id=" + id);
            book = new Book();
            if (rs.next()) {
                book = new Book();
                book.setId(rs.getLong(1));
                book.setTitle(rs.getString(2));
                book.setSubtitle(rs.getString(3));
                book.setIsbn(rs.getString(4));
                book.setPublisher(rs.getString(5));
                book.setPublishDate(rs.getDate(6));
                book.setPagesNb(rs.getInt(7));
                book.setBookCategory_id(rs.getLong(8));
                book.setLanguage_id(rs.getLong(9));
                book.setAuthor_id(rs.getLong(10));
                book.setItem_id(rs.getLong(11));
                book.setBookStatus_id(rs.getLong(12));
                
            }
        } catch (SQLException | ClassNotFoundException ex) {
            System.err.println("Caught Exception: " + ex.getMessage());
        } finally {
            try {
                if (stmt != null) {
                    stmt.close();
                }
                if (con != null) {
                    con.close();
                }
            } catch (SQLException ex) {
                System.err.println("Caught Exception: " + ex.getMessage());
            }
        }
        return book;
    }