An ATM simulator application made using Java, swing, and SQL.
// query To create and use the database, ensure the name of the database in MySQL and the project is the same.
Create database bankmanagementsystem; show databases; use bankmanagementsystem;
create table signup(formno varchar(20), name varchar(20), father_name varchar(20), dob varchar(20), gender varchar(20), email varchar(30), marital_satus varchar(20), address varchar(40), city varchar(25), pincode varchar(20), state varchar(25)); select * from signup;
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)); select * from signuptwo;
create table signupthree(formno varchar(20),accountType varchar(40),cardnumber varchar(25), pin varchar(20),facility varchar(100)); create table login(formno varchar(20), cardnumber varchar(20),pin varchar(20)); select * from signupthree; select * from login;
create table bank(pin varchar(10), date varchar(50), type varchar(20), amount varchar(20)); select * from bank;