Library Management System (LMS)

Version: 0.1 | Status: ✅ Pre-Production Ready | Date: 2026-04-09

A professional Java Swing desktop application for managing library operations with comprehensive book tracking, student management, circulation, and reporting.

🚀 Quick Start

For End Users (One-Time Setup)

⏱️ Total Time: ~4 minutes

Extract the Package:

Extract LMS-Setup.zip → Creates LMS folder

Read Quick Start (2 min):
```
Open: QUICKSTART.txt
```
Run Setup Wizard (2 min, one-time only):
```
java -jar LMS-Setup.jar
```
- Automated setup with 6 easy steps
- Creates admin user with your credentials
- Initializes database schema
- Generates desktop shortcuts (optional)

Launch Application (Every Time):

# Windows: Double-click run.bat
# Linux/Mac: Double-click run.sh or: ./run.sh

Login & Use:
- Username: ADMIN (or your chosen ID)
- Password: Your setup password
- System ready for library management!

📚 For Detailed Help: Read APPLICATION_LAUNCH_GUIDE.md

For Developers (Building from Source)

# Clone repository
git clone <repo-url>
cd LMS

# Compile sources
javac -d bin src/com/library/**/*.java

# Run application
java -cp "bin:lib/*" com.library.Main

# Build setup wizard JAR
./package-setup.sh  # Creates LMS-Setup.jar (113 MB)

📋 Features

✅ Book Management

Add/edit books with accession numbers
Catalog management (title, author, edition, publisher)
Stock tracking and monitoring
Bill tracking and pricing
Search by title, author, ISBN

✅ Student Management

Student registration with course details
Library card generation (automatic numbering)
Fee management and payment tracking
Issue limit control (per student)
ID card generation and printing

✅ Circulation Management

Issue books to students/faculty
Automatic return processing
Fine calculation (₹1/day overdue)
Book condition tracking
Due date management (7 days default)
Issue/return history

✅ Transaction Management

Seller registration and management
Purchase order creation
Bill entry and tracking
Auto-accession: Automatic book copy creation from bills
Bill reporting and exports

✅ Admin & Reporting

User management (create/edit admin & librarian users)
Audit log viewing (complete action history)
PDF report generation (professional branding)
Excel data export and import
System configuration

✅ Security

Role-based access control (ADMIN/LIBRARIAN)
SHA-256 password hashing
Comprehensive audit logging
User activity tracking
Secure session management

🛠️ System Requirements

Minimum Requirements

Java: Java 8 or higher (Java 26 tested)
Oracle Database: Oracle 10g XE or higher
RAM: 2GB minimum
Disk: 500MB for application + database space

Optional (for Containerized Database)

Podman/Docker: For running Oracle as container
Image: chameleon82/oracle-xe-10g:latest

Supported Operating Systems

✅ Linux (Ubuntu, CentOS, Fedora, etc.)
✅ Windows (7, 8, 10, 11)
✅ macOS (Intel & Apple Silicon)

📦 What's Included

Distribution Package (318 MB)

LMS-Setup.zip
└── LMS/
    ├── LMS-Setup.jar              (113MB setup wizard)
    ├── run.bat                    (Windows launcher)
    ├── run.sh                     (Linux/Mac launcher)
    ├── create-shortcut.bat        (Windows Desktop icon)
    ├── create-shortcut.sh         (Linux Desktop icon)
    ├── QUICKSTART.txt             (⭐ READ THIS FIRST!)
    ├── APPLICATION_LAUNCH_GUIDE.md (User guide)
    ├── FILES_REFERENCE.md         (File reference)
    └── lib/                       (200+ MB dependencies)

✨ What Users Get:

✅ Complete LMS application
✅ One-time setup wizard (fully automated)
✅ Smart launchers (auto-validates Java, directories, database)
✅ Desktop shortcuts (easy access)
✅ Clear documentation (no CLI knowledge needed)
✅ Production-grade setup (all 13 database tables)
✅ Ready to use immediately after setup

Source Repository

LMS/
├── src/                           (Java source code)
├── bin/                           (compiled .class files)
├── lib/                           (70MB+ JAR dependencies)
├── script.sql                     (database schema - 13 tables)
├── run.sh / run.bat               (application launchers)
├── create-shortcut.sh/bat         (desktop icon generators)
├── package-setup.sh               (build setup JAR script)
├── LMS-Setup.jar                  (production setup wizard)
├── README.md                      (this file)
├── QUICKSTART.txt                 (one-page quick start)
├── APPLICATION_LAUNCH_GUIDE.md    (user guide)
├── LAUNCHER_GUIDE.md              (technical reference)
├── DEPLOYMENT_PACKAGE.md          (distribution options)
├── ARCHITECTURE.md                (system design)
├── GUIDELINES.md                  (development standards)
└── docs/                          (detailed documentation)

🏗️ Architecture Overview

Four-Layer Architecture

UI Layer       → Java Swing (LoginFrame, DashboardPanel, etc.)
Service Layer  → Business logic (BookLogic, StudentLogic, etc.)
DAO Layer      → Pure JDBC database access
Model Layer    → Data transfer objects (Book, Student, etc.)
Database       → Oracle 10g XE

Key Modules

Login Module: Authentication via TBL_CREDENTIALS table
Book Module: Catalog, stock, accession number management
Student Module: Registration, fees, library cards
Circulation Module: Issue/return with fine calculation
Transaction Module: Seller → Order → Bill → Auto-accession workflow
Admin Module: User management, audit logs, reporting

For detailed architecture: See ARCHITECTURE.md

📖 Documentation

For End Users

Document	Purpose	Read Time
QUICKSTART.txt	Start here! One-page quick reference	2 min
APPLICATION_LAUNCH_GUIDE.md	Detailed user guide with troubleshooting	5 min
FILES_REFERENCE.md	What each file does	3 min

For System Administrators & IT

Document	Purpose	Read Time
LAUNCHER_GUIDE.md	Technical reference for launchers	5 min
DEPLOYMENT_PACKAGE.md	Distribution options (3 levels)	10 min
GUIDELINES.md	Installation and deployment standards	10 min

For Developers

Document	Purpose	Read Time
ARCHITECTURE.md	System design, layers, workflows	15 min
GUIDELINES.md	Development standards & conventions	10 min
docs/CHANGELOG.md	Complete project history	10 min
docs/SECURITY_AUDIT_REPORT.md	Security analysis & hardening	15 min

Quick Links

🚀 Distributing to Users? → DEPLOYMENT_PACKAGE.md
💻 Windows Issues? → LAUNCHER_GUIDE.md (Troubleshooting section)
🔧 Production Deployment? → GUIDELINES.md
🔒 Security Questions? → docs/SECURITY_AUDIT_REPORT.md
👨‍💻 Modifying Code? → ARCHITECTURE.md + GUIDELINES.md

🗄️ Database Setup

Automatic (Recommended) ✅

The setup wizard handles everything automatically:

✅ Connects to Oracle automatically
✅ Executes script.sql (creates all 13 tables)
✅ Creates essential sequences and triggers
✅ Creates admin user with your credentials
✅ Validates schema completely
✅ Ready to use immediately!

No manual SQL commands needed!

Manual Setup (Optional)

# Connect to Oracle
sqlplus PRJ2531H/PRJ2531H@XE

# Execute schema creation
@script.sql

# Exit
EXIT;

Database Details

URL: jdbc:oracle:thin:@localhost:1521:xe
User: PRJ2531H
Password: PRJ2531H
SID: xe (Express Edition)
Tables: 13 (automated creation by setup wizard)

Oracle via Container

# Start Oracle container
podman run -d --name oracle10g -p 1521:1521 \
  wnameless/oracle-xe-11g

# Verify running
podman ps | grep oracle

🎯 Common Tasks

First-Time User

Run setup wizard → Follow 6 steps → Installation complete
Launch application → Login with your admin account
Add student → Admin Panel → User Management
Add book → Book Management → Add New Book
Issue book → Circulation → New Issue

Admin Tasks

Create Users: Admin Panel → User Management → New User
View Audit Log: Admin Panel → Audit Logs
Generate Reports: Circulation/Books → Generate Report → Export PDF
Import Data: Admin Panel → Data Migration → Import Excel

Librarian Tasks

Issue Book: Circulation → New Issue → Select Student → Select Book
Return Book: Circulation → Return Book → Enter Details
Check Fines: Circulation → Student History → View Fines
Generate ID: Student Management → Generate Library Card

🔧 Troubleshooting

Setup Wizard Issues

"Database connection failed"

Check Oracle is running: podman ps | grep oracle
Start Oracle container if needed: podman run -d --name oracle10g -p 1521:1521 wnameless/oracle-xe-11g
Verify credentials: User=PRJ2531H, Pass=PRJ2531H, SID=xe

"ORA-00911: invalid character"

✅ FIXED - Setup wizard now handles inline SQL comments correctly

"PLS-00103: Encountered the symbol /"

✅ FIXED - Setup wizard now strips "/" before JDBC execution

"Admin user already exists"

Normal on fresh installs - admin user created automatically
Skip by clicking next in setup wizard

Application Launch Issues

"ClassNotFoundException"

Ensure bin/ folder contains compiled classes
Run setup wizard from correct directory
Check Java classpath: echo $CLASSPATH

"No suitable driver found for JDBC"

Verify lib/ojdbc6.jar exists
Check all JAR files in lib/ copied correctly
See LAUNCHER_GUIDE.md → Troubleshooting

Application won't start on Windows

Double-click run.bat from LMS folder
If command prompt flashes and closes:
1. Open command prompt manually
2. Navigate to LMS folder
3. Run: run.bat
4. Error message will display
See LAUNCHER_GUIDE.md for Windows-specific help

Application won't start on Linux

Make script executable: chmod +x run.sh
Run: ./run.sh
Check Java installation: java -version
See LAUNCHER_GUIDE.md → Linux Troubleshooting

"ORA-01882: timezone region not found"

✅ FIXED - Launchers now include correct JVM flags
Launchers automatically set -Doracle.jdbc.timezoneAsRegion=false

More Help

Can't find answer?

Read APPLICATION_LAUNCH_GUIDE.md (user guide)
Read LAUNCHER_GUIDE.md (technical reference)
Check ARCHITECTURE.md (system design)
Review docs/CHANGELOG.md (what's been fixed)

📊 Sample Workflows

Issue a Book Workflow

1. Librarian opens Circulation Module
2. Clicks "New Issue"
3. Selects student from list
4. Searches and selects book
5. System auto-calculates due date (+7 days)
6. Confirms and prints receipt
7. Book status changes to "ISSUED"
8. Fine tracked if returned late (₹1/day)

Student Registration Workflow

1. Librarian opens Student Management
2. Clicks "Register New Student"
3. Enters: Roll #, Name, Course, Address, Phone, Fee
4. System auto-generates Library Card ID (PPU-YYxxx)
5. Issues library card
6. Creates ID card printout
7. Student can now borrow books

Admin Setup Workflow

1. Run java -jar LMS-Setup.jar
2. Welcome screen → Click Next
3. Select installation path (default: /home/user/LMS)
4. System check (Java ✅, Oracle ✅)
5. Enter admin credentials (User ID, Password, Email, Phone)
6. Click Install → Progress bar shows...
   - Copying bin/ (classes)
   - Copying lib/ (dependencies)
   - Creating launcher scripts
   - Executing database schema
   - Creating admin user
7. Complete → Application installed at chosen location
8. Run ./run.sh to start application

🔒 Security Features

✅ Authentication:

Login with User ID + Password
SHA-256 password hashing
Role-based access (ADMIN/LIBRARIAN)

✅ Authorization:

Admin-only functions protected
User actions logged for audit

✅ Audit Trail:

All book transactions logged
User actions tracked with timestamp
Viewable in Admin Panel

✅ Data Protection:

Oracle 10g encryption support available
Secure JDBC connection
No plain-text credentials in code

📈 Performance Characteristics

Metric	Value	Notes
Users	1-10 concurrent	Suitable for small-medium libraries
Books	Unlimited	Index performance: <1s for 100k books
Transactions	~50/day	Tested on Oracle XE
Report Generation	5-30 seconds	Depends on dataset size
Memory Usage	~200MB	Running application
Database Size	~100MB+	Depends on data volume

Capacity Planning

10,000 books: 50MB database
5,000 students: 30MB database
100k transactions: 200MB database
5 years audit logs: 500MB logs

🚀 Deployment Options

Option 1: Standalone Installation (Recommended for Most)

Extract ZIP to desktop/laptop
Run setup wizard
Choose installation folder
Works offline after initial setup

Option 2: Server Deployment

Extract ZIP to server directory
Run setup wizard on server
Share Oracle database connection
Multiple users can access from network

Option 3: Container Deployment (Advanced)

Deploy in Docker/Podman container
Share volume with Oracle container
Orchestrate with docker-compose
See: docs/PODMAN_SETUP_GUIDE.md

📝 License & Support

Project Status: ✅ Pre-Production Ready (v0.1)

Latest Release: April 9, 2026

What's Production Ready:

✅ Setup wizard with automated database initialization
✅ SQL parser fixes (inline comments, PL/SQL blocks)
✅ Smart launchers with validation (Java, directories, database)
✅ Desktop shortcut generators (Windows & Linux)
✅ All 13 database tables created automatically
✅ Admin user creation automated
✅ Comprehensive error handling
✅ User-friendly documentation

Support & Documentation:

📖 User Guide: APPLICATION_LAUNCH_GUIDE.md
🚀 Quick Start: QUICKSTART.txt
🔧 Launcher Help: LAUNCHER_GUIDE.md
📦 Distribution: DEPLOYMENT_PACKAGE.md
🏗️ Architecture: ARCHITECTURE.md
📊 Complete history: docs/CHANGELOG.md
🔒 Security: docs/SECURITY_AUDIT_REPORT.md

🎓 Learning Path

For End Users (Just Want to Use LMS)

Extract LMS-Setup.zip (1 min)
Read QUICKSTART.txt (2 min)
Run java -jar LMS-Setup.jar (2 min)
Launch run.bat or run.sh and start using (ongoing)
Questions? Read APPLICATION_LAUNCH_GUIDE.md

Total Setup Time: ~5 minutes

For System Administrators (Installing for Others)

Read DEPLOYMENT_PACKAGE.md (understand 3 distribution options)
Read LAUNCHER_GUIDE.md (understand how launchers work)
Follow DEPLOYMENT_PACKAGE.md steps to package distribution
Test on Windows machine
Test on Linux machine
Distribute LMS-Setup.zip to your users
Reference LAUNCHER_GUIDE.md for troubleshooting

For Developers (Modifying Code)

Read ARCHITECTURE.md (understand system design)
Read GUIDELINES.md (understand coding standards)
Explore src/ folder (study existing code)
Read docs/CHANGELOG.md (understand recent changes)
Make modifications following guidelines
Test in local installation
Build new JAR: ./package-setup.sh
Commit with clear messages

🚀 Ready to Get Started?

For Users

# 1. Extract
unzip LMS-Setup.zip
cd LMS

# 2. Read quick start (2 minutes)
cat QUICKSTART.txt

# 3. Run setup (2 minutes, one-time)
java -jar LMS-Setup.jar

# 4. Launch application
./run.sh  # or run.bat on Windows

# ✨ Done! Enjoy LMS!

For Distributors

# See DEPLOYMENT_PACKAGE.md for:
# - What files to include
# - 3 distribution options
# - Step-by-step packaging
# - Email template for users

For Developers

# 1. Understand architecture
cat ARCHITECTURE.md

# 2. Understand standards
cat GUIDELINES.md

# 3. Start coding following the guidelines

❓ FAQ

Q: How long does setup take? A: About 2 minutes! Run java -jar LMS-Setup.jar and follow the wizard.

Q: Do I need to know the command line? A: No! Everything is automated. Just extract, run setup, click launch. No CLI needed.

Q: Can I run on Windows? A: Yes! Just double-click run.bat after setup.

Q: Can I run on Linux/Mac? A: Yes! Just run ./run.sh after setup.

Q: What database do I need? A: Oracle (10g XE or higher). Setup wizard handles everything.

Q: Can multiple users access simultaneously? A: Yes, the system is designed for 1-10 concurrent users.

Q: What if setup fails? A: Read APPLICATION_LAUNCH_GUIDE.md or LAUNCHER_GUIDE.md → Troubleshooting.

Q: Can I backup my data? A: Yes, use Oracle backup tools or export from Admin Panel.

Q: Is LMS secure? A: Yes! Includes password hashing, role-based access, audit logging. See docs/SECURITY_AUDIT_REPORT.md.

Q: What if I forget the admin password? A: Run setup wizard again to create a new admin user.

Q: Can I access from mobile? A: Currently desktop-only. Future enhancement planned.

Q: What are the system requirements? A: Java 8+ and Oracle database. See System Requirements section above.

📞 Getting Help

Problem? Follow this order:

Setup/Launch Problems? → APPLICATION_LAUNCH_GUIDE.md
Windows Issues? → LAUNCHER_GUIDE.md (Windows section)
Linux/Mac Issues? → LAUNCHER_GUIDE.md (Linux section)
Installation/Distribution? → DEPLOYMENT_PACKAGE.md
Architecture Questions? → ARCHITECTURE.md
Development Questions? → GUIDELINES.md
Still Stuck? → Check docs/CHANGELOG.md (what's been fixed)

🎉 You're Ready!

Quick Summary

✅ Setup: Run java -jar LMS-Setup.jar (2 min, one-time) ✅ Launch: Double-click run.bat or run.sh ✅ Use: Login and start managing your library ✅ Help: Read QUICKSTART.txt or APPLICATION_LAUNCH_GUIDE.md

Next Steps

Extract LMS-Setup.zip
Read QUICKSTART.txt (2 min)
Run java -jar LMS-Setup.jar
Launch the application
Enjoy! 📚

✨ Latest Features (v0.1)

Fixed & Production Ready:

✅ SQL parser now handles inline comments correctly
✅ PL/SQL parser now handles "/" correctly
✅ Launchers auto-validate Java, directories, database
✅ Desktop shortcut creation (one-click access)
✅ Setup wizard completely automated
✅ Admin user created automatically
✅ Comprehensive error messages
✅ Professional user guides included
✅ Ready for end-user distribution

Next Release Planned:

🔜 Mobile app support
🔜 Connection pooling for larger deployments
🔜 Enhanced reporting features

Enjoy LMS! 📚

Name		Name	Last commit message	Last commit date
Latest commit History 35 Commits
META-INF		META-INF
docs		docs
lib		lib
skills/lms-project		skills/lms-project
src		src
.env.example		.env.example
.gitattributes		.gitattributes
.gitignore		.gitignore
APPLICATION_LAUNCH_GUIDE.md		APPLICATION_LAUNCH_GUIDE.md
ARCHITECTURE.md		ARCHITECTURE.md
DEPLOYMENT_PACKAGE.md		DEPLOYMENT_PACKAGE.md
DISTRIBUTION_CHECKLIST.txt		DISTRIBUTION_CHECKLIST.txt
FILES_REFERENCE.md		FILES_REFERENCE.md
GUIDELINES.md		GUIDELINES.md
INSTALLATION_GUIDE.md		INSTALLATION_GUIDE.md
LAUNCHER_GUIDE.md		LAUNCHER_GUIDE.md
LMS.iml		LMS.iml
MANIFEST-SETUP-PROD.MF		MANIFEST-SETUP-PROD.MF
MANIFEST-SETUP.MF		MANIFEST-SETUP.MF
OracleInspector.java		OracleInspector.java
PRODUCTION_FIXES_REPORT.md		PRODUCTION_FIXES_REPORT.md
PRODUCTION_READY_REPORT.md		PRODUCTION_READY_REPORT.md
QUICKSTART.txt		QUICKSTART.txt
README.md		README.md
TestInstallation.java		TestInstallation.java
cleanup_prj2531h.sql		cleanup_prj2531h.sql
create-shortcut.bat		create-shortcut.bat
create-shortcut.sh		create-shortcut.sh
drop_user_safe.sql		drop_user_safe.sql
dummy.sql		dummy.sql
lms-setup.bat		lms-setup.bat
lms-setup.sh		lms-setup.sh
package-setup.bat		package-setup.bat
package-setup.sh		package-setup.sh
run-with-env.bat		run-with-env.bat
run-with-env.sh		run-with-env.sh
run.bat		run.bat
run.sh		run.sh
script.sql		script.sql
setup-wizard.sh		setup-wizard.sh
test-setup-build.sh		test-setup-build.sh
test-workflow.sh		test-workflow.sh
uninstall.bat		uninstall.bat
uninstall.sh		uninstall.sh
verify-setup.sh		verify-setup.sh

Folders and files

Latest commit

History

Repository files navigation

Library Management System (LMS)

🚀 Quick Start

For End Users (One-Time Setup)

For Developers (Building from Source)

📋 Features

✅ Book Management

✅ Student Management

✅ Circulation Management

✅ Transaction Management

✅ Admin & Reporting

✅ Security

🛠️ System Requirements

Minimum Requirements

Optional (for Containerized Database)

Supported Operating Systems

📦 What's Included

Distribution Package (318 MB)

Source Repository

🏗️ Architecture Overview

Four-Layer Architecture

Key Modules

📖 Documentation

For End Users

For System Administrators & IT

For Developers

Quick Links

🗄️ Database Setup

Automatic (Recommended) ✅

Manual Setup (Optional)

Database Details

Oracle via Container

🎯 Common Tasks

First-Time User

Admin Tasks

Librarian Tasks

🔧 Troubleshooting

Setup Wizard Issues

Application Launch Issues

More Help

📊 Sample Workflows

Issue a Book Workflow

Student Registration Workflow

Admin Setup Workflow

🔒 Security Features

📈 Performance Characteristics

Capacity Planning

🚀 Deployment Options

Option 1: Standalone Installation (Recommended for Most)

Option 2: Server Deployment

Option 3: Container Deployment (Advanced)

📝 License & Support

🎓 Learning Path

For End Users (Just Want to Use LMS)

For System Administrators (Installing for Others)

For Developers (Modifying Code)

🚀 Ready to Get Started?

For Users

For Distributors

For Developers

❓ FAQ

📞 Getting Help

🎉 You're Ready!

Quick Summary

Next Steps

✨ Latest Features (v0.1)

About

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Contributors

Uh oh!

Packages