Hello, I am writing a bank application in java. Need help connecting it to a oracle SQL database using JDBC.

I still need a way to:

-register new users

-sign in existing users

-give them account numbers

-update and save their account transaction history.

Can you please add on to my provided java code and make a orcale sql code then provided the JDBC code to connect it please.

Thank you.

package com.bank; import com.bank.screens.HomeScreen; 4. public class BankDriver { public static void main(String[] args) { HomeScreen homeScreen new HomeScreen (); %3D homeScreen.loginMenu (); System.out.println(); 10 } 11 LO package com.bank.models; import java.util.Objects; public class Account { private double balance; private int accountNumber; private String password; private String username; 10 11 public Account(String username, String password, double balance) { 12 this.balance = balance; 13 this.username = username; 14 this.password = password; 15 this. accountNumber = accountNumber; 16 17 18 public Account () { 19 20 21 22 public String getPassword() { 23 return password; 24 25 26 public String getUsername() { 27 return username; 28 29 30 public double getBalance () { 31 return balance; 32 33 { 34 public void setBalance(double balance) { 35 this.balance = balance; 36 37 38 public int getAccountNumber() { return accountNumber; } 39 40 public String accountSerialize() { 41 + password + " " + accountNumber + " " + balance; 42 return username 43 44 public int hash() { 45 return Objects.hashCode(username); 46 } 47 48 49 } 50 package com.bank.screens; import com.bank.models.Account; import java.util.Scanner; 6. public class HomeScreen { TransactionScreen ts = new TransactionScreen(); 8. - 0; int option 9. boolean success = false; 10 double balance = 0; 11 Scanner scanner = new Scanner (System.in); 12 public void loginMenu(){ 13 System.out.println(": -"): 14 System.out.println("Bank."); 15 System.out.println("1: Make an account"); 16 System.out.printin("2: Sign in"); 17 System.out.println("3: Exit"); 18 System.out.println("-- -"); 19 20 21 do { 22 23 System.out.println("Enter an option"); 24 25 try { option = Integer.parseInt(scanner.nextline ()); 26 %3D 27 28 catch(Exception e){ 29 System.out.println("Please select a number: "); 30 System.exit(0); 31 32 ************"): System.out.println("******* 33 ** 34 switch (option) { 35 36 case 1: makingNewAccount(); 37 38 39 break; 40 case 2: 41 signIn(); 42 43 break; 44 case 3: System.out.println("Thank you for using Bank."); 45 46 47 System.exit(0); 48 break; 49 default: System.out.println("Invalid entry, please try again"); 50 51 52 while (false); 53 System.out.println("Invalid username or password."); 54 55 } 56 57 private void makingNewAccount(){ 58 String userName, password, accountNumber; 59 double initialDeposit = 0; 60 System.out.println("Enter a username: "); 61 userName = scanner.nextLine (); 62 System.out. println("Enter a password: "); 63 64 password = scanner.nextLine (); boolean valid = false; 65 while (!valid) { 66 System.out.println("Please enter an initial deposit: "); 67 68 try { String dummy = scanner.next(); 69 balance = Double.parseDouble(dummy); 70 } catch (Exception e) { 71 System.out.println("Please enter a number: "); 72 73 74 if (balance acctBase = new Hashtable(); 11 String token = ""; 12 13 14 double balance = 0; 15 Scanner scanner = new Scanner (System.in); 16 17 public void transactionMenu() { 18 19 20 21 System.out.println(" "); 22 System.out.println("1: Make a deposit"); 23 System.out.println("2: Make a withdraw"); 24 System.out.println("3: View balance"); 25 System.out.println("4: Exit"); 26 System.out.println("--- "); 27 28 29 do { 30 31 System.out.printn("Enter an option"); 32 33 try { String dummy = scanner.next(); 34 option = Integer.parseInt(dummy); 35 36 catch (Exception e){ 37 System.out.println("Please select a number: "); 38 39 System.out.println("*** ******c**********************"* 40 41 switch (option) { 42 43 case 1: deposit(); 44 45 break; 46 case 2: 47 withdraw(); 48 break; 49 50 case 3: viewBalance(); 51 52 break; 53 case 4: System.out.println("Thank you for using Bank."); 54 55 56 System.exit(0); 57 58 default: System.out.println("Invalid entry, please try again"); 59 60 61 while (option != 4) ; 62 63 64 65 private void viewBalance() { 66 67 System.out.println("Your current balance is $ "+ balance); 68 transactionMenu(); 69 70 71 private void withdraw() { 72 73 boolean valid - false; 74 double withdraw = 0; 75 System.out.println("Please enter withdraw amount: "); 76 while (!valid) { 77 78 try { String dummy = scanner.next(); 79 78 try { String dummy = scanner.next(); 79 withdraw = Double.parseDouble (dummy); 80 } catch (Exception e) { 81 System.out.println("Please enter a number: "); 82 83 if (withdraw 0) { 111 balance = deposit + balance; 112 acctBase.get(token).setBalance (balance); 113 valid = true; 114 } else { 115 116 System.out.println("Please deposit amount greater than zero."); 117 118 transactionMenu(); 119 120 121 122 123 } transactionMenu(); 124 125 126