Assignment: Simple Address Book Application
1. Write a simple Address Book application. (100 pts).
a. Useaddressbook.sqltosetupadatabase.Yourdatabasenamewill be: addressbook.
b. Your path must be: jdbc:derby://localhost:1527/addressbook
c. Create a database class to keep related instance variables of your database.
d. Create an address class to keep related instance variables for an address. Add a constructor and set and get methods.
e. Create an AddressOptions class to keep all related methods.
f. Create a Java form which will be AddressScreen. (You can prefer to create .java file instead of a java form. Then, you will not upload a java form. However, when you create a java form, Netbeans also creates a .java file for you under the source folder. So, you will upload both.)
g. You will have 6 Jlabels, 4 JTextFields, 1 JTable, and 4 JButtons. Check the figure below.
h. Title will be "Address Book".
i. In one of the labels, display a title which is "Address Book".
j. When the program runs, in the table, you must list all related data. If the table is blank, do not display any row.
k. Cells must not be editable and resizable.
l. JTable must displayed in a JPanel.
m. Set a different background color for your JPanel.
n. A user fills first name, last name, e-mail, and phone number to add an address, and then click "add address" button. If any text field is blank, you will display a message that the user must supply all related values.
o. If text fields do not include any null value, a new address will be added, all data including new one, will be listed in the table. All text fields will be cleared. You will also display a message that the address is added successfully. See the figures below.
p. To update an address, the user must select a row and the table is not blank. You must control them and display a message that the table is blank, or a row is not selected. When a user clicks on a row, address details will be displayed in the related text fields. See the figures below.
q. The user updates values in any text field and then clicks "Update Address". Then, the address is updated.
r. When an address is updated, you must clear the text fields. You must display a message that the address is updated successfully. You must list updated version of the data in the table.
s. To delete an address, the user must select a row and the table is not blank. You must control them and display a message that the table is blank, or a row is not selected. When a user clicks on a row, address details will be displayed in the related text fields. See figures below.
t. When an address is deleted, you must clear the text fields. You must display a message that the address is deleted successfully. You must list updated version of the data in the table.
u. If the user clicks "Delete All" button, you will delete all data in the table and a blank table will be listed. Also, display a message that all addresses are deleted successfully. However, if the table is already a blank table, you will display a message that the table is blank. Check the figures below.
v. Change the icon of your JFrame. Use the icon provided to you. In this assignment, it is your responsibility to learn how to change an icon of a JFrame component.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- QUESTIONS.rar