Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Java Programming, Comprehensive Version

Authors: Y. Daniel Liang

10th Edition

133761312, 978-0133761313

More Books

Students also viewed these Programming questions

Question

write a java gui program to convert binary,decimal

Answered: 1 week ago

Question

Subtract the polynomials. (-x+x-5) - (x-x + 5)

Answered: 1 week ago