jdbcType 与 Java type

时间:2023-03-09 04:01:45
jdbcType  与 Java type
  • JDBC Type           Java Type
  • CHAR                String
  • VARCHAR             String
  • LONGVARCHAR         String
  • NUMERIC             java.math.BigDecimal
  • DECIMAL             java.math.BigDecimal
  • BIT                 boolean
  • BOOLEAN             boolean
  • TINYINT             byte
  • SMALLINT            short
  • INTEGER             int
  • BIGINT              long
  • REAL                float
  • FLOAT               double
  • DOUBLE              double
  • BINARY              byte[]
  • VARBINARY           byte[]
  • LONGVARBINARY       byte[]
  • DATE                java.sql.Date
  • TIME                java.sql.Time
  • TIMESTAMP           java.sql.Timestamp
  • CLOB                Clob
  • BLOB                Blob
  • ARRAY               Array
  • DISTINCT            mapping of underlying type
  • STRUCT              Struct
  • REF Ref
  • DATALINK            java.net.URL[color=red][/color]