Hi:
I have a problem
with JSP programming on JDBC ,it is a little bit complex ,but I'll try to make
myself clear.
I have a table in
my database named hcds ,its structure is as
follow:
.
.
........
Family | ModelNo | PartNumber | SerialNo | Customer | DateofShipment | DateofPurchase |
HB13L | KDD2200 | B33400TW | 1096706 | STD | 2001-9-19 | 2001-10-18 |
HB13L | KDD2200 | B33400TW | 1096796 | STD | 2001-9-19 | 2001-10-18 |
HB13L | KDD2200 | B131 | NH11T195F8HW | NKO | 2001-10-11 | 2001-10-21 |
HB13L | KDD2200 | B131 | NH10T1A15FV0 | NKO | 2001-10-26 | 2001-10-26 |
........ .
.
.
There are 500 lines in
the table.I use getString() to
obtain the data from it.
The problem is , the
getString("SerialNo") returns
null on
the line where the SerialNo change from a pure numeral
format(1096796) to a mixed format
(NH11T195F8HW).but it works well if the SerialNo is in a single
format.
When I picked up
four line as showed above to test ,same thing happened. but if I delete first
line(whose SerialNo was 1096706) or add some English characters in its SeroalNo
colum , the problem did NOT happen;
I am so confused and can
not solve it.
I really appreciate if
anybody can help me out of that.
Cutty