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 CompleteThe 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 & ImplementationGiven 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 herepublic 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;$\}\}$