Skip to content

ConstantineVac/school-app-jsp-mysql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

School App Pro - README

Overview

School App Pro is a web application that allows user admins to manage various aspects of a school system. The application provides functionalities for signing up, signing in, and performing basic CRUD (Create, Read, Update, Delete) operations for teachers, meetings, students, cities, and specialties.

Features

The School App Pro provides the following features:

User Authentication

  • User admins can sign up and create an account.

image

  • Existing user admins can sign in with their credentials.

image

  • User Passwords are hash encrypted while stored in the Database. image

Teachers Management

  • User admins can add new teachers to the system.

image

  • User admins can view a list of all teachers in the school.
  • User admins can update the information of existing teachers (e.g., first name, last name).
  • User admins have the option to delete teachers from the system.

image

Meetings Management

  • User admins can schedule new meetings with specified teachers and students.

image

  • User admins can view a list of all scheduled meetings.
  • User admins can update the details of existing meetings (e.g., room, meeting date).
  • They can also cancel or delete scheduled meetings.

image

Students Management

  • User admins can add new students to the system.

image

  • User admins can view a list of all students enrolled in the school.
  • User admins have the ability to update student information (e.g., first name, last name, gender).
  • They can remove students from the system if needed.

image

Cities Management

  • User admins can add new cities to the system.

image

  • User admins can view a list of all cities where the school operates.
  • User admins can update city information (e.g., city name).
  • They can delete cities from the system.

image

Specialties Management

  • User admins can add new specialties to the system.

image

  • User admins can view a list of all specialties of all tutors working at the school.
  • User admins can update specialty information (e.g., specialty name).
  • They can delete specialties from the system.

image

Technologies Used

The School App Pro is built using the following technologies:

  • Front-end: HTML, CSS, JavaScript
  • Back-end: Java with Servlets and JSP (JavaServer Pages) - Java Jakarta.
  • Database: MySQL for storing user admin credentials and school-related data

Installation

  1. Clone the School App Pro repository to your local machine.
  2. Set up a MySQL database and import the provided SQL schema to create the necessary tables.
  3. Configure the database connection details in the application's configuration files.
  4. Deploy the application on a Java web server (e.g., Apache Tomcat).

Usage

  1. Access the application through your web browser using the provided URL.
  2. Sign up as a user admin if you don't have an account, or sign in with your credentials.
  3. Use the navigation menu to access the different management functionalities (teachers, meetings, students, cities, specialties - when implemented).
  4. Perform the desired CRUD operations according to your needs.

Status

The School App Pro is currently under development, and some features are yet to be implemented. However, the existing functionalities are functional and can be used by user admins for basic management tasks.

Contributions

Contributions to the School App Pro project are welcome. If you encounter any issues or have ideas for improvement, please submit an issue or a pull request on the project's repository.


Thank you for taking your time to check out my School App Pro! If you have any questions or want to make any suggestions, please don't hesitate to contact us. Happy Coding!

About

A school application written in Java EE with JSP and MySQL. Deployed with TomCat Server.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors