Book Management System

A Java-based web application for managing books and authors using Servlets and Oracle Database.

📋 Overview

This Book Management System allows users to add and view book details along with author information. It demonstrates the use of Java Servlets, JDBC, and DAO design pattern for database operations.

✨ Features

• Add Books: Add new books with ISBN, title, type (General/Technical), author, and cost
• View Books: Search and display book details by ISBN
• Author Management: Maintain author information with contact details
• Input Validation: Validates book data before insertion
• Database Integration: Uses Oracle Database for persistent storage

🛠️ Technologies Used

• Backend: Java Servlets (Jakarta EE)
• Database: Oracle Database 11g/12c
• JDBC: Oracle JDBC Driver
• Server: Apache Tomcat 10.1.x
• Frontend: HTML5
• Design Pattern: DAO (Data Access Object)

📁 Project Structure

src/
├── com.wipro.book.bean/
│   ├── AuthorBean.java      # Author entity
│   └── BookBean.java         # Book entity
├── com.wipro.book.dao/
│   ├── AuthorDAO.java        # Author data access operations
│   └── BookDAO.java          # Book data access operations
├── com.wipro.book.service/
│   └── Administrator.java    # Business logic layer
├── com.wipro.book.servlet/
│   ├── MainServlet.java      # Handles add/view operations
│   └── ViewServlet.java      # Displays book details
└── com.wipro.book.util/
    └── DBUtil.java           # Database connection utility

webapp/
├── AddBook.html              # Add book form
├── ViewBook.html             # Search book form
├── Index.html                # Main menu
├── Invalid.html              # Invalid input page
└── Failure.html              # Operation failure page

🗄️ Database Schema

Author_tbl

CREATE TABLE Author_tbl (
    Author_code NUMBER(5) PRIMARY KEY,
    Author_name VARCHAR2(20) NOT NULL,
    Contact_no NUMBER(10)
);

Book_tbl

CREATE TABLE Book_tbl (
    ISBN VARCHAR2(10) PRIMARY KEY,
    BOOK_TITLE VARCHAR2(20) NOT NULL,
    BOOK_TYPE CHAR(1),
    AUTHOR_CODE NUMBER(5),
    BOOK_COST NUMBER(8,2),
    CONSTRAINT fk_author FOREIGN KEY (AUTHOR_CODE) REFERENCES Author_tbl(Author_code)
);

Sample Data

INSERT INTO Author_tbl VALUES (1, 'ROBINSharma', 8800799224);
INSERT INTO Author_tbl VALUES (2, 'R.K.Narayan', 9971935000);
INSERT INTO Author_tbl VALUES (3, 'Paulo coleho', 9876543212);
COMMIT;

🚀 Setup Instructions

Prerequisites

• JDK 11 or higher
• Apache Tomcat 10.1.x
• Oracle Database 11g/12c
• Oracle JDBC Driver (ojdbc8.jar or higher)

Installation Steps

1. Clone the repository

   git clone https://github.com/yourusername/book-management-system.git
   cd book-management-system

2. Configure Database
   • Update database credentials in DBUtil.java:

   String url = "jdbc:oracle:thin:@localhost:1521:xe";
   String user = "your_username";
   String pass = "your_password";

3. Create Database Tables

   • Execute the SQL scripts provided in the Database Schema section
   • Insert sample author data

4. Add JDBC Driver

   • Place ojdbc8.jar in /WEB-INF/lib/ directory

5. Deploy to Tomcat

   • Build the project as a WAR file
   • Deploy to Tomcat's webapps directory
   • Start Tomcat server

6. Access Application

   • Open browser and navigate to: http://localhost:8080/Library Management System/Main.html

📖 Usage

Adding a Book

1. Click on "ADD BOOK" from the main menu
2. Fill in the book details:
   • ISBN Number
   • Book Name
   • Book Type (General/Technical)
   • Select Author
   • Book Cost
3. Click "AddBook" to save

Viewing a Book

1. Click on "VIEW BOOK" from the main menu
2. Enter the ISBN code
3. Click "ViewBook" to display details

⚙️ Configuration

Book Type Options

• G: General
• T: Technical

Validation Rules

• All fields are mandatory
• Book cost must be positive
• ISBN must be unique
• Author must exist in the database
• Book type must be either 'G' or 'T'

🐛 Troubleshooting

Common Issues

1. ORA-01438: value larger than specified precision

• Ensure book cost doesn't exceed 999,999.99
• Solution: Modify column size or enter smaller values

2. Author not found

• Verify author name matches exactly with database (case-sensitive)
• Check for extra spaces in author names

3. Database connection failed

• Verify Oracle service is running
• Check database credentials in DBUtil.java
• Ensure JDBC driver is in classpath

🤝 Contributing

Contributions are welcome! Please follow these steps:

1. Fork the repository
2. Create a feature branch (git checkout -b feature/YourFeature)
3. Commit your changes (git commit -m 'Add some feature')
4. Push to the branch (git push origin feature/YourFeature)
5. Open a Pull Request

📝 License

This project is open source and available under the MIT License.

👤 Author

Your Name

• GitHub: @Sham0511

🙏 Acknowledgments

• Wipro Training Program
• Java Servlet Documentation
• Oracle Database Documentation

---

Note: This is an educational project demonstrating servlet-based web application development with database integration.

OUTPUT: