Home Java BookShop Inventory Management System (Point of Sales system)

BookShop Inventory Management System (Point of Sales system)

10 min read

The BookShop Inventory Management System is developed using Java and mysql. The project is built to manage books and transactions. To make a new transaction, fields such as: bookname, qty and payment needs to be selected. If you like to learn point of sales systems step by step, this is the right place to learn from the beginning. In this tutorial, we will learn  jasper reports step by step and design and print a receipts for the payments.


  1. POS
  2. Stock
  3. Recipt

Learn how to make this System Step by step

Step 1: Create the database named with “bookshop“. then established the database connection to download the mysql connector in order to connect Java & mysql.if you don’t  have an idea about  download the mysql connector you can follow this link.

To connect the database please refer the following code. To create the method name connect (); paste the below code inside the Connect () method.

After that call the method Connect() inside the constructor. When the programe is started to run, all the forms will be loaded along with the connection method. Pasted the Connect() method inside to the constructor.

Search Record

The system shall be able search the book name, price by the relevant “book id”.

Paste this Code inside the keypress Event of the textfield. we created the textfield name txtbcode of this project.

Add the Product details into the JTable

After receiving the product name and price where the user has the option to add the qty by clicking the add button to see all Products details which will be shown in the below table.

Paste this code inside the add button

Calculating the Total and balance

After that  create the method Sales().we have to create two different tables to store data into the database. we also have to create the following tables from database.
Sales : tables consist of following colums – id,subtotal,pay,bal.
Sales_product : tables consist of following –  id,sales_id,bname,price,qty,total.

Call the Sales() method inside the Print Invoice button. after calculating the total print receipt will be released. this print receipt is design by Jsper Reporting.

Paste this code inside the Print Invoice button

Print Recipt

i have attached the video link below. which will do this tutorials step by step.

Load More Related Articles
Load More By admin
Load More In Java

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

Ecommerce Project Asp.net mvc Step by Step

This tutorial will teach you  how to make a Ecommerce Project using Asp.net Mvc step …