Program Explanation Program: Filename: UpdateEmployee.java //Include library import javafx.application.Application; import javafx.stage.Stage; import javafx.scene.Scene; import javafx.scene.layout.HBox; import javafx.scene.layout.VBox; import javafx.geometry.Pos; import javafx.geometry.Insets; import javafx.scene.control.Label; import javafx.scene.control.TextField; import javafx.scene.control.Button; import javafx.event.EventHandler; import javafx.event.ActionEvent; import java.sql.*; //Define class UpdateEmployee public class UpdateEmployee extends Application { //Declare fields private TextField kloTxtFld; private Label rsltLbl; //Define main method public static void main(String[] args) { // Launch the application. launch(args); } //Override @Override //Define method start public void start(Stage pmStge) { // Create controls to get employee ID Label prmptLbl = new Label("Employee ID:"); TextField empIDTxtFiled = new TextField(); Button searchButton = new Button("Search"); // Create controls to display search results Label nmeDscrptr = new Label("Name:"); TextField nmeTxtFild = new TextField(); Label postnDscrptr = new Label("Position:"); TextField postnTxtFild = new TextField(); Label pyRteDscrptr = new Label("Pay Rate:"); TextField pyRteTxtFild = new TextField(); Button sveBttn = new Button("Save"); // Create an event handler for Search button. searchButton.setOnAction(event -> { // Get employee ID. String lEmpD = empIDTxtFiled.getText(); //Try block try { // Create a new EmployeeTableManager object EmployeeTableManager etManager = new EmployeeTableManager(); //Get employee information String nme = etManager.getName(lEmpD); String postn = etManager.getPosition(lEmpD); String pyrte = Double.toString(etManager.getPayRate(lEmpD)); // Display employee information nmeTxtFild.setText(nme); postnTxtFild.setText(postn); pyRteTxtFild.setText(pyrte); } //Catch block catch (SQLException e) { e.printStackTrace(); System.exit(0); } }); // Create event handler for Save button sveBttn.setOnAction(event -> { //Try block try { // Create a new EmployeeTableManager object EmployeeTableManager etManager = new EmployeeTableManager(); // Update employee record with the currently displayed information etManager.updateEmployee(empIDTxtFiled.getText(), nmeTxtFild.getText(), postnTxtFild.getText(), Double.parseDouble(pyRteTxtFild.getText())); // Clear current information from screen empIDTxtFiled.setText(""); nmeTxtFild.setText(""); postnTxtFild.setText(""); pyRteTxtFild.setText(""); } //Catch block catch (SQLException e) { e.printStackTrace(); System.exit(0); } }); // Create topmost HBox HBox srchHBx = new HBox(10, prmptLbl, empIDTxtFiled, searchButton); srchHBx.setAlignment(Pos.CENTER); srchHBx.setPadding(new Insets(10)); HBox nmeHbx = new HBox(10, nmeDscrptr, nmeTxtFild); nmeHbx.setAlignment(Pos.CENTER); nmeHbx.setPadding(new Insets(10)); HBox postnHbx = new HBox(10, postnDscrptr, postnTxtFild); postnHbx.setAlignment(Pos.CENTER); postnHbx.setPadding(new Insets(10)); HBox pyrteHbx = new HBox(10, pyRteDscrptr, pyRteTxtFild); pyrteHbx.setAlignment(Pos.CENTER); pyrteHbx.setPadding(new Insets(10)); // Put HBoxes in a VBox VBox vbox = new VBox(10, srchHBx, nmeHbx, postnHbx, pyrteHbx, sveBttn); vbox.setAlignment(Pos.CENTER); vbox.setPadding(new Insets(10)); // Create a Scene Scene scene = new Scene(vbox); // Add the Scene to the Stage pmStge.setScene(scene); // Set the stage title pmStge.setTitle("Employee Updater"); // Show the window pmStge.show(); } } Filename: EmployeeTableManager.java //Include library import java.sql.*; //Define class EmployeeTableManager public class EmployeeTableManager { //Define database URL public final String DbsUrl = "jdbc:derby:Personnel"; //Create a connection object private Connection cons; //Define a constructor public EmployeeTableManager() throws SQLException { //Call method cons = DriverManager.getConnection(DbsUrl); } //Define a method public String[] getEmployeeIDs() throws SQLException { //Define qeury String qury = "SELECT EmployeeID FROM Employee"; // Create a connection to database cons = DriverManager.getConnection(DbsUrl); // Create a Statement object for qeury Statement smtt = cons.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); // Execute qeury store result set. ResultSet res = smtt.executeQuery(qury); // Get the number of rows res.last(); int numRows = res.getRow(); res.first(); // Create an array for the employee IDs String[] lstDta = new String[numRows]; // Populate the array with employee IDs for (int indx = 0; indx < numRows; indx++) { // Store employee ID in the array lstDta[indx] = res...

Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)

7th Edition

ISBN: 9780134802213

Author: Tony Gaddis

Publisher: PEARSON

See similar textbooks

Videos

Question

Chapter 16, Problem 7PC

Expert Solution & Answer

Chapter 16 Solutions

Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)

Chapter 16.1, Problem 16.1CP Chapter 16.1, Problem 16.2CP Chapter 16.1, Problem 16.3CP Chapter 16.1, Problem 16.4CP Chapter 16.1, Problem 16.5CP Chapter 16.1, Problem 16.6CP Chapter 16.1, Problem 16.7CP Chapter 16.2, Problem 16.8CP Chapter 16.2, Problem 16.9CP Chapter 16.2, Problem 16.10CP

Additional Engineering Textbook Solutions

Find more solutions based on key concepts

Google’s “2-Step verification” security sends a message with a code in addition to your password when you attem...

SURVEY OF OPERATING SYSTEMS

Difference between the conceptual and logical data models.

Modern Database Management

Difference between high-level language, machine language and java-byte code: High-level language Machine langua...

Java: An Introduction to Problem Solving and Programming (8th Edition)

Find out whether the gold bar is fake or real.

Thinking Like an Engineer: An Active Learning Approach (4th Edition)

An object is data structure that contains methods and properties. A method uses objects to perform certain task...

Database Concepts (8th Edition)

ML name and C variable declaration: “let” construct is an expression which binds name to value. Purpose of let ...

Concepts Of Programming Languages

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.