JDBC与Java的数据类型映射关系
JDBC Type
</td> <td>Java Type
</td> </tr> <tr> <td>CHAR
</td> <td>String
</td> </tr> <tr> <td>VARCHAR
</td> <td>String
</td> </tr> <tr> <td>LONGVARCHAR
</td> <td>String
</td> </tr> <tr> <td>NUMERIC
</td> <td>java.math.BigDecimal
</td> </tr> <tr> <td>DECIMAL
</td> <td>java.math.BigDecimal
</td> </tr> <tr> <td>BIT
</td> <td>boolean
</td> </tr> <tr> <td>BOOLEAN
</td> <td>boolean
</td> </tr> <tr> <td>TINYINT
</td> <td>byte
</td> </tr> <tr> <td>SMALLINT
</td> <td>short
</td> </tr> <tr> <td>INTEGER
</td> <td>int
</td> </tr> <tr> <td>BIGINT
</td> <td>long
</td> </tr> <tr> <td>REAL
</td> <td>float
</td> </tr> <tr> <td>FLOAT
</td> <td>double
</td> </tr> <tr> <td>DOUBLE
</td> <td>double
</td> </tr> <tr> <td>BINARY
</td> <td>byte[]
</td> </tr> <tr> <td>VARBINARY
</td> <td>byte[]
</td> </tr> <tr> <td>LONGVARBINARY
</td> <td>byte[]
</td> </tr> <tr> <td>DATE
</td> <td>java.sql.Date
</td> </tr> <tr> <td>TIME
</td> <td>java.sql.Time
</td> </tr> <tr> <td>TIMESTAMP
</td> <td>java.sql.Timestamp
</td> </tr> <tr> <td>CLOB
</td> <td>Clob
</td> </tr> <tr> <td>BLOB
</td> <td>Blob
</td> </tr> <tr> <td>ARRAY
</td> <td>Array
</td> </tr> <tr> <td>DISTINCT
</td> <td>mapping of underlying type
</td> </tr> <tr> <td>STRUCT
</td> <td>Struct
</td> </tr> <tr> <td>REF
</td> <td>Ref
</td> </tr> <tr> <td>DATALINK
</td> <td>java.net.URL
</td> </tr> <tr> <td>JAVA_OBJECT
</td> <td>underlying Java class
</td> </tr> </tbody> </table>您可能感兴趣的文章:
JDBC 解决方案
Golang 映射 声明使用原理及方法
建立JSP操作以提高数据库访问的效率
JAVA与数据库连接方法(一)
JDBC与Java的数据类型映射关系
JDBC接口技术 <转>
python映射类型是什么
django的orm有什么优点
django中orm的好处
学会如何处理数据库中的null