StayTracked is a simple Project Tracking System developed in Java with a MySQL database. It helps users manage projects, track progress, and handle team accounts using OOP principles like inheritance and polymorphism.
- 🔐 User Management
- Manager and Normal Accounts
- Secure authentication
- Team-based access control
- 📌 Project Management
- Create, update, and delete projects
- Task assignment and tracking
- 🗄️ Database Integration
- Structured MySQL database with relationships
- Predefined SQL scripts for easy setup
- Java Development Kit (JDK 8 or later)
- Apache NetBeans IDE (Recommended for easier setup)
- MySQL Server (For database management)
- MySQL Connector/J (JDBC driver for Java and MySQL integration)
- Programming Language: Java
- Database: MySQL
- IDE: Apache NetBeans
- Version Control: Git & GitHub
- GUI Framework: Swing (with FlatLaf theme)
- Download and extract StayTracked.zip.
- You will get a folder named StayTracked/ (NetBeans project).
- Keep the Additional NetBeans Libraries/ folder in the same location (it contains required external JARs).
- Open Apache NetBeans.
- Go to File → Open Project.
- Select the extracted StayTracked/ folder and open it.
- If prompted, install missing plugins.
- Right-click StayTracked in NetBeans.
- Select Properties → Libraries.
- Click Add JAR/Folder.
- Navigate to the Additional NetBeans Libraries/ folder.
- Select all JAR files inside and add them to the project.
- Click OK to save changes.
- Open MySQL Workbench (or any SQL client).
- Create a new database named
StayTracked
:CREATE DATABASE StayTracked;
- Inside the StayTracked/ project folder, find
StayTrackedDB.sql
. - Import
StayTrackedDB.sql
into MySQL:- In MySQL Workbench, go to Server → Data Import.
- Select Import from Self-Contained File and choose
StayTrackedDB.sql
. - Click Start Import.
- Open
DBConnectionManager.java
inside NetBeans. - Update your database credentials:
String userName = "[your SQL username]"; String passWord = "[your SQL password, if any]";
- In NetBeans, right-click StayTracked and select Run.
- The StayTracked system should now launch successfully!
- Manager accounts can create teams and manage projects.
- Normal accounts can join teams and track tasks.
- Managers can create, assign projects to team members, and delete projects.
- Team members can view, update, and track project tasks.
For questions, contact us at aayan.shazim@gmail.com and malikharis2003@gmail.com.