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),

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

1 Expert Approved Answer
Step: 1 Unlock

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

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 Java Programming Questions!