---
title: Database Systems Lab 8
---
<h1 style='border: none'><center>Database Systems Lab 8</center></h1>
<h1 style='border: none'><center>JDBC Part 2</center></h1>
<h5><center>The Islamic University of Gaza<br>Engineering Faculty<br>Department of Computer Engineering</center></h5>
<h6>Authors: Usama R. Al Zayan & Rasha E. Kahil<span style="float:right">2023/03/24</span></h6>

---

## Expecteed outcomes
1. To be familiar with JavaFX, build first FXML application with user interfaces for manipulating data.
2. To explore more about JDBC API statements and resultsets.

## Lab 8: Time and Plan

| Tasks | Timing |
| -------- | -------- |
| Quiz 11 | 10 min |
| Task 1 | 80 min |

## Lab Tasks

**Your code should be organized in MVC format, it should also be readable and easy to understand.**

**Department Affairs**: We will extend our work now to include an interface for department secretary to use. This interface will provide access to some functionality that we ask you to implement.
1. View Department: the user selects a department name from a combo box, and clicks ‘Details’ as a result the interface shows him <department name, budget, building, number of students, number of instructors, avg_salary>.
2. User can then click ‘**Manage Department**’ that results in showing him a new window that includes 3 tabs. Each of those 3 tabs will show a table. One showing all instructors, showing students, and another showing courses.
3. Below each table of the 3 mentioned above, the user can find a button labeled “Add new” that allows him to add a new (student, instructor, or course). You are free to implement the add interface the way you like.
4. Two of the previously mentioned tables [student, and instructor] also provide another important feature; if the user clicks on a row of the table, he is transferred to the appropriate interface of that row’s details, user views the details including the picture, and he can edit the editable* details or delete that student/instructor. The interface warns the user if he clicks delete or if he leaves without saving his edits.
5. About the course table, we want it to be something special; an “editable table”. In such table, the user can double click on an editable* cell, the table then allows him to edit text inside that cell, and when he hits ‘Enter’ the change he made to the cell is reflected on the data in the database. If he hits ‘Esc’ the change is then cancelled and the original value is shown again.
* **Note:** All details are editable except IDs.

###### tags: `Database Systems` `IUG` `Computer Engineering`

<center>End Of Lab 8</center>