Monday, August 12, 2013

Simple Hibernate example

Hi Everyone,

Please create following scripts.In my system these tables are in HR schema or user.
Visit following URL to download the netbeans hibernate project code and let
me know if you face any issues.

Go to File->Download to download zip folder

https://docs.google.com/file/d/0BwZaaDwCofcNeFhDaEFtRVhTOEE/edit?pli=1

CREATE TABLE  CONTINENTS 
  ( CONTIID NUMBER, 
 CONTINAME VARCHAR2(100), 
  CONSTRAINT CONTI_PK PRIMARY KEY (CONTIID)
   )

CREATE TABLE  COUNTRIESHIB 
   ( CONTID NUMBER, 
 CONTNAME VARCHAR2(100), 
 CONTIFK NUMBER, 
  CONSTRAINT CONT_PK PRIMARY KEY (CONTID) , 
  CONSTRAINT CONTI_FK FOREIGN KEY (CONTIFK)
   REFERENCES  CONTINENTS (CONTIID) 
   )

CREATE SEQUENCE ContiSequence
 START WITH     1000
 INCREMENT BY   1
 NOCACHE
 NOCYCLE;

CREATE SEQUENCE CountrySequence
 START WITH     1000
 INCREMENT BY   1
 NOCACHE
 NOCYCLE;

Access continentAdd.jsp to add new continent
Access countryAdd.jsp to add new country.

No comments:

Post a Comment