VISVESVARAYA TECHNOLOGICAL UNIVERSITY

BELAGAVI-590018

An Internship Report
on
Online Payment System
Bachelor of Engineering in Computer Science and Engineering
of Visvesvaraya Technological University, Belagavi

Submitted by

Pooja Venkatesh Naik 1RN21CS106

Under the Guidance of:

Coordinator: Guide:
Mr. Ranjith V Ms. Supritha N
Assistant Professor Assistant Professor
Dept. of CSE Dept. of CSE

Department of Computer Science and Engineering

RNS Institute of Technology
(Accredited by NBA upto 30-06-2025)
Channasandra, [Link] Road, Bengaluru - 560098

2022-2023
 RNS INSTITUTE OF TECHNOLOGY
Channasandra, [Link] Road, Bengaluru-560098

DEPARTMENT OF COMPUTER SCIENCE ENGINEERING

(Accredited by NBA upto 30-06-2025)

CERTIFICATE

Certified that the Internship work entitled Online payment System has been successfully carried

by Pooja Venkatesh Naik bearing USN 1RN21CS106 bonafide students of RNS Institute of

Technology in partial fulfillment of the degree in Bachelor of Engineering in Computer Science

and Engineering of Visvesvaraya Technological University, Belagavi during academic year 2022-

2023. The internship report has been approved as it satisfies the academic requirements in respect of

internship work for the said degree.

Signature of Coordinator Signature of HOD Signature of Principal

Mr. Ranjith V Dr. Kiran P Dr. M K Venkatesha
Assistant Professor Professor and HoD Principal
Dept. of CSE Dept. of CSE RNSIT
Acknowledgement

At the very onset, I would like to place on record my gratitude to all those people who have helped

me in making this Internship work a reality. Our Institution has played a paramount role in guiding

us in the right direction. I would like to profoundly thank Sri. Satish R Shetty, Managing Director,

RNS Group of Companies, Bengaluru for providing such a healthy environment for the successful

completion of this Internship Project work.

I would like to thank our beloved Principal, Dr. M K Venkatesha, for providing the necessary

facilities to carry out this work. I am extremely grateful to Dr. Kiran P, Professor and Head,

Department of Computer Science and Engineering for having accepted to patronize me in the right

direction with all his wisdom.

I would like to express my sincere thanks to our Coordinator and guide, [Link] V, Assistant

Professor, Department of Computer Science and Engineering and Ms. Supritha N, for his constant

encouragement that motivated me to the successful completion of this work. Last but not the least,

I am thankful for all the teaching and non-teaching staff members of the Computer Science and

Engineering Department for their encouragement and support throughout this work.

Pooja Venkatesh Naik

1RN21CS106
Chapter 0

Figure 1: Java Programming Fundamentals

Dept. of CSE, RNSIT 2022-23 Page ii

Abstract

An online payment system in Java and MySQL is a software application that allows users to transfer

funds electronically over the internet. It enables users to make purchases or payments using a variety

of payment methods, such as credit cards, debit cards, e-wallets, and bank transfers.

The system is designed using Java programming language and utilizes the MySQL database

management system to store and manage transactional data. It offers a secure and reliable platform

for online transactions by implementing various security measures, such as encryption, authentication,

and authorization.

The system typically consists of two main components: a front-end interface and a back-

end processing engine. The front-end interface allows users to interact with the system, initiate

transactions, and view transactional data. The back-end processing engine is responsible for

processing the transactions, validating payment details, and updating the database.

To implement an online payment system in Java and MySQL, developers must have a solid

understanding of software engineering principles, Java programming language, and MySQL database

management. They should also be familiar with various payment gateway APIs, security protocols,

and web development frameworks to create a robust and efficient system.

Overall, an online payment system in Java and MySQL offers a fast, convenient, and secure way

for users to make online transactions, and it is an essential component of e-commerce applications.

iii
Contents

Acknowledgement i

1 Introduction 1

1.1 Problem Statement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

2 Requirement Analysis, Tools & Technologies 3

2.1 Functional Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

2.2 Non-functional Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

2.3 Software Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

2.3.1 Eclipse IDE for Java . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

2.3.2 MySQL database and MySQL workbench . . . . . . . . . . . . . . . . . . . 5

3 Design & Methodology 7

3.1 Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

3.2 Methodology . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

4 Implementation 9
Chapter 1

Introduction

An online payment system in Java and MySQL refers to a software application that allows users

to make transactions electronically over the internet. Java is a popular programming language that

is used for developing various web-based applications, while MySQL is a widely-used open-source

database management system.

Online payment systems typically involve a range of processes, including user authentication,

payment processing, and transaction tracking. These systems are designed to be secure and reliable,

ensuring that user information is protected and transactions are processed in a timely manner.

To implement an online payment system in Java and MySQL, developers typically need to have a

solid understanding of both programming languages and database management. They need to be able

to design and implement secure authentication systems, integrate with payment gateways, and ensure

that transactions are tracked and recorded accurately.

Overall, online payment systems in Java and MySQL are an important part of e-commerce and

online business. They provide users with a convenient and secure way to make transactions over the

internet, and they are an essential tool for businesses that want to reach a global audience and increase

their revenue streams.

1.1 Problem Statement

The problem statement for an online payment system in Java and MySQL could be:

Develop an online payment system that allows customers to securely purchase goods and services

1
Chapter 1 1.1. PROBLEM STATEMENT

from a website. The system should include a user registration and login process, as well as a payment

gateway integration for processing credit and debit card transactions. The system should also provide

users with the ability to view their transaction history and update their personal information.

The system should be built using Java as the programming language and MySQL as the database

management system. It should be designed to be scalable, secure, and reliable, with appropriate error

handling and data validation measures in place. Additionally, the system should be user-friendly and

intuitive, with clear and concise error messages and helpful feedback for users. The user interface

should be responsive and accessible on a variety of devices, including desktop and mobile devices.

Dept. of CSE, RNSIT 2022-23 Page 2

Chapter 2

Requirement Analysis, Tools & Technologies

2.1 Functional Requirements

User Registration: The payment system should allow users to create an account with their personal

and payment information.

Payment Processing: The system should be able to process payments from different payment

methods such as credit cards, debit cards, and e-wallets.

Payment Gateway Integration: The system should integrate with payment gateways such as

PayPal, Stripe, or [Link], to securely process payments.

Transaction History: The system should maintain a transaction history that users can access to

view their payment history and payment status.

Security: The payment system should ensure the security of user information and payment data

by using encryption, secure protocols, and authentication mechanisms.

Payment Notification: The system should send payment notifications to both the customer and the

merchant upon successful completion of a transaction.

Refunds: The system should allow merchants to initiate refunds for payments made by customers.

User Management: The system should allow administrators to manage user accounts and

permissions, including adding and removing users, and updating user information.

Reports and Analytics: The system should provide comprehensive reports and analytics for

merchants to track their sales, revenue, and other key metrics.

Integration with other systems: The payment system should be able to integrate with other systems

3
Chapter 2 2.2. NON-FUNCTIONAL REQUIREMENTS

such as inventory management, accounting, and customer relationship management (CRM) systems

2.2 Non-functional Requirements

Security: The system should ensure secure transactions by using encryption techniques, secure

sockets layer (SSL), and tokenization.

Performance: The system should be able to handle a large number of simultaneous transactions

and provide fast response times to users.

Reliability: The system should be available 24/7 with minimal downtime, and it should be able to

recover from failures quickly.

Scalability: The system should be able to handle increasing volumes of transactions without

affecting performance.

Usability: The system should be easy to use, with a simple and intuitive interface for users.

Accessibility: The system should be accessible to users with disabilities, such as visual

impairments.

Compatibility: The system should be compatible with different operating systems, browsers, and

devices.

2.3 Software Requirements

The software requirements are a description of the features and functionalities of the system. Table

2.1 gives details of software requirements.

Table 2.1: Software Requirements

Operating System Windows 7 and above

IDE Eclipse
Tools MySQL
Libraries JDBC, SQL workbench

Dept. of CSE, RNSIT 2022-23 Page 4

Chapter 2 2.3. SOFTWARE REQUIREMENTS

2.3.1 Eclipse IDE for Java

Eclipse is a popular integrated development environment (IDE) used primarily for developing Java

applications but also supports other programming languages. It offers a comprehensive set of tools for

software development, including code editing, debugging, testing, and version control. Eclipse also

has a modular architecture that allows developers to add functionality through a vast array of plug-ins.

It is open-source and has a large and active community of developers contributing to its development

and support. Eclipse is widely used in industry and academia for various software development

projects.

2.3.2 MySQL database and MySQL workbench

MySQL is an open-source relational database management system. It is one of the most widely used

databases in the world, and it is used by many large and small organizations to store and manage

their data. MySQL Workbench is an integrated development environment (IDE) that allows users to

design, develop, and manage MySQL databases. It includes features such as visual database design,

SQL development and execution, and database administration tools. MySQL and MySQL Workbench

are often used together to create, manage, and optimize MySQL databases for various applications.

JDBC Connector

• JDBC Connector for MySQL is a Java-based API that allows Java programs to connect and

interact with MySQL databases.

• It provides a standard set of interfaces for developers to work with databases, including

connecting to a database, executing SQL queries, and retrieving data.

• To use JDBC Connector for MySQL in a Java project, developers need to add the connector

JAR file to the project’s classpath.

• Eclipse IDE is a popular integrated development environment for Java development, providing

a range of features and tools to streamline the development process.

• Eclipse provides built-in support for JDBC, including the ability to create JDBC connections,

execute SQL statements, and view the results of queries.

Dept. of CSE, RNSIT 2022-23 Page 5

Chapter 2 2.3. SOFTWARE REQUIREMENTS

• Developers can use Eclipse’s Database Development perspective and Data Source Explorer to

manage JDBC connections and interact with MySQL databases.

• MySQL Workbench is a graphical tool for working with MySQL databases, providing a range

of features for database design, modeling, and administration.

• MySQL Workbench also includes built-in support for JDBC, allowing developers to connect to

MySQL databases and execute SQL queries directly from the tool.

Dept. of CSE, RNSIT 2022-23 Page 6

Chapter 3

Design & Methodology

3.1 Design

User Authentication: Users need to authenticate themselves before making any payments. This can

be done using a simple username and password system or more advanced methods like OAuth or

Two-Factor Authentication (2FA).

Payment Processing: The payment processing module should allow users to make payments using

different payment methods like credit cards, debit cards, PayPal, etc. The system should also validate

the user’s payment information and ensure that the payment is successful.

Payment History: The payment history module should keep track of all the payments made by

the user. This information is useful for users to track their spending and for the system to provide

analytics.

Security: The online payment system should be designed with security in mind. It should use

encryption to protect sensitive information like credit card numbers and passwords.

Reporting: The system should be able to generate reports based on various parameters like

payment method, user, amount, date, etc.

Refunds: The system should allow users to initiate refunds if they have made a payment in error

or if they are not satisfied with the product or service.

Overall, designing an online payment system in Java and MySQL requires careful planning and

execution to ensure that the system is secure, reliable, and easy to use.

7
Chapter 3 3.2. METHODOLOGY

3.2 Methodology

Define the requirements: The first step is to define the requirements of the online payment system.

This can be done by working with the stakeholders, including users, business owners, and developers,

to identify the features and functionalities required for the system.

Create a product backlog: The next step is to create a product backlog, which is a prioritized list

of all the features and functionalities required for the online payment system. The product backlog

should be continuously updated and refined throughout the development process.

Sprint planning: The development process is divided into sprints, which are short periods of time,

usually two weeks to one month. In the sprint planning meeting, the team selects the features and

functionalities from the product backlog that will be developed during the sprint.

Development: During the sprint, the development team works on developing the selected features

and functionalities. The team uses Java and MySQL to develop the system.

Daily stand-up meetings: The team meets daily to discuss progress, challenges, and plans for the

day. This helps to ensure that everyone is on the same page and any issues are addressed promptly.

Release: When all the features and functionalities have been developed, tested, and approved, the

system is released to the production environment.

Dept. of CSE, RNSIT 2022-23 Page 8

Chapter 4

Implementation

Setting up the development environment: Install the Java Development Kit (JDK) and an Integrated

Development Environment (IDE) like Eclipse or IntelliJ IDEA. Also, install MySQL database and a

JDBC driver.

Design the database schema: Design the database schema and create the necessary tables,

columns, and relationships. The schema should include tables for storing user information, payment

information, payment history, and other relevant data.

Implement user authentication: Implement user authentication using Java Servlets, JSPs, and

JDBC to connect to the MySQL database. The user’s authentication details can be stored in the

MySQL database, and the system can use JDBC to query the database and authenticate the user.

Implement payment processing: Implement payment processing using a payment gateway like

PayPal or Stripe. The user’s payment information can be encrypted and stored in the MySQL

database. The system can use JDBC to validate the user’s payment information and process the

payment using the payment gateway’s API.

Implement payment history: Implement payment history using JDBC to query the MySQL

database and retrieve the user’s payment history.

Implement security: Implement security using encryption algorithms like AES or RSA to encrypt

sensitive information like credit card numbers and passwords. The system can also use SSL/TLS to

secure the communication between the client and the server.

Implement reporting: Implement reporting using JDBC to query the MySQL database and

generate reports based on various parameters.

9
Chapter 4

Implement refunds: Implement refunds using the payment gateway’s API. The system can use the

API to initiate refunds for the user.

Test the system: Test the system thoroughly to ensure that it works as expected. Test all the

features and functionalities, and fix any issues or bugs that are found.

Deploy the system: Once the system has been tested and approved, deploy it to the production

environment.

Maintain the system: Continuously monitor and maintain the system to ensure that it remains

secure and functional. Apply bug fixes and updates as needed.

Dept. of CSE, RNSIT 2022-23 Page 10

Conclusion

In conclusion, an online payment system in Java and MySQL can provide a secure and reliable

platform for conducting financial transactions over the internet. By leveraging the robust features of

the Java programming language and the efficient data management capabilities of MySQL, developers

can create an intuitive and responsive payment system that meets the needs of businesses and

customers alike.

Key features of an online payment system in Java and MySQL might include secure user

authentication and authorization, encryption and decryption of sensitive data, real-time payment

processing and tracking, and comprehensive reporting and analytics. Developers may also need to

ensure compliance with relevant industry standards and regulations, such as PCI-DSS.

Overall, with careful planning, diligent testing, and ongoing maintenance and support, an online

payment system in Java and MySQL can help businesses streamline their financial operations and

provide a seamless experience for their customers.

11