QuizCore

QuizCore – A Java Swing based Quiz Management System with MySQL Database. Features include student login, quiz attempt with timer, abilities (50-50, skip, hint, add time), auto result calculation, result history, admin panel for adding & managing questions, and customizable settings.

Features

Student Side:

• Login with details
• Attempt quizzes by subject
• Timer-based quiz
• Abilities: 50-50, Skip (limited), Add Time, Hint
• Automatic result calculation
• Result history with CSV export

Admin Side:

• Add / Manage / View Questions
• Settings (time, number of questions, pass percentage, abilities allowed)
• View all students' results

Repo contents

• src/ — Java source (NetBeans layout)
• sql/quizcore_dump.sql — database schema + sample questions
• db.properties.example — DB config template (copy to db.properties)
• .gitignore — recommended ignore file

---

Quick start (developer / another machine)

Requirements

• Java 17 (or the Java version you used)
• MySQL 8 (or compatible)
• NetBeans (recommended) or your favorite IDE
• (Optional) MySQL Workbench or CLI for importing SQL

Setup DB (Import dump)

1. Create database quizcore (or choose another name and update jdbc.url).
2. Import the SQL dump:
   • MySQL Workbench: Server > Data Import > Import from Self-Contained File → choose sql/quizcore_dump.sql → Select Import to Existing Database: quizcore → Start Import.
   • CLI: bash mysql -u root -p CREATE DATABASE quizcore; exit mysql -u root -p quizcore < sql/quizcore_dump.sql

Configure application DB connection

1. Copy db.properties.example → db.properties
2. Fill values:
   • jdbc.url=jdbc:mysql://localhost:3306/quizcore?useSSL=false&serverTimezone=UTC jdbc.username=root jdbc.password=your_password
3. Place db.properties under src/main/resources/ (so it's on classpath) or next to compiled classes.

Run in NetBeans

• Open the project folder in NetBeans (File -> Open Project).
• Build and Run.
• OR run main in quizcore.student.QuizPanel for demo.

---

Notes & security

• Do not commit db.properties containing real credentials.
• If you publish to public GitHub, remove any secrets and rotate passwords if accidentally committed.

---

Export DB for distribution

• I included sql/quizcore_dump.sql which contains CREATE TABLE ... and sample data. Import it on target machine to recreate DB.

---

Screenshots

License

(Apache 2.0)