bank management system in java and mysql report1.pdf
4,227 views
33 slides
Jun 04, 2024
Slide 1 of 33
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
About This Presentation
truth is high but higher still is truth full living
Slide Content
1
SIX MONTH INDUSTRIAL TRAINING REPORT
“BANK MANAGEMENT SYSTEM”
Relational Database Management System
SUBMITTED IN PARTIAL FULFILLMENT FOR AWARD OF DEGREE OF
BACHELOR OF TECHNOGY
IN
COMPUTER SCIENCE ENGINEERING
BY
DIVYAM
2001591
DEPARTMENT OF COMPUTER SCIENCE ENGINEERING
SARDAR BEANT SINGH STATE UNIVERSITY GURDASPUR
JUNE 2024
SIX MONTH INDUSTRIAL TRAINING REPORT
“BANK MANAGEMENT SYSTEM”
Relational Database Management System
SUBMITTED IN PARTIAL FULFILLMENT FOR AWARD OF DEGREE OF
BACHELOR OF TECHNOGY
IN
COMPUTER SCIENCE ENGINEERING
BY
DIVYAM
2001591
DEPARTMENT OF COMPUTER SCIENCE ENGINEERING
SARDAR BEANT SINGH STATE UNIVERSITY GURDASPUR
JUNE 2024
2
3
Abstract
The Bank Account Management System is an application for maintaining a person's account in a bank. In
this project I tried to show the working of a banking account system and cover the basic functionality of a
Bank Account Management System. To develop a project for solving financial applications of a customer in
banking environment in order to nurture the needs of an end banking user by providing various ways to
perform banking tasks. Also, to enable the user’s work space to have additional functionalities which are not
provided under a conventional banking project.
The Bank Account Management System undertaken as a project is based on relevant technologies. The main
aim of this project is to develop software for Bank Account Management System. This project has been
developed to carry out the processes easily and quickly, which is not possible with the manuals systems,
which are overcome by this software. This project is developed using Java language. Creating and managing
requirements is a challenge of IT, systems and product development projects or indeed for any activity where
you have to manage a contractual relationship. Organization needs to effectively define and manage
requirements to ensure they are meeting needs of the customer, while proving compliance and staying on the
schedule and within budget.
The impact of a poorly expressed requirement can bring a business out of compliance or even cause injury or
death. Requirements definition and management is an activity that can deliver a high, fast return on
investment. The project analyzes the system requirements and then comes up with the requirements
specifications. It studies other related systems and then come up with system specifications. The system is
then designed in accordance with specifications to satisfy the requirements. The system design is then
implemented with Java. The system is designed as an interactive and content management system. The
content management system deals with data entry, validation confirm and updating whiles the interactive
system deals with system interaction with the administration and users. Thus, above features of this project
will save transaction time and therefore increase the efficiency of the system
Abstract
The Bank Account Management System is an application for maintaining a person's account in a bank. In
this project I tried to show the working of a banking account system and cover the basic functionality of a
Bank Account Management System. To develop a project for solving financial applications of a customer in
banking environment in order to nurture the needs of an end banking user by providing various ways to
perform banking tasks. Also, to enable the user’s work space to have additional functionalities which are not
provided under a conventional banking project.
The Bank Account Management System undertaken as a project is based on relevant technologies. The main
aim of this project is to develop software for Bank Account Management System. This project has been
developed to carry out the processes easily and quickly, which is not possible with the manuals systems,
which are overcome by this software. This project is developed using Java language. Creating and managing
requirements is a challenge of IT, systems and product development projects or indeed for any activity where
you have to manage a contractual relationship. Organization needs to effectively define and manage
requirements to ensure they are meeting needs of the customer, while proving compliance and staying on the
schedule and within budget.
The impact of a poorly expressed requirement can bring a business out of compliance or even cause injury or
death. Requirements definition and management is an activity that can deliver a high, fast return on
investment. The project analyzes the system requirements and then comes up with the requirements
specifications. It studies other related systems and then come up with system specifications. The system is
then designed in accordance with specifications to satisfy the requirements. The system design is then
implemented with Java. The system is designed as an interactive and content management system. The
content management system deals with data entry, validation confirm and updating whiles the interactive
system deals with system interaction with the administration and users. Thus, above features of this project
will save transaction time and therefore increase the efficiency of the system
4
ACKNOWLEDGEMENT
It is a great privilege for us to express our profound gratitude to our respected teacher Mr.. Lalit
Kashyap, Assistant Professor, Department of Computer Science Engineering, Sardar Beant
Singh State University Gurdaspur, for him consent, guidance, valuable suggestions,
supervision and inspiration throughout the course work without which it would have been
difficult to complete the work within scheduled time.
We are also indebted to the Head of the Department, Computer Science Engineering, Sardar
Beant Singh State University Gurdaspur, for permitting us to pursue the project. We would like
to take this opportunity to thank all the respected teachers of this department for being perennial
source of inspiration and showing the right path at the time of necessity.
ACKNOWLEDGEMENT
It is a great privilege for us to express our profound gratitude to our respected teacher Mr.. Lalit
Kashyap, Assistant Professor, Department of Computer Science Engineering, Sardar Beant
Singh State University Gurdaspur, for him consent, guidance, valuable suggestions,
supervision and inspiration throughout the course work without which it would have been
difficult to complete the work within scheduled time.
We are also indebted to the Head of the Department, Computer Science Engineering, Sardar
Beant Singh State University Gurdaspur, for permitting us to pursue the project. We would like
to take this opportunity to thank all the respected teachers of this department for being perennial
source of inspiration and showing the right path at the time of necessity.
5
TABLE OF CONTENTS
CHAPTER NO TITLE PAGE NO
ABSTRACT 3
ACKNOWLEDGEMENT 4
1. INTRODUCTION
1.1 Introduction 6
1.2 Project Overview 7
1.3 Aim of this project &Main purpose 8-9
2. TECHNOLOGIES USED
2.1 JAVA &Source code 10-19
2.2 MYSQL 20-21
3. LITERATURE SURVEY
3.1 Introduction to Java 22
3.2 Administrative module 23-24
3.3 Benefits of online banking 25-26
4. SCREENSHOTS OF PROJECT 27-29
5. DATABASE 30-31
6. CONCLUSION 32
7. BIBILOGRAPHY 33
TABLE OF CONTENTS
CHAPTER NO TITLE PAGE NO
ABSTRACT 3
ACKNOWLEDGEMENT 4
1. INTRODUCTION
1.1 Introduction 6
1.2 Project Overview 7
1.3 Aim of this project &Main purpose 8-9
2. TECHNOLOGIES USED
2.1 JAVA &Source code 10-19
2.2 MYSQL 20-21
3. LITERATURE SURVEY
3.1 Introduction to Java 22
3.2 Administrative module 23-24
3.3 Benefits of online banking 25-26
4. SCREENSHOTS OF PROJECT 27-29
5. DATABASE 30-31
6. CONCLUSION 32
7. BIBILOGRAPHY 33
6
CHAPTER – 1
INTRODUCTION
1.1 Introduction
The “Bank Account Management System” project is a model Internet Banking Site. This site enables the
customers to perform the basic banking transactions by sitting at their office or at homes through PC or
laptop. The system provides the access to the customer to create an account, deposit/withdraw the cash from
his account, also to view reports of all accounts present. The customers can access the banks website for
viewing their Account details and perform the transactions on account as per their requirements. With
Internet Banking, the brick-and-mortar structure of the traditional banking gets converted into a click and
portal model, thereby giving a concept of virtual banking a real shape. Thus, today's banking is no longer
confined to branches. E-banking facilitates banking transactions by customers round the clock globally.
The primary aim of this “Bank Account Management System” is to provide an improved design
methodology, which envisages the future expansion, and modification, which is necessary for a core sector
like banking. This necessitates the design to be expandable and modifiable and so a modular approach is
used in developing the application software.
Anybody who is an Account holder in this bank can become a member of Bank Account
Management System. He has to fill a form with his personal details and Account Number.
Bank is the place where customers feel the sense of safety for their property. In the bank, customers deposit
and withdraw their money. Transaction of money also is a part where customer takes shelter of the bank.
Now to keep the belief and trust of customers, there is the positive need for management of the bank, which
can handle all this with comfort and ease.
Smooth and efficient management affects the satisfaction of the customers and staff members, indirectly.
And of course, it encourages management committee in taking some needed decision for future enhancement
of the bank.
Now a day’s, managing a bank is tedious job up to certain limit. So software that reduces the work is
essential. Also, today’s world is a genuine computer world and is getting faster and faster day-by-day. Thus,
considering above necessities, the software for bank management has become necessary which would be
useful in managing the bank more efficiently.
All transactions are carried out online by transferring from accounts in the same Bank or international bank.
The software is meant to overcome the drawbacks of the manual system.
CHAPTER – 1
INTRODUCTION
1.1 Introduction
The “Bank Account Management System” project is a model Internet Banking Site. This site enables the
customers to perform the basic banking transactions by sitting at their office or at homes through PC or
laptop. The system provides the access to the customer to create an account, deposit/withdraw the cash from
his account, also to view reports of all accounts present. The customers can access the banks website for
viewing their Account details and perform the transactions on account as per their requirements. With
Internet Banking, the brick-and-mortar structure of the traditional banking gets converted into a click and
portal model, thereby giving a concept of virtual banking a real shape. Thus, today's banking is no longer
confined to branches. E-banking facilitates banking transactions by customers round the clock globally.
The primary aim of this “Bank Account Management System” is to provide an improved design
methodology, which envisages the future expansion, and modification, which is necessary for a core sector
like banking. This necessitates the design to be expandable and modifiable and so a modular approach is
used in developing the application software.
Anybody who is an Account holder in this bank can become a member of Bank Account
Management System. He has to fill a form with his personal details and Account Number.
Bank is the place where customers feel the sense of safety for their property. In the bank, customers deposit
and withdraw their money. Transaction of money also is a part where customer takes shelter of the bank.
Now to keep the belief and trust of customers, there is the positive need for management of the bank, which
can handle all this with comfort and ease.
Smooth and efficient management affects the satisfaction of the customers and staff members, indirectly.
And of course, it encourages management committee in taking some needed decision for future enhancement
of the bank.
Now a day’s, managing a bank is tedious job up to certain limit. So software that reduces the work is
essential. Also, today’s world is a genuine computer world and is getting faster and faster day-by-day. Thus,
considering above necessities, the software for bank management has become necessary which would be
useful in managing the bank more efficiently.
All transactions are carried out online by transferring from accounts in the same Bank or international bank.
The software is meant to overcome the drawbacks of the manual system.
7
1.2 Project Overview:
Our Bank Management System will serve as a centralized platform for managing various banking operations,
including account management, transaction processing, loan management, customer relationship
management, and reporting. The system will be user-friendly, secure, and scalable to accommodate the
evolving needs of the bank and its customers.
Key Features:
➢ Account Management: Enable bank staff to create, update, and manage customer accounts,
including savings, checking, and investment accounts.
➢ Transaction Processing: Facilitate seamless processing of transactions such as deposits,
withdrawals, fund transfers, and bill payments while ensuring accuracy and security.
➢ Loan Management: Provide functionalities for loan origination, processing, and management,
including application processing, credit evaluation, and loan servicing.
➢ Customer Relationship Management (CRM): Maintain comprehensive customer profiles,
communication history, and interactions to personalize services and enhance customer satisfaction.
➢ Reporting and Analytics: Generate insightful reports and analytics to provide bank management
with valuable insights into performance, financial health, customer behavior, and market trends.
1.2 Project Overview:
Our Bank Management System will serve as a centralized platform for managing various banking operations,
including account management, transaction processing, loan management, customer relationship
management, and reporting. The system will be user-friendly, secure, and scalable to accommodate the
evolving needs of the bank and its customers.
Key Features:
➢ Account Management: Enable bank staff to create, update, and manage customer accounts,
including savings, checking, and investment accounts.
➢ Transaction Processing: Facilitate seamless processing of transactions such as deposits,
withdrawals, fund transfers, and bill payments while ensuring accuracy and security.
➢ Loan Management: Provide functionalities for loan origination, processing, and management,
including application processing, credit evaluation, and loan servicing.
➢ Customer Relationship Management (CRM): Maintain comprehensive customer profiles,
communication history, and interactions to personalize services and enhance customer satisfaction.
➢ Reporting and Analytics: Generate insightful reports and analytics to provide bank management
with valuable insights into performance, financial health, customer behavior, and market trends.
8
AIM of this project &Main Purpose
1.3 AIM of this project
The main aim of designing and developing this Internet banking System Java primarily based
Engineering project is to provide secure and efficient net banking facilities to the banking customers over the
internet. Apache Server Pages, MYSQL database used to develop this bank application where all banking
customers can login through the secured web page by their account login id and password. Users will have
all options and features in that application like get money from western union, money transfer to others, and
send cash or money to inter banking as well as other banking customers by simply adding them as payees.
Main Purpose
The Traditional way of maintaining details of a user in a bank was to enter the details and record them. Every
time the user needs to perform some transactions he has to go to bank and perform the necessary actions,
which may not be so feasible all the time. It may be a hard-hitting task for the users and the bankers too. The
project gives real life understanding of Online Banking System and activities performed by various roles in
the supply chain. Here, we provide automation for banking system through Internet. Online Banking System
project captures activities performed by different roles in real life banking which provides enhanced
techniques for maintaining the required information up-to-date, which results in efficiency. The project gives
real life understanding of Online Banking System and activities performed by various roles in the supply
chain
AIM of this project &Main Purpose
1.3 AIM of this project
The main aim of designing and developing this Internet banking System Java primarily based
Engineering project is to provide secure and efficient net banking facilities to the banking customers over the
internet. Apache Server Pages, MYSQL database used to develop this bank application where all banking
customers can login through the secured web page by their account login id and password. Users will have
all options and features in that application like get money from western union, money transfer to others, and
send cash or money to inter banking as well as other banking customers by simply adding them as payees.
Main Purpose
The Traditional way of maintaining details of a user in a bank was to enter the details and record them. Every
time the user needs to perform some transactions he has to go to bank and perform the necessary actions,
which may not be so feasible all the time. It may be a hard-hitting task for the users and the bankers too. The
project gives real life understanding of Online Banking System and activities performed by various roles in
the supply chain. Here, we provide automation for banking system through Internet. Online Banking System
project captures activities performed by different roles in real life banking which provides enhanced
techniques for maintaining the required information up-to-date, which results in efficiency. The project gives
real life understanding of Online Banking System and activities performed by various roles in the supply
chain
9
Main Goal
1. Motto- Our motto is to develop a software program for managing the entire bank process related to
Administration accounts customer accounts and to keep each every track about their property and their
various transaction processes efficiently.
Hereby, our main objective is the customer’s satisfaction considering today’s faster in the world.
2. Customer Satisfaction: Client can do his operations comfortably without any risk or losing of his privacy.
Our software will perform and fulfill all the tasks that any customer would desire.
3. Saving Customer Time: Client doesn't need to go to the bank to do small operation.
4. Protecting the Customer: It helps the customer to be satisfied and comfortable in his choices, this
protection contains customer’s account, money and his privacy.
5. Transferring Money: Help client transferring money to/or another bank or country.
Methods
• We need to be able to generate an account number
• Account types: Savings or Current Account
• Maintain/update Balance
• Open/Close Account
• Withdraw/Deposit
Main Goal
1. Motto- Our motto is to develop a software program for managing the entire bank process related to
Administration accounts customer accounts and to keep each every track about their property and their
various transaction processes efficiently.
Hereby, our main objective is the customer’s satisfaction considering today’s faster in the world.
2. Customer Satisfaction: Client can do his operations comfortably without any risk or losing of his privacy.
Our software will perform and fulfill all the tasks that any customer would desire.
3. Saving Customer Time: Client doesn't need to go to the bank to do small operation.
4. Protecting the Customer: It helps the customer to be satisfied and comfortable in his choices, this
protection contains customer’s account, money and his privacy.
5. Transferring Money: Help client transferring money to/or another bank or country.
Methods
• We need to be able to generate an account number
• Account types: Savings or Current Account
• Maintain/update Balance
• Open/Close Account
• Withdraw/Deposit
10
CHAPTER 2
Technologies Used:
2.1 JAVA
Java is a high-level, object-oriented programming language developed by Sun Microsystems (now owned by
Oracle). It was designed to be platform-independent, meaning that Java programs can run on any device or
operating system with a Java Virtual Machine (JVM). Java is widely used for building desktop, web, and
mobile applications, as well as enterprise systems and large-scale distributed systems.
Key features of Java include its simplicity, readability, and scalability. Java programs are organized into
classes and objects, making it easy to manage complex codebases and promote code reuse. The language
supports multithreading, allowing programs to perform multiple tasks simultaneously, which is crucial for
developing responsive and efficient applications.
Java's syntax is similar to that of C++, making it relatively easy for developers to learn if they are familiar
with other programming languages. Additionally, Java provides automatic memory management through
garbage collection, which helps prevent memory leaks and simplifies memory management for developers.
One of Java's most significant advantages is its extensive standard library, which provides pre-built classes
and functions for common tasks such as networking, database access, and user interface development. This
rich ecosystem of libraries and frameworks accelerates the development process and reduces the need to
reinvent the wheel.
Java is also known for its strong emphasis on security. The language includes features such as bytecode
verification and runtime sandboxing to prevent unauthorized access and protect against malicious code
execution.
In summary, Java is a versatile, platform-independent programming language with a strong emphasis on
simplicity, scalability, and security. Its broad adoption and extensive ecosystem make it an excellent choice
for a wide range of applications, from small-scale projects to enterprise-level systems.
CHAPTER 2
Technologies Used:
2.1 JAVA
Java is a high-level, object-oriented programming language developed by Sun Microsystems (now owned by
Oracle). It was designed to be platform-independent, meaning that Java programs can run on any device or
operating system with a Java Virtual Machine (JVM). Java is widely used for building desktop, web, and
mobile applications, as well as enterprise systems and large-scale distributed systems.
Key features of Java include its simplicity, readability, and scalability. Java programs are organized into
classes and objects, making it easy to manage complex codebases and promote code reuse. The language
supports multithreading, allowing programs to perform multiple tasks simultaneously, which is crucial for
developing responsive and efficient applications.
Java's syntax is similar to that of C++, making it relatively easy for developers to learn if they are familiar
with other programming languages. Additionally, Java provides automatic memory management through
garbage collection, which helps prevent memory leaks and simplifies memory management for developers.
One of Java's most significant advantages is its extensive standard library, which provides pre-built classes
and functions for common tasks such as networking, database access, and user interface development. This
rich ecosystem of libraries and frameworks accelerates the development process and reduces the need to
reinvent the wheel.
Java is also known for its strong emphasis on security. The language includes features such as bytecode
verification and runtime sandboxing to prevent unauthorized access and protect against malicious code
execution.
In summary, Java is a versatile, platform-independent programming language with a strong emphasis on
simplicity, scalability, and security. Its broad adoption and extensive ecosystem make it an excellent choice
for a wide range of applications, from small-scale projects to enterprise-level systems.
11
Certainly! Java has evolved over the years since its inception in the mid-1990s, and its growth has been
influenced by various factors, including community contributions, industry demands, and technological
advancements. Here are some additional aspects to consider:
1. Platform Independence: Java's "Write Once, Run Anywhere" (WORA) principle is a cornerstone of
its design philosophy. Java source code is compiled into bytecode, which can run on any device or
platform that has a compatible Java Virtual Machine (JVM). This platform independence has made
Java a popular choice for developing cross-platform applications.
2. Strong Community and Ecosystem: Java has a vibrant and active community of developers
worldwide. This community contributes to the ongoing development of the language, creates
libraries, frameworks, and tools, and provides support and resources for fellow developers. The Java
ecosystem includes popular frameworks like Spring, Hibernate, and Apache Struts, which simplify
various aspects of application development.
3. Enterprise Adoption: Java is widely used in enterprise environments for building robust, scalable,
and secure applications. Its stability, performance, and extensive tooling support make it well-suited
for developing mission-critical systems such as banking software, e-commerce platforms, and large-
scale enterprise applications.
4. Continuous Evolution: Java continues to evolve with regular updates and new releases. The Java
Community Process (JCP) governs the evolution of the Java language and platform, ensuring that
changes are driven by community consensus and industry needs. Recent releases have introduced
features like modularization (Java 9), local-variable type inference (Java 10), and records (Java 14),
which enhance developer productivity and code readability.
5. Adaptability to Modern Trends: Java remains relevant in the ever-changing landscape of
technology. It has adapted to embrace modern paradigms and trends, such as cloud computing,
microservices architecture, and containerization. Frameworks like Spring Boot facilitate the
development of cloud-native applications, while tools like Docker and Kubernetes enable the
deployment and management of Java applications in containerized environments.
6. Education and Learning: Java is often used as an introductory programming language in computer
science education due to its simplicity, readability, and widespread adoption. Many universities and
educational institutions offer courses and resources for learning Java, making it accessible to students
and aspiring developers.
Overall, Java's versatility, stability, and extensive ecosystem make it a robust choice for a wide range of
applications, from small-scale projects to enterprise-level systems, and its continued evolution ensures its
relevance in the ever-changing landscape of software development.
Certainly! Java has evolved over the years since its inception in the mid-1990s, and its growth has been
influenced by various factors, including community contributions, industry demands, and technological
advancements. Here are some additional aspects to consider:
1. Platform Independence: Java's "Write Once, Run Anywhere" (WORA) principle is a cornerstone of
its design philosophy. Java source code is compiled into bytecode, which can run on any device or
platform that has a compatible Java Virtual Machine (JVM). This platform independence has made
Java a popular choice for developing cross-platform applications.
2. Strong Community and Ecosystem: Java has a vibrant and active community of developers
worldwide. This community contributes to the ongoing development of the language, creates
libraries, frameworks, and tools, and provides support and resources for fellow developers. The Java
ecosystem includes popular frameworks like Spring, Hibernate, and Apache Struts, which simplify
various aspects of application development.
3. Enterprise Adoption: Java is widely used in enterprise environments for building robust, scalable,
and secure applications. Its stability, performance, and extensive tooling support make it well-suited
for developing mission-critical systems such as banking software, e-commerce platforms, and large-
scale enterprise applications.
4. Continuous Evolution: Java continues to evolve with regular updates and new releases. The Java
Community Process (JCP) governs the evolution of the Java language and platform, ensuring that
changes are driven by community consensus and industry needs. Recent releases have introduced
features like modularization (Java 9), local-variable type inference (Java 10), and records (Java 14),
which enhance developer productivity and code readability.
5. Adaptability to Modern Trends: Java remains relevant in the ever-changing landscape of
technology. It has adapted to embrace modern paradigms and trends, such as cloud computing,
microservices architecture, and containerization. Frameworks like Spring Boot facilitate the
development of cloud-native applications, while tools like Docker and Kubernetes enable the
deployment and management of Java applications in containerized environments.
6. Education and Learning: Java is often used as an introductory programming language in computer
science education due to its simplicity, readability, and widespread adoption. Many universities and
educational institutions offer courses and resources for learning Java, making it accessible to students
and aspiring developers.
Overall, Java's versatility, stability, and extensive ecosystem make it a robust choice for a wide range of
applications, from small-scale projects to enterprise-level systems, and its continued evolution ensures its
relevance in the ever-changing landscape of software development.
12
Source Code
Deposit.java
package ASimulatorSystem;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
public class Deposit extends JFrame implements ActionListener{
JTextField t1,t2;
JButton b1,b2,b3;
JLabel l1,l2,l3;
String pin;
Deposit(String pin){
this.pin = pin;
ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("ASimulatorSystem/icons/atm.jpg"));
Image i2 = i1.getImage().getScaledInstance(1000, 1180, Image.SCALE_DEFAULT);
ImageIcon i3 = new ImageIcon(i2);
JLabel l3 = new JLabel(i3);
l3.setBounds(0, 0, 960, 1080);
add(l3);
l1 = new JLabel("ENTER AMOUNT YOU WANT TO DEPOSIT");
l1.setForeground(Color.WHITE);
l1.setFont(new Font("System", Font.BOLD, 16));
t1 = new JTextField();
t1.setFont(new Font("Raleway", Font.BOLD, 22));
b1 = new JButton("DEPOSIT");
b2 = new JButton("BACK");
setLayout(null);
l1.setBounds(190,350,400,35);
l3.add(l1);
t1.setBounds(190,420,320,25);
l3.add(t1);
b1.setBounds(390,588,150,35);
l3.add(b1);
b2.setBounds(390,633,150,35);
l3.add(b2);
Source Code
Deposit.java
package ASimulatorSystem;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
public class Deposit extends JFrame implements ActionListener{
JTextField t1,t2;
JButton b1,b2,b3;
JLabel l1,l2,l3;
String pin;
Deposit(String pin){
this.pin = pin;
ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("ASimulatorSystem/icons/atm.jpg"));
Image i2 = i1.getImage().getScaledInstance(1000, 1180, Image.SCALE_DEFAULT);
ImageIcon i3 = new ImageIcon(i2);
JLabel l3 = new JLabel(i3);
l3.setBounds(0, 0, 960, 1080);
add(l3);
l1 = new JLabel("ENTER AMOUNT YOU WANT TO DEPOSIT");
l1.setForeground(Color.WHITE);
l1.setFont(new Font("System", Font.BOLD, 16));
t1 = new JTextField();
t1.setFont(new Font("Raleway", Font.BOLD, 22));
b1 = new JButton("DEPOSIT");
b2 = new JButton("BACK");
setLayout(null);
l1.setBounds(190,350,400,35);
l3.add(l1);
t1.setBounds(190,420,320,25);
l3.add(t1);
b1.setBounds(390,588,150,35);
l3.add(b1);
b2.setBounds(390,633,150,35);
l3.add(b2);
13
b1.addActionListener(this);
b2.addActionListener(this);
setSize(960,1080);
setUndecorated(true);
setLocation(500,0);
setVisible(true);
}
public void actionPerformed(ActionEvent ae){
try{
String amount = t1.getText();
Date date = new Date();
if(ae.getSource()==b1){
if(t1.getText().equals("")){
JOptionPane.showMessageDialog(null, "Please enter the Amount to you want to Deposit");
}else{
Conn c1 = new Conn();
c1.s.executeUpdate("insert into bank values('"+pin+"', '"+date+"', 'Deposit', '"+amount+"')");
JOptionPane.showMessageDialog(null, "Rs. "+amount+" Deposited Successfully");
setVisible(false);
new Transactions(pin).setVisible(true);
}
}else if(ae.getSource()==b2){
setVisible(false);
new Transactions(pin).setVisible(true);
}
}catch(Exception e){
e.printStackTrace();
}
}
public static void main(String[] args){
new Deposit("").setVisible(true);
}
}
Signup.java
package ASimulatorSystem;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import com.toedter.calendar.JDateChooser;
b1.addActionListener(this);
b2.addActionListener(this);
setSize(960,1080);
setUndecorated(true);
setLocation(500,0);
setVisible(true);
}
public void actionPerformed(ActionEvent ae){
try{
String amount = t1.getText();
Date date = new Date();
if(ae.getSource()==b1){
if(t1.getText().equals("")){
JOptionPane.showMessageDialog(null, "Please enter the Amount to you want to Deposit");
}else{
Conn c1 = new Conn();
c1.s.executeUpdate("insert into bank values('"+pin+"', '"+date+"', 'Deposit', '"+amount+"')");
JOptionPane.showMessageDialog(null, "Rs. "+amount+" Deposited Successfully");
setVisible(false);
new Transactions(pin).setVisible(true);
}
}else if(ae.getSource()==b2){
setVisible(false);
new Transactions(pin).setVisible(true);
}
}catch(Exception e){
e.printStackTrace();
}
}
public static void main(String[] args){
new Deposit("").setVisible(true);
}
}
Signup.java
package ASimulatorSystem;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import com.toedter.calendar.JDateChooser;
14
import java.util.*;
public class Signup extends JFrame implements ActionListener{
JLabel l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12,l13,l14,l15;
JTextField t1,t2,t3,t4,t5,t6,t7;
JRadioButton r1,r2,r3,r4,r5;
JButton b;
JDateChooser dateChooser;
Random ran = new Random();
long first4 = (ran.nextLong() % 9000L) + 1000L;
String first = "" + Math.abs(first4);
Signup(){
setTitle("NEW ACCOUNT APPLICATION FORM");
ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("ASimulatorSystem/icons/logo.jpg"));
Image i2 = i1.getImage().getScaledInstance(100, 100, Image.SCALE_DEFAULT);
ImageIcon i3 = new ImageIcon(i2);
JLabel l11 = new JLabel(i3);
l11.setBounds(20, 0, 100, 100);
add(l11);
l1 = new JLabel("APPLICATION FORM NO. "+first);
l1.setFont(new Font("Raleway", Font.BOLD, 38));
l2 = new JLabel("Page 1: Personal Details");
l2.setFont(new Font("Raleway", Font.BOLD, 22));
l3 = new JLabel("Name:");
l3.setFont(new Font("Raleway", Font.BOLD, 20));
l4 = new JLabel("Father's Name:");
l4.setFont(new Font("Raleway", Font.BOLD, 20));
l5 = new JLabel("Date of Birth:");
l5.setFont(new Font("Raleway", Font.BOLD, 20));
l6 = new JLabel("Gender:");
l6.setFont(new Font("Raleway", Font.BOLD, 20));
l7 = new JLabel("Email Address:");
l7.setFont(new Font("Raleway", Font.BOLD, 20));
l8 = new JLabel("Marital Status:");
l8.setFont(new Font("Raleway", Font.BOLD, 20));
import java.util.*;
public class Signup extends JFrame implements ActionListener{
JLabel l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12,l13,l14,l15;
JTextField t1,t2,t3,t4,t5,t6,t7;
JRadioButton r1,r2,r3,r4,r5;
JButton b;
JDateChooser dateChooser;
Random ran = new Random();
long first4 = (ran.nextLong() % 9000L) + 1000L;
String first = "" + Math.abs(first4);
Signup(){
setTitle("NEW ACCOUNT APPLICATION FORM");
ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("ASimulatorSystem/icons/logo.jpg"));
Image i2 = i1.getImage().getScaledInstance(100, 100, Image.SCALE_DEFAULT);
ImageIcon i3 = new ImageIcon(i2);
JLabel l11 = new JLabel(i3);
l11.setBounds(20, 0, 100, 100);
add(l11);
l1 = new JLabel("APPLICATION FORM NO. "+first);
l1.setFont(new Font("Raleway", Font.BOLD, 38));
l2 = new JLabel("Page 1: Personal Details");
l2.setFont(new Font("Raleway", Font.BOLD, 22));
l3 = new JLabel("Name:");
l3.setFont(new Font("Raleway", Font.BOLD, 20));
l4 = new JLabel("Father's Name:");
l4.setFont(new Font("Raleway", Font.BOLD, 20));
l5 = new JLabel("Date of Birth:");
l5.setFont(new Font("Raleway", Font.BOLD, 20));
l6 = new JLabel("Gender:");
l6.setFont(new Font("Raleway", Font.BOLD, 20));
l7 = new JLabel("Email Address:");
l7.setFont(new Font("Raleway", Font.BOLD, 20));
l8 = new JLabel("Marital Status:");
l8.setFont(new Font("Raleway", Font.BOLD, 20));
15
l9 = new JLabel("Address:");
l9.setFont(new Font("Raleway", Font.BOLD, 20));
l10 = new JLabel("City:");
l10.setFont(new Font("Raleway", Font.BOLD, 20));
l11 = new JLabel("Pin Code:");
l11.setFont(new Font("Raleway", Font.BOLD, 20));
l12 = new JLabel("State:");
l12.setFont(new Font("Raleway", Font.BOLD, 20));
l13 = new JLabel("Date");
l13.setFont(new Font("Raleway", Font.BOLD, 14));
l14 = new JLabel("Month");
l14.setFont(new Font("Raleway", Font.BOLD, 14));
l15 = new JLabel("Year");
l15.setFont(new Font("Raleway", Font.BOLD, 14));
t1 = new JTextField();
t1.setFont(new Font("Raleway", Font.BOLD, 14));
t2 = new JTextField();
t2.setFont(new Font("Raleway", Font.BOLD, 14));
t3 = new JTextField();
t3.setFont(new Font("Raleway", Font.BOLD, 14));
t4 = new JTextField();
t4.setFont(new Font("Raleway", Font.BOLD, 14));
t5 = new JTextField();
t5.setFont(new Font("Raleway", Font.BOLD, 14));
t6 = new JTextField();
t6.setFont(new Font("Raleway", Font.BOLD, 14));
t7 = new JTextField();
t7.setFont(new Font("Raleway", Font.BOLD, 14));
b = new JButton("Next");
b.setFont(new Font("Raleway", Font.BOLD, 14));
b.setBackground(Color.BLACK);
b.setForeground(Color.WHITE);
l9 = new JLabel("Address:");
l9.setFont(new Font("Raleway", Font.BOLD, 20));
l10 = new JLabel("City:");
l10.setFont(new Font("Raleway", Font.BOLD, 20));
l11 = new JLabel("Pin Code:");
l11.setFont(new Font("Raleway", Font.BOLD, 20));
l12 = new JLabel("State:");
l12.setFont(new Font("Raleway", Font.BOLD, 20));
l13 = new JLabel("Date");
l13.setFont(new Font("Raleway", Font.BOLD, 14));
l14 = new JLabel("Month");
l14.setFont(new Font("Raleway", Font.BOLD, 14));
l15 = new JLabel("Year");
l15.setFont(new Font("Raleway", Font.BOLD, 14));
t1 = new JTextField();
t1.setFont(new Font("Raleway", Font.BOLD, 14));
t2 = new JTextField();
t2.setFont(new Font("Raleway", Font.BOLD, 14));
t3 = new JTextField();
t3.setFont(new Font("Raleway", Font.BOLD, 14));
t4 = new JTextField();
t4.setFont(new Font("Raleway", Font.BOLD, 14));
t5 = new JTextField();
t5.setFont(new Font("Raleway", Font.BOLD, 14));
t6 = new JTextField();
t6.setFont(new Font("Raleway", Font.BOLD, 14));
t7 = new JTextField();
t7.setFont(new Font("Raleway", Font.BOLD, 14));
b = new JButton("Next");
b.setFont(new Font("Raleway", Font.BOLD, 14));
b.setBackground(Color.BLACK);
b.setForeground(Color.WHITE);
16
r1 = new JRadioButton("Male");
r1.setFont(new Font("Raleway", Font.BOLD, 14));
r1.setBackground(Color.WHITE);
r2 = new JRadioButton("Female");
r2.setFont(new Font("Raleway", Font.BOLD, 14));
r2.setBackground(Color.WHITE);
ButtonGroup groupgender = new ButtonGroup();
groupgender.add(r1);
groupgender.add(r2);
r3 = new JRadioButton("Married");
r3.setFont(new Font("Raleway", Font.BOLD, 14));
r3.setBackground(Color.WHITE);
r4 = new JRadioButton("Unmarried");
r4.setFont(new Font("Raleway", Font.BOLD, 14));
r4.setBackground(Color.WHITE);
r5 = new JRadioButton("Other");
r5.setFont(new Font("Raleway", Font.BOLD, 14));
r5.setBackground(Color.WHITE);
ButtonGroup groupstatus = new ButtonGroup();
groupstatus.add(r3);
groupstatus.add(r4);
groupstatus.add(r5);
dateChooser = new JDateChooser();
//dateChooser.setBorder(new LineBorder(new Color(0, 0, 0), 1, true));
dateChooser.setForeground(new Color(105, 105, 105));
dateChooser.setBounds(137, 337, 200, 29);
add(dateChooser);
setLayout(null);
l1.setBounds(140,20,600,40);
add(l1);
l2.setBounds(290,80,600,30);
add(l2);
l3.setBounds(100,140,100,30);
add(l3);
t1.setBounds(300,140,400,30);
add(t1);
l4.setBounds(100,190,200,30);
add(l4);
r1 = new JRadioButton("Male");
r1.setFont(new Font("Raleway", Font.BOLD, 14));
r1.setBackground(Color.WHITE);
r2 = new JRadioButton("Female");
r2.setFont(new Font("Raleway", Font.BOLD, 14));
r2.setBackground(Color.WHITE);
ButtonGroup groupgender = new ButtonGroup();
groupgender.add(r1);
groupgender.add(r2);
r3 = new JRadioButton("Married");
r3.setFont(new Font("Raleway", Font.BOLD, 14));
r3.setBackground(Color.WHITE);
r4 = new JRadioButton("Unmarried");
r4.setFont(new Font("Raleway", Font.BOLD, 14));
r4.setBackground(Color.WHITE);
r5 = new JRadioButton("Other");
r5.setFont(new Font("Raleway", Font.BOLD, 14));
r5.setBackground(Color.WHITE);
ButtonGroup groupstatus = new ButtonGroup();
groupstatus.add(r3);
groupstatus.add(r4);
groupstatus.add(r5);
dateChooser = new JDateChooser();
//dateChooser.setBorder(new LineBorder(new Color(0, 0, 0), 1, true));
dateChooser.setForeground(new Color(105, 105, 105));
dateChooser.setBounds(137, 337, 200, 29);
add(dateChooser);
setLayout(null);
l1.setBounds(140,20,600,40);
add(l1);
l2.setBounds(290,80,600,30);
add(l2);
l3.setBounds(100,140,100,30);
add(l3);
t1.setBounds(300,140,400,30);
add(t1);
l4.setBounds(100,190,200,30);
add(l4);
17
t2.setBounds(300,190,400,30);
add(t2);
l5.setBounds(100,240,200,30);
add(l5);
dateChooser.setBounds(300, 240, 400, 30);
l6.setBounds(100,290,200,30);
add(l6);
r1.setBounds(300,290,60,30);
add(r1);
r2.setBounds(450,290,90,30);
add(r2);
l7.setBounds(100,340,200,30);
add(l7);
t3.setBounds(300,340,400,30);
add(t3);
l8.setBounds(100,390,200,30);
add(l8);
r3.setBounds(300,390,100,30);
add(r3);
r4.setBounds(450,390,100,30);
add(r4);
r5.setBounds(635,390,100,30);
add(r5);
l9.setBounds(100,440,200,30);
add(l9);
t4.setBounds(300,440,400,30);
add(t4);
l10.setBounds(100,490,200,30);
add(l10);
t5.setBounds(300,490,400,30);
add(t5);
t2.setBounds(300,190,400,30);
add(t2);
l5.setBounds(100,240,200,30);
add(l5);
dateChooser.setBounds(300, 240, 400, 30);
l6.setBounds(100,290,200,30);
add(l6);
r1.setBounds(300,290,60,30);
add(r1);
r2.setBounds(450,290,90,30);
add(r2);
l7.setBounds(100,340,200,30);
add(l7);
t3.setBounds(300,340,400,30);
add(t3);
l8.setBounds(100,390,200,30);
add(l8);
r3.setBounds(300,390,100,30);
add(r3);
r4.setBounds(450,390,100,30);
add(r4);
r5.setBounds(635,390,100,30);
add(r5);
l9.setBounds(100,440,200,30);
add(l9);
t4.setBounds(300,440,400,30);
add(t4);
l10.setBounds(100,490,200,30);
add(l10);
t5.setBounds(300,490,400,30);
add(t5);
18
l11.setBounds(100,540,200,30);
add(l11);
t6.setBounds(300,540,400,30);
add(t6);
l12.setBounds(100,590,200,30);
add(l12);
t7.setBounds(300,590,400,30);
add(t7);
b.setBounds(620,660,80,30);
add(b);
b.addActionListener(this);
getContentPane().setBackground(Color.WHITE);
setSize(850,800);
setLocation(500,120);
setVisible(true);
}
public void actionPerformed(ActionEvent ae){
String formno = first;
String name = t1.getText();
String fname = t2.getText();
String dob = ((JTextField) dateChooser.getDateEditor().getUiComponent()).getText();
String gender = null;
if(r1.isSelected()){
gender = "Male";
}else if(r2.isSelected()){
gender = "Female";
}
String email = t3.getText();
String marital = null;
if(r3.isSelected()){
marital = "Married";
}else if(r4.isSelected()){
marital = "Unmarried";
}else if(r5.isSelected()){
marital = "Other";
}
String address = t4.getText();
String city = t5.getText();
String pincode = t6.getText();
l11.setBounds(100,540,200,30);
add(l11);
t6.setBounds(300,540,400,30);
add(t6);
l12.setBounds(100,590,200,30);
add(l12);
t7.setBounds(300,590,400,30);
add(t7);
b.setBounds(620,660,80,30);
add(b);
b.addActionListener(this);
getContentPane().setBackground(Color.WHITE);
setSize(850,800);
setLocation(500,120);
setVisible(true);
}
public void actionPerformed(ActionEvent ae){
String formno = first;
String name = t1.getText();
String fname = t2.getText();
String dob = ((JTextField) dateChooser.getDateEditor().getUiComponent()).getText();
String gender = null;
if(r1.isSelected()){
gender = "Male";
}else if(r2.isSelected()){
gender = "Female";
}
String email = t3.getText();
String marital = null;
if(r3.isSelected()){
marital = "Married";
}else if(r4.isSelected()){
marital = "Unmarried";
}else if(r5.isSelected()){
marital = "Other";
}
String address = t4.getText();
String city = t5.getText();
String pincode = t6.getText();
19
String state = t7.getText();
try{
if(t6.getText().equals("")){
JOptionPane.showMessageDialog(null, "Fill all the required fields");
}else{
Conn c1 = new Conn();
String q1 = "insert into signup
values('"+formno+"','"+name+"','"+fname+"','"+dob+"','"+gender+"','"+email+"','"+marital+"','"+address+"','"
+city+"','"+pincode+"','"+state+"')";
c1.s.executeUpdate(q1);
new Signup2(first).setVisible(true);
setVisible(false);
}
}catch(Exception e){
e.printStackTrace();
}
}
public static void main(String[] args){
new Signup().setVisible(true);
}
}
String state = t7.getText();
try{
if(t6.getText().equals("")){
JOptionPane.showMessageDialog(null, "Fill all the required fields");
}else{
Conn c1 = new Conn();
String q1 = "insert into signup
values('"+formno+"','"+name+"','"+fname+"','"+dob+"','"+gender+"','"+email+"','"+marital+"','"+address+"','"
+city+"','"+pincode+"','"+state+"')";
c1.s.executeUpdate(q1);
new Signup2(first).setVisible(true);
setVisible(false);
}
}catch(Exception e){
e.printStackTrace();
}
}
public static void main(String[] args){
new Signup().setVisible(true);
}
}
20
2.2 MYSQL
MySQL is an open-source relational database management system (RDBMS) that is widely used for building
scalable, high-performance database-driven applications. Developed by MySQL AB (now owned by Oracle
Corporation), MySQL is renowned for its reliability, ease of use, and broad support across various platforms.
Here are some key aspects of MySQL:
1. Relational Database Management System (RDBMS): MySQL follows the relational model for
organizing data into tables with rows and columns. It supports SQL (Structured Query Language) for
querying and manipulating data, making it compatible with a vast ecosystem of tools and
frameworks.
2. Open Source and Community Edition: MySQL is available in multiple editions, including the
Community Edition, which is free and open-source under the GNU General Public License (GPL).
The Community Edition is widely used by developers and organizations for non-commercial projects
and small-scale deployments.
3. Scalability and Performance: MySQL is designed to handle large volumes of data and concurrent
connections efficiently. It supports features such as replication, clustering, and partitioning to scale
horizontally and vertically, ensuring optimal performance for diverse workloads.
4. High Availability and Durability: MySQL offers features like replication, failover, and backup and
recovery mechanisms to ensure high availability and data durability. These features enable
organizations to build resilient and fault-tolerant database architectures.
5. Cross-Platform Compatibility: MySQL is supported on various operating systems, including Linux,
Windows, macOS, and Unix-like systems, making it versatile and suitable for deployment in diverse
environments.
6. Integration and Ecosystem: MySQL integrates seamlessly with popular programming languages,
frameworks, and platforms. It provides connectors and APIs for languages like Java, Python, PHP,
and Node.js, enabling developers to interact with MySQL databases from their preferred development
environment.
7. Community and Support: MySQL has a large and active community of developers, administrators,
and enthusiasts who contribute to its development, provide support, and share knowledge through
forums, mailing lists, and online resources. Additionally, commercial support and services are
available from Oracle and other vendors for organizations requiring enterprise-level assistance.
8. Compatibility and Standards: MySQL adheres to SQL standards and is compliant with various
industry standards, ensuring compatibility with third-party tools, applications, and databases.
2.2 MYSQL
MySQL is an open-source relational database management system (RDBMS) that is widely used for building
scalable, high-performance database-driven applications. Developed by MySQL AB (now owned by Oracle
Corporation), MySQL is renowned for its reliability, ease of use, and broad support across various platforms.
Here are some key aspects of MySQL:
1. Relational Database Management System (RDBMS): MySQL follows the relational model for
organizing data into tables with rows and columns. It supports SQL (Structured Query Language) for
querying and manipulating data, making it compatible with a vast ecosystem of tools and
frameworks.
2. Open Source and Community Edition: MySQL is available in multiple editions, including the
Community Edition, which is free and open-source under the GNU General Public License (GPL).
The Community Edition is widely used by developers and organizations for non-commercial projects
and small-scale deployments.
3. Scalability and Performance: MySQL is designed to handle large volumes of data and concurrent
connections efficiently. It supports features such as replication, clustering, and partitioning to scale
horizontally and vertically, ensuring optimal performance for diverse workloads.
4. High Availability and Durability: MySQL offers features like replication, failover, and backup and
recovery mechanisms to ensure high availability and data durability. These features enable
organizations to build resilient and fault-tolerant database architectures.
5. Cross-Platform Compatibility: MySQL is supported on various operating systems, including Linux,
Windows, macOS, and Unix-like systems, making it versatile and suitable for deployment in diverse
environments.
6. Integration and Ecosystem: MySQL integrates seamlessly with popular programming languages,
frameworks, and platforms. It provides connectors and APIs for languages like Java, Python, PHP,
and Node.js, enabling developers to interact with MySQL databases from their preferred development
environment.
7. Community and Support: MySQL has a large and active community of developers, administrators,
and enthusiasts who contribute to its development, provide support, and share knowledge through
forums, mailing lists, and online resources. Additionally, commercial support and services are
available from Oracle and other vendors for organizations requiring enterprise-level assistance.
8. Compatibility and Standards: MySQL adheres to SQL standards and is compliant with various
industry standards, ensuring compatibility with third-party tools, applications, and databases.
21
• Storage Engines: MySQL supports multiple storage engines, each optimized for different use cases. The
most commonly used storage engine is InnoDB, which provides ACID (Atomicity, Consistency, Isolation,
Durability) transactions, foreign key constraints, and crash recovery capabilities. Other storage engines
include MyISAM (historically popular for read-heavy workloads), Memory (for fast, in-memory operations),
and NDB Cluster (optimized for distributed, high-availability environments).
• Replication: MySQL replication enables the replication of data from one MySQL database server (the
master) to one or more MySQL database servers (the slaves). Replication can be used for various purposes,
including scaling out read-heavy workloads, improving fault tolerance, and enabling geographic distribution
of data. MySQL replication supports different topologies, such as master-slave, master-master, and multi-
source replication.
• Partitioning: MySQL provides support for partitioning large tables into smaller, more manageable
partitions based on predefined criteria (e.g., range, hash, list). Partitioning can improve query performance,
data organization, and maintenance tasks, especially for tables with millions of rows or more. It allows for
more efficient data retrieval and storage by limiting the amount of data that needs to be scanned or updated.
• Security Features: MySQL offers various security features to protect sensitive data and ensure secure
access to the database. These features include authentication methods such as native password authentication,
secure connections using SSL/TLS encryption, role-based access control (RBAC) with user accounts and
privileges, and auditing capabilities to track and monitor database activity.
• Backup and Recovery: MySQL provides tools and mechanisms for backup and recovery to prevent data
loss and ensure data integrity. These include options for performing full backups, incremental backups, and
point-in-time recovery using tools like mysqldump, MySQL Enterprise Backup, or third-party backup
solutions. Additionally, MySQL supports binary logging, which records changes to the database, facilitating
incremental backups and replication.
• Performance Tuning: MySQL offers various features and configuration options for optimizing database
performance. This includes adjusting buffer sizes (e.g., innodb_buffer_pool_size), optimizing query
execution plans using indexes and query optimization techniques, monitoring and tuning server variables
(e.g., innodb_flush_log_at_trx_commit), and utilizing performance schema and other monitoring tools to
identify and resolve bottlenecks.
• High Availability Solutions: In addition to replication, MySQL provides high availability solutions such
as MySQL Group Replication and MySQL InnoDB Cluster. These solutions offer automated failover, data
consistency, and distributed coordination capabilities, enabling organizations to build highly available and
fault-tolerant database architectures.
• Storage Engines: MySQL supports multiple storage engines, each optimized for different use cases. The
most commonly used storage engine is InnoDB, which provides ACID (Atomicity, Consistency, Isolation,
Durability) transactions, foreign key constraints, and crash recovery capabilities. Other storage engines
include MyISAM (historically popular for read-heavy workloads), Memory (for fast, in-memory operations),
and NDB Cluster (optimized for distributed, high-availability environments).
• Replication: MySQL replication enables the replication of data from one MySQL database server (the
master) to one or more MySQL database servers (the slaves). Replication can be used for various purposes,
including scaling out read-heavy workloads, improving fault tolerance, and enabling geographic distribution
of data. MySQL replication supports different topologies, such as master-slave, master-master, and multi-
source replication.
• Partitioning: MySQL provides support for partitioning large tables into smaller, more manageable
partitions based on predefined criteria (e.g., range, hash, list). Partitioning can improve query performance,
data organization, and maintenance tasks, especially for tables with millions of rows or more. It allows for
more efficient data retrieval and storage by limiting the amount of data that needs to be scanned or updated.
• Security Features: MySQL offers various security features to protect sensitive data and ensure secure
access to the database. These features include authentication methods such as native password authentication,
secure connections using SSL/TLS encryption, role-based access control (RBAC) with user accounts and
privileges, and auditing capabilities to track and monitor database activity.
• Backup and Recovery: MySQL provides tools and mechanisms for backup and recovery to prevent data
loss and ensure data integrity. These include options for performing full backups, incremental backups, and
point-in-time recovery using tools like mysqldump, MySQL Enterprise Backup, or third-party backup
solutions. Additionally, MySQL supports binary logging, which records changes to the database, facilitating
incremental backups and replication.
• Performance Tuning: MySQL offers various features and configuration options for optimizing database
performance. This includes adjusting buffer sizes (e.g., innodb_buffer_pool_size), optimizing query
execution plans using indexes and query optimization techniques, monitoring and tuning server variables
(e.g., innodb_flush_log_at_trx_commit), and utilizing performance schema and other monitoring tools to
identify and resolve bottlenecks.
• High Availability Solutions: In addition to replication, MySQL provides high availability solutions such
as MySQL Group Replication and MySQL InnoDB Cluster. These solutions offer automated failover, data
consistency, and distributed coordination capabilities, enabling organizations to build highly available and
fault-tolerant database architectures.
22
CHAPTER – 3
LITERATURE SURVEY
3.1 Introduction to JAVA
Java is a high-level, object-oriented programming language initially developed by Sun Microsystems (now
owned by Oracle Corporation) in the mid-1990s. It was designed with the primary goal of providing a
platform-independent language that could be used to develop software for various computing platforms. Java
quickly gained popularity due to its simplicity, portability, and versatility, and it has since become one of the
most widely used programming languages in the world.
Here are some key features and characteristics of Java:
1. Platform Independence: Java programs are compiled into bytecode, which can be executed on any
platform that has a Java Virtual Machine (JVM). This "write once, run anywhere" approach enables
Java applications to run on diverse devices and operating systems without modification.
2. Object-Oriented: Java is a pure object-oriented programming language, which means that it revolves
around the concept of objects and classes. Objects encapsulate data and behavior, while classes serve
as blueprints for creating objects. This object-oriented paradigm promotes code reusability,
modularity, and maintainability.
3. Simple and Easy to Learn: Java was designed to be simple and straightforward, making it
accessible to novice programmers. It features a clean syntax, intuitive language constructs, and
comprehensive documentation, which contribute to its ease of learning and use.
4. Robust and Secure: Java's robustness stems from its strong type system, automatic memory
management (garbage collection), and exception handling mechanisms, which help prevent common
programming errors and runtime crashes. Additionally, Java's security features, such as sandboxing
and access controls, ensure that applications run securely in potentially hostile environments.
5. Rich Standard Library: Java comes with a vast standard library (Java API) that provides pre-built
classes and packages for performing a wide range of tasks, including input/output operations,
networking, data manipulation, graphical user interface (GUI) development, and more. This extensive
library accelerates application development and reduces the need for writing low-level code.
6. Multithreading Support: Java offers built-in support for multithreading, allowing developers to
create concurrent and parallel programs that leverage the capabilities of modern multicore processors.
Multithreading in Java enables applications to perform tasks concurrently, improving performance
and responsiveness.
CHAPTER – 3
LITERATURE SURVEY
3.1 Introduction to JAVA
Java is a high-level, object-oriented programming language initially developed by Sun Microsystems (now
owned by Oracle Corporation) in the mid-1990s. It was designed with the primary goal of providing a
platform-independent language that could be used to develop software for various computing platforms. Java
quickly gained popularity due to its simplicity, portability, and versatility, and it has since become one of the
most widely used programming languages in the world.
Here are some key features and characteristics of Java:
1. Platform Independence: Java programs are compiled into bytecode, which can be executed on any
platform that has a Java Virtual Machine (JVM). This "write once, run anywhere" approach enables
Java applications to run on diverse devices and operating systems without modification.
2. Object-Oriented: Java is a pure object-oriented programming language, which means that it revolves
around the concept of objects and classes. Objects encapsulate data and behavior, while classes serve
as blueprints for creating objects. This object-oriented paradigm promotes code reusability,
modularity, and maintainability.
3. Simple and Easy to Learn: Java was designed to be simple and straightforward, making it
accessible to novice programmers. It features a clean syntax, intuitive language constructs, and
comprehensive documentation, which contribute to its ease of learning and use.
4. Robust and Secure: Java's robustness stems from its strong type system, automatic memory
management (garbage collection), and exception handling mechanisms, which help prevent common
programming errors and runtime crashes. Additionally, Java's security features, such as sandboxing
and access controls, ensure that applications run securely in potentially hostile environments.
5. Rich Standard Library: Java comes with a vast standard library (Java API) that provides pre-built
classes and packages for performing a wide range of tasks, including input/output operations,
networking, data manipulation, graphical user interface (GUI) development, and more. This extensive
library accelerates application development and reduces the need for writing low-level code.
6. Multithreading Support: Java offers built-in support for multithreading, allowing developers to
create concurrent and parallel programs that leverage the capabilities of modern multicore processors.
Multithreading in Java enables applications to perform tasks concurrently, improving performance
and responsiveness.
23
Administrative Modules
3.2Administrative modules
Here in my project there are two types of modules. This module is the main module which performs all the
main operations in the system. The major operations in the system are:
Admin Module
Admin can access this project there is an authorization process. If you login as an Admin then you will be
redirected to the Admin Home Page and if you are a simple user you will be redirected to your Account
Home Page. This performs the following functions: Create
Individual Accounts, manage existing accounts, View all transactions, Balance enquiry,
Delete/close account etc.
1- Admin login
2- Add/delete/update account
3- Withdrawal/deposit/statements transaction
4- Account Information
5- User details list
6- Active/Inactive account
7- View transaction histories
User Module
A simple user can access their account and can deposit/withdraw money from their account.
User can also transfer money from their account to any other bank account. User can see their transaction
report and balance enquiry too.
1- User login, use PIN system
2- Creating/open new account registration
3- Funds transfer (local/international/domestic)
4- View statements transaction
5- User account details
6- Change Password and Pin
Administrative Modules
3.2Administrative modules
Here in my project there are two types of modules. This module is the main module which performs all the
main operations in the system. The major operations in the system are:
Admin Module
Admin can access this project there is an authorization process. If you login as an Admin then you will be
redirected to the Admin Home Page and if you are a simple user you will be redirected to your Account
Home Page. This performs the following functions: Create
Individual Accounts, manage existing accounts, View all transactions, Balance enquiry,
Delete/close account etc.
1- Admin login
2- Add/delete/update account
3- Withdrawal/deposit/statements transaction
4- Account Information
5- User details list
6- Active/Inactive account
7- View transaction histories
User Module
A simple user can access their account and can deposit/withdraw money from their account.
User can also transfer money from their account to any other bank account. User can see their transaction
report and balance enquiry too.
1- User login, use PIN system
2- Creating/open new account registration
3- Funds transfer (local/international/domestic)
4- View statements transaction
5- User account details
6- Change Password and Pin
24
Banks terms:
1. All requests received from customers are logged for backend fulfillment and are effective from the time
they are recorded at the branch.
2. Rules and regulations applicable to normal banking transactions in India will be applicable mutatis
mutandis for the transactions executed through this site.
3. The BAMS Bank service cannot be claimed as a right. The bank may also convert this into a discretionary
service anytime.
4. Dispute between the customer and the Bank in this service is subject to the jurisdiction of the courts in the
Republic of India and governed by the laws prevailing in India.
5. The Bank reserves the right to modify the services offered or the Terms of service of
BAMS Bank. The changes will be notified to the customers through a notification on the Site.
Customer’s obligations
1. The customer has an obligation to maintain secrecy in regard to Username &
Password registered with the Bank. The bank presupposes that login using valid
Username and Password is a valid session initiated by none other than the customer.
2. Transaction executed through a valid session will be construed by RR to have emanated from the
registered customer and will be binding on him/her.
3. The customer will not attempt or permit others to attempt accessing the BAMS Bank through any unlawful
means.
Banks terms:
1. All requests received from customers are logged for backend fulfillment and are effective from the time
they are recorded at the branch.
2. Rules and regulations applicable to normal banking transactions in India will be applicable mutatis
mutandis for the transactions executed through this site.
3. The BAMS Bank service cannot be claimed as a right. The bank may also convert this into a discretionary
service anytime.
4. Dispute between the customer and the Bank in this service is subject to the jurisdiction of the courts in the
Republic of India and governed by the laws prevailing in India.
5. The Bank reserves the right to modify the services offered or the Terms of service of
BAMS Bank. The changes will be notified to the customers through a notification on the Site.
Customer’s obligations
1. The customer has an obligation to maintain secrecy in regard to Username &
Password registered with the Bank. The bank presupposes that login using valid
Username and Password is a valid session initiated by none other than the customer.
2. Transaction executed through a valid session will be construed by RR to have emanated from the
registered customer and will be binding on him/her.
3. The customer will not attempt or permit others to attempt accessing the BAMS Bank through any unlawful
means.
25
Benefits of online banking
3.3 Benefits of online banking
Many of us lead busy lives. Some of us are up before the crack of dawn, getting ourselves prepared so we
can in turn get our families ready for the day. We rush to work, rush to get the kids to school, and at the end
of the day we rush home only to brace ourselves for the next day. After a hectic day, the last thing you want
to do is spend time waiting in line at the bank, or even the post office. That's where Online Banking comes
in. Many of the benefits of doing our banking online are obvious:
1- You don't have to wait in line.
2- You don't have to plan your day around the bank's hours.
3- You can look at your balance whenever you want, not just when you get a statement.
There are some hidden benefits too. As a young bank customer, you're just learning how to manage your
money and observe your spending patterns.
Online banking allows you to watch your money on a daily basis if you want to. By keeping close tabs on
your funds, you'll always be aware of what's happening in your bank account.
For those experienced spenders, this option is far more appealing than the sudden discovery that you're
broke!
It's also helpful to watch how much interest you're gathering on investments and savings or what service
charges you have incurred.
Most available benefits
1. Online banking with key bank is fast, secure, convenient and free.
2. Quick, simple, authenticated access to accounts via the web application.
3. Simply scalable to grow with changing system requirement.
4. Global enterprise wide access to information.
5. Improved data security, restricting unauthorized access.
6. Minimize Storage Space.
Benefits of online banking
3.3 Benefits of online banking
Many of us lead busy lives. Some of us are up before the crack of dawn, getting ourselves prepared so we
can in turn get our families ready for the day. We rush to work, rush to get the kids to school, and at the end
of the day we rush home only to brace ourselves for the next day. After a hectic day, the last thing you want
to do is spend time waiting in line at the bank, or even the post office. That's where Online Banking comes
in. Many of the benefits of doing our banking online are obvious:
1- You don't have to wait in line.
2- You don't have to plan your day around the bank's hours.
3- You can look at your balance whenever you want, not just when you get a statement.
There are some hidden benefits too. As a young bank customer, you're just learning how to manage your
money and observe your spending patterns.
Online banking allows you to watch your money on a daily basis if you want to. By keeping close tabs on
your funds, you'll always be aware of what's happening in your bank account.
For those experienced spenders, this option is far more appealing than the sudden discovery that you're
broke!
It's also helpful to watch how much interest you're gathering on investments and savings or what service
charges you have incurred.
Most available benefits
1. Online banking with key bank is fast, secure, convenient and free.
2. Quick, simple, authenticated access to accounts via the web application.
3. Simply scalable to grow with changing system requirement.
4. Global enterprise wide access to information.
5. Improved data security, restricting unauthorized access.
6. Minimize Storage Space.
26
Future Look
The “Banking Online System is a big and ambitious project. I am thankful for being provided this great
opportunity to work on it. As already mentioned, this project has gone through extensive research work. On
the basis of the research work, we have successfully designed and implemented banking online System. To
know what the future of online banking looks like, it’s probably worth looking at the present – online
banking isn’t new. When you think of online banking, you probably think about a computer (either a desktop
or laptop), a three or four step security process and then an interface that lets you view the balance of your
various bank accounts and credit cards, whilst permitting you to transfer money and pay bills. And you’re not
wrong either. The most valuable future looks are following below:
1- More branches of the bank, maybe it will be international, that means more ATM machines outside.
2- Customer issues development based on their needs, so the help desk will be aware of their needs and easy
to use.
3- Developing a mobile App for banking system that help users to do the obtained his operations without go
to the bank only he needs to sign in using his A/C NO. And password and then use your own PIN. Finally the
system will update automatically.
Future Look
The “Banking Online System is a big and ambitious project. I am thankful for being provided this great
opportunity to work on it. As already mentioned, this project has gone through extensive research work. On
the basis of the research work, we have successfully designed and implemented banking online System. To
know what the future of online banking looks like, it’s probably worth looking at the present – online
banking isn’t new. When you think of online banking, you probably think about a computer (either a desktop
or laptop), a three or four step security process and then an interface that lets you view the balance of your
various bank accounts and credit cards, whilst permitting you to transfer money and pay bills. And you’re not
wrong either. The most valuable future looks are following below:
1- More branches of the bank, maybe it will be international, that means more ATM machines outside.
2- Customer issues development based on their needs, so the help desk will be aware of their needs and easy
to use.
3- Developing a mobile App for banking system that help users to do the obtained his operations without go
to the bank only he needs to sign in using his A/C NO. And password and then use your own PIN. Finally the
system will update automatically.
27
CHAPTER – 4
SCREENSHOTS OF PROJECT
CHAPTER – 4
SCREENSHOTS OF PROJECT
28
29
30
CHAPTER – 5
DATABASE
What is MySQL ?
MySQL is the world’s most popular open source database. According to DB-Engines,
MySQL ranks as the second-most-popular database, behind Oracle Database. MySQL powers
many of the most accessed applications, including Facebook, Twitter, Netflix, Uber, Airbnb,
Shopify, and Booking.com. Since MySQL is open source, it includes numerous features
developed in close cooperation with users over more than 25 years. So it’s very likely that
your favorite application or programming language is supported by MySQL Database.
Why MySQL?
MySQL is important when creating a website. MySQL determines the speed of when things
load on your site and how fast you can access that stored data. It has a direct impact on site
performance, which makes it an integral part of web design. Speed is king after all.
ADVANTAGES OF MYSQL:
➢ Open Source:
MySQL is open-source software, which means it is freely available for use and can
be customized to suit your specific needs. This can lead to cost savings and greater
flexibility.
Scalability:
MySQL can handle large amounts of data and high traffic websites with ease. It
offers various replication and clustering options to scale vertically or horizontally as
your data and user base grow.
High Performance:
MySQL is known for its fast and efficient performance. It uses various storage
engines (such as InnoDB and MyISAM) that can be optimized for specific use cases.
Proper indexing and query optimization can also enhance performance significantly.
CHAPTER – 5
DATABASE
What is MySQL ?
MySQL is the world’s most popular open source database. According to DB-Engines,
MySQL ranks as the second-most-popular database, behind Oracle Database. MySQL powers
many of the most accessed applications, including Facebook, Twitter, Netflix, Uber, Airbnb,
Shopify, and Booking.com. Since MySQL is open source, it includes numerous features
developed in close cooperation with users over more than 25 years. So it’s very likely that
your favorite application or programming language is supported by MySQL Database.
Why MySQL?
MySQL is important when creating a website. MySQL determines the speed of when things
load on your site and how fast you can access that stored data. It has a direct impact on site
performance, which makes it an integral part of web design. Speed is king after all.
ADVANTAGES OF MYSQL:
➢ Open Source:
MySQL is open-source software, which means it is freely available for use and can
be customized to suit your specific needs. This can lead to cost savings and greater
flexibility.
Scalability:
MySQL can handle large amounts of data and high traffic websites with ease. It
offers various replication and clustering options to scale vertically or horizontally as
your data and user base grow.
High Performance:
MySQL is known for its fast and efficient performance. It uses various storage
engines (such as InnoDB and MyISAM) that can be optimized for specific use cases.
Proper indexing and query optimization can also enhance performance significantly.
31
Reliability:
MySQL is a robust and stable database system. It has a proven track record in the
industry and is widely used in mission-critical applications. It supports ACID
(Atomicity, Consistency, Isolation, Durability) compliance to ensure data reliability.
Security:
MySQL provides robust security features, including user authentication, authorization,
and encryption. It also supports SSL for secure data transmission and allows you to
restrict access based on IP addresses or networks.
Ease of Use:
MySQL is known for its user-friendly interfaces, making it accessible for both
beginners and experienced developers. It supports SQL (Structured Query Language),
which is a widely used language for managing and querying databases.
Community and Support:
MySQL has a large and active community of developers and users. This means you
can find plenty of resources, documentation, and community support to help you with
any issues or questions you may have.
Cross-Platform Compatibility:
MySQL is available for various platforms, including Windows, Linux, macOS, and
more. This cross-platform compatibility allows you to run MySQL on different
operating systems without major compatibility issues.
Reliability:
MySQL is a robust and stable database system. It has a proven track record in the
industry and is widely used in mission-critical applications. It supports ACID
(Atomicity, Consistency, Isolation, Durability) compliance to ensure data reliability.
Security:
MySQL provides robust security features, including user authentication, authorization,
and encryption. It also supports SSL for secure data transmission and allows you to
restrict access based on IP addresses or networks.
Ease of Use:
MySQL is known for its user-friendly interfaces, making it accessible for both
beginners and experienced developers. It supports SQL (Structured Query Language),
which is a widely used language for managing and querying databases.
Community and Support:
MySQL has a large and active community of developers and users. This means you
can find plenty of resources, documentation, and community support to help you with
any issues or questions you may have.
Cross-Platform Compatibility:
MySQL is available for various platforms, including Windows, Linux, macOS, and
more. This cross-platform compatibility allows you to run MySQL on different
operating systems without major compatibility issues.
32
Conclusion
This project is developed to nurture the needs of a user in a banking sector by embedding all the tasks of
transactions taking place in a bank. Future version of this project will still be much enhanced than the current
version. Writing and depositing checks are perhaps the most fundamental ways to move money in and out of
a checking account, but advancements in technology have added ATM and debit card transactions. All banks
have rules about how long it takes to access your deposits, how many debit card transactions you're allowed
in a day, and how much cash you can withdraw from an ATM. Access to the balance in your checking
account can also be limited by businesses that place holds on your funds.
Banks are providing internet banking services also so that the customers can be attracted. By asking the bank
employs we came to know that maximum numbers of internet bank account holders are youth and business
man. Online banking is an innovative tool that is fast becoming a necessity. It is a successful strategic
weapon for banks to remain profitable in a volatile and competitive marketplace of today. If proper training
should be given to customer by the bank employs to open an account will be beneficial secondly the website
should be made friendlier from where the customers can directly make and access their accounts.
Thus, the Bank Management System it is developed and executed successfully.
Conclusion
This project is developed to nurture the needs of a user in a banking sector by embedding all the tasks of
transactions taking place in a bank. Future version of this project will still be much enhanced than the current
version. Writing and depositing checks are perhaps the most fundamental ways to move money in and out of
a checking account, but advancements in technology have added ATM and debit card transactions. All banks
have rules about how long it takes to access your deposits, how many debit card transactions you're allowed
in a day, and how much cash you can withdraw from an ATM. Access to the balance in your checking
account can also be limited by businesses that place holds on your funds.
Banks are providing internet banking services also so that the customers can be attracted. By asking the bank
employs we came to know that maximum numbers of internet bank account holders are youth and business
man. Online banking is an innovative tool that is fast becoming a necessity. It is a successful strategic
weapon for banks to remain profitable in a volatile and competitive marketplace of today. If proper training
should be given to customer by the bank employs to open an account will be beneficial secondly the website
should be made friendlier from where the customers can directly make and access their accounts.
Thus, the Bank Management System it is developed and executed successfully.
33
BIBILOGRAPHY
1. Code for Interview YouTube Channel
(https://www.youtube.com/playlist?list=PL5BFcXE899zxVrWaO3Ul6ly2SVJMnJFOr)
2. Online Bank Account Management System
Website: http://www.slideshare.net (Collect some info for report documents)
3. Learning MYSQL, JavaScript, jQuery, PHP, HTML, CSS3,
Website: http://www.w3schools.com
4. PHP and MySQL video tutorials
Website: http://www.freehinditutorial.com, http://www.youtube.com
5. Veneeva, V. (2006), “E-Banking (Online Banking) and Its Role in Today's Society”,
Ezine articles
6. JavaScript validation for empty input field
Website:http://stackoverflow.com/questions/3937513/javascript-validation-for-empty-
input-field ,
7. JavaScript form validation: Validate Password, Validate Email, Validate Phone
Number, http://webcheatsheet.com/javascript/form_validation.php
BIBILOGRAPHY
1. Code for Interview YouTube Channel
(https://www.youtube.com/playlist?list=PL5BFcXE899zxVrWaO3Ul6ly2SVJMnJFOr)
2. Online Bank Account Management System
Website: http://www.slideshare.net (Collect some info for report documents)
3. Learning MYSQL, JavaScript, jQuery, PHP, HTML, CSS3,
Website: http://www.w3schools.com
4. PHP and MySQL video tutorials
Website: http://www.freehinditutorial.com, http://www.youtube.com
5. Veneeva, V. (2006), “E-Banking (Online Banking) and Its Role in Today's Society”,
Ezine articles
6. JavaScript validation for empty input field
Website:http://stackoverflow.com/questions/3937513/javascript-validation-for-empty-
input-field ,
7. JavaScript form validation: Validate Password, Validate Email, Validate Phone
Number, http://webcheatsheet.com/javascript/form_validation.php
Tags
Categories
GeneralDownload
Download Slideshow Get the original presentation fileQuick Actions
Statistics
- Views 4,227
- Slides 33
- Favorites 1
- Age 546 days
Related Slideshows
22
Pray For The Peace Of Jerusalem and You Will Prosper
RodolfoMoralesMarcuc
32 views
26
Don_t_Waste_Your_Life_God.....powerpoint
chalobrido8
33 views
31
VILLASUR_FACTORS_TO_CONSIDER_IN_PLATING_SALAD_10-13.pdf
JaiJai148317
31 views
14
Fertility awareness methods for women in the society
Isaiah47
30 views
35
Chapter 5 Arithmetic Functions Computer Organisation and Architecture
RitikSharma297999
27 views
5
syakira bhasa inggris (1) (1).pptx.......
ourcommunity56
29 views