DTKproject ⚡️

Timetable-Management-System !

Features

In this project I created Desktop application using Java. You can use this application to manage your timetable in a good way. You can develop this project as you wish under the MIT license.

⚡️ The application has three types of users.

• Student
• Lecturer
• Admin

⚡️ Connect directly with the mysql database.
⚡️ Real time data update to application.
⚡️ The database contains 7 data tables.

• assessments
• exam_details
• issue_time
• lecturers
• location
• subjects
• userdetails

⚡️ All data table operations with DML. (Data Manipulation Language)

• Data INSERT
• Data UPDATE
• Data DELETE

⚡️ User login authentication with real database data.
⚡️ Automatically identify the login user and their corresponding tasks.
⚡️ Better real-time data analysis with pie chart and tables
⚡️ And many more features...

---

Getting Started 🚀

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. Follow the below steps for that.

1. Prerequisites 📋

You'll need NetBeans and phpMyAdmin installed on your computer.

I am demonstrating this demo using windows operating system. If you are using other OS please use relevet Prerequisites program version.

2. Download 👇

• NetBeans
• phpMyAdmin

3. how to run phpMyAdmin for windows ? 🤷‍♀️

The easiest way to get phpMyAdmin on Windows is using third party products which include phpMyAdmin together with a database and web server such as XAMPP.

• After installing it, you need to start Apache and MySql.
• Then click Admin button under MySql section.

---

How To Use 🔧

From your command line, first clone Timetable-Management-System:

1. Download code

• Method-01

# Clone the repository
$ git clone https://github.com/kusal-tharindu/Timetable-Management-System

• Method-02

Download directly from github.

2. Import the Sql source file into phpMyAdmin

• Go to the Import section and select the database file and import it. (downloaded Database file-name: schooltimetable)

For additional study ( This java code already have in the project file )

// Database connection code
	
public class DBConnection {
    
    public static void main(String args[]) {
        getConnection();
    }

   
    static Connection con = null;
    
    public static Connection getConnection(){
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/schooltimetable","root","");
            System.out.println("DataBase connected");
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("DataBase Disconnected");
        }
        return con;
    }  
}

3. Open nbproject via NetBeans

• Open the netbeans application and open the netBeans project under the files section.
• After that go to relevet downloaded extract-file and select it.
• Then run the project. (Click the green triangle icon for that)

---

How to work with Application?

Run the project. (Click the green triangle icon for that)

(1) Signup Jframe

• Provide details of username, password( With numbers, uppercase and lowercase ), email and user type.
• Then click on the signup button.

• Real time update data tables in database.

(2) Login Jframe

• Fill the relevant information in the black.

(3) Dashboard Jframe

The dashboard you get will vary depending on the user type you provide when you sign up. Accordingly there are three types of dashboard.

• Student Dashboard
• Lecturer Dashboard
• Admin Dashboard

(4) Admin Lecture Hall Jframe

• If you are registered as an administrator you can add, update and delete lecture halls.
• Also, you can see here all the lecture halls currently included in the system.

(5) Admin user add Jframe

• If you are registered as an administrator you can add, update and delete Users.

(6) Issuses Jframe

• You can book the seat through this jframe.

(7) Location Search Jframe

• Here, you can search the location.

(8) Subject add Jframe

• Here, You can add, update and delete Users.

---

Authors ✍

• Kusal Tharindu

•   - Kusal Tharindu

• 

Wanna read my articles?

•   Portfolio
•   Personal Blog

Contributors 🤝

•   Sasindu K Karunarathna
•   Malitha Abeysinghe
•   IMKDilshan

---

License 📄

This project is licensed under the MIT License.

Find out more details: LICENSE.md

---

Fair Use Act Disclaimer 🛑

This project is for educational purposes only.

Fair Use Copyright Disclaimer under section 107 of the Copyright Act of 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, education and research. Fair use is a use permitted by copyright statute that might otherwise be infringing.

Find out more details: Disclaimer.md

---

Acknowledgments 🎁

I was motivated to create this project because I wanted to contribute on something useful for the dev community.

Many thanks to all my contributors who helped make this project a reality.

---

You can help me by Donating 💰

---

Contact Me 📞

If you have any questions about this Privacy Policy, You can contact us:

• By email: contact@dtk2globle.com