Hibernate_MySQL_数据类型的对应关系
如下所示Hibernate 实体,
@Entity
@Table(name = "tb_hello_user")
public class HelloUser {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
private String stringFlag;
private int intFlag;
private float floatFlag;
private byte byteFlag;
private char charFlag;
private short shortFlag;
private boolean online;
private long longFlag;
private double doubleFlag;
private String address;
private Date lastLoginDate;
private Date birthday;
private Long longObjFlag;
private Double doubleObjFlag;
private BigDecimal bigDecimalFlag;
private Boolean boolObjFlag;
private Float floatObjFlag;
private Integer integerObjFlag;
private Short shortObjFlag;
private Character characterObjFlag;
..............
}
自动生成的schema 为:
CREATE TABLE `tb_hello_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`address` varchar(255) DEFAULT NULL,
`bigDecimalFlag` decimal(19,2) DEFAULT NULL,
`birthday` datetime DEFAULT NULL,
`boolObjFlag` bit(1) DEFAULT NULL,
`byteFlag` tinyint(4) NOT NULL,
`charFlag` char(1) NOT NULL,
`characterObjFlag` char(1) DEFAULT NULL,
`doubleFlag` double NOT NULL,
`doubleObjFlag` double DEFAULT NULL,
`floatFlag` float NOT NULL,
`floatObjFlag` float DEFAULT NULL,
`intFlag` int(11) NOT NULL,
`integerObjFlag` int(11) DEFAULT NULL,
`lastLoginDate` datetime DEFAULT NULL,
`longFlag` bigint(20) NOT NULL,
`longObjFlag` bigint(20) DEFAULT NULL,
`online` bit(1) NOT NULL,
`shortFlag` smallint(6) NOT NULL,
`shortObjFlag` smallint(6) DEFAULT NULL,
`stringFlag` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
从自动生成的schema 中就可以看出对应关系来了。
==================END==================