Student record management is an application which connects and interfaces with a secure database to safely and securely store, view and update records.
Consider a scenario of a where lecturers, admin staff, and authorities need to go through the records of students for various purposes like searching for a particular student’s details. Manually going through records is a tedious job and time-consuming. Hence, it is better to have a software that allows users to insert, update, search, or delete records automatically. Hence, your team have been tasked with designing a Java program of a student record management system for CPUT faculty of engineering and the built environment. The design should enable the creation of new student records, store the personal and academic records of each student, allow all student records to be accessed by authorizes, but restrict access to lectures and admins (e.g., registration, courses enrollment).
-
Record management
a. Add/Remove/View personal info
b. Academic Records attached to profile
-
Access Control
a. Login Page (user control)
- Once logged in, able to change password
b. Different access levels
SRM uses a MySQL database to store and manage records
-
Use the connector to connect to database
SRM needs JAVA and JAVA Development Kit 23
-
JAVA Development Kit 23 can be found @
https://www.oracle.com/za/java/technologies/downloads/#jdk23-windows
-
JAVA can be found @
-
Download the SRM folder
Open in your favourite java editor e.g. Apache Netbeans
- Database view from inside Apache Netbeans
- Database view from linux server
