v2.0-Java

🎓 Student GUI — Java v2.0

An enhanced Java Swing desktop app for managing student marks, upgraded with modern features matching the Python v2 release.

✨ What's New in v2.0

• 📊 Excel export (.xlsx) — replaces CSV, opens in Excel/Google Sheets
• 🔑 UUID v7 time-ordered IDs in the database (better indexing)
• 🎨 Appearance toggle — switch between Light and Dark mode live
• 📐 2-column subject marks layout — cleaner form UX
• 📈 Improved bar chart — value labels above each bar, Y-axis fixed at 0–100
• 🛡️ Enhanced input validation — 9 SQL injection patterns + HTML sanitization

📥 Installation

1. Download StudentGUI-v2-2.0.exe
2. Run the installer and follow the setup wizard
3. Create a .env file in the install directory:

DB_HOST=your-db-host DB_USER=your_user DB_PASS=your_password DB_NAME=your_db DB_PORT=3306

4. Launch StudentGUI-v2 from the Start Menu

⚙️ Requirements

• Windows 10/11
• MySQL database (local or cloud — e.g. Aiven)

📦 Assets

File	Description
StudentGUI-v2-2.0.exe	Windows installer

v1.0-Java

🎓 Student GUI - Java v1.0

A Java Swing desktop application to manage student marks with a MySQL database backend.

✨ Features

• Add, update, and delete student records
• Enter marks for 6 subjects: Science, Social, Maths, English, Hindi, Kannada
• View all records in a sortable table
• Charts and export support

📥 Installation

1. Download StudentGUI-1.0.exe below
2. Run the installer and follow the setup wizard
3. Create a .env file in the install directory with your DB credentials:

DB_HOST=your-db-host DB_USER=your_user DB_PASS=your_password DB_NAME=your_db DB_PORT=3306

4. Launch StudentGUI from the Start Menu

⚙️ Requirements

• Windows 10/11
• MySQL database (local or cloud e.g. Aiven)

📦 Assets

File	Description
StudentGUI-1.0.exe	Windows installer

(Student Management System) SMS Pro App (v2.0)

🎓 SMS Pro - Student Management System v2.0

We are excited to announce the release of SMS Pro v2.0! This version is a complete overhaul of the original Student Management System, featuring a modern design, advanced analytics, and improved data management.

✨ Highlights

Modern UI Engine: Migrated from standard Tkinter to CustomTkinter for a premium, high-DPI responsive interface.
Performance Analytics: A new dedicated dashboard with real-time charts to visualize student performance per subject.
Excel Integration: One-click export functionality to generate professional .xlsx student reports.

🚀 Key Features

Dynamic Dashboard: View total student counts, class averages, and top performers at a glance.
Live Search: Instantly filter student records by Name or Roll Number.
Visual Charts: Interactive bar charts for subject-wise average scoring.
Appearance Modes: Support for Dark Mode, Light Mode, and System Sync.
Robust Data Entry: Streamlined form for adding student marks across 6 major subjects.

🛠 Fixes & Improvements

Graceful Error Handling: The app now informs you of database connection issues instead of closing unexpectedly.
Input Validation: Added checks to ensure marks are numeric and required fields are filled.
Database Resilience: Improved connection pooling logic in
database_helper.py
to prevent data loss.

📦 What's included?

SMS_Pro.exe: Standalone Windows executable.
Source code: Fully modular Python code (gui_app_v2.py, database_helper.py).

⚙️ Setup Instructions

1. Download the SMS_Pro.exe from the assets below.
2. Create a .env file in the same folder as the EXE with your MySQL credentials:
3. Launch the app and manage your student data like a pro!

DB_HOST=your_host
DB_USER=your_user
DB_PASS=your_password
DB_NAME=your_database
DB_PORT=your_port

---

Found a bug? Open an issue on GitHub!

(Student Management System) SMS Pro App (v1.0)

(Student Management System) SMS Pro App (v1.0)

We have packaged the Student Marks System into a standalone Windows application! You can now run the tool without installing Python or any libraries.

📥 Download Student Marks Management System.exe

System Requirements:

• OS: Windows 10/11
• Internet: Required (To connect to the Cloud Database)

🔧 How to Run

1. Download the .exe file from the Assets section below.
2. Double-click to launch.

⚠️ Note on Windows Security

Since this is a custom application and not signed by Microsoft, Windows Defender might show a warning popup saying "Windows protected your PC".
(This happens because the app was built by an individual developer, not a registered corporation.)

This is how it will look once installed

Changelog v1.0:

• ✅ Full GUI support (Tkinter).
• ✅ Direct connection to Cloud MySQL Server.
• ✅ Error handling for duplicate entries.
• ✅ Standalone executable format.

Full Changelog: https://github.com/toxicbishop/python-mysql-marks/commits/v1.0