Write a client-server loan application program

Assignment Help DOT NET Programming
Reference no: EM132658705

Assessment item - 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 following 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 clear 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 or failure of the View/Insert/Update operations. For example, "Record found/record not found" when the user selects View, "Record Inserted/failed 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 ID 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.

Acknowledgment: Task 1 is based on Exercise 34.1 from the textbook.

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).

Acknowledgment: Task 2 is based on Exercise 33.1 from the textbook.

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
Acknowledgment: Task 3 is based on Exercise 32.6 from the textbook.

RATIONALE
This assessment task will assess the following learning outcome/s:
• be able to design and implement multithreaded Java applications.
• be able to design and construct Java Graphical User Interfaces (GUI) that interact with problem domain objects.
• be able to create, connect to and update a relational database using the Java Database Connectivity (JDBC).
• be able to write programs that would communicate with another program running in the network.
• be able to deconstruct/analyse the object-oriented features of a Java program.

Attachment:- Database and Network Programming.rar

Reference no: EM132658705

Questions Cloud

What is the highest annual mortgage interest rate : You figure the largest mortgage payment that you can afford to make each month is $1450, you want to borrow $250,000 in the forms
Calculate long term sustainability for a company : How to calculate long term sustainability for a company.
Compute the amount of administrative cost chargeable : If Carlin and Marley switched from its current accounting method to an activity-based costing system, compute the amount of administrative cost chargeable
Explain the financial factors that would influence decision : Which contract would you choose and why? Explain the financial factors that would influence your decision.
Write a client-server loan application program : Write a client-server loan application program The client sends loan information (annual interest rate, number of years, and loan amount) to the server
Difference in Advance Nursing Practice : Conceptual models will serve as a framework for organizing beliefs and knowledge about your professional roles and competencies
Project initial investment outlay : The project will also require an initial $180,047 investment in net working capital. What is the project's initial investment outlay?
Many different parts that nursing involves : To understand nursing as a whole, we must break it down and get better understanding of the many different parts that nursing involves.
Compute the overhead cost allocated to Beta : St. Vincent's, Inc., currently uses traditional costing procedures, Compute the overhead cost allocated to Beta by using traditional costing procedures

Reviews

Write a Review

DOT NET Programming Questions & Answers

  Develop web services based application

Develop and test a Web services based application that meets the requirements applying SOA design principles.

  Design style elements in asp

Add drop down lists for modifying the different style elements for the label element that displays the time

  Create a shopping cart in asp

The users will use a browser to access the on-line store. The web server software for the production web server is Windows 2003 Server /IIS6.

  Inventory management system in c# application

Inventory management system in c# application

  Using .net resources to teach .net

This project will use the .NET framework to produce a set of materials to demonstrate the fundamental principles of .NET. Ideally it should demonstrate some of the principles of the framework e.g. interoperability.

  Prepare a marymount faculty site

Prepare a Marymount faculty site

  Blinky lights

Analysis proving that your code blinks the LEDs at the specified rates.

  Prepare a web application

Prepare a web application that will be used to keep track of patients registering in a hospital.

  Implementing the insurance management system

Implementing the Insurance Management System and implementation of Components as Web Services.

  Describe the characteristics of visual studio 2005

Describe the characteristics of Visual Studio 2005 Visual Studio.Net is a suite of products that includes 4 main languages. Name these languages and outline their use in industries

  What is a connectionstring

What is a ConnectionString. Give a suitable example to illustrate the various part of a ConnectionString

  Prepare a web application for internet service provider

Prepare a Web application and write the code also event planning document base. This web application allows the user to sign up for an Internet service provider for home connectivity.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd