Installation and Setup Guide for JSP & MySQL

1️⃣ Prerequisites

Before you begin, ensure you have the following installed:

• Java Development Kit (JDK) (Recommended: JDK 8 or above)
• Apache Tomcat (Recommended: Tomcat 9 or above)
• MySQL Database Server (Ensure MySQL service is running)
• MySQL Connector/J (mysql-connector-j-9.2.0.jar)
• An IDE (Eclipse, IntelliJ, or NetBeans)

2️⃣ Setting Up MySQL Database

Step 1: Install MySQL Server

If not already installed, download and install MySQL from MySQL Downloads.

Step 2: Create a Database and Table

Run the following SQL commands to set up the database:

CREATE DATABASE test;
USE test;

CREATE TABLE students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL UNIQUE,
    age INT NOT NULL
);

3️⃣ Setting Up Apache Tomcat

Step 1: Download and Install Tomcat

• Download Apache Tomcat from Tomcat Official Site