Modern responsive web application with Java Spring Boot backend, MySQL database, and AWS deployment support.

• Responsive Dashboard - Modern UI with real-time analytics
• REST API - Complete CRUD operations with Spring Boot
• Analytics Engine - Built-in reporting with MySQL views and procedures
• AWS Ready - Configured for Elastic Beanstalk and RDS deployment
• Mobile First - Fully responsive design with Tailwind CSS

• 🏗️ Architecture

• Frontend (HTML/CSS/JS) → Spring Boot API → MySQL Database
                                      ↓
                                AWS Elastic Beanstalk + RDS
• Frontend: Responsive HTML/CSS/JS with Tailwind CSS
• Backend: Java Spring Boot REST API
• Database: MySQL with analytics capabilities
• Hosting: AWS Elastic Beanstalk + RDS

• 📦 Quick Start

  Prerequisites

  • Java 11+
  • Maven 3.6+
  • MySQL 8.0+
  • AWS CLI (for deployment)

  Local Development

  1. Clone the repository

     git clone <your-repo-url>
     cd webapp-project
  2. Setup MySQL database
  3. mysql -u root -p < database/schema.sql
     mysql -u root -p < database/sample-data.sql
  4. # Set environment variables or update application.properties
     export DB_HOST=localhost
     export DB_NAME=webapp_db
     export DB_USER=root
     export DB_PASSWORD=your-password
  5. run the application
  6. mvn spring-boot:run

  7. Access the dashboard Open http://localhost:8080

  8. 🚀 AWS Deployment

     Database Setup

     1. Connect to your RDS MySQL instance
     2. Run the SQL scripts:

        mysql -h your-rds-endpoint.amazonaws.com -u admin -p webapp_db < database/schema.sql
        mysql -h your-rds-endpoint.amazonaws.com -u admin -p webapp_db < database/sample-data.sql

         

     Application Deployment

     1. Build the application

        mvn clean package

         

     2. Deploy to Elastic Beanstalk

        eb init
        eb create
        eb deploy

         

     3. Set environment variables in EB console

        DB_HOST=your-rds-endpoint.amazonaws.com
        DB_NAME=webapp_db
        DB_USER=admin
        DB_PASSWORD=your-secure-password
        

         

     📊 API Endpoints

     Endpoint	Method	Description
     /api/dashboard/stats	GET	Dashboard statistics
     /api/products	GET/POST	Product management
     /api/products/top	GET	Top selling products
     /api/orders/recent	GET	Recent orders
     /api/analytics/monthly-sales	GET	Monthly sales data

     🗄️ Database Schema

     • users - User management and authentication
     • products - Product catalog with categories
     • orders - Order tracking and management
     • order_items - Detailed order line items
     • categories - Product categorization

     Analytics Views

     • monthly_sales - Revenue and order trends
     • product_performance - Product sales analytics

     🛠️ Tech Stack

     Frontend:

     • HTML5/CSS3/JavaScript
     • Tailwind CSS
     • Chart.js
     • Font Awesome

     Backend:

     • Java 11
     • Spring Boot 2.7
     • Spring Data JPA
     • MySQL Connector

     Database:

     • MySQL 8.0
     • Stored Procedures
     • Analytics Views

     Deployment:

     • AWS Elastic Beanstalk
     • AWS RDS MySQL
     • Maven

     📱 Screenshots

     The dashboard features:

     • Real-time statistics cards
     • Interactive sales charts
     • Product performance tables
     • Recent orders tracking
     • Fully responsive design

     🤝 Contributing

     1. Fork the repository
     2. Create a feature branch
     3. Commit your changes
     4. Push to the branch
     5. Create a Pull Request

     📄 License

     This project is licensed under the MIT License.

     🆘 Support

     For support and questions:

     • Create an issue in this repository
     • Check the AWS deployment guide above
     • Review the API documentation