SQL的数据类型与Java数据类型的对应关系

SQL的数据类型与Java数据类型的对应关系

新一篇:

<script>function StorePage(){d=document;t=d.selection?(d.selection.type!='None'?d.selection.createRange().text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://www.365key.com/storeit.aspx?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t),'keyit','scrollbars=no,width=475,height=575,left=75,top=20,status=no,resizable=yes'));keyit.focus();}</script>

 

SQL数据类型                 Java数据类型
CHAR                                      String
VARCHAR                              String
LONGVARCHAR                  String
NUMERIC                      java.math.BigDecimal
DECIMAL                      java.math.BigDecimal
BIT                                         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

datetime                 java.sql.Timestamp 

blob                          java.sql.Blob