Execution Steps :
-
Extract the bank.management.system zip file on specific folder.
-
open Apache Netbeans IDE.
-
Open project in Apache Netbeans IDE :
- file
- Open Project.
- Select the project in which drive the project is saved.
- click on open.
-
Add JAR files :
- click on right click on Libraries option it shoes in left panel.
- click on Add Jar/Folder.
- Select where you saved the jar file.
- click on Open.
-
Open mysql workbench and type below queries :
1 - Create database with name bankmanagementsystem in mysql
create database bankmanagementsystem;2 - Select the database you just created
use bankmanagementsystem;3 - Create our first Table in the selected database with name signup
create table signup(formno varchar(20), name varchar(20), father_name varchar(20), dob varchar(20), gender varchar(20),email varchar(30), marital_status varchar(20), address varchar(40), city varchar(25), pincode varchar(20), state varchar(25));4 - Create the second table to store more information of user
create table signuptwo(formno varchar(20), religion varchar(20), category varchar(20), income varchar(20), education varchar(20), occupation varchar(20), pan varchar(20), aadhar varchar(20), seniorcitizen varchar(20), existingaccount varchar(20));5 - Create the third table to store the account information of user
create table signupthree(formno varchar(20), accountType varchar(40), cardnumber varchar(25), pin varchar(10), facility varchar(100));6 - Create the Login table to store login information
create table login(formno varchar(20), cardnumber varchar(25), pin varchar(10));7 - Now create bank table to store transactions related information
create table bank(pin varchar(10), date varchar(50), type varchar(20), amount varchar(20)); -
Run the code.