Write a program that views, inserts, and updates staff information stored in a database, as shown in Figure 32.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:

Transcribed Image Text:

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) ); Record found BIOL BIOL ID 121 Last Name Smith First Name Peter MI F Address 100 Main Street aty Savaiialı CHEM CS MATH State GA CHEM MATH lelephone 9124345665 dear View Insert Update (a) (b)