Hibernate Demo

package com.hibernate.venkat;

import java.io.Serializable;
import java.util.Date;

import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity

public class Pungi  {
  /**
*
*/

private int id;
private String Fitness;
private String Company;

@Id
@GeneratedValue
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getFitness() {
return Fitness;
}
public void setFitness(String fitness) {
Fitness = fitness;
}
public String getCompany() {
return Company;
}
public void setCompany(String company) {
Company = company;
}
@Override
public String toString() {
return "Pungi [id=" + id + ", Fitness=" + Fitness + ", Company=" + Company
+ "]";
}


 
}
---------------------------------------------------------------------------------------------

package com.hibernate.venkat;

import java.util.Date;
import java.util.Iterator;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.tool.hbm2ddl.SchemaExport;

/**
 * @author venkat
 *
 */
public class TestStudent {

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
AnnotationConfiguration config=new AnnotationConfiguration();
config.addAnnotatedClass(Pungi.class);
config.configure("hibernate.cfg.xml");

//new SchemaExport(config).create(true, true);


SessionFactory sf=config.buildSessionFactory();
Session session = sf.getCurrentSession();
session.beginTransaction();

Query q=session.createQuery("from Pungi where id>1 and company=''");
List list=q.list();

for (Iterator iterator = list.iterator(); iterator.hasNext();) {
Pungi object = (Pungi) iterator.next();
System.out.println(object.toString());
}


}

}

----------------------------------------

<?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">

<hibernate-configuration>

    <session-factory>

        <!-- Database connection settings -->

        <property name="connection.driver_class">oracle.jdbc.OracleDriver</property>

        <property name="connection.url">jdbc:oracle:thin:@localhost:1521:xe</property>

        <property name="connection.username">venkat</property>

        <property name="connection.password">venkat</property>

        <!-- JDBC connection pool (use the built-in) -->

        <property name="connection.pool_size">2</property>

        <!-- SQL dialect -->

        <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>

        <!-- Enable Hibernate's current session context -->

        <property name="current_session_context_class">thread</property>

        <!-- Disable the second-level cache  -->

        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

        <!-- Echo all executed SQL to stdout -->

        <property name="show_sql">true</property>

        

        <!-- Drop and re-create the database schema on startup -->

<!--         <property name="hbm2ddl.auto">create</property> -->

<!--         <mapping resource="org/hibernate/tutorial/domain/Event.hbm.xml"/> -->

<!--         <mapping resource="org/hibernate/tutorial/domain/Person.hbm.xml"/> -->

    </session-factory>

</hibernate-configuration>