Reference no: EM132656172
Assessment - Database and Network Programming
TASK
Task 1: Database Application
For this program, you are to write a Java GUI-based program that allows the user to view, insert and update information within a MySQL database.
Your database will contain only one table, called Staff, with the foliowing fields: An ID (the primary key), last name, first name, middle initial (MI), address, city, state (ACT, NSW, NT, QLD, SA, TAS, VIC, WA), and a telephone number.
Your program should allow the user to view a staff record with a specified ID, to insert a new record into the table, to update any field (except the ID) of an existing staff member record, and to dear all fields from the display. Your GUI design should be similar-to the image below. In addition, make sure you include the following features:
• Display an appropriate message indicating-the success orfailure of the View/insert/Update operations For example, "Record found/record not found' when the user selects View, "Record Inserted/faited to insert" when the user selects Insert, and "Record updated/failed to update" when the user selects Update.
• When no record is displayed (e.g., when the program first starts), or when the user selects Clear, display a message inviting the user to view or insert a new record.
• When inserting a new record, the ID field should be generated automatically so that it is unique for the table,
• The 1D field should only be editable when the user chooses to search for a new record to View. IDS returned from the database through the View operation, or generated as part of the Insert operation, should not be editable
• When Inserting or Updating a record, ensure all fields (e.g., Last name, first name, etc.) are not left blank, and that the telephone number contains only digits. Ensure the state is valid.
Task 2 Network Application
Write a client-server loan application program The client sends loan information (annual interest rate, number of years, and loan amount) to the server. The server computes the monthly payment and the total payment, and sends these details back to the client (see image below).
Task 3: Multi-threaded Animation
The program described in listing 15.12 of your textbook displays a bouncing ball, as shown below:
Modify this program so that
• it has a label which displays the current speed of the ball
• users can increase and decrease the speed of the ball by using an up or down arrow key
• it uses a thread to animate the bouncing ball movements
Attachment:- Database and Network Programming.rar