Skip to content

JavaFX application imitating working with a database of deans office

Notifications You must be signed in to change notification settings

mzebrak/java-h2db-deans-office

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

java-h2db-deans-office

My practice with h2 database and JavaFX to learn more about these technologies.

It is a simple window application that allows you to submit database queries using a form.

There are some SELECT, INSERT, UPDATE, and DELETE queries. You can add a row, edit it by editing the values in the form on the left side or delete a selected row.

This is how it looks:

1. application started and 4th student selected

2. 4th student edited (Julie -> Hannah)

3. subject "Physics" selected

4. subject "Physics" removed

5. subject "English" with rating 5 has been added and attempted to add a subject by the index that no one student has

(index_number in subjects is a FOREIGN key that references index_number in students, so in the students table there must be a student with a given index_number)

"Index not found!" is displayed in the first field

About

JavaFX application imitating working with a database of deans office

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages