一个JDBC问题

Question

Invalid value for getInt() - 'q'
你有个东西是'q'
应该getString 而你却geInt()贴那么多出来干什么？

Answer 1

总之数据库里不是int型的东西，你用GETINT就不行，你改成GETSTRING

Answer 2

+---------+----------+------+-----+---------+-------+
| Field   | Type     | Null | Key | Default | Extra |
+---------+----------+------+-----+---------+-------+
| id      | char(1)  |      | PRI |         |       |
| name    | char(10) |      |     |         |       |
| address | char(50) | YES  |     | 广州    |       |
+---------+----------+------+-----+---------+-------+

Answer 3

+---------+----------+------+-----+---------+-------+
| Field   | Type     | Null | Key | Default | Extra |
+---------+----------+------+-----+---------+-------+
| id      | int(3)   |      | PRI |         |       |
| name    | char(10) |      |     |         |       |
| address | char(50) | YES  |     | 广州    |       |
+---------+----------+------+-----+---------+-------+