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 ...

Get Web Services: A Java™ Developer’s Guide Using E-Speak now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.