1 ONLINE BANKING

ONLINE BANKING

A Project Report

Submitted in the partial fulfillment for the award of BBaacchheelloorr ooff TTeecchhnnoollooggyy

IInn

CCoommppuutteerr SScciieennccee ampamp EEnnggiinneeeerriinngg

Submitted to Dr APJ ABDUL KALAM TECHNICAL UNIVERSITY

LUCKNOW (UP)

Submitted by

AARRPPIITTAA SSRRIIVVAASSTTAAVVAA ((11331166331100001122))

AASSHHWWAANNII SSIINNGGHH ((11331166331100001144))

Under the Guidance of

SShhiivvaamm SSrriivvaassttaavvaa

Department of Computer Science amp Engineering

Dr MC SAXENA GROUP OF COLLEGES

LUCKNOW

NOV-2016

2 ONLINE BANKING

TABLE OF CONTENTS

Chapter 1 INTRODUCTION 5-7

11 Introduction 12 Objectives 13 Scope

Chapter 2 PROJECT CATEGORY 8-10

21 JSP (Java Server Pages)

22 Servlet

23 RDBMS

Chapter 3 SYSTEM ANALYSIS 11-16

31 Project Scheduling

311 PERT Chart

312 Gantt Chart

32 Software Requirement Specifications (SRS)

33 UML(Unified Modelling Language) Diagrams

Chapter 4 SYSTEM DESIGN 17-21

41 Modularization Details

42 Database Design

Chapter 5 TESTING 22

51 Testing Techniques

511 Unit Testing

512 Integration Testing

Chapter 6 OUTPUT SCREEN 23-27

61 Output Screen

611 indexjsp

612 loginjsp

613 newaccountjsp

3 ONLINE BANKING

614 depositjsp

615 withdrawjsp

616 transferjsp

617 passbookjsp

Chapter 7 LIMITATIONS AND FUTURE WORK 28

71 Limitations

72 Future Scope and Further Enhancements

REFERENCES 29

4 ONLINE BANKING

ldquoONLINE

BANKINGrdquo

5 ONLINE BANKING

Chapter 1 INTRODUCTION

11 Introduction

Online banking also known as internet banking e-banking or virtual banking is an electronic

payment system that enables customers of a bank or other financial institution to conduct a

range of financial transactions through the financial institutions website The online banking

system will typically connect to or be part of the core banking system operated by a bank and

is in contrast to branch banking which was the traditional way customers accessed banking

services

The main goal of the system is to automate the process carried out in the bank with improved

performance an realize the vision of paperless banking

PROBLEM STATEMENTS

This banking process consists of five divisions There are customer details creating a new

account withdrawing money transferring money to the another account and depositing

money as well as customer can see his passbook after doing various transactions

To create a new account verifies the rules and after successful creation of the account he get

an account number and OTP (One Time Password) from a database To withdraw money

checks the balance in our account and then get the money To deposit money enter the

account number and give the account to be deposited Customer can also close his account

permanently or deactivate his account on the temporary basis according to his requirement

6 ONLINE BANKING

12 Objectives 1 To allow only authorized user to access various function and processed available in the

system

2 Reduced clerical work as most of the work done by computer

3 Provide greater speed amp reduced time consumption

4 Ensures that users can be able to open their accounts in a convenient manner at a

convenient time anytime anywhere as long as they are connected to the internet

5 Allow for users to check their transaction and account details conveniently again anytime

anywhere

7 ONLINE BANKING

13 Scope

Banking activities are considered to be the life blood of the national Economy Without

banking services trading and business activities cannot be carried on smoothly Banks are the

distributors and protectors of liquid capital which is of vital significance to a developing

country

Efficient administration of the banking system helps in the economic Growth of the nation

Banking is useful to trade and commerce

8 ONLINE BANKING

Chapter 2 Project Category

21 JSP (Java Server Pages) JavaServer Pages (JSP) is a technology for developing web pages that support dynamic

content which helps developers insert java code in HTML pages by making use of special

JSP tags most of which start with lt and end with gt

A JavaServer Pages component is a type of Java servlet that is designed to fulfill the role of

a user interface for a Java web application Web developers write JSPs as text files that

combine HTML or XHTML code XML elements and embedded JSP actions and

commands

Using JSP you can collect input from users through web page forms present records from a

database or another source and create web pages dynamically

JSP tags can be used for a variety of purposes such as retrieving information from a

database or registering user preferences accessing JavaBeans components passing control

between pages and sharing information between requests pages etc

9 ONLINE BANKING

22 Servlets Java Servlets are programs that run on a Web or Application server and act as a middle layer

between a request coming from a Web browser or other HTTP client and databases or

applications on the HTTP server

Using Servlets you can collect input from users through web page forms present records

from a database or another source and create web pages dynamically

Java Servlets often serve the same purpose as programs implemented using the Common

Gateway Interface (CGI) But Servlets offer several advantages in comparison with the

CGI-

Performance is significantly better

Servlets execute within the address space of a Web server It is not necessary to

create a separate process to handle each client request

Servlets are platform-independent because they are written in Java

Java security manager on the server enforces a set of restrictions to protect the

resources on a server machine So servlets are trusted

The full functionality of the Java class libraries is available to a servlet It can

communicate with applets databases or other software via the sockets and RMI

mechanisms that you have seen already

10 ONLINE BANKING

23 RDBMS

RDBMS stands for Relational Database Management System RDBMS is the basis for SQL

and for all modern database systems like MS SQL Server IBM DB2 Oracle MySQL and

Microsoft Access

A Relational database management system (RDBMS) is a database management system

(DBMS) that is based on the relational model as introduced by E F Codd

There are many popular RDBMS available to work with However our project uses

MySQL database for back end processiong

MySQL

MySQL is an open source SQL database which is developed by Swedish company MySQL

AB MySQL is pronounced my ess-que-ell in contrast with SQL pronounced sequel

MySQL is supporting many different platforms including Microsoft Windows the major

Linux distributions UNIX and Mac OS X

MySQL has free and paid versions depending on its usage (non-commercialcommercial)

and features MySQL comes with a very fast multi-threaded multi-user and robust SQL

database server

Features High Performance

High Availability

Scalability and Flexibility Run anything

Robust Transactional Support

Web and Data Warehouse Strengths

Strong Data Protection

Comprehensive Application Development

Management Ease

Open Source Freedom and 24 x 7 Support

11 ONLINE BANKING

Chapter 3 SYSTEM ANALYSIS

31 Project Scheduling

311 PERT Chart

S Start

A Analysis

B Design CUI

C Coding

D Testing

E Maintenance

F Design GUI

G Testing GUI

H Implementation

12 ONLINE BANKING

312 Gantt Chart

0

05

1

15

2

25

3

35

4

45

Analysis Designing Coding Testing Maintenance

No

of

Wee

ks

Processes

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

2 ONLINE BANKING

TABLE OF CONTENTS

Chapter 1 INTRODUCTION 5-7

11 Introduction 12 Objectives 13 Scope

Chapter 2 PROJECT CATEGORY 8-10

21 JSP (Java Server Pages)

22 Servlet

23 RDBMS

Chapter 3 SYSTEM ANALYSIS 11-16

31 Project Scheduling

311 PERT Chart

312 Gantt Chart

32 Software Requirement Specifications (SRS)

33 UML(Unified Modelling Language) Diagrams

Chapter 4 SYSTEM DESIGN 17-21

41 Modularization Details

42 Database Design

Chapter 5 TESTING 22

51 Testing Techniques

511 Unit Testing

512 Integration Testing

Chapter 6 OUTPUT SCREEN 23-27

61 Output Screen

611 indexjsp

612 loginjsp

613 newaccountjsp

3 ONLINE BANKING

614 depositjsp

615 withdrawjsp

616 transferjsp

617 passbookjsp

Chapter 7 LIMITATIONS AND FUTURE WORK 28

71 Limitations

72 Future Scope and Further Enhancements

REFERENCES 29

4 ONLINE BANKING

ldquoONLINE

BANKINGrdquo

5 ONLINE BANKING

Chapter 1 INTRODUCTION

11 Introduction

Online banking also known as internet banking e-banking or virtual banking is an electronic

payment system that enables customers of a bank or other financial institution to conduct a

range of financial transactions through the financial institutions website The online banking

system will typically connect to or be part of the core banking system operated by a bank and

is in contrast to branch banking which was the traditional way customers accessed banking

services

The main goal of the system is to automate the process carried out in the bank with improved

performance an realize the vision of paperless banking

PROBLEM STATEMENTS

This banking process consists of five divisions There are customer details creating a new

account withdrawing money transferring money to the another account and depositing

money as well as customer can see his passbook after doing various transactions

To create a new account verifies the rules and after successful creation of the account he get

an account number and OTP (One Time Password) from a database To withdraw money

checks the balance in our account and then get the money To deposit money enter the

account number and give the account to be deposited Customer can also close his account

permanently or deactivate his account on the temporary basis according to his requirement

6 ONLINE BANKING

12 Objectives 1 To allow only authorized user to access various function and processed available in the

system

2 Reduced clerical work as most of the work done by computer

3 Provide greater speed amp reduced time consumption

4 Ensures that users can be able to open their accounts in a convenient manner at a

convenient time anytime anywhere as long as they are connected to the internet

5 Allow for users to check their transaction and account details conveniently again anytime

anywhere

7 ONLINE BANKING

13 Scope

Banking activities are considered to be the life blood of the national Economy Without

banking services trading and business activities cannot be carried on smoothly Banks are the

distributors and protectors of liquid capital which is of vital significance to a developing

country

Efficient administration of the banking system helps in the economic Growth of the nation

Banking is useful to trade and commerce

8 ONLINE BANKING

Chapter 2 Project Category

21 JSP (Java Server Pages) JavaServer Pages (JSP) is a technology for developing web pages that support dynamic

content which helps developers insert java code in HTML pages by making use of special

JSP tags most of which start with lt and end with gt

A JavaServer Pages component is a type of Java servlet that is designed to fulfill the role of

a user interface for a Java web application Web developers write JSPs as text files that

combine HTML or XHTML code XML elements and embedded JSP actions and

commands

Using JSP you can collect input from users through web page forms present records from a

database or another source and create web pages dynamically

JSP tags can be used for a variety of purposes such as retrieving information from a

database or registering user preferences accessing JavaBeans components passing control

between pages and sharing information between requests pages etc

9 ONLINE BANKING

22 Servlets Java Servlets are programs that run on a Web or Application server and act as a middle layer

between a request coming from a Web browser or other HTTP client and databases or

applications on the HTTP server

Using Servlets you can collect input from users through web page forms present records

from a database or another source and create web pages dynamically

Java Servlets often serve the same purpose as programs implemented using the Common

Gateway Interface (CGI) But Servlets offer several advantages in comparison with the

CGI-

Performance is significantly better

Servlets execute within the address space of a Web server It is not necessary to

create a separate process to handle each client request

Servlets are platform-independent because they are written in Java

Java security manager on the server enforces a set of restrictions to protect the

resources on a server machine So servlets are trusted

The full functionality of the Java class libraries is available to a servlet It can

communicate with applets databases or other software via the sockets and RMI

mechanisms that you have seen already

10 ONLINE BANKING

23 RDBMS

RDBMS stands for Relational Database Management System RDBMS is the basis for SQL

and for all modern database systems like MS SQL Server IBM DB2 Oracle MySQL and

Microsoft Access

A Relational database management system (RDBMS) is a database management system

(DBMS) that is based on the relational model as introduced by E F Codd

There are many popular RDBMS available to work with However our project uses

MySQL database for back end processiong

MySQL

MySQL is an open source SQL database which is developed by Swedish company MySQL

AB MySQL is pronounced my ess-que-ell in contrast with SQL pronounced sequel

MySQL is supporting many different platforms including Microsoft Windows the major

Linux distributions UNIX and Mac OS X

MySQL has free and paid versions depending on its usage (non-commercialcommercial)

and features MySQL comes with a very fast multi-threaded multi-user and robust SQL

database server

Features High Performance

High Availability

Scalability and Flexibility Run anything

Robust Transactional Support

Web and Data Warehouse Strengths

Strong Data Protection

Comprehensive Application Development

Management Ease

Open Source Freedom and 24 x 7 Support

11 ONLINE BANKING

Chapter 3 SYSTEM ANALYSIS

31 Project Scheduling

311 PERT Chart

S Start

A Analysis

B Design CUI

C Coding

D Testing

E Maintenance

F Design GUI

G Testing GUI

H Implementation

12 ONLINE BANKING

312 Gantt Chart

0

05

1

15

2

25

3

35

4

45

Analysis Designing Coding Testing Maintenance

No

of

Wee

ks

Processes

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

3 ONLINE BANKING

614 depositjsp

615 withdrawjsp

616 transferjsp

617 passbookjsp

Chapter 7 LIMITATIONS AND FUTURE WORK 28

71 Limitations

72 Future Scope and Further Enhancements

REFERENCES 29

4 ONLINE BANKING

ldquoONLINE

BANKINGrdquo

5 ONLINE BANKING

Chapter 1 INTRODUCTION

11 Introduction

Online banking also known as internet banking e-banking or virtual banking is an electronic

payment system that enables customers of a bank or other financial institution to conduct a

range of financial transactions through the financial institutions website The online banking

system will typically connect to or be part of the core banking system operated by a bank and

is in contrast to branch banking which was the traditional way customers accessed banking

services

The main goal of the system is to automate the process carried out in the bank with improved

performance an realize the vision of paperless banking

PROBLEM STATEMENTS

This banking process consists of five divisions There are customer details creating a new

account withdrawing money transferring money to the another account and depositing

money as well as customer can see his passbook after doing various transactions

To create a new account verifies the rules and after successful creation of the account he get

an account number and OTP (One Time Password) from a database To withdraw money

checks the balance in our account and then get the money To deposit money enter the

account number and give the account to be deposited Customer can also close his account

permanently or deactivate his account on the temporary basis according to his requirement

6 ONLINE BANKING

12 Objectives 1 To allow only authorized user to access various function and processed available in the

system

2 Reduced clerical work as most of the work done by computer

3 Provide greater speed amp reduced time consumption

4 Ensures that users can be able to open their accounts in a convenient manner at a

convenient time anytime anywhere as long as they are connected to the internet

5 Allow for users to check their transaction and account details conveniently again anytime

anywhere

7 ONLINE BANKING

13 Scope

Banking activities are considered to be the life blood of the national Economy Without

banking services trading and business activities cannot be carried on smoothly Banks are the

distributors and protectors of liquid capital which is of vital significance to a developing

country

Efficient administration of the banking system helps in the economic Growth of the nation

Banking is useful to trade and commerce

8 ONLINE BANKING

Chapter 2 Project Category

21 JSP (Java Server Pages) JavaServer Pages (JSP) is a technology for developing web pages that support dynamic

content which helps developers insert java code in HTML pages by making use of special

JSP tags most of which start with lt and end with gt

A JavaServer Pages component is a type of Java servlet that is designed to fulfill the role of

a user interface for a Java web application Web developers write JSPs as text files that

combine HTML or XHTML code XML elements and embedded JSP actions and

commands

Using JSP you can collect input from users through web page forms present records from a

database or another source and create web pages dynamically

JSP tags can be used for a variety of purposes such as retrieving information from a

database or registering user preferences accessing JavaBeans components passing control

between pages and sharing information between requests pages etc

9 ONLINE BANKING

22 Servlets Java Servlets are programs that run on a Web or Application server and act as a middle layer

between a request coming from a Web browser or other HTTP client and databases or

applications on the HTTP server

Using Servlets you can collect input from users through web page forms present records

from a database or another source and create web pages dynamically

Java Servlets often serve the same purpose as programs implemented using the Common

Gateway Interface (CGI) But Servlets offer several advantages in comparison with the

CGI-

Performance is significantly better

Servlets execute within the address space of a Web server It is not necessary to

create a separate process to handle each client request

Servlets are platform-independent because they are written in Java

Java security manager on the server enforces a set of restrictions to protect the

resources on a server machine So servlets are trusted

The full functionality of the Java class libraries is available to a servlet It can

communicate with applets databases or other software via the sockets and RMI

mechanisms that you have seen already

10 ONLINE BANKING

23 RDBMS

RDBMS stands for Relational Database Management System RDBMS is the basis for SQL

and for all modern database systems like MS SQL Server IBM DB2 Oracle MySQL and

Microsoft Access

A Relational database management system (RDBMS) is a database management system

(DBMS) that is based on the relational model as introduced by E F Codd

There are many popular RDBMS available to work with However our project uses

MySQL database for back end processiong

MySQL

MySQL is an open source SQL database which is developed by Swedish company MySQL

AB MySQL is pronounced my ess-que-ell in contrast with SQL pronounced sequel

MySQL is supporting many different platforms including Microsoft Windows the major

Linux distributions UNIX and Mac OS X

MySQL has free and paid versions depending on its usage (non-commercialcommercial)

and features MySQL comes with a very fast multi-threaded multi-user and robust SQL

database server

Features High Performance

High Availability

Scalability and Flexibility Run anything

Robust Transactional Support

Web and Data Warehouse Strengths

Strong Data Protection

Comprehensive Application Development

Management Ease

Open Source Freedom and 24 x 7 Support

11 ONLINE BANKING

Chapter 3 SYSTEM ANALYSIS

31 Project Scheduling

311 PERT Chart

S Start

A Analysis

B Design CUI

C Coding

D Testing

E Maintenance

F Design GUI

G Testing GUI

H Implementation

12 ONLINE BANKING

312 Gantt Chart

0

05

1

15

2

25

3

35

4

45

Analysis Designing Coding Testing Maintenance

No

of

Wee

ks

Processes

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

4 ONLINE BANKING

ldquoONLINE

BANKINGrdquo

5 ONLINE BANKING

Chapter 1 INTRODUCTION

11 Introduction

Online banking also known as internet banking e-banking or virtual banking is an electronic

payment system that enables customers of a bank or other financial institution to conduct a

range of financial transactions through the financial institutions website The online banking

system will typically connect to or be part of the core banking system operated by a bank and

is in contrast to branch banking which was the traditional way customers accessed banking

services

The main goal of the system is to automate the process carried out in the bank with improved

performance an realize the vision of paperless banking

PROBLEM STATEMENTS

This banking process consists of five divisions There are customer details creating a new

account withdrawing money transferring money to the another account and depositing

money as well as customer can see his passbook after doing various transactions

To create a new account verifies the rules and after successful creation of the account he get

an account number and OTP (One Time Password) from a database To withdraw money

checks the balance in our account and then get the money To deposit money enter the

account number and give the account to be deposited Customer can also close his account

permanently or deactivate his account on the temporary basis according to his requirement

6 ONLINE BANKING

12 Objectives 1 To allow only authorized user to access various function and processed available in the

system

2 Reduced clerical work as most of the work done by computer

3 Provide greater speed amp reduced time consumption

4 Ensures that users can be able to open their accounts in a convenient manner at a

convenient time anytime anywhere as long as they are connected to the internet

5 Allow for users to check their transaction and account details conveniently again anytime

anywhere

7 ONLINE BANKING

13 Scope

Banking activities are considered to be the life blood of the national Economy Without

banking services trading and business activities cannot be carried on smoothly Banks are the

distributors and protectors of liquid capital which is of vital significance to a developing

country

Efficient administration of the banking system helps in the economic Growth of the nation

Banking is useful to trade and commerce

8 ONLINE BANKING

Chapter 2 Project Category

21 JSP (Java Server Pages) JavaServer Pages (JSP) is a technology for developing web pages that support dynamic

content which helps developers insert java code in HTML pages by making use of special

JSP tags most of which start with lt and end with gt

A JavaServer Pages component is a type of Java servlet that is designed to fulfill the role of

a user interface for a Java web application Web developers write JSPs as text files that

combine HTML or XHTML code XML elements and embedded JSP actions and

commands

Using JSP you can collect input from users through web page forms present records from a

database or another source and create web pages dynamically

JSP tags can be used for a variety of purposes such as retrieving information from a

database or registering user preferences accessing JavaBeans components passing control

between pages and sharing information between requests pages etc

9 ONLINE BANKING

22 Servlets Java Servlets are programs that run on a Web or Application server and act as a middle layer

between a request coming from a Web browser or other HTTP client and databases or

applications on the HTTP server

Using Servlets you can collect input from users through web page forms present records

from a database or another source and create web pages dynamically

Java Servlets often serve the same purpose as programs implemented using the Common

Gateway Interface (CGI) But Servlets offer several advantages in comparison with the

CGI-

Performance is significantly better

Servlets execute within the address space of a Web server It is not necessary to

create a separate process to handle each client request

Servlets are platform-independent because they are written in Java

Java security manager on the server enforces a set of restrictions to protect the

resources on a server machine So servlets are trusted

The full functionality of the Java class libraries is available to a servlet It can

communicate with applets databases or other software via the sockets and RMI

mechanisms that you have seen already

10 ONLINE BANKING

23 RDBMS

RDBMS stands for Relational Database Management System RDBMS is the basis for SQL

and for all modern database systems like MS SQL Server IBM DB2 Oracle MySQL and

Microsoft Access

A Relational database management system (RDBMS) is a database management system

(DBMS) that is based on the relational model as introduced by E F Codd

There are many popular RDBMS available to work with However our project uses

MySQL database for back end processiong

MySQL

MySQL is an open source SQL database which is developed by Swedish company MySQL

AB MySQL is pronounced my ess-que-ell in contrast with SQL pronounced sequel

MySQL is supporting many different platforms including Microsoft Windows the major

Linux distributions UNIX and Mac OS X

MySQL has free and paid versions depending on its usage (non-commercialcommercial)

and features MySQL comes with a very fast multi-threaded multi-user and robust SQL

database server

Features High Performance

High Availability

Scalability and Flexibility Run anything

Robust Transactional Support

Web and Data Warehouse Strengths

Strong Data Protection

Comprehensive Application Development

Management Ease

Open Source Freedom and 24 x 7 Support

11 ONLINE BANKING

Chapter 3 SYSTEM ANALYSIS

31 Project Scheduling

311 PERT Chart

S Start

A Analysis

B Design CUI

C Coding

D Testing

E Maintenance

F Design GUI

G Testing GUI

H Implementation

12 ONLINE BANKING

312 Gantt Chart

0

05

1

15

2

25

3

35

4

45

Analysis Designing Coding Testing Maintenance

No

of

Wee

ks

Processes

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

5 ONLINE BANKING

Chapter 1 INTRODUCTION

11 Introduction

Online banking also known as internet banking e-banking or virtual banking is an electronic

payment system that enables customers of a bank or other financial institution to conduct a

range of financial transactions through the financial institutions website The online banking

system will typically connect to or be part of the core banking system operated by a bank and

is in contrast to branch banking which was the traditional way customers accessed banking

services

The main goal of the system is to automate the process carried out in the bank with improved

performance an realize the vision of paperless banking

PROBLEM STATEMENTS

This banking process consists of five divisions There are customer details creating a new

account withdrawing money transferring money to the another account and depositing

money as well as customer can see his passbook after doing various transactions

To create a new account verifies the rules and after successful creation of the account he get

an account number and OTP (One Time Password) from a database To withdraw money

checks the balance in our account and then get the money To deposit money enter the

account number and give the account to be deposited Customer can also close his account

permanently or deactivate his account on the temporary basis according to his requirement

6 ONLINE BANKING

12 Objectives 1 To allow only authorized user to access various function and processed available in the

system

2 Reduced clerical work as most of the work done by computer

3 Provide greater speed amp reduced time consumption

4 Ensures that users can be able to open their accounts in a convenient manner at a

convenient time anytime anywhere as long as they are connected to the internet

5 Allow for users to check their transaction and account details conveniently again anytime

anywhere

7 ONLINE BANKING

13 Scope

Banking activities are considered to be the life blood of the national Economy Without

banking services trading and business activities cannot be carried on smoothly Banks are the

distributors and protectors of liquid capital which is of vital significance to a developing

country

Efficient administration of the banking system helps in the economic Growth of the nation

Banking is useful to trade and commerce

8 ONLINE BANKING

Chapter 2 Project Category

21 JSP (Java Server Pages) JavaServer Pages (JSP) is a technology for developing web pages that support dynamic

content which helps developers insert java code in HTML pages by making use of special

JSP tags most of which start with lt and end with gt

A JavaServer Pages component is a type of Java servlet that is designed to fulfill the role of

a user interface for a Java web application Web developers write JSPs as text files that

combine HTML or XHTML code XML elements and embedded JSP actions and

commands

Using JSP you can collect input from users through web page forms present records from a

database or another source and create web pages dynamically

JSP tags can be used for a variety of purposes such as retrieving information from a

database or registering user preferences accessing JavaBeans components passing control

between pages and sharing information between requests pages etc

9 ONLINE BANKING

22 Servlets Java Servlets are programs that run on a Web or Application server and act as a middle layer

between a request coming from a Web browser or other HTTP client and databases or

applications on the HTTP server

Using Servlets you can collect input from users through web page forms present records

from a database or another source and create web pages dynamically

Java Servlets often serve the same purpose as programs implemented using the Common

Gateway Interface (CGI) But Servlets offer several advantages in comparison with the

CGI-

Performance is significantly better

Servlets execute within the address space of a Web server It is not necessary to

create a separate process to handle each client request

Servlets are platform-independent because they are written in Java

Java security manager on the server enforces a set of restrictions to protect the

resources on a server machine So servlets are trusted

The full functionality of the Java class libraries is available to a servlet It can

communicate with applets databases or other software via the sockets and RMI

mechanisms that you have seen already

10 ONLINE BANKING

23 RDBMS

RDBMS stands for Relational Database Management System RDBMS is the basis for SQL

and for all modern database systems like MS SQL Server IBM DB2 Oracle MySQL and

Microsoft Access

A Relational database management system (RDBMS) is a database management system

(DBMS) that is based on the relational model as introduced by E F Codd

There are many popular RDBMS available to work with However our project uses

MySQL database for back end processiong

MySQL

MySQL is an open source SQL database which is developed by Swedish company MySQL

AB MySQL is pronounced my ess-que-ell in contrast with SQL pronounced sequel

MySQL is supporting many different platforms including Microsoft Windows the major

Linux distributions UNIX and Mac OS X

MySQL has free and paid versions depending on its usage (non-commercialcommercial)

and features MySQL comes with a very fast multi-threaded multi-user and robust SQL

database server

Features High Performance

High Availability

Scalability and Flexibility Run anything

Robust Transactional Support

Web and Data Warehouse Strengths

Strong Data Protection

Comprehensive Application Development

Management Ease

Open Source Freedom and 24 x 7 Support

11 ONLINE BANKING

Chapter 3 SYSTEM ANALYSIS

31 Project Scheduling

311 PERT Chart

S Start

A Analysis

B Design CUI

C Coding

D Testing

E Maintenance

F Design GUI

G Testing GUI

H Implementation

12 ONLINE BANKING

312 Gantt Chart

0

05

1

15

2

25

3

35

4

45

Analysis Designing Coding Testing Maintenance

No

of

Wee

ks

Processes

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

6 ONLINE BANKING

12 Objectives 1 To allow only authorized user to access various function and processed available in the

system

2 Reduced clerical work as most of the work done by computer

3 Provide greater speed amp reduced time consumption

4 Ensures that users can be able to open their accounts in a convenient manner at a

convenient time anytime anywhere as long as they are connected to the internet

5 Allow for users to check their transaction and account details conveniently again anytime

anywhere

7 ONLINE BANKING

13 Scope

Banking activities are considered to be the life blood of the national Economy Without

banking services trading and business activities cannot be carried on smoothly Banks are the

distributors and protectors of liquid capital which is of vital significance to a developing

country

Efficient administration of the banking system helps in the economic Growth of the nation

Banking is useful to trade and commerce

8 ONLINE BANKING

Chapter 2 Project Category

21 JSP (Java Server Pages) JavaServer Pages (JSP) is a technology for developing web pages that support dynamic

content which helps developers insert java code in HTML pages by making use of special

JSP tags most of which start with lt and end with gt

A JavaServer Pages component is a type of Java servlet that is designed to fulfill the role of

a user interface for a Java web application Web developers write JSPs as text files that

combine HTML or XHTML code XML elements and embedded JSP actions and

commands

Using JSP you can collect input from users through web page forms present records from a

database or another source and create web pages dynamically

JSP tags can be used for a variety of purposes such as retrieving information from a

database or registering user preferences accessing JavaBeans components passing control

between pages and sharing information between requests pages etc

9 ONLINE BANKING

22 Servlets Java Servlets are programs that run on a Web or Application server and act as a middle layer

between a request coming from a Web browser or other HTTP client and databases or

applications on the HTTP server

Using Servlets you can collect input from users through web page forms present records

from a database or another source and create web pages dynamically

Java Servlets often serve the same purpose as programs implemented using the Common

Gateway Interface (CGI) But Servlets offer several advantages in comparison with the

CGI-

Performance is significantly better

Servlets execute within the address space of a Web server It is not necessary to

create a separate process to handle each client request

Servlets are platform-independent because they are written in Java

Java security manager on the server enforces a set of restrictions to protect the

resources on a server machine So servlets are trusted

The full functionality of the Java class libraries is available to a servlet It can

communicate with applets databases or other software via the sockets and RMI

mechanisms that you have seen already

10 ONLINE BANKING

23 RDBMS

RDBMS stands for Relational Database Management System RDBMS is the basis for SQL

and for all modern database systems like MS SQL Server IBM DB2 Oracle MySQL and

Microsoft Access

A Relational database management system (RDBMS) is a database management system

(DBMS) that is based on the relational model as introduced by E F Codd

There are many popular RDBMS available to work with However our project uses

MySQL database for back end processiong

MySQL

MySQL is an open source SQL database which is developed by Swedish company MySQL

AB MySQL is pronounced my ess-que-ell in contrast with SQL pronounced sequel

MySQL is supporting many different platforms including Microsoft Windows the major

Linux distributions UNIX and Mac OS X

MySQL has free and paid versions depending on its usage (non-commercialcommercial)

and features MySQL comes with a very fast multi-threaded multi-user and robust SQL

database server

Features High Performance

High Availability

Scalability and Flexibility Run anything

Robust Transactional Support

Web and Data Warehouse Strengths

Strong Data Protection

Comprehensive Application Development

Management Ease

Open Source Freedom and 24 x 7 Support

11 ONLINE BANKING

Chapter 3 SYSTEM ANALYSIS

31 Project Scheduling

311 PERT Chart

S Start

A Analysis

B Design CUI

C Coding

D Testing

E Maintenance

F Design GUI

G Testing GUI

H Implementation

12 ONLINE BANKING

312 Gantt Chart

0

05

1

15

2

25

3

35

4

45

Analysis Designing Coding Testing Maintenance

No

of

Wee

ks

Processes

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

7 ONLINE BANKING

13 Scope

Banking activities are considered to be the life blood of the national Economy Without

banking services trading and business activities cannot be carried on smoothly Banks are the

distributors and protectors of liquid capital which is of vital significance to a developing

country

Efficient administration of the banking system helps in the economic Growth of the nation

Banking is useful to trade and commerce

8 ONLINE BANKING

Chapter 2 Project Category

21 JSP (Java Server Pages) JavaServer Pages (JSP) is a technology for developing web pages that support dynamic

content which helps developers insert java code in HTML pages by making use of special

JSP tags most of which start with lt and end with gt

A JavaServer Pages component is a type of Java servlet that is designed to fulfill the role of

a user interface for a Java web application Web developers write JSPs as text files that

combine HTML or XHTML code XML elements and embedded JSP actions and

commands

Using JSP you can collect input from users through web page forms present records from a

database or another source and create web pages dynamically

JSP tags can be used for a variety of purposes such as retrieving information from a

database or registering user preferences accessing JavaBeans components passing control

between pages and sharing information between requests pages etc

9 ONLINE BANKING

22 Servlets Java Servlets are programs that run on a Web or Application server and act as a middle layer

between a request coming from a Web browser or other HTTP client and databases or

applications on the HTTP server

Using Servlets you can collect input from users through web page forms present records

from a database or another source and create web pages dynamically

Java Servlets often serve the same purpose as programs implemented using the Common

Gateway Interface (CGI) But Servlets offer several advantages in comparison with the

CGI-

Performance is significantly better

Servlets execute within the address space of a Web server It is not necessary to

create a separate process to handle each client request

Servlets are platform-independent because they are written in Java

Java security manager on the server enforces a set of restrictions to protect the

resources on a server machine So servlets are trusted

The full functionality of the Java class libraries is available to a servlet It can

communicate with applets databases or other software via the sockets and RMI

mechanisms that you have seen already

10 ONLINE BANKING

23 RDBMS

RDBMS stands for Relational Database Management System RDBMS is the basis for SQL

and for all modern database systems like MS SQL Server IBM DB2 Oracle MySQL and

Microsoft Access

A Relational database management system (RDBMS) is a database management system

(DBMS) that is based on the relational model as introduced by E F Codd

There are many popular RDBMS available to work with However our project uses

MySQL database for back end processiong

MySQL

MySQL is an open source SQL database which is developed by Swedish company MySQL

AB MySQL is pronounced my ess-que-ell in contrast with SQL pronounced sequel

MySQL is supporting many different platforms including Microsoft Windows the major

Linux distributions UNIX and Mac OS X

MySQL has free and paid versions depending on its usage (non-commercialcommercial)

and features MySQL comes with a very fast multi-threaded multi-user and robust SQL

database server

Features High Performance

High Availability

Scalability and Flexibility Run anything

Robust Transactional Support

Web and Data Warehouse Strengths

Strong Data Protection

Comprehensive Application Development

Management Ease

Open Source Freedom and 24 x 7 Support

11 ONLINE BANKING

Chapter 3 SYSTEM ANALYSIS

31 Project Scheduling

311 PERT Chart

S Start

A Analysis

B Design CUI

C Coding

D Testing

E Maintenance

F Design GUI

G Testing GUI

H Implementation

12 ONLINE BANKING

312 Gantt Chart

0

05

1

15

2

25

3

35

4

45

Analysis Designing Coding Testing Maintenance

No

of

Wee

ks

Processes

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

8 ONLINE BANKING

Chapter 2 Project Category

21 JSP (Java Server Pages) JavaServer Pages (JSP) is a technology for developing web pages that support dynamic

content which helps developers insert java code in HTML pages by making use of special

JSP tags most of which start with lt and end with gt

A JavaServer Pages component is a type of Java servlet that is designed to fulfill the role of

a user interface for a Java web application Web developers write JSPs as text files that

combine HTML or XHTML code XML elements and embedded JSP actions and

commands

Using JSP you can collect input from users through web page forms present records from a

database or another source and create web pages dynamically

JSP tags can be used for a variety of purposes such as retrieving information from a

database or registering user preferences accessing JavaBeans components passing control

between pages and sharing information between requests pages etc

9 ONLINE BANKING

22 Servlets Java Servlets are programs that run on a Web or Application server and act as a middle layer

between a request coming from a Web browser or other HTTP client and databases or

applications on the HTTP server

Using Servlets you can collect input from users through web page forms present records

from a database or another source and create web pages dynamically

Java Servlets often serve the same purpose as programs implemented using the Common

Gateway Interface (CGI) But Servlets offer several advantages in comparison with the

CGI-

Performance is significantly better

Servlets execute within the address space of a Web server It is not necessary to

create a separate process to handle each client request

Servlets are platform-independent because they are written in Java

Java security manager on the server enforces a set of restrictions to protect the

resources on a server machine So servlets are trusted

The full functionality of the Java class libraries is available to a servlet It can

communicate with applets databases or other software via the sockets and RMI

mechanisms that you have seen already

10 ONLINE BANKING

23 RDBMS

RDBMS stands for Relational Database Management System RDBMS is the basis for SQL

and for all modern database systems like MS SQL Server IBM DB2 Oracle MySQL and

Microsoft Access

A Relational database management system (RDBMS) is a database management system

(DBMS) that is based on the relational model as introduced by E F Codd

There are many popular RDBMS available to work with However our project uses

MySQL database for back end processiong

MySQL

MySQL is an open source SQL database which is developed by Swedish company MySQL

AB MySQL is pronounced my ess-que-ell in contrast with SQL pronounced sequel

MySQL is supporting many different platforms including Microsoft Windows the major

Linux distributions UNIX and Mac OS X

MySQL has free and paid versions depending on its usage (non-commercialcommercial)

and features MySQL comes with a very fast multi-threaded multi-user and robust SQL

database server

Features High Performance

High Availability

Scalability and Flexibility Run anything

Robust Transactional Support

Web and Data Warehouse Strengths

Strong Data Protection

Comprehensive Application Development

Management Ease

Open Source Freedom and 24 x 7 Support

11 ONLINE BANKING

Chapter 3 SYSTEM ANALYSIS

31 Project Scheduling

311 PERT Chart

S Start

A Analysis

B Design CUI

C Coding

D Testing

E Maintenance

F Design GUI

G Testing GUI

H Implementation

12 ONLINE BANKING

312 Gantt Chart

0

05

1

15

2

25

3

35

4

45

Analysis Designing Coding Testing Maintenance

No

of

Wee

ks

Processes

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

9 ONLINE BANKING

22 Servlets Java Servlets are programs that run on a Web or Application server and act as a middle layer

between a request coming from a Web browser or other HTTP client and databases or

applications on the HTTP server

Using Servlets you can collect input from users through web page forms present records

from a database or another source and create web pages dynamically

Java Servlets often serve the same purpose as programs implemented using the Common

Gateway Interface (CGI) But Servlets offer several advantages in comparison with the

CGI-

Performance is significantly better

Servlets execute within the address space of a Web server It is not necessary to

create a separate process to handle each client request

Servlets are platform-independent because they are written in Java

Java security manager on the server enforces a set of restrictions to protect the

resources on a server machine So servlets are trusted

The full functionality of the Java class libraries is available to a servlet It can

communicate with applets databases or other software via the sockets and RMI

mechanisms that you have seen already

10 ONLINE BANKING

23 RDBMS

RDBMS stands for Relational Database Management System RDBMS is the basis for SQL

and for all modern database systems like MS SQL Server IBM DB2 Oracle MySQL and

Microsoft Access

A Relational database management system (RDBMS) is a database management system

(DBMS) that is based on the relational model as introduced by E F Codd

There are many popular RDBMS available to work with However our project uses

MySQL database for back end processiong

MySQL

MySQL is an open source SQL database which is developed by Swedish company MySQL

AB MySQL is pronounced my ess-que-ell in contrast with SQL pronounced sequel

MySQL is supporting many different platforms including Microsoft Windows the major

Linux distributions UNIX and Mac OS X

MySQL has free and paid versions depending on its usage (non-commercialcommercial)

and features MySQL comes with a very fast multi-threaded multi-user and robust SQL

database server

Features High Performance

High Availability

Scalability and Flexibility Run anything

Robust Transactional Support

Web and Data Warehouse Strengths

Strong Data Protection

Comprehensive Application Development

Management Ease

Open Source Freedom and 24 x 7 Support

11 ONLINE BANKING

Chapter 3 SYSTEM ANALYSIS

31 Project Scheduling

311 PERT Chart

S Start

A Analysis

B Design CUI

C Coding

D Testing

E Maintenance

F Design GUI

G Testing GUI

H Implementation

12 ONLINE BANKING

312 Gantt Chart

0

05

1

15

2

25

3

35

4

45

Analysis Designing Coding Testing Maintenance

No

of

Wee

ks

Processes

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

10 ONLINE BANKING

23 RDBMS

RDBMS stands for Relational Database Management System RDBMS is the basis for SQL

and for all modern database systems like MS SQL Server IBM DB2 Oracle MySQL and

Microsoft Access

A Relational database management system (RDBMS) is a database management system

(DBMS) that is based on the relational model as introduced by E F Codd

There are many popular RDBMS available to work with However our project uses

MySQL database for back end processiong

MySQL

MySQL is an open source SQL database which is developed by Swedish company MySQL

AB MySQL is pronounced my ess-que-ell in contrast with SQL pronounced sequel

MySQL is supporting many different platforms including Microsoft Windows the major

Linux distributions UNIX and Mac OS X

MySQL has free and paid versions depending on its usage (non-commercialcommercial)

and features MySQL comes with a very fast multi-threaded multi-user and robust SQL

database server

Features High Performance

High Availability

Scalability and Flexibility Run anything

Robust Transactional Support

Web and Data Warehouse Strengths

Strong Data Protection

Comprehensive Application Development

Management Ease

Open Source Freedom and 24 x 7 Support

11 ONLINE BANKING

Chapter 3 SYSTEM ANALYSIS

31 Project Scheduling

311 PERT Chart

S Start

A Analysis

B Design CUI

C Coding

D Testing

E Maintenance

F Design GUI

G Testing GUI

H Implementation

12 ONLINE BANKING

312 Gantt Chart

0

05

1

15

2

25

3

35

4

45

Analysis Designing Coding Testing Maintenance

No

of

Wee

ks

Processes

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

11 ONLINE BANKING

Chapter 3 SYSTEM ANALYSIS

31 Project Scheduling

311 PERT Chart

S Start

A Analysis

B Design CUI

C Coding

D Testing

E Maintenance

F Design GUI

G Testing GUI

H Implementation

12 ONLINE BANKING

312 Gantt Chart

0

05

1

15

2

25

3

35

4

45

Analysis Designing Coding Testing Maintenance

No

of

Wee

ks

Processes

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

12 ONLINE BANKING

312 Gantt Chart

0

05

1

15

2

25

3

35

4

45

Analysis Designing Coding Testing Maintenance

No

of

Wee

ks

Processes

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

13 ONLINE BANKING

32 Software Requirement Specifications (SRS)

Software Requirements Hardware Requirements

Operating System Windows or linux or

MAC

Processor any

Front End HTML JSP Hard Disk 1 GB minimum

Back End Servlet RAM 256MB or more

Database MYSQL Any Screen

Web Server Tomcat-Apache 80

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

14 ONLINE BANKING

33 UML (Unified Modelling Language) Diagrams

331 Use Case Diagram

Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions (use cases) that some system or systems (subject) should or can perform in collaboration with one or more external users of the system (actors)

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

15 ONLINE BANKING

332 State Chart Diagram

State Chart Diagrams are used to represent a single object and hoe its behavior causes it to change state

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

16 ONLINE BANKING

333 Activity Diagram

Activity Diagrams are used to model how different areas of work behave with each other and interaction

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

17 ONLINE BANKING

Chapter 4 SYSTEM DESIGN

41 Modularization Details

Following are the modules which are used in our project

411 Bank Customer Module

1 Create New Account All the requirements should be filled with proper with correct

identification such as account number name and initial deposit

2 Login Correct account number should be required to access through existing customer

otherwise this facility is not executable There are also number of options regarding users to

avail the facilities system is giving to the user

3 Amount Depositing withdraw and transfer This required a amount customer want to

deposit or withdraw or transfer and show the current balance after executing customerrsquos

requirement

4 View Passbook Customers can see their passbook after doing all the necessary

transactions they want

5 View Profile Correct account number should be required in order to view details of

customerrsquos account If not entered correct account number then it canrsquot be accessed

6 Update Profile Customers can also update their profile if they want any modifications or

changes in their respective profile

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

18 ONLINE BANKING

412 Administrator Module

1 View all accounts of the customers Admin can view all the accounts of the various

account holders which are existing in the database

2 View all Transactions Admin can check passbook of any account holder

3 DeleteClose Account Admin has the right to delete or close the account of any account

holder

4 Search for any Account Admin can search for any account and can see the passbook of

any customer by clicking on his account

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

19 ONLINE BANKING

42 Database Design

Table Name users Description- Store the details of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type full_name varchar(45)

father_name varchar(45)

DOB date

address varchar(80)

mobileno varchar(10) PK

email varchar(50)

gender varchar(45)

aadhar longblob

photo longblob

sign longblob

regdatetime timestamp

Security_Question varchar(100)

Security_Answer varchar(45)

Table No 421 users

Table Name Admin Description- generates OTP(One Time Password) for users Key constraints Primary Key (accountno) Column Name Data Type

accountno int(13) PK AI

OTP int(5)

Table 422 Admin

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

20 ONLINE BANKING

Table Name account Description- Store the accounts of users Used By- Customers Key constraints Primary Key (mobileno)

Column Name Data Type type varchar(45)

accountno int (13)

full_name varchar(45)

password varchar(45)

mobileno varchar(45) PK

regdatetime timestamp

amount double

Table No 423 Account

Table Name accountno_otp Description- Stores account no and password generated for users by the system Used By Customers Key constraints Primary Key (accountno)

Column Name Data Type

accountno int(13) PK

OTP varchar(10)

Table 424 Accountno_otp

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

21 ONLINE BANKING

Table Name Passbook Description- Stores all the transaction details made by the customers Used By Customers Admin

Column Name Data Type

dor timestamp

accountno varchar(45)

accounttype varchar(45)

transactiontype varchar(45)

amount double

totbal double

mobileno varchar(45)

Related Tables

account(mobilenorarr mobileno)

Table 425 Passbook Table Name Deleted Accounts Description- Store those accounts which are permanently deleted Used By- Admin

Column Name Data Type

type varchar(45)

accountno varchar(45)

full_name varchar(45)

father_name varchar(45)

DOB timestamp

amount varchar(45)

address varchar(45)

mobileno varchar(45)

email varchar(45)

gender varchar(45)

regdatetime timestamp

Table 426 Deleted Accounts

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

22 ONLINE BANKING

Chapter 5 TESTING

51 Testing Techniques Testing is a process of executing the program with the

intent of finding errors and it establishes confidence that the program does what it is suppose

to do Testing can be performed in two ways-

511 Unit Testing

It is testing of individual module Before initiating unit testing it must be ensured that the

code is peer previewed

512 Integration Testing

Integration testing is performed after all the software units are combined together The

objective here is to test the software interfaces Project team conducts the integration testing

Before entering integration testing it may be ensured that code review and unit testing have

been performed on the individual software modules

I conducted the unit testing for finding errors and the results of the unit testing are

recorded and action initiated for rectification of the errorsdefects as well as Integration

testing to check the proper interfacing among the modules

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

23 ONLINE BANKING

Chapter 6 OUTPUT SCREEN

61 Output Screen

611 indexjsp

Figure 611

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

24 ONLINE BANKING

612 loginjsp

Figure 612

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

25 ONLINE BANKING

613 newaccountjsp

Figure 613

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

26 ONLINE BANKING

614 depositjsp

Figure 614

615 withdrawjsp

Figure 615

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

27 ONLINE BANKING

616 transferjsp

Figure 616

617 passbookjsp

Figure 617

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

28 ONLINE BANKING

Chapter 7 LIMITATIONS AND FUTURE WORK

71 Limitations

1 The failure of a larger institution could have serious ramifications for the entire system in

that if one universal bank were to collapse it could lead to a systemic financial crisis

2 SSL(Security Socket Layer) is not used

72 Future Scope and Further Enhancements

As we know that In IT industries continuous changes or modifications in the software or

applications have been made in order to improve the existing software so that it will be more

User friendly and easy to use for the users The Project entitled ldquoOnline Bankingrdquo is

successfully developed and tested These modules are the basics of Online bank which we

have added in this project the project can be further extended by adding more modules in it

without any such difficulty because proper interfacing among the modules have been done

The new modules can be added in the project in order to make this project complete one

These are

1 QR Code for the users so that they can scan their account number and user name in order

to provide security

2 Reminders for customers so that they can set their tasks

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm

29 ONLINE BANKING

REFERENCES

Websites

wwwstackoverflowcom

httpwwwjavatpointcomjsp-tutorial

httpwwwjavatpointcomservlet-tutorial

httpwwww3schoolscombootstrapdefaultasp

httpwwwtutorialspointcomjsp

httpscreatelycomdiagramexampleh16syri82Online20Internet

20Banking20System

httpswwwtutorialspointcomumluml_standard_diagramshtm