Marian G Java Exercise 31.11 Chegg × Module Calendar-CIST2x/ D 0133593517.pdf -c

Question

Marian G Java Exercise 31.11 Chegg × Module Calendar-CIST2x/ D 0133593517.pdf -c , www.ebooksbucket.com/uploads itprogramming/java/Introduction-to-Java%20Programming-Comprehensive Version·pdf *32.1 (Access and update a Staff table) 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) 32 01 DxExerdse32 02 Record found BIOL ID 121 Last Name Smith Address 100 Main Street Gty Sdvdlildli elephone 9124345665 First Name Peter MI CHEM CS MATH State GA CHEM ATH View Insert Update ear FIGURE 32.27 (a) The program lets you view, insert, and update staff information. (b) The PieChart and BarChart components display the query data obtained from the data module O e 2:05 AM 1/30/2016 Search the web and Windows

Explanation / Answer

View the database

select * from Staff;

Insert into database

insert into Staff(id,lastname,firstname,mi,address,city,state,telephone,email) values(121,'smith','peter','F','100 main street','savanhah','GA',9124345665,'unkonwn@gmail.com');

Update the values of the database
upate table Staff set lastname="mathew" where Id=120;

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.