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...
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.
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.
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
ApacheandMySql. - Then click Admin button under MySql section.
From your command line, first clone Timetable-Management-System:
- Method-01
# Clone the repository
$ git clone https://github.com/kusal-tharindu/Timetable-Management-System
- Method-02
Download directly from github.
- 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;
}
}
- 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)
Run the project. (Click the green triangle icon for that)
- 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.
- Fill the relevant information in the black.
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
- 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.
- If you are registered as an administrator you can add, update and delete Users.
- You can book the seat through this jframe.
- Here, you can search the location.
- Here, You can add, update and delete Users.
-
Kusal Tharindu -
- Kusal Tharindu
-
This project is licensed under the MIT License.
Find out more details: LICENSE.md
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
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.
If you have any questions about this Privacy Policy, You can contact us:
- By email: [email protected]