Your first project should demonstrate your knowledge of the following topics: Java SQL JDBC Basic...

Question

Your first project should demonstrate your knowledge of the following topics:

Java

SQL

JDBC

Basic Data Structures

Basic File I/O

You will be building a console application that persists data in a database with at least 3 tables which adhere to 3rd normal form (3NF). The basic form of this project should be that of a console-based banking app.

Minimum Requirements

Basic validation (no negative deposits/withdrawals, malformed emails, names with numbers, etc.)

All exceptions are properly caught and handled

Proper use of OOP principles

Documentation (all classes and methods have basic inline documentation)

Use of custom data structures (do not use java.util Collection types! Implement your own List)

SQL Data Persistance (at least 3 tables; all 3NF (normal form))

Banking App User Stories

These are user stories to describe the banking app. If you are not building the banking app for your project, you will need to discuss with your trainer to establish proper user stories.

Minimum Viable Product

As a user, I can register for an account.

As a user, I can login to my account.

As a user, I can create one or more bank accounts.

As a user, I can deposit funds into my account(s).

As a user, I can withdraw funds from my account(s).

As a user, I can display all of my accounts in a list which includes current balance.

All monetary amounts should be displayed in a proper currency format ($1,234.56).

Tech Stack

You should be employing the following technologies in your project.

Java 8

Apache Maven

MariaDB deployed on AWS RDS

Swapnil · Accepted Answer

91851/bankdb.sql
CREATE TABLE "APP"."EMPLOYEE"
(
   E_ID varchar(255)PRIMARY KEY NOT NULL,
   FIRST_NAME varchar(255),
   LAST_NAME varchar(255),
   PASSWORD varchar(60) NOT NULL
);
CREATE TABLE "APP"."CUSTOMER"
(
   C_ID INTEGER default GENERATED_BY_DEFAULT not null primary key,
   DOB varchar(255),
   FIRST_NAME varchar(255),
   LAST_NAME varchar(255)
 
);
CREATE TABLE "APP"."SAVINGACCOUNT"
(
   CUSTOMERID INT not null,
   ACCNUM varchar(255) not null,
   BALANCE INT
 
);
CREATE INDEX ACCNUM on "APP"."SAVINGACCOUNT"(ACCNUM);
ALTER TABLE "SAVINGACCOUNT"ADD FOREIGN KEY (CUSTOMERID)REFERENCES CUSTOMER(C_ID);
91851/src/bankconsole/applicationContext.xml
 
     
     
     
     
         
         
         
             
                 
            
        
         
             
                 
                 
                     
            
        
    
     
         
    
     
     
         
         
    
91851/src/bankconsole/console/Main.java
91851/src/bankconsole/console/Main.java
package bankconsoleapp.console;
import bankconsoleapp.models.Customer;
import bankconsoleapp.models.Employee;
import bankconsoleapp.services.CustomerService;
import bankconsoleapp.services.EmployeeService;
import bankconsoleapp.services.SavingService;
import java.util.Scanner;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
public class Main 
{
    public static void main(String[] args) 
    {
        ApplicationContext context = new ClassPathXmlApplicationContext("bankconsoleapp/applicationContext.xml");    
        EmployeeService eS = context.getBean("EmployeeService", EmployeeService.class);
        CustomerService cS = context.getBean("CustomerService", CustomerService.class);
        SavingService sS = context.getBean("SavingService", SavingService.class);
        String userName, pass;
        Scanner in = new Scanner(System.in);
        boolean user = false;
        boolean savingRedo = false;
        do 
        {
            System.out.println("Enter Employee ID:");
            userName = in.nextLine();
            for (Employee emp : eS.getAllEmp()) 
            {
                if (userName.equals(emp.geteID())) 
                {
                    System.out.println("Password:");
                    pass = in.nextLine();
                    for (Employee em : eS.getAllEmp()) 
                    {
                        if (pass.equals(em.getPassword())) 
                        {
                            user = true;
                        }
                    }
                }
            }
        } 
        while (!user);
        long start = System.currentTimeMillis();
        long end = start + 60 * 1000; 
        int operation = 0;
        int userChoice;
        boolean quit = false;
        do 
        {
            System.out.println("ACME Bank Saving System:");
            System.out.println("------------------------");
            System.out.println("1. Create Customer & Saving Account");
            System.out.println("2. Deposit Money");
            System.out.println("3. Withdraw Money");
            System.out.println("4. View Balance");
            System.out.println("5. Quit");
            System.out.print("Operation count: " + operation + "(Shut down at 5)");
            userChoice = in.nextInt();
            switch (userChoice) 
            {
                case 1:
                    System.out.println("Create Customer :");
                    String FirstN, LastN, DoB, accNum, answer;
                    Scanner sc = new Scanner(System.in);
                    Customer c = new Customer();
                    int saID = 0;
                    System.out.println("Enter First Name:");
                    FirstN = sc.nextLine();
                    c.setFname(FirstN);
                    System.out.println("Enter Last Name:");
                    LastN = sc.nextLine();
                    c.setLname(LastN);
                    System.out.println("Enter Date of Birth:");
                    DoB = sc.nextLine();
                    c.setDoB(DoB);
                    do 
                    {
                        System.out.println("Creating saving acount, Enter Account Number:");
                        accNum = sc.nextLine();
                        c.setSA(accNum);
                        c.setSavingAccounts(c.getSA());
                        saID++;
                        System.out.println("Create another SA? Y/N?");
                        answer = sc.nextLine();
                        if (answer.equals("n")) 
                        {
                            savingRedo = true;

Your first project should demonstrate your knowledge of the following topics: Java SQL JDBC Basic Data Structures Basic File I/O You will be building a console application that persists data in a...

Answer To: Your first project should demonstrate your knowledge of the following topics: Java SQL JDBC Basic...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment