SQL Server Types | JDBC Types (java.sql.Types) | Java Language Types |
---|---|---|
bigint | BIGINT | long |
timestamp binary uniqueidentifier | BINARY | byte[] |
bit | BIT | boolean |
charnchar | CHAR | String |
N/A | DATE | java.sql.Date |
decimal money smallmoney | DECIMAL | java.math.BigDecimal |
N/A | DOUBLE | double |
float | FLOAT | double |
int | INTEGER | int |
image | LONGVARBINARY | byte[] |
text ntext | LONGVARCHAR | String |
N/A | NULL | N/A |
numeric | NUMERIC | java.math.BigDecimal |
N/A | OTHER | N/A |
real | REAL | float |
smallint tinyint | SMALLINT | short |
N/A | TIME | N/A |
datetime smalldatetime | TIMESTAMP | java.sql.Timestamp |
N/A | TINYINT | byte[] |
varbinary | VARBINARY | byte[] |
varchar nvarchar | VARCHAR | String |
SQL Server数据类型对应的JDBC数据类型(java.sql.Types)和Java数据类型
最新推荐文章于 2022-05-31 21:46:11 发布