Archivedc++qtmysqltcp
Elderly Item Finder System
A desktop elderly item-finding management system built with Qt C++ and MySQL. Locates item storage positions via RFID tag scanning, supports item & position management, elderly profile management, search records & exception handling, query-count statistics and data export, with a TCP server for card-reader hardware integration.
Project Highlights
- Desktop application developed with Qt C++, using QMainWindow + QStackedWidget multi-page architecture with QSS resource styling.
- Connects to MySQL database via QODBC driver, covering 6 tables: login account, elderly profile, item tag, tag position, search record, and query statistics.
- Uses singleton pattern (SingleSql) to encapsulate database connection, sharing one instance globally to avoid redundant connections.
- RFID-tag-driven item management: binds RFID tag ID and owner elderly to each item, supports adding, listing, searching storage position by name, and deleting by tag ID.
- Item position management: binds storage location (StorageID) to each tag, supports adding and removing position associations.
- Card-scan item finding & registration flow: receives reader data via TCP server (QTcpServer listening on port 8888), matches target item ID after scanning, registers return record on match, flags exception on mismatch.
- Search record & exception handling: records set position vs. actual position for each search, marks IsException as 1 when item is misplaced and triggers exception handling flow.
- Elderly profile management: records name, ID number, gender, age, and memory decline status, supports table display, query by ID and deletion.
- Query statistics panel: counts queries per item in descending order, one-click refresh, and export to TXT file for archiving.
- Account login & registration system: login with account and password, registration links to ID number, main features unlocked after successful login.