Lab Overview: General Specs

TCO:

Desired (Lab) Learning Outcome: Upon completion of the lab the students will be able to create a user interface that allows for the display, insertion, update, and deletion of records from a database.

Dependencies: Lab 1 and Reading assignments, on-site and on-line topic/lectures.

Lab Overview: Lab Presentation

Add, Update, and Delete Database Interface

Assignment: You are to build a user interface that will allow for the insertion, deletion and the updating of records in a database. This interface needs to have navigation buttons to allow the display of each of the records.

Narrative: Your company has just purchased another organization that is not very technically proficient and it uses a manual record keeping system. You have been charged with developing a user interface that will allow the sales department to view, add, update, and delete records from its list of customers.

You are to modify the week 1 lab to include the following:

Insert button and action listener code that will add a new record to the database

Update button and action listener code that will modify a record in the database

Delete button and action listener code that will delete a record in the database

A programmer needs to ensure that user mistakes are minimized; for this reason, please make sure your application does the following:

• Uses a JOptionPane.showConfirmDialog to prompt the user when inserting or updating a record, this ensures the user really intended to do the insert or update.
• Make sure a textbox cannot be edited accidentally (disable them until they need to be edited).
• Disable the buttons when necessary so that they cannot be accidentally clicked during an operation such as inserting a new record.

Steps:

• Insert/Update/Delete buttons need to be added to the existing program developed in Lab 1.
• Buttons need to be coded according to their functions (they should do Insertions, Updates, and Deletes).
• Test/Run program and fix any bugs.
• JOptionPane dialog boxes need to be coded to prompt users of DB modifications.
• Test/Run program and fix any bugs.
• Buttons and Textboxes need to be disabled until they are ready to use.
• Test/Run program and fix any bugs.

Student Lab Plan

Student Name:

Date:

Read the Lab Presentation and respond to the following items prior to beginning the lab exercise.

1. Define the problem(s) to be solved.




2. Identify the steps you will take to solve the problem(s) in the order you will execute them.




3. How will you know that the problem has been solved successfully?




4. What information do you need, or what research do you need to do, in order to accomplish the solution?




5. What specific computer commands or computer tools will you use to accomplish this lab task?

Lab Student Report

Prepare this Lab Report when you have completed and lab assignment. Include any charts, graphs required to complete the lab. Refer to your initial lab plan to respond to the first questions.

1. Define the problem you were solving in this lab.




2. Did your initial plan successfully identify the tasks required to solve the problem? If not, why?




3. Did the lab require any change in the sequence of steps from your initial plan? Explain.




4. What challenges did you meet in working towards a solution?




5. Were you successful in solving the problem? If yes, explain your solution, if no, explain the solution you did use. Please be specific, and provide a detailed description of your solution.
   
   
   
6. Did you use methods you learned in class? If yes, explain your solution, if no, explain the solution you did use. Please be specific, and provide a detailed description of your solution.
   
   
   
7. What questions related to this lab still remain for you?