JSP Tag Libraries

Скачать в pdf «JSP Tag Libraries»
Existing data sources


Cosmetics has an existing customer database in a DBMS called hSQL in which the company has stored product and category information. The new system may reuse this data, although the tables will want to be expandable and editable as needed.


The existing customer database (
table 13.3) is currently primarily used for:


■    Printing package delivery labels


■    Call-backs to identify customers when taking orders


■    Faxing receipts of orders


Table 13.3 Existing customer data


Attribute name


Data type


Description


Id


Integer


The unique identifier of a customer.


Company


Varchar


The customer’s company name.


Name


Varchar


The customer’s name.


Address


Varchar


The customer’s address.


Phone


Varchar


The customer ‘s phone number.


Fax


Varchar


The customer’s fax number.

To place an order, a user must have an existing profile in the customer database. This provides Cosmetics an index of the number of its customers. Currently, no record is kept on the number of orders a customer logs. Keeping track of this will be part of the solution, but at the moment, only the total number of orders, not the number of orders per customer, is of interest.


The existing category data (
table 13.4) is primarily used for grouping the products into their various lines. As understood by the table definition, Cosmetics’ current system allows categories only in single-depth. No category tree is needed or asked for in the new system.

Скачать в pdf «JSP Tag Libraries»