In metro cities we can see you a huge rush at shopping malls on holidays and weekends. This becomes even more when there are huge offers and discounts. Nowadays people purchase a variety of items and put them in the trolley. After total purchasing one should approach counter for billing purpose. By using barcode the cashier prepares the bill which is a time consuming process. This results in long queues at the billing counters. This project presents an idea to develop a system in shopping malls to overcome the above problem. To achieve this all products in the mall should be equipped with RFID tags and smart check-out counter. First of all customer must login / signup with the system. When one puts any product on RFID reader its code will be detected automatically, the item name and cost will be displayed on the LCD, thereby the cost gets added to the total bill. You need to continue this process until you complete with scanning of all the products. After completion, you may generate the bill which would be mailed to your registered account and the amount will be debited from your registered credit card. By doing this lot of time and man power can be saved.
Default the system only have one Admin only
USERNAME:: Admin
PASSWORD:: Admin123
All the details of user are stored onto database into table userinformation which is encrypted
All the RFID and product details are stored into rfid_info table and all the data here is also encrypted
WAMP/XAMP/LAMP for MYSQL database
Netbeans/IntelIJ for development purpose
JAVA 1.8 (JDK 1.8 & JRE 1.8)
Arduino UNO r3(2 piece)
RC522 RFID scanner module
Buzzer, LED's (2 RED AND 2 GREEN), Jumper Cables,
Download the zip file and extract all the folder's from it.
Keep this extracted folder named "RFID_Based_SmartShoppingSystem" in 'C://' only which look like "C://RFID_Based_SmartShoppingSystem/" to avoid errors.
Import the SQL file named "rfid_basedshoppingsystem" to your Database. You can see how to import the sql file in WAMP/XAMP/LAMP from youtube.
Upload the arduino file named "RFID.ino" in one of the Arduino UNO from "/arduino files/RFID/RFID.ino"
Upload the another file named "Exit.ino" in another Arduino UNO form "/arduino files/Exit/Exit.ino".
Attach those 2 Arduino boards to your system and See the circuit diagram for connection reference given in "Smart shopping System final.pptm" on slide #5 & #6 and "Smart shopping system final.pdf" on page #24.
The jar files required by you are in folder named "jarfiles". You can see how to add jar files to your project from youtube.
line: 23 -> Enter the servername of your DB in place of "servername", Enter the port_number of your DB in place of "port_number", Enter User name and Password in place of "User_Name here" & "Password here" respectively connection = DriverManager.getConnection("jdbc:mysql://servername:port_number/rfid_basedshoppingsystem?useSSL=false", "User_Name here", "Password here");
line: 114-> Enter sender's email in place of "[email protected]" in String user = "[email protected]";
line: 115-> Enter sender's account's password in place of "your password" in String pss = "your password";
line: 154 -> Enter reciever's email in place of "To_email_address"
line: 92 -> Enter sender's email in place of "[email protected]" in String user = "[email protected]";
line: 93 -> Enter sender's account's password in place of "your password" in String pss = "your password";
line: 147-> Enter reciever's email in place of "To_email_address" and Pdf file path in place of "C:\RFID_Based_SmartShoppingSystem\pdfFiles\@kevin.pdf" in sendMessage("To_email_address","C:\RFID_Based_SmartShoppingSystem\pdfFiles\@kevin.pdf");
line: 14 -> Check the your COM port of arduino connected to Arduino with LED's and enter here appropriate one in place of "COM4" in Arduino("COM4", 9600);
line: 76 -> Check the your COM port of arduino connected to Arduino with RC522 module and enter here appropriate one in place of "COM3" in System.setProperty("gnu.io.rxtx.SerialPorts", "COM3");