How are JDBC types mapped to DataSet Column types

The JDBC to DataSet type mapping is pretty much the same as the JDBC to Java type mapping:

JDBC Types	DataSet Types
java.sql.Types.LONGVARCHAR java.sql.Types.CHAR java.sql.Types.VARCHAR Oracle ROWID is a String:	Variant.STRING
java.sql.Types.NUMERIC java.sql.Types.DECIMAL	Variant.BIGDECIMAL
java.sql.Types.BIT	Variant.BOOLEAN
java.sql.Types.TINYINT	Variant.BYTE
java.sql.Types.SMALLINT	Variant.SHORT
java.sql.Types.INTEGER	Variant.INT
java.sql.Types.BIGINT	Variant.LONG
java.sql.Types.REAL	Variant.FLOAT
java.sql.Types.FLOAT java.sql.Types.DOUBLE	Variant.DOUBLE
java.sql.Types.VARBINARY java.sql.Types.LONGVARBINARY java.sql.Types.BINARY	Variant.INPUTSTREAM
java.sql.Types.DATE	Variant.DATE
java.sql.Types.TIME	Variant.TIME
java.sql.Types.TIMESTAMP	Variant.TIMESTAMP
java.sql.Types.OTHER	Variant.OBJECT

分享到：

映射 SQL 和 Java 类型 | ResultSet getTables

• 2007-12-10 14:46
• 浏览 1735
• 评论(0)
• 查看更多