April 2003
Intermediate to advanced
750 pages
16h 53m
English
In this section, we develop a CustomerInfoBmp bean to illustrate the use of BMP.
The CustomerInfoBmp bean represents additional information for a customer of the bank. For each kind of additional information, we create a row in a CUSTOMERINFO table. Additional information could be a photo for printing on the credit card or a scanned image for the identification card.
Table 13-1 shows the layout of the CUSTOMERINFO table.
| Column name | Type | Length | Key | Nulls | Description |
|---|---|---|---|---|---|
| CUSTOMERID | INTEGER | PK | No | Customer ID | |
| INFOID | INTEGER | PK | No | Information ID (1,2,...) | |
| DESCRIPTION | VARCHAR | 50 | No | Yes | Description of information |
| DATA | BLOB | 10000 | No | Yes | Binary data |
This design allows for ...
Read now
Unlock full access