iReedBooks-2

iReedBooks-2 is an online bookshop project where users can browse and purchase books across various categories, simulate checkout, and manage orders. It includes an admin panel for management tasks such as book, author, and genre administration. (github.com)

Table of Contents

• Features
• Tech Stack
• Prerequisites
• Installation
• Usage
• Project Structure
• Database Schema
• Configuration
• Contributing
• License

Features

• User authentication (login, register, password reset) (github.com)
• Remember-me and session management with filters and listeners (github.com, github.com)
• Browse books by categories and authors, view detailed book pages (github.com)
• Shopping cart and checkout simulation (github.com)
• Order tracking and order history (github.com)
• Admin panel for managing books, authors, genres, and orders (github.com)
• Email notifications for order confirmations (github.com)

Tech Stack

• Java EE (Servlets & JSP)
• Microsoft SQL Server 18 (mssql-JDBC driver) (github.com)
• Apache Tomcat (or any servlet container)
• Ant (build.xml) (github.com)
• NetBeans IDE project

Prerequisites

• Java JDK 8 or higher
• Microsoft SQL Server 18
• Apache Tomcat or compatible servlet container
• (Optional) NetBeans IDE for development

Installation

1. Clone the repository:

   git clone https://github.com/COSYBANANA63/iReedBooks-2.git
   cd iReedBooks-2

2. Import into NetBeans or build with Ant:

   ant clean build

3. Set up the database:
   • Run the script at DB/script.sql to create the BookStore database and schema. (github.com, github.com)
4. Configure the database connection in src/java/util/DatabaseConnection.java (update JDBC_URL). (github.com)
5. Configure SMTP settings in src/java/util/EmailService.java (update SMTP_HOST, SMTP_USER, SMTP_PASSWORD). (github.com)
6. Deploy the generated WAR (dist/iReedBooks_2_Web_exploded) to your servlet container.

Usage

• Access the application at http://localhost:8080/iReedBooks-2/.
• Register a new user or log in at /auth/login.
• Browse books at /bookList.jsp or the homepage.
• Manage your cart at /cart.jsp.
• Checkout and view orders at /orders.jsp.
• Admin pages:
  • Login at /admin-login.jsp.
  • Dashboard at /admin-dashboard.jsp.

Project Structure

📦iReedBooks-2
 ┣ DB/
 ┃ ┗ script.sql (database setup)              ([github.com](https://github.com/COSYBANANA63/iReedBooks-2/tree/master/DB), [github.com](https://github.com/COSYBANANA63/iReedBooks-2/blob/master/DB/script.sql))
 ┣ build.xml (Ant build script)             ([github.com](https://github.com/COSYBANANA63/iReedBooks-2/blob/master/build.xml))
 ┣ src/java/
 ┃ ┣ filters/ (session and security filters)([github.com](https://github.com/COSYBANANA63/iReedBooks-2/blob/master/src/java/filters/SessionCheckFilter.java))
 ┃ ┣ servlets/ (core servlets handling requests) ([github.com](https://github.com/COSYBANANA63/iReedBooks-2/tree/master/src/java/servlets))
 ┃ ┗ util/ (utility classes: DB connection, email, listeners)([github.com](https://github.com/COSYBANANA63/iReedBooks-2/blob/master/src/java/util/DatabaseConnection.java), [github.com](https://github.com/COSYBANANA63/iReedBooks-2/blob/master/src/java/util/EmailService.java))
 ┗ web/ (JSP pages and static assets)      ([github.com](https://github.com/COSYBANANA63/iReedBooks-2/tree/master/web))

Database Schema

The DB/script.sql file defines tables such as Users, Book, Genre, Author, Transactions, RememberMeTokens, and others, along with foreign key relationships and indexes. (github.com)

Configuration

Update the following configuration files:

• src/java/util/DatabaseConnection.java: JDBC connection URL.
• src/java/util/EmailService.java: SMTP host, user, and password.
• web/WEB-INF/web.xml: servlet mappings and filter configurations.

Contributing

Contributions are welcome! Please fork the repository and submit a pull request.

License

MIT