1
2
3
4
5
6
7
8
9
mysql> desc test;
+-------+------------+------+-----+---------+-------+
| Field | Type       | Null | Key | Default | Extra |
+-------+------------+------+-----+---------+-------+
| id1   | tinyint(2) | YES  |     | NULL    |       |
| id2   | tinyint(1) | YES  |     | NULL    |       |
+-------+------------+------+-----+---------+-------+
2 rows in set (0.04 sec)

1
2
3
4
5
6
7
8
9
10
11
mysql> insert into test(id1,id2) values(123,2);
Query OK, 1 row affected (0.00 sec)

mysql> select * from test;
+------+------+
| id1  | id2  |
+------+------+
|  123 |    2 |
+------+------+
1 row in set (0.00 sec)

1
2
3
4
5
6
7
8
9
10
11
12
mysql> insert into test values(5,10);
Query OK, 1 row affected (0.00 sec)

mysql> select * from test;
+------+------+
| id1  | id2  |
+------+------+
|  123 |    2 |
|    5 |   10 |
+------+------+
2 rows in set (0.00 sec)

1
2
3
4
5
6
7
8
9
10
11
12
13
14

mysql> alter table test modify id1 tinyint(2) zerofill; // 必须告诉数据库，显示位数不足2位时，前面要补0 
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select * from test;
+------+------+
| id1  | id2  |
+------+------+
|  123 |    2 |
|   05 |   10 |
+------+------+
2 rows in set (0.00 sec)

1
2
3
4
5
6
7
8
9
10
11
int id = rs.getInt("id");
String name = rs.getString("name");
int job_id = rs.getInt("job_id");
int mgr = rs.getInt("mgr");
Date hiredate = rs.getDate("hiredate");
// salary 在数据库中的类型是 decimal
BigDecimal salary = rs.getBigDecimal("salary");
// bonus 在数据库中的类型是 decimal
BigDecimal bonus = rs.getBigDecimal("bonus");
int dept_id = rs.getInt("dept_id");

1
2
3
4
setByte​(int parameterIndex, byte x)
setBlob​(int parameterIndex, Blob x)
setDouble​(int parameterIndex, double x)