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 | 定长字符 |
是不是一对一,一对多,多对一,多对多;这些映射关系啊
映射是一对一,多对一,你结合执教坐标系的函数曲线的特点就记下了!~
有一对一,一对多,和多对多这三种
施主快躲开老衲要开枪了