SAIBOOK is a Java web application developed using core Java web technologies including JDBC, Servlets, JSP, and EL/JSTL.
The application simulates an online bookstore system with user and admin modules, cart management, and order processing functionality.
This project demonstrates strong foundational knowledge of Java web development before Spring Boot.
- Java
- JDBC
- Servlets
- JSP
- EL (Expression Language)
- JSTL
- Oracle
- Apache Tomcat
- Admin Login
- Add New Books
- Update Book Details
- Delete Books
- View All Books
- Manage Inventory
- User Registration
- User Login
- View Available Books
- Add to Cart
- Remove from Cart
- View Cart
- Purchase Books
- Logout
The application follows MVC pattern using Servlets:
JSP (View) → Servlet (Controller) → DAO (Model) → Database
- DAO Pattern
- MVC Architecture
- Session Management
- Structured relational schema
- Book entity management
- User authentication tables
- Cart and order tracking
- Optimized JDBC query handling
- HTTP Session used for:
- User authentication tracking
- Cart item storage
- Prevented unauthorized access to protected pages
- Layered DAO architecture
- Reusable database connection utility
- CRUD operations using JDBC
- Dynamic data rendering using JSP & EL
- Server-side request handling via Servlets
- Configure database credentials in
DBConnection.java - Deploy project on Apache Tomcat
- Access application via: http://localhost:8080/SAIBOOK_App
- Built complete web application without Spring framework
- Implemented MVC using Servlets and JSP
- Applied DAO pattern for database abstraction
- Managed sessions for authentication and cart handling
- Strengthened JDBC and SQL integration skills
Ganta Lakshman Naga Durga Sairam
Java Full Stack Developer
Hyderabad, India