🎓 Microservices – Student Management System

Java | J2EE | Spring Boot | REST | SOAP | MySQL | Docker | AWS EC2 | Python Mar 2024 – May 2024

A production-grade microservice for managing student records, exposing both REST and SOAP APIs, backed by MySQL, containerised with Docker, deployable on AWS EC2, and automated via Python scripts.

---

📁 Project Structure

student-management-system/
│
├── student-service/                   ← Spring Boot Microservice
│   ├── src/main/java/com/sms/
│   │   ├── StudentServiceApplication.java   ← Main class + seed data
│   │   ├── model/Student.java               ← JPA Entity
│   │   ├── repository/StudentRepository.java← Spring Data JPA
│   │   ├── service/StudentService.java      ← Business logic
│   │   ├── controller/
│   │   │   └── StudentRestController.java   ← REST API (@RestController)
│   │   └── soap/
│   │       ├── StudentSoapEndpoint.java     ← SOAP endpoint (@Endpoint)
│   │       ├── SoapModels.java              ← JAXB request/response
│   │       └── WebServiceConfig.java        ← WSDL + Spring WS config
│   ├── src/main/resources/
│   │   ├── application.properties
│   │   └── wsdl/students.xsd               ← XSD schema for SOAP
│   ├── pom.xml                             ← Maven dependencies
│   └── Dockerfile                          ← Multi-stage Docker build
│
├── frontend/
│   └── index.html                          ← Single-page dashboard UI
│
├── python-scripts/
│   ├── automation.py                       ← Bulk import, health check, stats
│   ├── soap_client.py                      ← Python SOAP client (zeep)
│   └── requirements.txt
│
├── SMS-Postman-Collection.json             ← Import into Postman
├── docker-compose.yml                      ← Full stack orchestration
├── nginx.conf                              ← Reverse proxy config
├── init.sql                                ← DB init script
├── deploy-ec2.sh                           ← AWS EC2 one-click deploy
└── README.md

---

🛠 Tech Stack

Layer	Technology
Language	Java 17 (J2EE)
Framework	Spring Boot 3.2
REST API	Spring MVC (@RestController)
SOAP API	Spring WS (@Endpoint, WSDL/XSD)
ORM	Spring Data JPA + Hibernate
Database	MySQL 8.0
Connection Pool	HikariCP
Validation	Bean Validation (Jakarta)
Monitoring	Spring Actuator
Containerisation	Docker + Docker Compose
Cloud	AWS EC2 (Ubuntu 22.04)
Reverse Proxy	Nginx
Automation	Python 3 (requests, zeep)
Testing	Postman, JUnit 5, MockMvc
Build Tool	Maven 3.9

---

🚀 Quick Start

Option A – Docker Compose (Recommended)

# 1. Clone and enter
git clone <repo-url>
cd student-management-system

# 2. Launch everything
docker-compose up -d

# 3. Run Python automation (bulk import + health check)
pip3 install -r python-scripts/requirements.txt
python3 python-scripts/automation.py all

Option B – Run Locally

# 1. Start MySQL
mysql -u root -p -e "CREATE DATABASE student_db;"

# 2. Configure DB in application.properties
cd student-service
# Edit src/main/resources/application.properties

# 3. Build & Run
mvn clean package -DskipTests
java -jar target/student-service-1.0.0.jar

---

🔌 REST API Reference

Base URL: http://localhost:8080/api

Method	Endpoint	Description
GET	/students	List all students
GET	/students?search=<kw>	Search by name/email/roll
GET	/students?department=<dept>	Filter by department
POST	/students	Create new student
GET	/students/{id}	Get student by ID
GET	/students/roll/{rollNumber}	Get by roll number
PUT	/students/{id}	Full update
PATCH	/students/{id}/status	Update status only
DELETE	/students/{id}	Delete student
GET	/students/stats/summary	Statistics overview
GET	/students/health	Health check

Create Student – Sample Payload

POST /api/students
{
  "firstName":  "Aarav",
  "lastName":   "Sharma",
  "email":      "aarav.sharma@sms.edu",
  "rollNumber": "CS2024001",
  "department": "Computer Science",
  "semester":   5,
  "phone":      "+91-9876543210",
  "gpa":        3.8,
  "status":     "ACTIVE"
}

---

🧼 SOAP Web Service

WSDL: http://localhost:8080/soap/students.wsdl
Endpoint: http://localhost:8080/soap
Namespace: http://sms.com/students/soap

Operations

Operation	Description
GetAllStudentsRequest	Get all students
GetStudentByIdRequest	Get student by ID
CreateStudentRequest	Create via SOAP
DeleteStudentRequest	Delete via SOAP

Sample SOAP Request

<soapenv:Envelope
  xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
  xmlns:tns="http://sms.com/students/soap">
  <soapenv:Body>
    <tns:GetStudentByIdRequest>
      <tns:id>1</tns:id>
    </tns:GetStudentByIdRequest>
  </soapenv:Body>
</soapenv:Envelope>

---

🐍 Python Automation

cd python-scripts
pip3 install -r requirements.txt

# Check service health
python3 automation.py health

# Bulk import from CSV
python3 automation.py import

# Export all to JSON
python3 automation.py export

# Print stats report
python3 automation.py stats

# SOAP client demo
python3 soap_client.py

# Run all tasks
python3 automation.py all

---

🐳 Docker

# Build image manually
docker build -t student-service ./student-service

# Run with env vars
docker run -d -p 8080:8080 \
  -e DB_HOST=mysql \
  -e DB_USER=sms_user \
  -e DB_PASS=sms_password \
  student-service

# Full stack
docker-compose up -d
docker-compose ps
docker-compose logs -f student-service

---

☁️ AWS EC2 Deployment

# SSH into your EC2 instance
ssh -i your-key.pem ubuntu@<EC2-IP>

# Upload project
scp -i your-key.pem -r student-management-system ubuntu@<EC2-IP>:~

# One-click deploy
chmod +x deploy-ec2.sh
./deploy-ec2.sh

screen short

EC2 Security Group – Required Inbound Rules:

Port	Protocol	Purpose
22	TCP	SSH
80	TCP	HTTP
3000	TCP	Frontend
8080	TCP	Spring Boot API

---

📮 Postman Testing

1. Open Postman
2. Click Import → select SMS-Postman-Collection.json
3. Set environment variable BASE_URL = http://localhost:8080
4. Run the collection

---

📊 Actuator Endpoints

URL	Purpose
/actuator/health	Health status
/actuator/info	App metadata
/actuator/metrics	JVM + HTTP metrics

---

🗄️ Database Schema

CREATE TABLE students (
  id           BIGINT AUTO_INCREMENT PRIMARY KEY,
  first_name   VARCHAR(100) NOT NULL,
  last_name    VARCHAR(100) NOT NULL,
  email        VARCHAR(150) UNIQUE NOT NULL,
  roll_number  VARCHAR(20)  UNIQUE NOT NULL,
  department   VARCHAR(100) NOT NULL,
  semester     INT,
  date_of_birth DATE,
  phone        VARCHAR(20),
  address      TEXT,
  gpa          DOUBLE,
  status       ENUM('ACTIVE','INACTIVE','GRADUATED','SUSPENDED') DEFAULT 'ACTIVE',
  created_at   DATETIME,
  updated_at   DATETIME
);

---

👤 Author

• Project: Microservices – Student Management System
• Duration: March 2024 – May 2024
• Stack: Java, J2EE, Spring Boot, REST, SOAP, MySQL, Docker, AWS EC2, Python