Java programming

(Access and update a Staff table) Write a Java applet 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 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)

);

Staff Table Staff Information ID 121 Last Name Smith Address 100 Main Street City Savannah Telephone 9123335555 First Name John mi F | State lon View nsrUpdate Clear Record found Staff Table Staff Information ID 121 Last Name Smith Address 100 Main Street City Savannah Telephone 9123335555 First Name John mi F | State lon View nsrUpdate Clear Record found