integer int or Integer INTEGER
long long or java.lang.Long BIGINT
short short or java.lang.Short SMALLINT
float float or java.lang.Float FLOAT
double double or java.lang.Double DOUBLE
big_decimal java.math.BigDecimal NUMERIC
character java.lang.String CHAR(1)
string java.lang.String VARCHAR
byte byte or java.lang.Byte TINYINT
boolean boolean or java.lang.Boolean BIT
yes_no boolean or java.lang.Boolean CHAR(1)('Y' or 'N')
true_false boolean or java.lang.Boolean CHAR(1)('Y' or 'N')
date java.util.Date or java.sql.Date DATE
time java.util.Date or java.sql.Time TIME
timestamp java.util.Date or java.sql.TimeStamp TIMESTAMP
calendar java.util.Calendar TIMESTAMP
calendar_date java.util.Calendar DATE
binary byte[] VARBINARY( or BLOB)
text java.lang.String CLOB
serializable java.io.Serializable VARBINARY (or BLOB)
clob java.sql.Clob CLOB
blob java.sql.Blob BLOB
class java.lang.Class VARCHAR
locale java.util.Locale VARCHAR
timezone java.util.TimeZone VARCHAR
currency java.util.Currency VARCHAR
bernate类型 | Java类型 | 标准SQL类型 | 大小 |
integer/int | Integer/int | integer | 4byte |
long | Long/long | bigint | 8 |
short | Short/short | smallint | 2 |
byte | Byte/byte | tinyint | 1 |
float | Float/float | float | 4 |
double | Double/double | double | 8 |
big_decimal | BigDecimal | numeric | |
character | Character/String/char | char(1) | 定长字符 |
string | String | varchar | 变长字符 |
boolean/yes_no/yes_false | Boolean/boolean | bit | 布尔类型 |
date | java.util.Date/java.sql.Date | date | 日期 |
timestamp | java.util.Date/java.util.Timestamp | timestamp | 日期 |
calendar | Calendar | timestamp | 日期 |
calendar_date | Calendar | date | 日期 |
binary | byte[] | blob | blob |
text | String | text | clob |
serializable | 实现java.io.Serializable接口的任意java类 | blob | blob |
clob | java.sql.Clob | clob | clob |
blob | java.sql.Blob | blob | blob |
class | java.lang.Class | varchar | 定长字符 |
locale | java.util.Locale | varchar | 定长字符 |
timezone | java.util.TimeZone | varchar | 定长字符 |
currency | java.util.Currency | varchar | 定长字符 |
是不是一对一,一对多,多对一,多对多;这些映射关系啊
映射是一对一,多对一,你结合执教坐标系的函数曲线的特点就记下了!~
有一对一,一对多,和多对多这三种