日期:2014-05-16 浏览次数:20456 次
| SQLSERVER JDBC对照 | ||||
| 1 | int | java.lang.Integer | 4 | |
| 2 | varchar | java.lang.String | 12 | |
| 3 | char | java.lang.String | 1 | |
| 4 | nchar | java.lang.String | 1 | |
| 5 | nvarchar | java.lang.String | 12 | |
| 6 | text | java.lang.String | -1 | |
| 7 | ntext | java.lang.String | -1 | |
| 8 | tinyint | java.lang.Integer | -6 | |
| 9 | int | java.lang.Integer | 4 | |
| 10 | tinyint | java.lang.Integer | -6 | |
| 11 | smallint | java.lang.Integer | 5 | |
| 12 | bit | java.lang.Boolean | -7 | |
| 13 | bigint | java.lang.Long | -5 | |
| 14 | float | java.lang.Double | 6 | |
| 15 | decimal | java.math.BigDecimal | 3 | |
| 16 | money | java.math.BigDecimal | 3 | |
| 17 | smallmoney | java.math.BigDecimal | 3 | |
| 18 | numeric | java.math.BigDecimal | 2 | |
| 19 | real | java.lang.Float | 7 | |
| 20 | uniqueidentifier | java.lang.String | 1 | |
| 21 | smalldatetime | java.sql.Timestamp | 93 | |
| 22 | datetime | java.sql.Timestamp | 93 | |
| 23 | timestamp | byte[] | -2 | |
| 24 | binary | byte[] | -2 | |
| 25 | varbinary | byte[] | -3 | |
| 26 | image | byte[] | -4 | |
| 27 | sql_variant | java.lang.String | 12 |