Book Nookery
April 2023Software
BookNookery is a Java-based desktop application developed to manage bookstore inventory and automate billing operations. It replaces traditional handwritten records with a structured system that ensures better accuracy, faster processing, and organized data handling. Built as part of an OOP course, the project integrates Java Swing for UI, JDBC for database connectivity, and MySQL for persistent storage, simulating a real-world business workflow
A complete Java desktop solution that automates bookstore inventory and billing, replacing manual errors with a structured database-driven system.
Tech Stack
Java
Features
- Full CRUD operations for managing book inventory
- Fast search and filtering for efficient stock handling
- Automated billing with accurate price and tax calculation
- Invoice generation using JasperReports
- Persistent data storage with MySQL integration
- Clean GUI built with Java Swing
Challenges
- Designing proper relationships between database tables
- Handling complex logic for billing and price calculations
- Managing data consistency between UI and database
- Debugging JDBC connection and query issues
- Structuring the application using OOP principles correctly
Learnings
- Strong understanding of OOP concepts in real application development
- Hands-on experience with SQL queries and database design
- Learned how frontend (Swing) connects with backend (MySQL via JDBC)
- Improved logic building for real-world problems like billing systems
- Gained experience in building complete desktop applications
Highlights
- Successfully built a full end-to-end desktop application
- Strengthened both Java and database fundamentals