• Stars
    star
    109
  • Rank 319,077 (Top 7 %)
  • Language
    Java
  • License
    MIT License
  • Created over 6 years ago
  • Updated about 1 year ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

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.

Learn SQL Application - SQL برنامج تعلم لغة الإستعلام

Desktop application 💻 to help teacher 👨‍🏫 in practical work (TP) to evaluate the student 👨‍🎓.

License MIT

Features ✔️

  • 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 😟

  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 😃

  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)

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 💡

  • 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

Home

![](Screenshots/home.PNG img home">

Practical work

img connection screenshot

Traceability

screenshot

Traceability > Student

screenshot screenshot screenshot screenshot screenshot screenshot

Traceability > Question

screenshot screenshot screenshot

Guide

img guide

Manage Question

screenshot of manage question screenshot of manage question screenshot of manage question screenshot of manage question

Manage Account

screenshot of manage account screenshot of manage account screenshot of manage account screenshot of manage account

Settings

screenshot of settings screenshot of settings screenshot of settings screenshot of settings screenshot of settings

Chat

screenshot of chat screenshot of chat 2

About

screenshot about

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.

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

More Repositories

1

Calculator

Calculator app created with Java Swing, It is simple with an easy code to help novices learn how to operate a calculator.
Java
435
star
2

SpyGen

Trojan 🐍 (keylogger, take screenshots, open your webcam) 🔓
Java
212
star
3

PrayerTimes

Desktop application 💻 for calculating Muslim prayer times 🕌 and setting an alarm (Adhan) ⏰ for the prayer times.
Java
163
star
4

HotelReservationSystem

A web application to book a room in a hotel (room reservation).
Java
143
star
5

Tutorials

Step by step to learn coding and build Apps 🎉. Code files of Youtube & University tutorials.
Java
95
star
6

FXMaterialDesign

JavaFx Material Design Models (UI/UX) 🎉
Java
81
star
7

clean-code

DSA, TDD, and Software Design principles implementation
Java
79
star
8

FullStack-Angular-SpringBoot

Customer Relationship Managment [Full-stack Web Development using Angular & SpringBoot (RestFull API)]
TypeScript
66
star
9

FXMailer

Desktop application Tool. Allow you to send a beautiful html template to multiple email recipients with one click!
Java
62
star
10

slides-remote

Control Power Point from your Phone (WIFI Presentation Remote)
Java
57
star
11

FXFaceDetection

Real-Time Face Detection App using Computer Vision & JavaFX
Java
54
star
12

FlyingAgent

Mobile Agent that moves on a platform distributed on many machines and recover the mac address of each machine during the deplacement
Java
46
star
13

ChatFX

Desktop application 💻 that allow you to make a live chat.
Java
44
star
14

FXTools

My JavaFX resources, libraries & ready tools (GUI) using in JavaFX projects.
Java
41
star
15

problem-solving

Problems with my solutions of Daily Coding Problem website
Python
40
star
16

WebcamFX

Open the camera, take pictures 📷 & save them using Javafx.
Java
39
star
17

QRCodeFX

Simple tool to generate/read QR Code and export it.
Java
33
star
18

quiz-app

Java Quiz - Desktop Application
Java
33
star
19

java-pocs

Codes and samples were written 💻 to demonstrate the usage of Java with various technologies.
Java
33
star
20

FXTableGen

JavaFX JFoenix Table Generator Tool
Java
29
star
21

DataStructuresAndAlgorithms

Data Structures and Algorithms implemented in Java.
Java
27
star
22

academic-projects

Practical Work solutions & projects of my master degree class at university 👨‍🎓
Java
25
star
23

TicTacToe

A simple Tic Tac Toe (XO) game 🎮 developped using Java Swing.
Java
21
star
24

AndroidLearning

A Collection of Android projects & UI/UX Samples 📱 [for my learning proccess]
Java
21
star
25

FXMessenger

Desktop App - Clone Facebook Messenger [In progress]
Java
20
star
26

Cryptography

Cryptography algorithms implemented in Java.
Java
18
star
27

DevResources

مصادر تعلم البرمجة
18
star
28

Blockchain

Blockchain implemented in Java.
Java
17
star
29

houarizegai-website-v1

My personal web site version 1
HTML
17
star
30

web-scraping

Code samples of web scraping using Java.
Java
15
star
31

CalculatorFX

Calculator 📱 UI made it using JavaFX.
Java
15
star
32

FullStack-Angular-Firebase

E-Commerce / Full-Stack web application using Angular & Firebase.
TypeScript
15
star
33

EarthquakePlaces

Android App help you to search 🔍 to the earthquake places 🌇 and view it in Maps with his details in table.
Java
14
star
34

MyWebSite

My personal web site created with HTML & CSS.
HTML
14
star
35

LaTeXLearning

Let's learn LaTeX together! ❤️ code files was written in my learning process [we will update it by adding more...].
TeX
14
star
36

Pharmacy-Blockchain

Open Hackathon Sep 2018 - Oran.
Java
13
star
37

KotlinTutorials

Step by step to build Kotlin Apps 🎉. Code files for youtube tutorial
Kotlin
13
star
38

XMLvsJSON

XML vs JSON
Java
12
star
39

ATMSimulator

Used the notion of threads and parallelism to make a ATM Simulator.
Java
12
star
40

BanqueWS

Banking Web Services using SOAP
Java
12
star
41

MailsSender

Desktop App that allow you to send HTML emails to multiple receivers
Java
11
star
42

FXExamples

JavaFX Example Projects
Java
11
star
43

MASProjects

Multi-agent system projects
Java
11
star
44

HouariZegai

11
star
45

HackerRank-Solutions

Solution of HackerRank problems.
Java
11
star
46

PrologExercise

Prolog Examples with Solutions
Prolog
11
star
47

JavaInterview

Java Interview Coding Challange.
Java
10
star
48

JavaFXPortsSamples

JavaFX for Desktop, Mobile (Android, IOS) & Embedded Systems with one code!
Java
10
star
49

SpoCom

Sport Competition Desktop App
Java
10
star
50

DataScienceLearning

For Learn Data Science
Jupyter Notebook
10
star
51

SchedulingAlgorithms

Implementation of SPQ, WRR, and DWRR Scheduling Algorithms
Java
9
star
52

ScalingFiltering

Scaling in Cloud Computing Filtering (Recommendation System ✔️).
Java
9
star
53

MachineLearningProjects

This Repository contains the code, dataset and projects that I made during the learning of machine learning,
Jupyter Notebook
9
star
54

AES

AES algorithm implementation in Java
Java
9
star
55

JavaTutorials

Some Code files of my Java Workshops 🎉
Java
8
star
56

TicTacToe-Android

XO Game of Android
Java
8
star
57

UnivSchedulingSystem

University Scheduling Management System
HTML
8
star
58

PascalTutorial

Step by step to build pascal programs 🎉. Code files for youtube tutorial.
Pascal
8
star
59

XMLLearning

The code was written 💻 in my learning 📖 process.
XSLT
7
star
60

JS-Examples

Javascript & JQuery examples.
JavaScript
7
star
61

FXGames

A Collection of games made with JavaFX ❤️
Java
7
star
62

FXKotlin

A collection of examples made it with JavaFX for Kotlin.
Kotlin
6
star
63

library

Backend API of a Library Management System
Java
5
star
64

Tennis

Basic Tennis Game (Kata)
Java
4
star
65

AI-Hack-Tunisia-2019

Jupyter Notebook
4
star
66

JNIExample

Steps of using Java Native Interface (mix between Java & C/C++ codes)
Java
4
star
67

GestionCommerciale

Commercial Management System, it can manage customers, suppliers, invoicing, delivery, stocks, regulations, ...and more
Java
3
star
68

spring-solr

Java
3
star
69

springfx-boilerplate

Java
2
star
70

portfolio

CSS
2
star
71

openid-mock

Java
2
star
72

cloud-config

Common configuration of Micro Services with Spring Cloud
2
star
73

GitHubWorkshop

1
star
74

oauth2-spring-boilerplate

Java
1
star
75

morning-fresh

BDD with Java and Cucumber
Java
1
star
76

go-api

Golang REST API
1
star
77

boumerdes-github-workshop

Java
1
star
78

jooby-poc

Jooby Framework Proof of concepts
Java
1
star
79

github-workshop-gdg-sba

1
star
80

GitWorkshop

Python
1
star