java中常见数据库字段类型与java.sql.Types的对应

转自：http://blog.csdn.net/hbzyaxiu520/article/details/5457225

[java]  view plain  copy

1. 常见数据库字段类型与java.sql.Types的对应  
2.   
3. Oracle与java.sql.Types的对应   
4.   
5. Oracle                                java.sql.Types    
6.   
7.  blob                                     blob  
8.  char                                     char  
9.  clob                                     clob  
10.  date                                    date  
11.  number                               decimal  
12.  long                                     varbinary  
13.  nclob,nvarchar2                   other  
14.  smallint                                smallint  
15.  timestamp                            timstamp  
16.  raw                                      varbinary  
17.  varchar2                               varchar  
18.   
19. Sql server与java.sql.Types的对应   
20.   
21. Sql server                           java.sql.Types  
22.    bigint (2005,2008)                bigint  
23.    timstamp,binary                    binary  
24.    bit                                         bit  
25.    char,nchar,unqualified          char  
26.    datetime                               date  
27.    money,smallmoney,decimal  decimal  
28.    float (2005,2008)                  double  
29.    float(2000)                            float  
30.    int                                          integer  
31.    image                                    longvarbinary  
32.    text,ntext,xml                        longvarchar  
33.   
34.     numeric                                 numeric  
35.     real                                       real  
36.     smallint                                smallint  
37.     datetime,smalldatetime       timestamp  
38.     tinyint                                  tinyint  
39.     varbinary                             varbinay  
40.     nvarchar,varchar                 varchar  
41.   
42. DB2与java.sql.Types的对应   
43.   
44. bigint                                       bigint  
45.    blob                                      blob  
46.    character,graphic                 char  
47.    clob                                      clob  
48.    date                                     date  
49.    decimal                                decimal  
50.    double                                 double  
51.     integer                               integer  
52.     longvargraphic                   longvarchar  
53.     longvarchar  
54.   
55. real                                        real  
56.  smallint                                 smallint  
57.  time                                      time  
58.  timestamp                            timestamp  
59.  vargraphic                            varchar  
60.  varchar  
61.   
62. MySQL与java.sql.Types的对应   
63.   
64. MySQL                          java.sql.Types  
65.   bigint                              bigint  
66.    tinyblob                         binary  
67.    bit                                  bit  
68.    enum,set,char               char  
69.    date,year                      date  
70.    decimal,numeric            decimal  
71.    double,real                   double  
72.    mediumint,int                integer  
73.    blob,mediumblob           blob  
74.    longblob  
75.    float                               real  
76.   
77. smallint                           smallint  
78.    time                             time  
79.    timestamp,datetime     timestamp  
80.    tinyint                           tinyint  
81.    varbinary,binary           varbinay  
82.    varchar,tinytext,text     varchar  
83.   
84.   
85. Sybase与java.sql.Types的对应   
86.   
87. Sybase                            java.sql.Types  
88.    binary                                 binary  
89.    bit                                       bit  
90.    char,nchar,                            char  
91.    money,smallmoney,decimal    decimal  
92.    float                                     double  
93.     int                                       integer  
94.    image                                    longvarbinary  
95.    text                                      longvarchar  
96. numeric                                   numeric  
97.     real                                     real  
98.     smallint                              smallint  
99.     datetime,smalldatetime     timestamp  
100.     tinyint                                 tinyint  
101.     varbinar,timestamp            varbinay  
102.     nvarchar,varchar ,sysname   varchar