Question
Write a Java GUI program that views, inserts, and updates staff information stored in a database, as shown in the following figure. The view button
Write a Java GUI program that views, inserts, and updates staff information stored in a database, as shown in the following figure.
The view button displays a record with a specified ID. The Staff table is created as follows:
The Insert button creates a new record
The Update button updates an existing record
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)
);
You have to develop code to create the database and table
E Exercise37_1 Staff Information ID 123456789 Last Name Smith First Name John mi F Address 100 Main Street City Savannah Telephone 912-333-5555 State GA View Insert Update Clear Database connected
Step by Step Solution
3.46 Rating (159 Votes )
There are 3 Steps involved in it
Step: 1
Import javaxswing Import javaxswingborderEmptyBorder Import javaxswingborderTitleBorder Import javasql Javaawt import Import javaawtevent Public Exercise Class 1 extends JApplet Private static final l...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started