Question
Develop a GUI Java application that will allow the manager to submit information about users. The information will be stored in a simple Oracle database.
Develop a GUI Java application that will allow the manager to submit information about users. The information will be stored in a simple Oracle database. The database table are shown in the following sql:
CREATE TABLE "SYS"."USERS"
( "FIRSTNAME" VARCHAR2(20 BYTE),
"LASTNAME" VARCHAR2(20 BYTE),
"EMAIL" VARCHAR2(20 BYTE),
"PHONE" VARCHAR2(20 BYTE)
)
You can use SQL Developer to create your database in Oracle server.
You should show all users information in the listview(see the sample design below)
Your GUI should provide the necessary SWING components that will allow the user to enter and display the data. You will use JDBC to provide the following operations:
1. Insert user information into the database.
2. search the existing user information.
3. Display all users information. You may use a ListView to display the users. Allow the manager to select user.
Use prepared statements to implement all database operations.
FirstName: LastName: Email: PhoneStep by Step Solution
There are 3 Steps involved in it
Step: 1
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