LSQLApp

KO | EN

gitlite — search

#typescript #ai-agents #ai #dsh-plugin #deepseek-harness #open-source #cli #claude-code #codex #developer-tools #react #windows

★ 109 Open GitHub ↗

Desktop application that helps teacher 👨‍🏫 in practical work (TP) to evaluate the student 👨‍🎓, and help students to learn SQL (structure query language) - Learning by doing.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Learn SQL Application - SQL برنامج تعلم لغة الإستعلام
Desktop application :computer: to help teacher 👨‍🏫  in practical work (TP) to evaluate the student 👨‍🎓.

[![License MIT](https://img.shields.io/badge/license-MIT-blue.svg)](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/LICENSE)

## Features :heavy_check_mark:
* Simple to use
* Fast and beautiful design
* We used material design & UX library to build this application
* We used MVC design pattern
* Password hashed
*... and more

## Problematic :worried:
1. Lack of tools to establish a student knowledge base.
2. Lack of traceability.
3. We can not judge the efforts of each student (people who work and who doesn't work).
4. Lack of time to evaluate the student.
5. Problem of manual entry in practical work.

## Objectives :smiley:
1. Gives a portable solution and H24 work to gain this understanding.
2. Automate manual stains.
3. Archive students essays at the time of TP.
4. Help the teacher to evaluate the student.

## Libraries used
* JFoenix (Material design)
* ControlsFx (UX)
* FontawesomeFx (Icons)
* Connector/J (JDBC)
* Webcam-capture ([download](http://webcam-capture.sarxos.pl))

## Technology used
* JavaFX

## Requirements
* Java version 8
* IDE like Intellij IDEA or other
* MySQL database

## How to use the application
1. Download the repository files (project) from the download section or clone this project by typing in the bash the following command:

git clone https://github.com/HouariZegai/LSQLApp.git
2. Open it in Intellij IDEA and download the libraries used (montioned above) and add it in the project.
3. Import & execute the SQL queries from the Database folder to the MySQL database.
4. Run the application :D

## Outlook for evolution and improvement :bulb:
* Put the multiplatform application (Desktop, Android & Web).
* Deploy the application in online mode.
* Increase interactivity between user and application.
* Developed the back-end of the chat module (communication between user, send message, audio or video call, send files ...).
* Add a part of education (read books, courses, ...) linked by traceability.
* Add a part of QCM (put multichoix questions).
* Auto evaluation.

## Screenshots

### Login
![login img](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/login.PNG)

### Home
![App home screenshot](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/home.PNG)

### Practical work
![img connection](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/practical-work/c3.PNG)
![screenshot](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/practical-work/c6.PNG)

### Traceability
![screenshot](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/traceability/trac.PNG)
### Traceability > Student
![screenshot](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/traceability/trac-student/trac2.PNG)
![screenshot](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/traceability/trac-student/trac3.PNG)
![screenshot](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/traceability/trac-student/trac4.PNG)
![screenshot](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/traceability/trac-student/trac5.PNG)
![screenshot](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/traceability/trac-student/trac6.PNG)
![screenshot](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/traceability/trac-student/trac7.PNG)
### Traceability > Question
![screenshot](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/traceability/trac-question/trac8.PNG)
![screenshot](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/traceability/trac-question/trac9.PNG)
![screenshot](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/traceability/trac-question/trac10.PNG)

### Guide
![img guide](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/guide.PNG)

### Manage Question
![screenshot of manage question](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/manage-question/q.PNG)
![screenshot of manage question](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/manage-question/q2.PNG)
![screenshot of manage question](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/manage-question/q3.PNG)
![screenshot of manage question](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/manage-question/q4.PNG)

### Manage Account
![screenshot of manage account](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/manage-account/a.PNG)
![screenshot of manage account](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/manage-account/a2.PNG)
![screenshot of manage account](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/manage-account/a3.PNG)
![screenshot of manage account](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/manage-account/a4.PNG)

### Settings
![screenshot of settings](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/settings/s.PNG)
![screenshot of settings](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/settings/s2.PNG)
![screenshot of settings](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/settings/s3.PNG)
![screenshot of settings](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/settings/s4.PNG)
![screenshot of settings](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/settings/s5.PNG)

### Chat
![screenshot of chat](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/chat/c.PNG)
![screenshot of chat 2](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/chat/c2.PNG)

### About
![screenshot about](https://raw.githubusercontent.com/HouariZegai/LSQLApp/master/Screenshots/about.PNG)

## Contributing
If you want to contribute to this project and make it better with new ideas, your pull request is very welcomed.
If you find any issue just put it in the repository issue section, thank you.

.سبحَانَكَ اللَّهُمَّ وَبِحَمْدِكَ، أَشْهَدُ أَنْ لا إِلهَ إِلأَ انْتَ أَسْتَغْفِرُكَ وَأَتْوبُ إِلَيْكَ

LSQLApp

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README