the file for exporting the database structure is contained in the folder src/main/resources/com/example/demo/sql_files
. database already has data.
this is the implementation of a business school website with advanced training courses. there are two parts - student and manager. the student has access to editing the profile, viewing courses, enrolling in them, viewing applications and grading the course after the application is approved.
the manager can review applications, view all applications, download or view business school reports, modify existing courses, and add new courses.
first of all, the user - the guest - must register in the system. the program includes input error handling. this is what the login screen looks like. before that, the user - the guest - will not be able to get any information.
then access to one of two personal accounts is possible - the manager, who is previously registered in the system, and the student.
if you are afraid to register, then you can log in with the password and login of an already created user:
login = eckyl@bk.ru password = sds2013
manager login and password are:
login = manager password = sds2013
manager's personal account interface:
the manager can download a xlsx-report on students or courses:
students's personal account interface: