Hibernate Tutorial «Prev  Next»

Preparing Hibernate Database

Let us consider a simple database schema with a singe table as USER.
CREATE  TABLE `user` (USER_ID` int(11) NOT NULL default  '0',
`USER_NAME` varchar(255) NOT NULL  default '',
`USER_PASSWORD` varchar(255) NOT NULL  default '',
`USER_FIRST_NAME` varchar(255) default  NULL,
`USER_LAST_NAME` varchar(255) default  NULL,
`USER_EMAIL` varchar(255) default  NULL,
`USER_CREATION_DATE` date default  NULL,
`USER_MODIFICATION_DATE` date default  NULL,
PRIMARY KEY (`USER_ID`),
UNIQUE KEY `USER_NAME` (`USER_NAME`)
) ;