Introduction

Bank Management System means banks provide comprehensive electronic fund transfer and
payment solutions that enable thousands of Citizens, Financial Institutions and hundreds of
businesses the convenience of receiving and transferring their funds online.

It's fast, easy and puts you in complete control – you decide who to transfer funds, checking of
the account details. Receive and pay all your paper bills at one site – at your bank, credit union.

Plus, you can enhance the convenience of transferring funds by receiving your bills
electronically, checking statuses of accounts and viewing the statements can possible with this
system. You can do this from one secure online location, in just a few minutes.

Banking system provides the greater opportunity to interact with Account holder. But in regular
system there are no more interactions with an account holder or trustee. Authorities of Bank
Management System can Provides the greater knowledge on Bank Management System and they
can effectively.

This Bank System is windows software designed in Java programming language for the purpose
of effective Bank Management System . It mainly aims at making the banking system easily
accessible from anywhere and improving and enhancing the running banking process. With the
use of this software, bank customers don’t need to go to bank to make inquiry regarding their
balance or to transfer their balance to other account or for any other banking services.
1.1 PURPOSE OF THE SYSTEM
1. SECURITY: There is a lot of security of data on this content management system. One
cannot open our system without knowing the password. Immediately after opening login screen
will appear on screen. Only after entering the correct username and password user can operate
our system.

2. REFERENTIAL INTEGRITY: User cannot change the date in the transaction files.
Addition of data can be done only on the master files date in transaction files cannot be entered
until addition is done on the master files.

3. EASY RETRIEVAL OF DATA: Data is retrieved easily and quick using sql commands.
Online commands are used to retrieve huge amount of data.

4. GENERATION OF AUTOMATIC VALUES: In project in some screen some fields

generated automatically like Profile detail, Account number, etc.
1.2 SCOPE OF THE PROPOSED SYSTEM
Though there are many online systems available on internet but this can compete with them with
some advancement in its functionality and can be used by any bank organization to maintain
their customers account and online transaction process. The basic functionalities of the system
are:

Modules For Customer:-

1. Sign up Module:
Description- New customer can sign up in to the system. New customer should enter personal
details and password in the registration form and then click on “submit” button. A new account
will make in the system.

2. Sign in Module:-
Description- Existing customer must have user-id and password to login into the system.
Customer should enter user-id and password and click on sign in button for login into the
system.
3. Change Password Module:-
Description- Existing customer can change their existing password with new password through
the application by login into the system. Customer should enter user-Id and password into the
login page and then click on sign in button. Now, various services appear on screen from which
user must click on “Change Password” button. Now, enter the new password and then click on
“Set Password” button for reset the password.

4. Forgot Password Module:-

Description- If existing customer forgot his/her password then, customer can retrieve their
password by simply clicking on “Forgot Password” .Now, new page will appear on screen where
he/she can fill user-id and email-id which is linked to the account. In this way, we can retrieve
their password.

5. Cash Withdraw Module:-

Description- Existing customer can withdraw money from their account through the application
by login into the system. Customer should enter user-Id and password into the login page and
then click on sign in button. Now, various services will appear on screen from which user must
click on “Cash Withdraw” button and then, new window will appear on screen to fill the required
details for withdrawing money.
2
6. Cash Deposit Module:-
Description- Existing customer can deposit money in their account through the application by
login into the system. Customer should enter user-Id and password into the login page and then
click on sign in button. Now, various services will appear on screen from which user must click
on “Cash Deposit” button and then, new page will appear on screen to fill the required details for
depositing money.

7.Balance Enquiry Module:-

Description- Existing customer can see their account balance through the application by login
into the system. Customer should enter user-Id and password into the login page and then click
on sign in button. Now, various services will appear on screen from which user must click on
“Balance Enquiry” button and then existing account balance will appear on screen.

8. Logout Module:-
Description- Existing customers can logout from the system by simply clicking on logout button which
was already login into the system.

Modules For Administrator:-

9. Transactions Report Module:-
Description- Administrator can see transactions report through the application by login into the
system. Administrator should enter user-Id and password into the login page and then click on
login button. Now, various services will appear on screen from which admin must click on “
Transactions Report” button and then, transactions history will appear on screen.

10. All Accounts Report Module:-

Description- Administrator can see all accounts report through the application by login into the
system. Administrator should enter user-Id and password into the login page and then click on
sign in button. Now, various services will appear on screen from which admin must click on “
All Accounts Report” button and then, report will appear on screen.

1.3 OVERVIEW OF PROPOSED SYSTEM

MENU DRIVEN: The project uses menu throughout which we can choose required options.
Menus are self-explanatory, as they are very easy to use and user can go to any other web page
using the menu.

3
2. USER CONFIRMATION: Whenever the user tries to delete or edit the data, the system
asks for the confirmation. This is used to avoid the accidental changes to the database. A
confirmation is also provided for the exit of the application.

3. GRAPHICAL USER INTERFACE: User is provided with a graphical interface in which

user can select from various options and can perform desired operations with perfect
understanding of the menu selected.

1.4 BUSINESS CONTEXT

Existing banking system is a manual system, which leads to a number of problems in
maintaining proper records. These are:

1. PAPER WORK: All the activities that are performed by Management involve a lot of
paper work involving register consultations and entries. A separate file has to be maintained for
each kind of activity and for different periods of time.
2. TIME CONSUMPTION:A lot of time is consumed in referencing the registers involved
for particular activities and a lot of computation as well as report verification activity is also
paper based and time consuming.

3. COMPLEXITY: Complexity of information handling and the gathering and

determination of information is usually the most difficult problem faced.

4. REDUNDANCY: Maintaining separate files for each department can lead to duplication
of data present in files. This can lead to:

a) Inconsistencies

b) Update anomalies

c) Decentralization problems

5. HUMAN ERRORS: Human kind of errors may be generated in typing errors and slow
arithmetic calculations, fatigue and boredom.

6. ILLEGAL ACCESS: The security of a lot of documents, which are paper, based if
difficult may be in terms of illegal access or manipulation by malicious personals either
intentionally or by accident.

4
 Objective of Bank Management System
• To allow only authorized user (Bank Employee) to access various functions
available in the system.
• Open any account wanted by the user.
• Reduce clerical work as most of the work done by computer.
• Provide greater speed & reduced time consumption.
• To increase the number of account and customer.
• This will reduced the manual workload and give information instantly. The
software will maintain the list of A/C and customer record and Transaction
record.

• The software will be user friendly so that even a beginner can operate the
package and thus maintain the status of A/C, do the transaction and
maintain balance status easily.
• The Project Banking system has been made to automate the Banking
system being followed by a banking company that deals in current account
with or without check facility.

Functionalities provided by Bank

Management System are as follow :
• Provides the searching facilities based on various factor such as account

customer , user-id and email-id.

• Bank Management System also manage the balance detail for transaction

Details, banking detail, accounts.

• It tracks all the information of bank, balance, transaction etc  Manager the
information of bank.
• Show the information and description of the account customer.
• To increase efficiency of manage the accounts of bank.
• It deals with monitoring the information and transaction of transaction.
• Manage the information of transaction.

5
 System Analysis
System analysis is a process of gathering and interpreting facts, diagnosing problems and the
information about the Bank Management System to recommend improvements on the system. It
is problem solving activity that requires intensive communication between the system users and
system developers. System analysis or study is an important phase of any system developments
process. The system is studied to the minutest detail and analyzed. The system analyst plays the
role of the interrogator and dwells deep into the working of the present system. The system is
viewed as a whole and the input to the system are identified. The outputs from the organizations
are traced to the various processes, system analysis is b concerned with becoming aware of the
problems , identifying the relevant and decisional variables , analyzing and synthesizing the
various factors and determining an optimal or at least a satisfactory solution or program of
action. A detailed study of the process must be made by various techniques like
interview ,questionnaires etc. the data collected by these sources must be scrutinized to arrive to
a conclusion. The conclusion is an understanding of how the system functions. This system is
called the existing system. Now the existing system is subjected to close study and problems
areas are identified. The designers now function as a problem solver and try to sort out the
difficulties that the enterprise faces. The solutions are given as proposals. The proposal is than
weighed with the existing system analytically and the best one is selected. The proposal is
presented to the user for an endorsement by the user. The proposal is reviewed on user request
and suitable changes are made. This is loop that ends as soon as the user is satisfied with
proposal. Preliminary study is the process of gathering and interpreting facts, using the
information for further studies on the system. Preliminary study is problem solving activity that
requires intensive communication between the system users and system developers. It does
various feasibility studies. In these studies a rough figure of the system activities can be
obtained, from which the decision about the strategies to be followed for effective system study
and analysis can be taken.

Existing system of Bank Management System

Existing system is the traditional banking, where customers have to go through the long queue,
time wasted and still wouldn’t have access to efficient and effective banking system

The developed system is an innovation in the area of private banking. In the existing system the
no. of staff required for completing the work is more, while the new system requires lesser staffs
generally.
The data entry process requires the data on the paper, which is then feed into the application by
the operator while doing so; the data entry operator has to look into the paper again &again and
6
thus the chances of in accuracies in the typed contents increases. Also the process includes
higher transportation cost, increased handling cost, more time delays, low accuracy, more usage
of resources like registers, books, papers, etc.

• Lack of security of data.

• More man power.
• Time consuming.
• Consumers large volume of pare work.
• Needs manual calculations.
• No direct role for the higher officials.

Proposed system of Bank Management System :

The aim of process system is to develop a system of improved facilities. The proposed system
can overcome all the limitations of the existing system. The system provided security and
reduces the manual world. Hence the requirement is to develop a system that minimizes all these
overheads included while giving the maximum output for the organization.

The basis for the project is to develop a fully automated banking system that includes depositing
of amount, withdrawal of amount and exporting the outcome back to the client while considering
all the tools and facilities than a client may need for efficient and effective output.
• Security of data.
• Ensure data accuracy`s.
• Proper control of the higher officials.
• Minimize manual data entry.
• Minimum time needed for the various processing.
• Greater efficiency.
• Better service.
• User friendliness and interactive.

Benefits of the system

• quick, authenticated access to accounts via the desktop.

• Easily scalable to grow with changing system requirement.

• Enterprise wide access to information.

• Improved information security, restricting unauthorized access.

7
 • Minimize Storage Space

In manual system, much storage space for data files is required so to overcome this problem, on
automated well managed database is developed for saving storage space. This s/w saves space
and stores information efficiently. It ends the burden of having large manual filing storage
system.

Banking System can be used extensively

• Withdrawal of amount by the client.

• Deposition of amount by the client.

• Faster balance enquiry

There are three classes of items to be defined:

Data element: smallest unit of data.

Data structure: group of data element handled as a unit.

Data flow and data stores: temporary location of data and permanent location of data.

1. Decision tree: -A decision tree is a diagram that presents condition and actions
sequentially. It is a method of showing relationship of each condition and its
permissibleactions.3. Decision table: -A d e c i s i o n t a b l e i s a t a b l e o f contingencies for
defining a
problem and actions to be taken single representation of the relationship between conditions and
actions

2. Decision table: -A decision table is a table of contingencies for defining a

problem and actions to be taken single representation of the relationship between
conditions and actions.

Following are some rules, which define the construction of data A

dictionary entries:
• Words should be define to understand for what they need and not the
variable need by which the may be described in the program.
8
 • Each word must be unique .we cannot have two or more definition of the
same client.
• Aliases or synonyms are allowed when two or more enters show the same
meaning. For example a vendor number may also be called as customer
number.
• self-defining word should not be decomposed .it means that the reduction of
any information in to sub part should be done.

Software Required:

The project is implemented in Core Java as it provides the implementation of awt package that are used
to connect distinct applications, hence the software’s required in the creation and execution of the
project are JAVA JDK 1.7 .As we know JAVA is a platform independent language so this software runs
with JRE environment on any desired platform i.e. Linux ,windows 9x, XP, or 2000 or any operating
system.

Hardware Required:

As the project involve database, its hardware requirements are minimal. Any System with Pentium P2
or above processor, 32MB RAM, 1GB Hard Disk, a LAN Card, and a CDROM is sufficient. Its network
based software so computers connected with any kind of mode (wireless, LAN connected etc) will suit its
requirements. . . . It can also be run on a single machine for its demo use.

9
Software requirement specification
The software requirements specification is a produced at the culmination of
the a task. The function and performance allocated to software as a part of
system engineering are refined by establishing a complete information
description , a detailed functional and behavioral ,an indication of performance
requirements and design constraints, appropriate validation criteria and other
data pertinent to requirements.

The proposed system has the following requirements:

• System needs store information about new entry of accounts.

• System needs to help the internal staff to keep information of bank and
find them as per various queries.
• System need to maintain quantity record.
• System need to keep the record of customer.
• System need to update and delete the record.
• System also needs a search area.
• It also needs a security to prevent data.

The reason behind it is that there is lot of information to be maintained and

have to be kept in mind while running the business .for this reason we have
provided features present stem is partially automated(computerized) , actually
existing system is quite; abprious as one has to enter same information at three
different places.

Following points should be well considered:

• Documents and reports that must be provided by the new system, there
can also be few report , which can help management in decision making
and cost controlling, but since these report do not get required
attention, such kind of reports and information were also identified and
given required attention.
• Details of the information needed for each document and report.
• The required frequency and distribution for each document and report.

10
Technologies and Requirements

● Front End: JAVA JDK 1.7

● Programming Language: JAVA

11
 ● Back End: MySQL Non-functional

Requirements
• Secure access of require data.
• 24X7 availability
• user friendly
• Intelligent user interfaces

powerful language. Not even a single language is idle to this feature but java is
closer to this feature. The programs written on one platform can run on any
platform provided the platform must have the JVM.

Simple: There are various features that make the java as a simple language.
Programs are easy to write and debug because java does not use the pointers
explicitly. It is much harder to write the java programs that can crash the system
but

Dynamic: While executing the java program the user can get the required files dynamically
from a local drive or from a computer thousands of miles away from the user just by connecting
with the Internet.

Secure: Java does not use memory pointers explicitly. All the programs in java are run under
an area known as the sand box. Security manager determines the accessibility options of a class
like reading and writing a file to the local disk. Java uses the public key encryption system to
allow the java applications to transmit over the internet in the secure encrypted form. The byte
code Verifier checks the classes after loading.

Performance: Java uses native code usage, and lightweight process called threads. In the
beginning interpretation of byte code resulted the performance slow but the advance version of
JVM uses the adaptive and just in time compilation technique that improves the performance.

12
Multithreaded: Java is also a multithreaded programming language. Multithreading means
a single program having different threads executing independently at the same time. Multiple
threads execute instructions according to the program code in a process or a program.
Multithreading works the similar way as multiple processes run on one computer.
Multithreading programming is a very interesting concept in Java. In multithreaded programs not
even a single thread disturbs the execution of other thread. Threads are obtained from the pool of
available ready to run threads and they run on the system CPUs. This is how Multithreading
works in Java which you will soon come to know in details in later chapters.

Interpreted: We all know that Java is an interpreted language as well. With an interpreted
language such as Java, programs run directly from the source code. The interpreter program
reads the source code and translates it on the fly into computations. Thus, Java as an interpreted
language depends on an interpreter program.
Architecture Neutral: The term architectural neutral seems to be weird, but yes Java is
an architectural neutral language as well. The growing popularity of networks makes developers
think distributed. In the world of network it is essential that the applications must be able to
migrate easily to different computer systems. Not only to computer systems but to a wide variety
of hardware architecture and operating system architectures as well. The Java compiler does this
by generating byte code instructions, to be easily interpreted on any machine and to be easily
translated into native machine code on the fly. The compiler generates an architecture-neutral
object file format to enable a Java application to execute anywhere on the network and then the
compiled code is executed on many processors, given the presence of the Java runtime system.
Hence Java was designed to support applications on network. This feature of Java has thrived the
programming language.

ABOUT : JDK
The Java Development Kit (JDK) is a Sun Microsystems product aimed at Java developers.
Since the introduction of Java, it has been by far the most widely used Java SDK. On 17
November 2006, Sun announced that it would be released under the GNU General Public
License (GPL), thus making it free software. This happened in large part on 8 May 2007[1] and
the source code was contributed to the Open JDK.

The primary components of the JDK are a selection of programming tools, including:

13
 • Java – The loader for Java applications. This tool is an interpreter and can interpret the
class files generated by the javac compiler. Now a single launcher is used for both
development and deployment. The old deployment launcher, jre, is no longer provided
with Sun JDK.
• javac – The compiler, which converts source code into Java bytecode
• Jar – The archiver, which packages related class libraries into a single JAR file. This tool
also helps manage JAR files.
• javadoc – The documentation generator, which automatically generates documentation
from source code comments
• jdb – The debugger
• javap – The class file disassembler
• Appletviewer – This tool can be used to run and debug Java applets without a web
browser.
• javah – The C header and stub generator, used to write native methods  Extcheck –
This utility can detect JAR-file conflicts.
• apt – The annotation processing tool
• jhat – (Experimental) Java heap analysis tool
• Jstack – (Experimental) This utility prints Java stack traces of Java threads.
• jstat – (Experimental) Java Virtual Machine statistics monitoring tool
• jstatd – (Experimental) jstat daemon
• Jinfo – (Experimental) This utility gets configuration information from a running Java
process or crash dump.
• jmap – (Experimental) This utility outputs the memory map for Java and can print shared
object memory maps or heap memory details of a given process or core dump.
• idlj – The IDL-to-Java compiler. This utility ge nerates Java bindings from a given
IDL file.
• policy tool – The policy creation and management tool, which can determine policy for a
Java runtime, specifying which permissions are available for code from various sources
• VisualVM – visual tool integrating several command line JDK tools and lightweight
performance and memory profiling capabilities

The JDK also comes with a complete Java Runtime Environment, usually called a private
runtime. It consists of a Java Virtual Machine and all of the class libraries that will be present in
the production environment, as well as additional libraries only useful to developers, such as the
internationalization libraries and the IDL libraries.

5.3 DATA FLOW DIAGRAMS:

A data flow diagram is graphical tool used to describe and analyze movement of data through a
system. These are the central tool and the basis from which the other components are developed.
14
The transformation of data from input to output, through processed, may be described logically
and independently of physical components associated with the system. These are known as the
logical data flow diagrams. The physical data flow diagrams show the actual implements and
movement of data between people, departments and workstations.

15
 1-Sign up Module:

Sign up- Info 1.1 Verify data 1.2

Sign up Verification

Valid User

Transaction

Update
1.3

processing
signup
sign - up

16
 2-Sign in Module

Customer Sign in
2.1

Access check data

Authenticat
signup
ion 2.2

Services

2.3

Enter user-id &

17
Screenshot

18
19
20
 Use Case Diagram
Bank Management System

Sign-up
All Accounts

Report

Sign -in

Transactions
Change
Passwor Reports
d

Forgot
Customer Passwor Update
d Account

Deposit

Admin
Delete
Account

Withdraw

Balance
Enquiry

21
 Modules Description
1. Sign up Module:
Description- New customer can sign up in to the system. New customer should enter personal
details and password in the registration form and then click on “submit” button. A new account
will make in the system.

2. Sign in Module:-
Description- Existing customer must have user-id and password to login into the system.
Customer should enter user-id and password and click on sign in button for login into the
system.

3. Change Password Module:-

Description- Existing customer can change their existing password with new password through
the application by login into the system. Customer should enter user-Id and password into the
login page and then click on sign in button. Now, various services appear on screen from which
user must click on “Change Password” button. Now, enter the new password and then click on
“Set Password” button for reset the password.

4. Forgot Password Module:- Description- If existing customer forgot his/her

password then, customer can retrieve their password by simply clicking on “Forgot
Password” .Now, new page will appear on screen where he/she can fill user-id and email-id
which is linked to the account. In this way, we can retrieve their password.

5. Cash Withdraw Module:-

Description- Existing customer can withdraw money from their account through the application
by login into the system. Customer should enter user-Id and password into the login page and
then click on sign in button. Now, various services will appear on screen from which user must
click on “Cash Withdraw” button and then, new window will appear on screen to fill the required
details for withdrawing money.

6. Cash Deposit Module:-

Description- Existing customer can deposit money in their account through the application by
login into the system. Customer should enter user-Id and password into the login page and then
click on sign in button. Now, various services will appear on screen from which user must click

22
on “Cash Deposit” button and then, new page will appear on screen to fill the required details for
depositing money.

7.Balance Enquiry Module:-

Description- Existing customer can see their account balance through the application by login
into the system. Customer should enter user-Id and password into the login page and then click
on sign in button. Now, various services will appear on screen from which user must click on
“Balance Enquiry” button and then existing account balance will appear on screen.

8. Logout Module:-
Description- Existing customers can logout from the system by simply clicking on logout button
which was already login into the system.

Modules For Administrator:-

9. Transactions Report Module:-
Description- Administrator can see transactions report through the application by login into the
system. Administrator should enter user-Id and password into the login page and then click on
login button. Now, various services will appear on screen from which admin must click on “
Transactions Report” button and then, transactions history will appear on screen.

10. All Accounts Report Module:-

Description- Administrator can see all accounts report through the application by login into the
system. Administrator should enter user-Id and password into the login page and then click on
sign in button. Now, various services will appear on screen from which admin must click on “
All Accounts Report” button and then, report will appear on screen.

11. Update Account Module:-

Description- Administrator can update accounts details through the application by login into the
system. Administrator should enter user-Id and password into the login page and then click on
sign in button. Now, various services will appear on screen from which admin must click on
“Update Account” button and then, update account page will appear on screen.

12. Delete Account Module:-

Description- Administrator can delete any account through the application by login into the
system. Administrator should enter user-Id and password into the login page and then click on
login button. Now, various services will appear on screen from which admin must click on
“Delete Account” button and then, delete account page will appear on screen

23
 Coding
Signin Module:-
import java.awt.*;

import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

class Login extends JFrame implements ActionListener

{
JLabel l1,back,l2,l3;
JTextField tf1;
JPasswordField pf2;
JButton b1,b2,b3;
Transcations o=null;
TranscationsAdmin o1=null;
Login()
{

setFont(new Font("System", Font.BOLD, 22));

Font f = getFont();
setTitle("AUTOMATED TELLER MACHINE");

setLayout(null);

24
ImageIcon icon=new ImageIcon("index2.jpg");
back=new JLabel(icon); setSize(1500,1500);
back.setBounds(0,0,2000,2000); add(back);

l1 = new JLabel("WELCOME TO SBI");

l1.setFont(new Font("Osward", Font.BOLD, 38));

l2 = new JLabel("Card No:");

l2.setFont(new Font("Raleway", Font.BOLD, 28));

l3 = new JLabel("PIN:");
l3.setFont(new Font("Raleway", Font.BOLD, 28));

tf1 = new JTextField(15);

pf2 = new JPasswordField(15);
b1 = new JButton("SIGN IN");
b1.setBackground(Color.BLACK);
b1.setForeground(Color.WHITE);

b2 = new JButton("SIGN UP");

b2.setBackground(Color.BLACK);
b2.setForeground(Color.WHITE);

b3 = new JButton("FORGET");
b3.setBackground(Color.BLACK);
b3.setForeground(Color.WHITE);

setLayout(null);

l1.setBounds(175,50,450,200);
back.add(l1);

l2.setBounds(125,150,375,200);
back.add(l2);

l3.setBounds(125,225,375,200);
back.add(l3);

tf1.setFont(new Font("Arial", Font.BOLD, 14));

tf1.setBounds(300,235,230,30);
back.add(tf1);

pf2.setFont(new Font("Arial", Font.BOLD, 14));

pf2.setBounds(300,310,230,30);
back.add(pf2);

25
 b1.setFont(new Font("Arial", Font.BOLD, 14));
b1.setBounds(300,400,100,30);
back.add(b1);

b2.setFont(new Font("Arial", Font.BOLD, 14));

b2.setBounds(430,400,100,30);
back.add(b2);

b3.setFont(new Font("Arial", Font.BOLD, 14));

b3.setBounds(300,450,230,30);
back.add(b3);

b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
getContentPane().setBackground(Color.WHITE);

setSize(750,750);
setLocation(500,200);
setVisible(true);

}
public void actionPerformed(ActionEvent ae){

Connection can=null;
try

Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e1)
{
System.out.println("error :"+e1);
}
try
{

can=DriverManager.getConnection("jdbc:mysql://localhost:3306/bankdetail","root","");

}
catch(Exception e2)
{
System.out.println("error :"+e2);

26
}

if(ae.getSource()==b1)

try

String un=tf1.getText();

String pw=pf2.getText();

PreparedStatement pstml=can.prepareStatement("select * from signup where custid=? and

pin=?");

pstml.setString(1,un);
pstml.setString(2,pw);

ResultSet rs=pstml.executeQuery();

if(rs.next())

{
String srole=rs.getString("role");

JOptionPane.showMessageDialog(null,"Welcome "+un);

if(srole.equals("user"))
o=new Transcations(un);

else
o1=new TranscationsAdmin();

else

JOptionPane.showMessageDialog(null,"invalid user name or password");

27
 }

catch(Exception ax)

System.out.print("error"+ae);

else if (ae.getSource()==b2)

setVisible(false);

Signup o=new Signup();

else if(ae.getSource()==b3)

setVisible(false);

ForgotPass obj=new ForgotPass();

public static void main(String[] s)

JFrame frame=new JFrame();

new Login();

28
}

Sign-up Module:-
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.*;
class Signup extends JFrame implements ActionListener
{

JLabel l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12,back;
JTextField t1,t2,t3,t4,t5,t6,t7,t8;
JRadioButton r1,r2,r3,r4;
JButton b1,b2,b3;
ButtonGroup bg1,bg2;

Signup()
{

setFont(new Font("System", Font.BOLD, 22));

Font f = getFont();
FontMetrics fm = getFontMetrics(f);
setTitle("NEW ACCOUNT APPLICATION FORM");

setLayout(null);
ImageIcon icon=new ImageIcon("index2.jpg");
back=new JLabel(icon); setSize(1500,1500);
back.setBounds(0,0,2000,2000);
add(back);

l1 = new JLabel("APPLICATION FORM NO. ");

29
 l1.setFont(new Font("Raleway", Font.BOLD, 38));

l2 = new JLabel(" Personal Details");

l2.setFont(new Font("Raleway", Font.BOLD, 22));

l3 = new JLabel("customer id:");

l3.setFont(new Font("Raleway", Font.BOLD, 20));

l4 = new JLabel("Pin:");
l4.setFont(new Font("Raleway", Font.BOLD, 20));

l5 = new JLabel("name:");
l5.setFont(new Font("Raleway", Font.BOLD, 20));

l6 = new JLabel("Father_name:");
l6.setFont(new Font("Raleway", Font.BOLD, 20));

l7 = new JLabel("date:");
l7.setFont(new Font("Raleway", Font.BOLD, 20));

l8 = new JLabel("gender:");
l8.setFont(new Font("Raleway", Font.BOLD, 20));

l9 = new JLabel("email:");
l9.setFont(new Font("Raleway", Font.BOLD, 20));

l10 = new JLabel("marital_status:");

l10.setFont(new Font("Raleway", Font.BOLD, 20));

l11 = new JLabel("pincode:");

l11.setFont(new Font("Raleway", Font.BOLD, 20));

l12 = new JLabel("Address:");

l12.setFont(new Font("Raleway", Font.BOLD, 20));

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

t8 = new JTextField();
t8.setFont(new Font("Raleway", Font.BOLD, 14));

b1= new JButton("SUBMIT"); b2= new

JButton("BACK"); b1.setFont(new
Font("Raleway", Font.BOLD, 14));
b1.setBackground(Color.BLACK);
b1.setForeground(Color.WHITE); b2.setFont(new
Font("Raleway", Font.BOLD, 14));
b2.setBackground(Color.BLACK);
b2.setForeground(Color.WHITE);

b3= new JButton("Search");

b3.setFont(new Font("Raleway", Font.BOLD, 14));
b3.setBackground(Color.BLACK);
b3.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.WHITE);

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

bg1=new ButtonGroup();
bg1.add(r1);

31
 bg1.add(r2);

bg2=new ButtonGroup();
bg2.add(r3);
bg2.add(r4);

setLayout(null);
l1.setBounds(140,20,600,40);
back.add(l1);

l2.setBounds(290,70,600,30);
back.add(l2);

l3.setBounds(100,140,100,30);
back.add(l3);

t1.setBounds(300,140,400,30);
back.add(t1);

l4.setBounds(100,190,200,30);
back.add(l4);

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

l5.setBounds(100,240,200,30);
back.add(l5);
t3.setBounds(300,240,400,30);
back.add(t3);

l6.setBounds(100,290,200,30);
back. add(l6);
t4.setBounds(300,290,400,30);
back.add(t4);

l7.setBounds(100,340,200,30);
back.add(l7); t5.setBounds(300,340,400,30);
back.add(t5);

l8.setBounds(100,390,200,30);
back.add(l8);

32
 r1.setBounds(300,390,60,30);
back.add(r1);

r2.setBounds(450,390,90,30);
back.add(r2);

catch(Exception ax)

System.out.print("error"+ae);

}
}
else if(ae.getSource()==b2)

Login o=new Login();

else if(ae.getSource()==b3)

{
System.out.println("custid :"+un);
try
{

pstml=con.prepareStatement("select * from signup where custid=?");

pstml.setString(1,un);

rs=pstml.executeQuery();

if(rs.next())
{

JOptionPane.showMessageDialog(null,"Account detail already

exists accept another");
33
 }

}
catch(Exception ex)
{
System.out.println(" Error in creating account");
}
}
}

public static void main(String[] args)

{
Signup o=new Signup();
}

Forgot Password Module:-

import javax.swing.*;
import java.awt.event.*;

import java.sql.*;

import java.awt.*;
class ForgotPass extends JFrame implements ActionListener

JLabel l1,l2,l3;
JTextField tf;

JPasswordField pf;

JButton b1,b2,b3;

ForgotPass()

setFont(new Font("System", Font.BOLD, 10));

34
 Font f = getFont();
setTitle("ForgotPass");

setLayout(null);

l1=new JLabel("Forgot Password form");

l1.setFont(new Font("Osward", Font.BOLD, 24));

l2=new JLabel("Customer Id"); l2.setFont(new

Font("Osward", Font.BOLD, 24)); l3=new
JLabel("E-mail id"); l3.setFont(new
Font("Osward", Font.BOLD, 24));

tf=new JTextField(20);

pf=new JPasswordField(20);

b1=new JButton("submit");
b1.setBackground(Color.BLACK);
b1.setForeground(Color.WHITE);

b2=new JButton("Cancel");
b2.setBackground(Color.BLACK);

Transaction Module:-
import java.awt.*; import
java.awt.event.*; import
javax.swing.*;
import java.sql.*;

class Transcations extends JFrame implements ActionListener{

String un;
JLabel l1;
JButton b1,b2,b4,b5,b6,b7;
Deposit dep;
Withdrawl with;
Fastcash fast;
Pin pin;
35
BalEnq be; Balance
ba;
public void actionPerformed(ActionEvent ae)
{

if(ae.getSource()== b1)
dep=new Deposit(un);

else if(ae.getSource()==b2)

with=new Withdrawl(un);
else if(ae.getSource()==b5)

pin=new Pin(un);

else if(ae.getSource()==b4)

ba=new Balance(un);

else if(ae.getSource()==b6)
be=new BalEnq(un);

else if(ae.getSource()==b7)

Change Password Module:-

import java.awt.*; import
java.awt.event.*; import
javax.swing.*;
import java.sql.*;

class Pin extends JFrame implements ActionListener{

JPasswordField t1,t2,t3;
JButton b1,b2;
JLabel l1,l2,l3,l4;
String un;
Pin()
{
}

36
 Pin(String tempun)
{
un=tempun;

setFont(new Font("System", Font.BOLD, 22));

Font f = getFont();

setTitle("PIN CHANGE");

l1 = new JLabel("CHANGE YOUR PIN");

l1.setFont(new Font("System", Font.BOLD, 35));

l2 = new JLabel("Current PIN:");

l2.setFont(new Font("System", Font.BOLD, 22));

l3 = new JLabel("New PIN:");

l3.setFont(new Font("System", Font.BOLD, 22));

l4 = new JLabel("Re-Enter New PIN:");

l4.setFont(new Font("System", Font.BOLD, 22));

t1 = new JPasswordField();
t1.setFont(new Font("Raleway", Font.BOLD, 22));

t2 = new JPasswordField();
t2

Cash Withdraw Module:-

import java.awt.*; import
java.awt.event.*; import
javax.swing.*; import
java.sql.*;
import java.util.*;

class Withdrawl extends JFrame implements ActionListener{

JTextField t1,t2,t3;
JButton b1,b2;
JLabel l1,l2,l3;
String un;
Withdrawl()
{
}

37
 Withdrawl(String tempun)
{ un=tempun;
setFont(new Font("System", Font.BOLD, 22));
Font f = getFont();
setTitle("Withdrawl");

l1 = new JLabel("Account no");

l1.setFont(new Font("System", Font.BOLD, 35));

l2 = new JLabel(" cash");

l2.setFont(new Font("System", Font.BOLD, 35));

l3 = new JLabel("date");
l3.setFont(new Font("System", Font.BOLD, 35));

t1 = new JTextField();
t1.setFont(new Font("Raleway", Font.BOLD, 22));

t2 = new JTextField();
t2.setFont(new Font("Raleway", Font.BOLD, 22));

t3 = new JTextField();
t3.setFont(new Font("Raleway", Font.BOLD, 22));

b1 = new JButton("Submit");
String s22=t2.getText();

pstml

String s33=t3.getText();

int amt=Integer.parseInt(s22);
PreparedStatement pstml=can.prepareStatement("update signup set
balance=balance-"+amt+" where custid=? ");

pstml.setString(1,s11); int
ra=pstml.executeUpdate();
if(ra>0)

JOptionPane.showMessageDialog(null,"Transaction
Successfull");

38
 }

else

JOptionPane.showMessageDialog(null,"invalid user name or

password");

catch(Exception e)

System.out.print("error"+e);

}
else if(ae.getSource()==b2){

new Transcations().setVisible(true);
setVisible(false);
}

Cash Deposit Module:-

import java.awt.*; import
java.awt.event.*; import
javax.swing.*; import
java.sql.*;
import java.util.*;
39
class Deposit extends JFrame implements ActionListener{

JTextField t1,t2,t3;
JButton b1,b2;
JLabel l1,l2,l3;
String un;
Deposit()
{
}

Deposit(String tempun)
{
un=tempun;
setFont(new Font("System", Font.BOLD, 22));
Font f = getFont();
setTitle("DEPOSIT");

l1 = new JLabel("Account no");

l1.setFont(new Font("System", Font.BOLD, 35));

l2 = new JLabel(" cash");

l2.setFont(new Font("System", Font.BOLD, 35));

l3 = new JLabel("date"); l3.setFont(new

Font("System", Font.BOLD, 35));

t1 = new JTextField();
t1.setFont(new Font("Raleway", Font.BOLD, 22));

t2 = new JTextField();
t2.setFont(new Font("Raleway", Font.BOLD, 22));

t3 = new JTextField();
t3.setFont(new Font("Raleway", Font.BOLD, 22));

b1 = new JButton("Submit");
b1.setFont(new Font("System", Font.BOLD, 18));
b1.setBackground(Color.BLACK);
b1.setForeground(Color.WHITE);

b2 = new JButton("Back");
b2.setFont(new Font("System", Font.BOLD, 18));
b2.setBackground(Color.BLACK); b2.setForeground(Color.WHITE);
setLayout(null);

40
 l1.setBounds(100,100,300,30);
add(l1);

t1.setBounds(400,100,250,30);
add(t1);

l2.setBounds(100,180,800,30);
add(l2);

t2.setBounds(400,180,250,30);
add(t2);

l3.setBounds(100,260,250,30);
add(l3);

t3.setBounds(400,260,250,30);
add(t3);

b1.setBounds(260,380,125,50);
add(b1);

b2.setBounds(415,380,125,50);
add(b2);

b1

Balance Enquiry Module:-

import java.awt.*; import
javax.swing.*;
import java.sql.*;

class Balance extends Canvas

{
String un;
Balance(String custid)
{
un=custid;
JFrame frame = new JFrame("Balance Eqnuiry");
setSize(1200, 1200);
frame.add(this); frame.pack();
frame.setVisible(true);
41
 }
Balance()
{}

public static void main(String[] args) {

new Balance();
}

public void paint(Graphics g) {

Connection con=null;
Statement stmt=null;
ResultSet rs=null;

int y=100;
try
{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/bankdetail","root","");
//here sonoo is database name, root is username and password
stmt=con.createStatement();
}
catch(Exception e1){ System.out.println(e1);}

Admin Module:-
import java.awt.*; import
java.awt.event.*; import
javax.swing.*;
import java.sql.*;

class TranscationsAdmin extends JFrame implements ActionListener{

JLabel l1;
JButton b1,b2,b7,b4;

TranscationsAdmin()
{

setFont(new Font("System", Font.BOLD, 22));

Font f = getFont();

42
 setTitle("TRANSACTION");

l1 = new JLabel("Admin page");

l1.setFont(new Font("System", Font.BOLD, 38));

b1 = new JButton("Account Manage");

b1.setFont(new Font("System", Font.BOLD, 18));
b1.setBackground(Color.BLACK);
b1.setForeground(Color.WHITE);

b2 = new JButton("Report A/C");

b2.setFont(new Font("System", Font.BOLD, 18));
b2.setBackground(Color.BLACK);
b2.setForeground(Color.WHITE);

b4 = new JButton("Report Balance");

b4.setFont(new Font("System", Font.BOLD, 18));
b4.setBackground(Color.BLACK);
b4.setForeground(Color.WHITE);

b7 = new JButton("EXIT"); b7.setFont(new

Font("System", Font.BOLD, 18));
b7.setBackground(Color.BLACK);
b7.setForeground(Color.WHITE);

Account Manage Module:-

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*; import
java.util.*;
class AccountManage extends JFrame implements ActionListener
{

JLabel l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12;
JTextField t1,t2,t3,t4,t5,t6,t7,t8;
JRadioButton r1,r2,r3,r4;
JButton b1,b2,b3,b4,b5;
ButtonGroup bg1,bg2;
43
 AccountManage()
{

setFont(new Font("System", Font.BOLD, 22));

Font f = getFont();
FontMetrics fm = getFontMetrics(f);
setTitle("Admin Modification page");

l1 = new JLabel("Admin Modification page ");

l1.setFont(new Font("Raleway", Font.BOLD, 38));

l2 = new JLabel(" Personal Details");

l2.setFont(new Font("Raleway", Font.BOLD, 22));

l3 = new JLabel("customer id:");

l3.setFont(new Font("Raleway", Font.BOLD, 20));

l4 = new JLabel("Pin:");
l4.setFont(new Font("Raleway", Font.BOLD, 20));

l5 = new JLabel("name:");
l5.setFont(new Font("Raleway", Font.BOLD, 20));
l

Transactions Reports Module:-

import java.awt.*; import
javax.swing.*;
import java.sql.*;

class BalEnq extends Canvas

{
String un;
BalEnq(String custid)
{
un=custid;
JFrame frame = new JFrame("Balance Eqnuiry");

44
 setSize(1200, 1200);
frame.add(this); frame.pack();
frame.setVisible(true); }
BalEnq()
{}

public static void main(String[] args) {

new BalEnq();
}

public void paint(Graphics g) {

45
• For Java installation
https://www.java.com/en/download/

• For MySQL Database installation

http://www.mysql.com/index.html

 Reference websites
www.javatpoint.com
www.w3schools.com
http://www.tutorialspoint.com/java/index.htm

 Reference Books
Thinking in java
OCJP Certified Programmer for Java
Learn Java in Easy Steps
Complete reference Java

46
47