An RFID Secure Entry Android App for US Open Pickleball Championships

Written by

Dr. Roger Webster

"This App reads Patron RFID Tags and Checks Authorized Entry Using a MySql Data Base."

In 2020 the US Open Pickleball Championships will be held on the April 18th — April 25th, 2020 in Naples, Florida.

VIP Patrons enter the event and this App scans their RFID tag on a Turck RFID Smart Phone Device, and then sends that tag number to a Mysql database on a LAN. The Mysql database returns information: First Name, Last Name, ValidID, and an Image if it is available.
If the ValidID entry returned from the Mysql database is 'Valid' then 'Entry Allowed' is sent to the Mysql database and logged. The VIP Patron is then allowed entry to the event. If the ValidID entry returned from the Mysql database is 'Invalid' then 'Entry Denied' is sent to the Mysql database and logged and entry is not allowed. An InvalidID could be a lost or stolen tag. This App secures valid entry into the event.

This project brings together several new and exciting technologies:
  • Android App Development
  • Smart Phone Security Entry Software
  • Android Studio IDE and SDK
  • Manifests in Apps
  • Layout design in Apps
  • GUI Programming
  • Icon development
  • Image Button development
  • IP Addresses
  • RFID device interaction for scanning RFID chips in tags
  • SQL Data Base Technologies
  • LAN server interaction with an Android App over a local area network
This App was written using Android Studio and written in Java by Dr. Roger Webster under the direction of Bryan McKenzie, Director of IT for US Open Pickleball in Naples, Florida. The app uses the UGronkIt SDK to interface with the hand held smart phone Turck RFID device. Testing was done using 2019 tag numbers with RFID devices. Dummy data was used in the Mysql Data Base for testing. This App runs on almost any Android device, we used a Samsung Galaxy Android phone for testing. The App also checks to see if the MySql database is running and/or there is a Network Error. Over 12,000 people are expected to attend this event every April in Naples, Florida.

App ScreenShots

Hand Held RFID Device App

cypressWalk.png

VIP Patron RFID Ticket

cypressWalk.png

Icon for App

lanianewright-2016x1512

App Main Menu

cypressWalk.png

Start Scanning RFID Tags

handheld.png

Valid Tag in Sql DataBase

lanianewright-2016x1512

INVALID Tag in Sql DataBase

cypressWalk.png

Stop Scanning RFID Tags

handheld.png

Actions Button

lanianewright-2016x1512

Check Battery Button

cypressWalk.png

About App IP Address

handheld.png

Network Sql DataBase Error

networkerror.jpg