人生不止眼前的电脑！通过本文主要向大家介绍了jdbc,mysql等相关知识,希望本文的分享对您有所帮助
| mysql数据库字段类型 | jdbc类型编号 |
|---|---|
| tinyint | -6 |
| smallint | 5 |
| mediumint | 4 |
| int | 4 |
| integer | 4 |
| bigint | -5 |
| bit | -7 |
| real | 8 |
| double | 8 |
| float | 7 |
| numeric | 3 |
| decimal | 3 |
| char | 1 |
| varchar | 12 |
| date | 91 |
| time | 92 |
| year | 91 |
| timestamp | 93 |
| datetime | 93 |
| tinyblob | -2 |
| blob | -4 |
| mediumblob | -4 |
| longblob | -4 |
| tinytext | 12 |
| text | -1 |
| mediumtext | -1 |
| longtext | -1 |
| enum | 1 |
| set | 1 |
| binary | -2 |
| varbinary | -3 |
| point | 1111 |
| linestring | 1111 |
| polygon | 1111 |
| geometry | -2 |
| multipoint | 1111 |
| multilinestring | 1111 |
| multipolygon | 1111 |
| geometrycollection | 1111 |