Hibernate

1. First create project in eclipse(either java project/webproject)
2. configure the required jar for sql or mysql or any data base
2. right click on project and Add hibernate capabilities
3. then configure the hibenate configureation file
<?xml version='1.0' encoding='UTF-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> Generated by MyEclipse Hibernate Tools. --><br /><hibernate-configuration> <br /><session-factory> <br /><property name="dialect">org.hibernate.dialect.MySQLDialect</property> <br /><property name="connection.url">jdbc:mysql://localhost:3306/frameworkdb</property> <property name="connection.username">root</property> <br /><property name="connection.password">12345678</property> <br /><property name="connection.driver_class">com.mysql.jdbc.Driver</property> <br /><property name="hibernate.show_sql ">true</property> <br /><property name="hibernate.hbm2ddl.auto">update</property> <br /><mapping resource="authentication.hbm.xml"> <br /></session-factory> <br /> </hibernate-configuration><br />
4. create the POJO code that will map the table column names eg.

/** * */ package com.hib.to; /** * @author kumar.ganapathy * */ public class Authenticate { private long uid; private String userName; private String passWord; /** * @return the uid */ public long getUid() { return uid; } /** * @param uid the uid to set */ public void setUid(long uid) { this.uid = uid; } /** * @return the userName */ public String getUserName() { return userName; } /** * @param userName the userName to set */ public void setUserName(String userName) { this.userName = userName; } /** * @return the passWord */ public String getPassWord() { return passWord; } /** * @param passWord the passWord to set */ public void setPassWord(String passWord) { this.passWord = passWord; } }


5. create the mapping xml called authenticate.hbm.xml

<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="com.hib.to.Authenticate" table="authentication"> <id name="uid" type="long" column="userid"> </id> <property name="userName"> <column name="username"> </property> <property name="passWord"> <column name="password"> </property> </class> </hibernate-mapping>

6. create main class to run hibernate as standalone


package com.hib.showcase; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import com.hib.to.Authenticate; public class FirstHibernateprg { /** * @param args */ public static void main(String[] args) { Session session=null; try{ SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory(); session =sessionFactory.openSession(); Transaction tr= session.beginTransaction(); Authenticate auth=new Authenticate(); String sql="delete from authentication where uid=6"; Query qq=session.createQuery(sql); auth.setUid(6); auth.setUserName("praveen"); auth.setPassWord("007"); //session.save(auth); qq.executeUpdate(); tr.commit(); }catch(Exception e){ System.out.println("error : "+e.getMessage()); e.printStackTrace(); }finally{ session.flush(); session.close(); } } }



7. run the application as like normal standalone java class