| Field | Detail |
|---|---|
| 👤 Name | Samuel Monsalve Orrego |
| 🧭 Clan | Lovelace |
| samuel.monsalve.orrego@gmail.com | |
| 🪪 Document | CC 1013458915 |
A comprehensive desktop application for library management built with Java SE 17, featuring book catalog management, member registration, loan tracking, and CSV export capabilities.
- 🚀 Features
- 🏗️ Architecture
- 💻 Installation
- 🎯 Usage
- 🗄️ Database Schema
- 🧩 Project Structure
- 🧪 Testing
- ⚙️ Configuration
- 📖 API Documentation
- 🤝 Contributing
- 🎉 Acknowledgments
- CRUD Operations: Add, view, update, and delete books
- Advanced Search: Find books by title or author
- ISBN Validation: Ensure unique ISBN numbers
- Stock Control: Track total and available copies
- CSV Export: Export complete book catalog
- Member Registration: Add new library members
- ID Validation: Unique identification number system
- Status Management: Activate/deactivate members
- Contact Info: Store email and phone details
- CSV Export: Export member directory
- Loan Processing: Create book loans with validation
- Return Handling: Manage returns and fine calculation
- Transaction Safety: ACID-compliant loan operations
- Status Tracking: Active, returned, and overdue loans
- Loan Limits: Enforce per-member book limits
- Overdue Loans: Track and identify overdue books
- Fine Calculation: Automated fine computation
- CSV Reports: Export loan/overdue reports
- Activity Logging: Full operational logging
┌─────────────────┐ ┌─────────────────┐ ┌─────────────────┐
│ VIEW │ │ CONTROLLER │ │ SERVICE │
├─────────────────┤ ├─────────────────┤ ├─────────────────┤
│ MenuView │ │ BookController │ │ BookService │
│ BookView │◄---│MemberController │◄---│ MemberService │
│ MemberView │ │ LoanController │ │ LoanService │
│ LoanView │ └─────────────────┘ └─────────────────┘
└─────────────────┘ │ │
▼ ▼
┌─────────────────┐ ┌─────────────────┐
│ DAO │ │ DOMAIN │
├─────────────────┤ ├─────────────────┤
│ BookDAO │ │ Book │
│ MemberDAO │ │ Member │
│ LoanDAO │ │ Loan │
└─────────────────┘ └─────────────────┘
- 🧩 MVC Architecture: Clear separation of concerns
- 🗂️ DAO Pattern: Abstracts database access
- ⚙️ Service Layer: Encapsulates business logic
- 📦 DTO Pattern: Simplified data transfer
- ☕ Java JDK 17 or higher
- 🛢️ MySQL Server 8.0+
- 🔗 MySQL Connector/J 8.0+
-
Clone the Repository
git clone https://github.com/Samnmy/LibroNova.git cd LibroNova -
Configure Database Connection
Edit theconfig.propertiesfile:db.url=jdbc:mysql://localhost:3306/library_db db.user=your_username db.password=your_password
-
Add MySQL Connector
Download MySQL Connector/J
Add it to your project classpath. -
Run the Application
javac -cp ".:mysql-connector-java-8.0.xx.jar" app/Main.java java -cp ".:mysql-connector-java-8.0.xx.jar" app.Main
public class Main {
public static void main(String[] args) {
DatabaseConfig.initializeDatabase();
// Controllers and views auto-initialize
}
}📚 Book Management: Add, search, update, delete, export
👥 Member Management: Register, view, update, deactivate, export
🔄 Loan Management: Create, return, view, overdue, history
📊 Reports: Overdue loans and CSV reports
File: library_db.sql
books— book informationmembers— library membersloans— loan transactions- Includes foreign key relationships and constraints
LibroNova/
├── src/
│ ├── app/
│ │ ├── Main.java
│ │ └── TestConnection.java
│ ├── config/
│ │ └── DatabaseConfig.java
│ ├── controller/
│ │ ├── BookController.java
│ │ ├── MemberController.java
│ │ └── LoanController.java
│ ├── dao/
│ │ ├── BookDAO.java
│ │ ├── BookDAOJDBC.java
│ │ ├── MemberDAO.java
│ │ ├── MemberDAOJDBC.java
│ │ ├── LoanDAO.java
│ │ └── LoanDAOJDBC.java
│ ├── domain/
│ │ ├── Book.java
│ │ ├── Member.java
│ │ └── Loan.java
│ ├── exceptions/
│ │ └── BusinessException.java
│ ├── service/
│ │ ├── BookService.java
│ │ ├── MemberService.java
│ │ └── LoanService.java
│ ├── util/
│ │ ├── CSVExportUtil.java
│ │ └── DateUtils.java
│ └── view/
│ ├── BookView.java
│ ├── MemberView.java
│ ├── LoanView.java
│ └── MenuView.java
├── export/
├── config.properties
├── library_db.sql
└── README.md
javac -cp ".:mysql-connector-java-8.0.xx.jar:junit-platform-console-standalone-1.9.0.jar" service/*Test.java
java -jar junit-platform-console-standalone-1.9.0.jar --class-path . --scan-class-path- BookServiceTest: CRUD operations and validation
- MemberServiceTest: Member management
- LoanServiceTest: Loan logic and fines
- DomainObjectsTest: Entity validation
# Database Configuration
db.url=jdbc:mysql://localhost:3306/library_db
db.user=root
db.password=your_password
# Business Rules
loan.days=14
fine.per.day=5.00
max.books.per.member=3- INFO: General operations
- WARNING: Business rule violations
- SEVERE: Errors and exceptions
- FINE: Debug information
public class BookService {
public void addBook(Book book) throws BusinessException;
public List<Book> getAllBooks();
public Optional<Book> getBookByIsbn(String isbn);
public void updateBook(Book book) throws BusinessException;
public void deleteBook(Integer id) throws BusinessException;
public boolean isBookAvailableForLoan(Integer bookId);
}public class LoanService {
public void createLoan(Integer bookId, Integer memberId) throws BusinessException;
public void returnLoan(Integer loanId) throws BusinessException;
public List<Loan> getActiveLoans();
public List<Loan> getOverdueLoans();
public int countActiveLoansByMember(Integer memberId);
}We welcome contributions!
- Fork the repository
- Create a branch
git checkout -b feature/AmazingFeature
- Commit your changes
git commit -m "Add AmazingFeature" - Push to the branch
git push origin feature/AmazingFeature
- Open a Pull Request
- ☕ Built with Java SE 17
- 🛢️ MySQL for data persistence
- 🧪 JUnit 5 for testing
- 📘 PlantUML for diagrams
© 2025 LibroNova Project — Developed with ❤️ by Samnmy