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)

);

Connection dialog Enter database information JDBC Driver com.mysqljdbc.Driver Database URLjdbc:mysql:ilocalhost/javabook Username scott Password Connection dialog Enter database information DBC Driver com.mysql.jdbc.Driver Database URLjdbc:mysql:localhostjavabook Username scot Password No connection Connect to DB nnected to jdbc:mysql:/localhostjavabook Connect to DB FIGURE 34.28 The DBConnectionPanel component enables the user to enter database information