University Application - JAVA, MySQL
This is a university application that uses Java Swing in the front-end and MYSQL at the back-end. This app enables students to perform certain activities relating courses that are offered and friends on the application. Users can also update/change their profile on the app.
Features that this application offers are as below:
1. User can login to the system.
User can only login using the credentials (username & password) stored on MySQL database. If the input is incorrect, an error message is displayed. If login is successful, a welcome dialog window is displayed.
2. User can check/search all available courses in the system & view details about them.
After logging in the main page is displayed. User can check there the list of the courses offered in this app, as well as other details: course instructor, course program, schedule, location and what major the course belongs to. User can search in the table by course name or course instructor.
3. User can add or drop a course.
On the main page, user can add a course to his/her course list. User needs to insert the course ID. If the course doesn't belong to the major of the user, an error dialog window is displayed, showing that user should join a course to his/her major. When add is successful, another dialog window showing that the course is added to course list is displayed and the data: course ID, student ID and date enrolled is placed to list.
Also, on the main page user can drop a course. If the course is not on the course's list, an error dialog window is displayed, otherwise the dropping is successful.
4. User can check/search all students in the system.
On main page, user can search students on the app, as well as their data: email, major.
5. User can add friends to his friend list.
On main page, user can add friends to his/her friend list. User cannot add him/herself as a friend, neither add a friend that doesn't exist on the database. If the adding is valid, a successful dialog window is displayed.
6. User can add comments about a course.
On main page, user can add comments about courses. He/she should insert name, course and comment in order to insert comments on the forum.
7. User can "Check on recent" to see who has recently joined a course.
Users are able to see the activity feed of other users when they join a specific course.
8. User can edit and save his profile information.
On profile, users can modify their profile data: name, email and age. They cannot change their major, student ID and registered date. When saving the information, a successful dialog window is displayed.
9. User can check his courses list.
On profile, user can check on courses he/she has enrolled. There user can check the course name, course ID, start date and end date of the course.
10. User can check his friend list.
On profile, users can see their friend's list, as well as friend's data which include: email, registration date and age.
11. User can check friend's courses.
On profile, users can check courses that their friends have enrolled, their course ID, start date and end date of the course.
The source code can be found here.