Question: Write a program that views, inserts, and updates staff information stored in a database, as shown in Figure 34.27a. The View button displays a record

Write a program that views, inserts, and updates staff information stored in a database, as shown in Figure 34.27a. The View button displays a record with a specified ID. The Insert button inserts a new record. The Update button updates the record for the specified ID. The Staff table is created as follows:

create table Staff (
id char(9) not null,
lastName varchar(15),
firstName varchar(15),
mi char(1),
address varchar(20),
city varchar(20),
state char(2),
telephone char(10),
email varchar(40),
primary key (id)
);

ExtraExercise34 01 Record not found D 121 Lat Name Smith MF First

ExtraExercise34 01 Record not found D 121 Lat Name Smith MF First Name Feter Address 100 Main Street State GA City Savannah Telephone 9214345665 View Insert Update Clear (a)

Step by Step Solution

3.34 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

import javasqlConnection import javasqlDriverManager import javasqlResultSet import javasqlSQLException import javasqlStatement import javafxapplicationApplication import javafxgeometryPos import java... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Introduction to Java Programming and Data Structure Questions!