In this lab, you will add the CAccount class to the StateUBookstore project. This component will use ADO code to access the StateUBookstore database. The component will verify that the student has enough available credit to purchase a book.

To see a demonstration of the lab solution, click your modem speed or Download below.

(Requires the Microsoft Windows Media Player.)

Estimated time to complete this lab: 120 minutes

To complete the exercises in this lab, you must have the required software. For detailed information about the labs and setup for the labs, see the Labs section in this course.

Objectives

After completing this lab, you will be able to:

• Use the ADO Connection object to create a connection to a database.
  
  
• Create an ADO Recordset object that contains information from a database.
  
  
• Use the Execute method of a connection to update database information.

Prerequisites

Before working on this lab, you should be familiar with the following:

• Using the ADO Object model
  
  
• Working with class modules

Exercises

The following exercises provide practice working with the concepts and techniques covered in this chapter:

• Exercise 1: Creating the CAccount Class

  In this exercise, you will create the CAccount class that handles the financial transaction for buying a book.

• Exercise 2: Implementing the Authorize Method

  In this exercise, you will write code to initialize the CAccount class. You will also implement the Authorize method of the CAccount class.

• Exercise 3: Implementing the Debit Method

  In this exercise, you will implement the Debit method of the CAccount class.

• Exercise 4: Using the CAccount Class

  In this exercise, you will add code that uses the CAccount class you've created. This class will be used when a student attempts to buy a book from the State University Bookstore.

• Exercise 5: Testing the CAccount Class

  In this exercise, you will test the lab solution using specific scenarios that will test different cases that the CAccount component should handle.