java使用dbutils操作mysql的null

java使用dbutils操作mysql的null

目的

mysql中的null 到javaBean中的值

通过mysql驱动查询

1.这是表的结构与内容

mysql> desc test; -- 表的结构
+----------+-----------------------+------+-----+---------+-------+
| Field    | Type                  | Null | Key | Default | Extra |
+----------+-----------------------+------+-----+---------+-------+
| id       | int(11)               | NO   | PRI | 0       |       |
| salary   | float                 | YES  |     | NULL    |       |
| nickname | varchar(20)           | YES  |     | NULL    |       |
| time     | datetime              | YES  |     | NULL    |       |
| age      | int(11)               | YES  |     | NULL    |       |
| gender   | enum('male','female') | YES  |     | NULL    |       |
| adult    | tinyint(1)            | YES  |     | NULL    |       |
+----------+-----------------------+------+-----+---------+-------+
7 rows in set (0.01 sec)

mysql> select * from test; -- 表中内容
+----+--------+----------+---------------------+------+--------+-------+
| id | salary | nickname | time                | age  | gender | adult |
+----+--------+----------+---------------------+------+--------+-------+
|  1 |   NULL | NULL     | NULL                | NULL | NULL   |  NULL |
+----+--------+----------+---------------------+------+--------+-------+
1 rows in set (0.00 sec)

2.使用mysql驱动直接查询数据

• 对象类型返回的都是null
• 基本数据类型返回的是默认值
  • int：0
  • float：0.0
  • boolean：false

PreparedStatement pstm = conn.prepareStatement("select * from test where id=?");
pstm.setInt(1,1);
ResultSet resultSet = pstm.executeQuery();
while (resultSet.