Write a Java GUI program that views, inserts, and updates staff information stored in a database, as shown in the following figure. 

              The view button displays a record with a specified ID. The Staff table is created as follows:

              The Insert button creates a new record

              The Update button updates an existing record

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)

);

You have to develop code to create the database and table

  

Transcribed Image Text:

E Exercise37_1 Staff Information ID 123456789 Last Name Smith First Name John mi F Address 100 Main Street City Savannah Telephone 912-333-5555 State GA View Insert Update Clear Database connected E Exercise37_1 Staff Information ID 123456789 Last Name Smith First Name John mi F Address 100 Main Street City Savannah Telephone 912-333-5555 State GA View Insert Update Clear Database connected

Answer rating: 100% (QA)

Import javaxswing Import javaxswingborderEmptyBorder Import javaxswingborderTitleBorder Import javasql Javaawt import Import javaawtevent Public Exercise Class 1 extends JApplet Private static final l... View the full answer