Project Report on “BANK MANAGEMENT SYSTEM” Relational

Database Management System B. Tech 4thYear (Branch – CS)

School of Engineering & Technology, IFTM University.

Submitted To:
Submitted By:
Aditya Khanna (21119002)
Adarsh Kumar (20118002)

Teacher’s Name
Student’s Name
S.No. TOPICS Page
No.
1 Acknowledgement 5

2 Certificate 6

3 Introduction 7

4 Abstract 9

5 Aim of the Project 11

6 Main Purpose 12

7 Main Goal 13

8 Methods 14

9 Administrative Module 15

10 Bank Terms 17

11 Customer’s Obligation 18

12 Benefits of online Banking 19

13 Future looks 21

14 Conclusion 22

15 Refence 24

16 Source code 25

17 Screenshots 47
 ACKNOWLEDGEMENT

This Project report was completed as a result of support

from many people, although not all of them can be
mentioned.

We wish to express our sincere gratitude to God for his

protection, providence, guidance and above all, for
sustaining us.

We are greatly indebted to our good supervisor Bharat

Bhushan Agarwal for his useful and necessary
observation, suggestions, contribution and corrections.
We would not have been able to achieve anything in this
research without your supervision. May God enrich you
greatly in every area of life.

Finally, we wish to express our appreciation to our

parents for their love and support.

Student’s Name

CERTIFICATE
 This is to certify that Project Report entitled” BANK
MANAGEMENT SYSTEM”. Which is submitted by “Aditya
Khanna (21119002), Adarsh Kumar (20118002) in partial
fulfilment of the requirement for the award of B. Tech in
Department of Computer science of School of
Engineering & Technology, IFTM University, is a record
of the candidate own work carried out by him under our
supervision. The matter embodied in this thesis is
original and has not been submitted for the award of
other degree.
 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.
 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 analyse 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

AIM OF THE 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

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 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 fulfil 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
 ADMINISTRATIVE MODULE

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
 BANK TERMS:
1. All requests received from customers are logged for
backend fulfilment 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 OBLIGATION
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.

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.
 FUTURE LOOKS
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.

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.
 REFERENCE
1. Code for Interview YouTube Channel
(https://www.youtube.com/playlist?
list=PL5BFcXE899zxVrWaO3Ul6ly2SVJMnJFOr)
2. OnlineBank 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.p
hp

SOURCE CODE
Deposit.java

package ASimulatorSystem;

import
java.awt.*;
import
java.awt.eve
nt.*; 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/i
cons/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,40
0,35); l3.add(l1);
t1.setBounds(190,420,32
0,25); l3.add(t1);

b1.setBounds(390,588,15
0,35); l3.add(b1);

b2.setBounds(390,633,15
0,35); l3.add(b2);

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.getTex
t().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(tru
e);
}
}

Signup.java

package ASimulatorSystem;
import
java.awt.*;
import
java.awt.eve
nt.*; import
javax.swing.
*; import
java.sql.*;
import
com.toedter.calendar.JDate
Chooser; 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("ASimulat
orSystem/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));

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);

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.WHIT
E);

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.WHIT
E);

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.WH
ITE);

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,6
00,40); add(l1);

l2.setBounds(290,80,6
00,30); add(l2);

l3.setBounds(100,140,1
00,30); add(l3);

t1.setBounds(300,140,4
00,30); add(t1);

l4.setBounds(100,19
0,200,30); add(l4);

t2.setBounds(300,190,400,30);
 add(t2);

l5.setBounds(100,24
0,200,30); add(l5);

dateChooser.setBounds(300, 240, 400, 30);

l6.setBounds(100,290,2
00,30); add(l6);

r1.setBounds(300,290,
60,30); add(r1);

r2.setBounds(450,290,
90,30); add(r2);

l7.setBounds(100,340,2
00,30); add(l7);
t3.setBounds(300,340,4
00,30); add(t3);

l8.setBounds(100,39
0,200,30); add(l8);

r3.setBounds(300,39
0,100,30); add(r3);
r4.setBounds(450,39
0,100,30); add(r4);

r5.setBounds(635,39
0,100,30); add(r5);

l9.setBounds(100,440,2
00,30); add(l9);
t4.setBounds(300,440,4
00,30); add(t4);

l10.setBounds(100,490,2
00,30); add(l10);

t5.setBounds(300,490,4
00,30); add(t5);

l11.setBounds(100,540,2
00,30); add(l11);

t6.setBounds(300,54
0,400,30); add(t6);

l12.setBounds(100,59
0,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()).get
Text(); 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();
 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);
}
}

SCREENSHOTS