Originally posted by long lingyu: Can I display the record No. in the client GUI? or I should hide the column.
Hi long, its upto you. You can hide the details from the CSR and just show him actual data or else you can show record number. The second case can be used if you want to allow the CSR to book using record number.
In case you want to show your record ID, you may have to handle (or not to handle) the numbering. For example, if the database contains 3 records, and 1 is mark deleted, the GUI shows only 2 records. But, which of the following you want to have: option 1:
If you choose option 1, it is easier to implement, although the record number is not in sequence. If you choose option 2, it looks better than option 1, but you may need extra afford to re-order the record number. Thus, I simply not to show the record number, as in fact, the CSR does not need to know this info. Nick.
When I book a record, I want to find the record through recNo, if I haven't get the record number,should I find the record through the field first? I think showing the number in JTable is more easier to handle. But the requirement?
Originally posted by long lingyu: When I book a record, I want to find the record through recNo, if I haven't get the record number,should I find the record through the field first? I think showing the number in JTable is more easier to handle. But the requirement?
The assignment instructions are silent on whether you can show record numbers in the JTable. Since it isn't prohibited by any requirement I think you are free to do so. The record number does have a meaning (it's the records's physical order in the database file) so I would strongly recommend Nick's option 1 if you decide to show the record numbers in the JTable. Option 2 doesn't make any sense to me and it seems to violate the inherent meaning of the record number. I displayed record numbers to the user in the JTable, so I was able to get the record number for a record from the JTable.