Exercise: Revise the code for using transactions in the Payable Entry application

In this exercise, you$$ll modify the way transactions are used by the Payable Entry application that has been presented in this chapter. That will give you some practice working with transactions.

$1.$ Open the Payable Entry application in your Chapter $10$ directory.

$2.$ Review the code in the PayableDB class that implements the use of transactions. Note that it uses just one command object for three different types of SQL statements, so the properties of the command have to be changed each time a new type of SQL statement is executed.

$3.$ Modify the code in the PayableDB class so it uses a separate command object for each type of SQL statement that is executed, but still implements the use of transactions. $($You may need to refer back to Chapter $8$ to refresh your memory on how to associate a transaction between commands.$)$

$4.$ Test your modifications.