Web Services: A Java™ Developer’s Guide Using E-Speak

C.1. Order Database

The order database used in Chapter 4 consists of two tables. The table users contains the user information, and the table orders contains the orders associated with the customers in the users table. The schema for users is shown in Table C.1, followed by a sample entry in Table C.2.

Table C.1. Schema for Table users

Field Name	Type	Description
custId	Text	Primary key
userName	Text	User name
password	Text	Password
outputFormat	Text	Desired output format. T — Text, X — XML
custName	Text	Customer name as it would appear in the order status report

Table C.2. Sample Entry for Table users

custID	userName	password	outputFormat	custName
1	scott	scottymn	T	Scott Baumann

The orders table schema is as shown in Table C.3. Note that the ...