Question: 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
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:

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)
Step by Step Solution
3.21 Rating (162 Votes )
There are 3 Steps involved in it
Program Plan Create a user named scott and set its password to tiger in mysql Create a database named javabook using the user scott Create a new table in javabook named Staff and set its columns and t... View full answer
Get step-by-step solutions from verified subject matter experts
