Assume that you have an Oracle database schema named ebookshop, the ebookshop DB is located on $192\mathrm{.}168\mathrm{.}1\mathrm{.}10$ server. The ebookshop DB has several tables, including the Book table. The Oracle Schema DB user is $$ebookshop$,$ whereas the DB password is $$pwd$.$

Notes:

The class OracleConnection is not fully written, you need to complete the missing parts $-$whenever necessary$-$ so that you convert it into functioning code snippets.

Paste or upload the resulting new Java file as part of your answer below.

The file should contain no errors $($errors are typically penalized$)$

$//$Write down the necessary imports in separate statements!

$..............................$

$..............................$

public class OracleConnection $\{$

static final String DB$\_$URL $="............................................................................................................"$;

static final String USER $="....................."$;

static final String PASS $="$pwd$"$;

public static Connection getOracleConnection $()$ throws $.............................................\{$

Connection myConn $=$ null;

try $\{$

myConn $=\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$getConnection$($DB$\_$URL, USER, PASS$)$;

$\}$catch $(----------------$ ex$)\{$

$----------------$

$\}$

return myConn;

$\}$

$\}$

Part $2$: Design & Implementation

Given the Java class OracleConnection above. Based on the books table, Book Java class, and the BookCRUD Java interface below:

The UML class diagram for the class Book Java bean $($class$)$:

Book

$-$ id: long

$-$ title: String

$-$ author: String

$-$ double: price

$-$ int: qty

$+$getId$()$: long

$+$setId$($id: long$)$: void

$...$ the rest of getters and setters placed here

public interface BookCRUD $\{$

int updateBook$($Book b$)$;$//$update existing book record.

$\}$

$$Your task is to complete the BookCRUDOpertions Java class below so that you can save a book record to DB$.$ Please take care of insertion status. You should also write a test case $($i$.$e$.1$ line of code$)$ that shows how to use BookCRUDOpertions from the main method.

Upload or paste the resulting Java file as part of your answer.

The file should contain no errors $($errors are typically penalized$)$

public class BookCRUDOpertions implements BookCRUD$\{$

public int updateBook$($Book b$)\{$

int status $=0$;

try $(----------------------------------------------$

PreparedStatement pstmt $=--------------------------------------$;$)$

$\{$

$//$Write down your code here to update the book object in DB$.$

$\}$ catch $($SQLException se$)\{$

se$.$printStackTrace$()$;

$\}$catch $($Exception e$)\{$

e$.$printStackTrace$()$;

$\}$

return status;

$\}$

$\}$