Assume that you have an Oracle database schema named ecommerce, which is hosted on the $192\mathrm{.}168\mathrm{.}88\mathrm{.}30$ server that uses $1523$ as DB port. The ecommerce DB has several tables, including the authors table. The Oracle Schema DB user is $$ecommerce$,$ whereas the DB password is $$ptuk$.$

Part $1$: Code Complete

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!

$//$All the missing parts should be completed.

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

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

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;

Class.forName$("...............................................................................")$;

try $\{$

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

$\}$catch $(.............................................$ cne$)\{$

cne.printStackTrace$()$;

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

se$.$printStackTrace$()$;

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

e$.$printStackTrace$()$;

$\}$

return myConn;

$\}$

$\}$

Part $2$: Design & Implementation

Given the Java class OracleConnection. Based on the authors table, Author Java class, and the AuthorCRUD Java interface below:

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

Author

$-$ id: long

$-$ title: String

$-$ full$\_$name: String

$-$ double: salary

$-$ int: bcount

$+$getId$()$: long

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

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

public interface AuthorCRUD $\{$

int addAuthor$($Author a$)$;$//$add new author record to the DB$.$

$\}$

$$Your task is to complete the AuthorCRUDOperations Java class below so that you can save an author 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 AuthorCRUDOpertions 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 AuthorCRUDOpertions implements AuthorCRUD

$\{$

public int addAuthor$($Author aut$)\{$

int status $=0$;

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

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

$\{$

$//$Write down your code here to insert Author object to DB$.$

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

se$.$printStackTrace$()$;

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

e$.$printStackTrace$()$;

$\}$

return status;

$\}$

$\}$