Online Banking System jsp,servlet MVC architecture java web application with source code.

 

This is our OOP project we develop web application that is online banking system so I will describe more about our web application. 😍 We mention our project details after the mvc architecture details.

ADS

do you know what is the mvc architecture ?

Model, View, and Controller(mvc) are the three basic logical components that make up an application using the architectural pattern known as framework. MVC is hence an abbreviation. Each element of the architecture is designed to tackle a particular application development task. The business logic layer and presentation layer are separated by MVC. Historically, it was applied to desktop graphical user interfaces (GUIs). MVC architecture in web technology is now widely used to create both web and mobile applications.

View

A view is the area of the program that depicts how data is presented as a example when you go to the website you can see lot of components (login form, register form etc.) that are the view.When you insert something inside the form that go the controller part.

The information gathered from the model data is used to construct views. A view asks the model for information so that it can show the user's output presentation.

The view also displays the data from tables, charts, and diagrams. Any customer view, for instance, will include all the UI elements, such as text fields, drop down menus, etc.

Controller

The area of the application that manages user interaction is known as the Controller. The controller interprets the user's mouse and keyboard inputs, causing the model and view to adjust as necessary.

The model receives commands from a controller to change its state (E.g., Saving a specific document). Additionally, the controller issues directives to its associated view to modify its visual appearance (For example scrolling a particular document).

Model

The model component houses the logic and data for the model. It represents any connected business logic or data that is being moved across controller components. A Controller object, for instance, will get the customer information from the database. It modifies data and either uses it to render the same data or sends it back to the database.

It responds to the views' requests for updates as well as the controller's requests for updates. Additionally, since it is the lowest level of the pattern, it is in charge of maintaining data.

Example:

consider car ,car has panels, the steering wheel, the brake and more these are use to give function to engine so driver can see panels, the steering wheel, the brake but he can not see engine that store inside the car so panels, the steering wheel, the brake so these component are view of the car and that view input handle by the engine so controller is the engine other thing is we need to store (DB) data inside the car we need to store fuel storage(diesel and petrol) is the model of the car.

Okay lets talk about our project details.😇

we use Eclipse enterprise edition and MySQL workbench and apache server  to do this web application .we get few functions 

• admin management (login only)
• user management(login, register, profile delete and update )
• bank account management(add account details, update account, view account details and delete details)
• loan management(add loan details, delete and update loan details and view of the loan details)
• employee management(add employee details, update and delete employee details and view all the employee details)

when login to the admin we can see 3 management that are bank account management, loan management and employee management because that all function should include inside the admin.

admin username = admin , password's = admin@@ 

or

admin username = andrew , password's = andrew@@

our database and table 

you need below software application and  below tool or source to run this application and I will give link also

• Apache Tomcat server
• MySQL workbench
• eclipse enterprise edition
• jar files (need to store bin folder and set the build path with adding jar files)
• java jdk

Apache Tomcat server downloads link :https://tomcat.apache.org/download-90.cgi#9.0.68

MySQL_workbench:https://drive.google.com/drive/folders/1FeoU-fd3yIDqc2xBFTIV7WrtdEqtbJw3?usp=share_link

jdk:https://drive.google.com/file/d/1y6jKtB54AqhRcQnEJYX7MCoh6VsGCJkW/view?usp=share_link

eclipse:https://www.eclipse.org/downloads/packages/release/kepler/sr2/eclipse-ide-java-ee-developers

Jar files:https://drive.google.com/file/d/1Yl3lZmKAQ1eFRNHLr8TvJqfQssf5bD1t/view?usp=share_link

project view 

project downwards link :

https://drive.google.com/file/d/13lvnUxsHm8CQMhnDTlEWZpMR4USq0w4h/view?usp=sharing

below sql all query create db as bank_oop:

-- MySQL dump 10.13 Distrib 8.0.31, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: bank_oop -- ------------------------------------------------------ -- Server version 8.0.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `account_type` -- DROP TABLE IF EXISTS `account_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `account_type` ( `id` int NOT NULL AUTO_INCREMENT, `acc_type` varchar(45) DEFAULT NULL, `prefix` varchar(45) DEFAULT NULL, `mini_balance` varchar(45) DEFAULT NULL, `interest` varchar(45) DEFAULT NULL, `status` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_type` -- LOCK TABLES `account_type` WRITE; /*!40000 ALTER TABLE `account_type` DISABLE KEYS */; INSERT INTO `account_type` VALUES (1,'Saving Account','SA','1000','4','Select status'),(4,'Current Account','C.A','1000','2','Active'); /*!40000 ALTER TABLE `account_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `admin` -- DROP TABLE IF EXISTS `admin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `admin` ( `id` int NOT NULL AUTO_INCREMENT, `username` varchar(45) DEFAULT NULL, `password` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `admin` -- LOCK TABLES `admin` WRITE; /*!40000 ALTER TABLE `admin` DISABLE KEYS */; INSERT INTO `admin` VALUES (1,'admin','admin@@'),(2,'andrew','andrew@@'); /*!40000 ALTER TABLE `admin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customer` -- DROP TABLE IF EXISTS `customer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer` ( `id` int NOT NULL AUTO_INCREMENT, `fname` varchar(45) DEFAULT NULL, `lname` varchar(45) DEFAULT NULL, `birthDate` varchar(45) DEFAULT NULL, `mobile` varchar(45) DEFAULT NULL, `nic` varchar(45) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `username` varchar(45) DEFAULT NULL, `password` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customer` -- LOCK TABLES `customer` WRITE; /*!40000 ALTER TABLE `customer` DISABLE KEYS */; INSERT INTO `customer` VALUES (7,'chathuranga','rasanjalii','2000-11-14','076-5906262','2000031901163v','kavindiedu@gmail.commmmm','chathuranga','1234'),(11,'chathura','rasanjali','2000/11/14','908978666','2000031901163v','chathurangapriyadarshana29@gmail.com','chathura rpcp','chathura12@@'),(15,'Kavindi','Rasanjali','1999-01-01','0778641638','995012855V','kavindiedu@gmail.com','Anjuu','anju5073'); /*!40000 ALTER TABLE `customer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `employee` -- DROP TABLE IF EXISTS `employee`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `employee` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(45) DEFAULT NULL, `branch_of_work` varchar(45) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `mobile` varchar(45) DEFAULT NULL, `employee_type` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `employee` -- LOCK TABLES `employee` WRITE; /*!40000 ALTER TABLE `employee` DISABLE KEYS */; INSERT INTO `employee` VALUES (1,'Chathuranga','Eheliyagoda','chathurangapriyadarshana29@gmail.com','0765906262','Manager'),(2,'kavindi','anuradhapura','kavindiedu@gmail.com','0778641638','manager'),(3,'kavindi','anuradhapura','kavindiedu@gmail.com','071-3443452','manager'),(7,'kavindi','eheliyagoda','kamal@gmail.com','076-45034012','clerk'),(10,'Andrew','colombo','andrew@123gmail.com','071-34421365','clerk'),(17,'chathurnga','eheliyagoda','kavindiedu@gmail.com','0765906262','clerk'); /*!40000 ALTER TABLE `employee` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `loan` -- DROP TABLE IF EXISTS `loan`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `loan` ( `id` int NOT NULL AUTO_INCREMENT, `loanType` varchar(45) DEFAULT NULL, `prefix` varchar(45) DEFAULT NULL, `minAmount` varchar(45) DEFAULT NULL, `maxAmount` varchar(45) DEFAULT NULL, `interest` varchar(45) DEFAULT NULL, `terms` varchar(45) DEFAULT NULL, `status` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `loan` -- LOCK TABLES `loan` WRITE; /*!40000 ALTER TABLE `loan` DISABLE KEYS */; INSERT INTO `loan` VALUES (6,'Business Loan','BL','100','10000','2','10','Active'),(8,'Business loan','BL','25000','200000','3','---','Active'),(10,'new advertisment loan','al','20000','100000','3','---','Active'); /*!40000 ALTER TABLE `loan` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2022-11-08 21:01:15

file structure 

thank you 💓