Write a series of single statements. Actually, these statements form the core of an important type of file-processing program—namely, a file-matching program. In commercial data processing, it’s common to have several files in each application system. In an accounts receivable system, for example, there’s generally a master file containing detailed information about each customer, such as the customer’s name, address, telephone number, outstanding balance, credit limit, discount terms, contract arrangements and possibly a condensed history of recent purchases and cash payments.

As transactions occur (i.e., sales are made and payments arrive in the mail), information about them is entered into a file. At the end of each business period (a month for some companies, a week for others, and a day in some cases), the file of transactions (called "trans.txt") is applied to the master file (called "oldmast.txt") to update each account’s purchase and payment record. During an update, the master file is rewritten as the file "newmast.txt", which is then used at the end of the next business period to begin the updating process again.

File-matching programs must deal with certain problems that do not arise in single-file programs. For example, a match does not always occur. If a customer on the master file has not made any purchases or cash payments in the current business period, no record for this customer will appear on the transaction file. Similarly, a customer who did make some purchases or cash payments could have just moved to this community, and if so, the company may not have had a chance to create a master record for this customer. Write a complete file-matching accounts receivable program. Use the account number on each file as the record key for matching purposes. Assume that each file is a sequential text file with records stored in increasing account-number order.

a) Define class TransactionRecord. Objects of this class contain an account number and amount for the transaction. Provide methods to modify and retrieve these values.

b) Modify class Account in Fig. 15.9 to include method combine, which takes a TransactionRecord object and combines the balance of the Account object and the amount value of the TransactionRecord object.

c) Write a program to create data for testing the program. Use the sample account data in Figs. 15.16 and 15.17. Run the program to create the files trans.txt and oldmast.txt to be used by your file-matching program.

d) Create class FileMatch to perform the file-matching functionality. The class should contain methods that read oldmast.txt and trans.txt. When a match occurs (i.e., records with the same account number appear in both the master file and the transaction file), add the dollar amount in the transaction record to the current balance in the master record, and write the "newmast.txt" record. (Assume that purchases are indicated by positive amounts in the transaction file and payments by negative amounts.) When there’s a master record for a particular account, but no corresponding transaction record, merely write the master record to "newmast.txt". When there’s a transaction record, but no corresponding master record, print to a log file the message "Unmatched transaction record for account number…" (fill in the account number from the transaction record). The log file should be a text file named "log.txt".

Fig. 15.9

Fig. 15.16

Fig. 15.17

1 2 3 4 5 6 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 45 454 45 45 42 43 // Fig. 15.9: Account.java // Account class for storing records as objects. public class Account { private int account Number; private String firstName; private String lastName; private double balance; 46 } // initializes an Account with default values public Account() {this(0, "", "", 0.0);} // initializes an Account with provided values public Account (int account Number, String firstName, String lastName, double balance) { this.account Number = account Number; this.firstName = firstName; this.lastName = lastName; this.balance = balance; } // get account number public int getAccount Number() {return account Number;} // set account number public void setAccount Number(int accountNumber) {this.account Number = account Number;} // get first name public String getFirstName() {return firstName;} // set first name public void setFirstName (String firstName) {this.firstName = firstName; } //get last name public String getLastName () {return lastName; } // set last name public void setLastName (String lastName) {this. lastName lastName; } // get balance public double getBalance() {return balance;} // set balance public void setBalance (double balance) {this.balance = balance; }