Java/Hibernate/Query

Материал из Java эксперт
Перейти к: навигация, поиск

Simple Query

   <source lang="java">

///////////////////////////////////////////////////////////////////////// import java.util.Date; import java.util.List; import org.hibernate.Session; import org.hibernate.Hibernate; import org.hibernate.Transaction; public class SimpleRetrieveTest {


 public static void main(String[] args) {
   HibernateUtil.setup("create table EVENTS ( uid int, name VARCHAR, start_Date date, duration int, location_id int);");
   HibernateUtil.setup("create table locations ( uid int, name VARCHAR, address VARCHAR);");
   // hibernate code start
   Session session = HibernateUtil.currentSession();
   Transaction tx = session.beginTransaction();
       Location location = new Location();
       location.setName("USA");
       location.setAddress("Address");
       session.save(location);
       Event e= new Event();
       e.setId(11111L);
       e.setName("testSave");
       e.setStartDate(new Date());
       e.setLocation(location);
       e.setName("testSave");
   session.save(e);
       List results = session.createQuery("from Event e where e.name="testSave"").list();
   
   System.out.println(results.size());
   
   tx.rumit();
   HibernateUtil.closeSession();
   HibernateUtil.sessionFactory.close();
   // hibernate code end
   
 
   HibernateUtil.checkData("select * from events;");
   
 }

}

///////////////////////////////////////////////////////////////////////// public class Location {

   private Long id;
   private String name;
   private String address;
   public Long getId() {
       return id;
   }
   public void setId(Long id) {
       this.id = id;
   }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public String getAddress() {
       return address;
   }
   public void setAddress(String address) {
       this.address = address;
   }

}


/////////////////////////////////////////////////////////////////////////

<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC

   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping >

   <class name="Location" table="locations" lazy="true">
       <id name="id" column="uid" type="long">
           <generator class="native"/>
       </id>
       <property name="name" type="string"/>
       <property name="address" type="string"/>
   </class>

</hibernate-mapping>

///////////////////////////////////////////////////////////////////////// <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC

   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

   <class name="Event" table="events">
       <id name="id" column="uid" type="long" unsaved-value="null">
           <generator class="assigned"/>
       </id>
       <property name="name" type="string" length="100"/>
       <property name="startDate" column="start_date"
                 type="date"/>
       <property name="duration" type="integer"/>
       <many-to-one name="location" column="location_id"
                    class="Location"/>
   </class>

</hibernate-mapping>

/////////////////////////////////////////////////////////////////////////

import java.util.Date; public class Event {

 private Long id;
 private String name;
 private Date startDate;
 private int duration;
   private Location location;
 public void setId(Long id) {
   this.id = id;
 }
 
 public Long getId() {
   return id;
 }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public Date getStartDate() {
       return startDate;
   }
   public void setStartDate(Date startDate) {
       this.startDate = startDate;
   }
   public int getDuration() {
       return duration;
   }
   public void setDuration(int duration) {
       this.duration = duration;
   }
   public Location getLocation() {
       return location;
   }
   public void setLocation(Location location) {
       this.location = location;
   }

}

///////////////////////////////////////////////////////////////////////// <?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>
       
       <property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
       <property name="connection.url">jdbc:hsqldb:data/tutorial</property>
       <property name="connection.username">sa</property>
       <property name="connection.password"></property>
       
       <property name="connection.pool_size">1</property>
       
       <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
       
       <property name="show_sql">true</property>
       <mapping resource="Event.hbm.xml"/>
       <mapping resource="Location.hbm.xml"/>
       <mapping resource="Speaker.hbm.xml"/>
   </session-factory>

</hibernate-configuration>

      </source>
   
  
 
  



Simple Query for Only Class Property

   <source lang="java">

///////////////////////////////////////////////////////////////////////// import java.util.Date; import java.util.List; import org.hibernate.Session; import org.hibernate.Hibernate; import org.hibernate.Transaction; public class SimpleRetrieveTest {


 public static void main(String[] args) {
   HibernateUtil.setup("create table EVENTS ( uid int, name VARCHAR, start_Date date, duration int, location_id int);");
   HibernateUtil.setup("create table locations ( uid int, name VARCHAR, address VARCHAR);");
   // hibernate code start
   Session session = HibernateUtil.currentSession();
   Transaction tx = session.beginTransaction();
       Location location = new Location();
       location.setName("USA");
       location.setAddress("Address");
       session.save(location);
       Event e= new Event();
       e.setId(11111L);
       e.setName("testSave");
       e.setStartDate(new Date());
       e.setLocation(location);
       e.setName("testSave");
   session.save(e);
       List results = session.createQuery("select e.name from Event e where e.name=?").setString(0, "testSave").list();
   
   System.out.println(results);
   
   tx.rumit();
   HibernateUtil.closeSession();
   HibernateUtil.sessionFactory.close();
   // hibernate code end
 }

}

///////////////////////////////////////////////////////////////////////// public class Location {

   private Long id;
   private String name;
   private String address;
   public Long getId() {
       return id;
   }
   public void setId(Long id) {
       this.id = id;
   }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public String getAddress() {
       return address;
   }
   public void setAddress(String address) {
       this.address = address;
   }

}


///////////////////////////////////////////////////////////////////////// <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC

   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping >

   <class name="Location" table="locations" lazy="true">
       <id name="id" column="uid" type="long">
           <generator class="native"/>
       </id>
       <property name="name" type="string"/>
       <property name="address" type="string"/>
   </class>

</hibernate-mapping>

/////////////////////////////////////////////////////////////////////////

<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC

   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

   <class name="Event" table="events">
       <id name="id" column="uid" type="long" unsaved-value="null">
           <generator class="assigned"/>
       </id>
       <property name="name" type="string" length="100"/>
       <property name="startDate" column="start_date"
                 type="date"/>
       <property name="duration" type="integer"/>
       <many-to-one name="location" column="location_id"
                    class="Location"/>
   </class>

</hibernate-mapping>

/////////////////////////////////////////////////////////////////////////

import java.util.Date; public class Event {

 private Long id;
 private String name;
 private Date startDate;
 private int duration;
   private Location location;
 public void setId(Long id) {
   this.id = id;
 }
 
 public Long getId() {
   return id;
 }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public Date getStartDate() {
       return startDate;
   }
   public void setStartDate(Date startDate) {
       this.startDate = startDate;
   }
   public int getDuration() {
       return duration;
   }
   public void setDuration(int duration) {
       this.duration = duration;
   }
   public Location getLocation() {
       return location;
   }
   public void setLocation(Location location) {
       this.location = location;
   }

}

/////////////////////////////////////////////////////////////////////////

      </source>
   
  
 
  



Simple Query Iterating Class results

   <source lang="java">

/////////////////////////////////////////////////////////////////////////

import java.util.*; import org.hibernate.Session; import org.hibernate.Hibernate; import org.hibernate.Transaction; public class SimpleRetrieveTest {


 public static void main(String[] args) {
   HibernateUtil.setup("create table EVENTS ( uid int, name VARCHAR, start_Date date, duration int, location_id int);");
   HibernateUtil.setup("create table locations ( uid int, name VARCHAR, address VARCHAR);");
   // hibernate code start
   Session session = HibernateUtil.currentSession();
   Transaction tx = session.beginTransaction();
       Location location = new Location();
       location.setName("USA");
       location.setAddress("Address");
       session.save(location);
       Event e= new Event();
       e.setId(11111L);
       e.setName("testSave");
       e.setStartDate(new Date());
       e.setLocation(location);
       e.setName("testSave");
   session.save(e);
       Iterator iter =  session.createQuery("select e.location from Event e where e.name=?").setString(0, "testSave").iterate();
   
       while ( iter.hasNext() ) {
           Location qux = (Location) iter.next();  // fetch the object
           // something we couldnt express in the query
           System.out.println(qux.getName());
       }    
   tx.rumit();
   HibernateUtil.closeSession();
   HibernateUtil.sessionFactory.close();
   // hibernate code end
 }

}

/////////////////////////////////////////////////////////////////////////

<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC

   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping >

   <class name="Location" table="locations" lazy="true">
       <id name="id" column="uid" type="long">
           <generator class="native"/>
       </id>
       <property name="name" type="string"/>
       <property name="address" type="string"/>
   </class>

</hibernate-mapping>

/////////////////////////////////////////////////////////////////////////

public class Location {

   private Long id;
   private String name;
   private String address;
   public Long getId() {
       return id;
   }
   public void setId(Long id) {
       this.id = id;
   }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public String getAddress() {
       return address;
   }
   public void setAddress(String address) {
       this.address = address;
   }

}

/////////////////////////////////////////////////////////////////////////

<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC

   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

   <class name="Event" table="events">
       <id name="id" column="uid" type="long" unsaved-value="null">
           <generator class="assigned"/>
       </id>
       <property name="name" type="string" length="100"/>
       <property name="startDate" column="start_date"
                 type="date"/>
       <property name="duration" type="integer"/>
       <many-to-one name="location" column="location_id"
                    class="Location"/>
   </class>

</hibernate-mapping>

/////////////////////////////////////////////////////////////////////////

import java.util.Date; public class Event {

 private Long id;
 private String name;
 private Date startDate;
 private int duration;
   private Location location;
 public void setId(Long id) {
   this.id = id;
 }
 
 public Long getId() {
   return id;
 }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public Date getStartDate() {
       return startDate;
   }
   public void setStartDate(Date startDate) {
       this.startDate = startDate;
   }
   public int getDuration() {
       return duration;
   }
   public void setDuration(int duration) {
       this.duration = duration;
   }
   public Location getLocation() {
       return location;
   }
   public void setLocation(Location location) {
       this.location = location;
   }

}

/////////////////////////////////////////////////////////////////////////

      </source>
   
  
 
  



Simple Query Queries That Returns Tuples

   <source lang="java">

///////////////////////////////////////////////////////////////////////// import java.util.*; import org.hibernate.Session; import org.hibernate.Hibernate; import org.hibernate.Transaction; public class SimpleRetrieveTest {


 public static void main(String[] args) {
   HibernateUtil.setup("create table EVENTS ( uid int, name VARCHAR, start_Date date, duration int, location_id int);");
   HibernateUtil.setup("create table locations ( uid int, name VARCHAR, address VARCHAR);");
   // hibernate code start
   Session session = HibernateUtil.currentSession();
   Transaction tx = session.beginTransaction();
       Location location = new Location();
       location.setName("USA");
       location.setAddress("Address");
       session.save(location);
       Event e= new Event();
       e.setId(11111L);
       e.setName("testSave");
       e.setStartDate(new Date());
       e.setLocation(location);
       e.setName("testSave");
   session.save(e);
       Iterator iter =  session.createQuery("select e.name, e.location from Event e where e.name=?").setString(0, "testSave").iterate();
   
       while ( iter.hasNext() ) {
           Object[] tuple = (Object[]) iter.next();
           System.out.println(tuple[0]);
           System.out.println(tuple[1]);
       }    
       tx.rumit();
   HibernateUtil.closeSession();
   HibernateUtil.sessionFactory.close();
   // hibernate code end
 }

}

///////////////////////////////////////////////////////////////////////// <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC

   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping >

   <class name="Location" table="locations" lazy="true">
       <id name="id" column="uid" type="long">
           <generator class="native"/>
       </id>
       <property name="name" type="string"/>
       <property name="address" type="string"/>
   </class>

</hibernate-mapping>


///////////////////////////////////////////////////////////////////////// public class Location {

   private Long id;
   private String name;
   private String address;
   public Long getId() {
       return id;
   }
   public void setId(Long id) {
       this.id = id;
   }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public String getAddress() {
       return address;
   }
   public void setAddress(String address) {
       this.address = address;
   }

}


///////////////////////////////////////////////////////////////////////// <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC

   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

   <class name="Event" table="events">
       <id name="id" column="uid" type="long" unsaved-value="null">
           <generator class="assigned"/>
       </id>
       <property name="name" type="string" length="100"/>
       <property name="startDate" column="start_date"
                 type="date"/>
       <property name="duration" type="integer"/>
       <many-to-one name="location" column="location_id"
                    class="Location"/>
   </class>

</hibernate-mapping>

///////////////////////////////////////////////////////////////////////// import java.util.Date; public class Event {

 private Long id;
 private String name;
 private Date startDate;
 private int duration;
   private Location location;
 public void setId(Long id) {
   this.id = id;
 }
 
 public Long getId() {
   return id;
 }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public Date getStartDate() {
       return startDate;
   }
   public void setStartDate(Date startDate) {
       this.startDate = startDate;
   }
   public int getDuration() {
       return duration;
   }
   public void setDuration(int duration) {
       this.duration = duration;
   }
   public Location getLocation() {
       return location;
   }
   public void setLocation(Location location) {
       this.location = location;
   }

}


/////////////////////////////////////////////////////////////////////////

      </source>
   
  
 
  



Simple Query Scalar Results

   <source lang="java">

///////////////////////////////////////////////////////////////////////// import java.util.*; import org.hibernate.Session; import org.hibernate.Hibernate; import org.hibernate.Transaction; public class SimpleRetrieveTest {


 public static void main(String[] args) {
   HibernateUtil.setup("create table EVENTS ( uid int, name VARCHAR, start_Date date, duration int, location_id int);");
   HibernateUtil.setup("create table locations ( uid int, name VARCHAR, address VARCHAR);");
   // hibernate code start
   Session session = HibernateUtil.currentSession();
   Transaction tx = session.beginTransaction();
       Location location = new Location();
       location.setName("USA");
       location.setAddress("Address");
       session.save(location);
       Event e= new Event();
       e.setId(11111L);
       e.setName("testSave");
       e.setStartDate(new Date());
       e.setLocation(location);
       e.setName("testSave");
   session.save(e);
       Iterator iter =  session.createQuery("select e.name, e.id from Event e where e.name=?").setString(0, "testSave").iterate();
   
       while ( iter.hasNext() ) {
           Object[] tuple = (Object[]) iter.next();
           System.out.println(tuple[0]);
           System.out.println(tuple[1]);
       }    
       tx.rumit();
   HibernateUtil.closeSession();
   HibernateUtil.sessionFactory.close();
   // hibernate code end
 }

}

///////////////////////////////////////////////////////////////////////// <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC

   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping >

   <class name="Location" table="locations" lazy="true">
       <id name="id" column="uid" type="long">
           <generator class="native"/>
       </id>
       <property name="name" type="string"/>
       <property name="address" type="string"/>
   </class>

</hibernate-mapping>


///////////////////////////////////////////////////////////////////////// public class Location {

   private Long id;
   private String name;
   private String address;
   public Long getId() {
       return id;
   }
   public void setId(Long id) {
       this.id = id;
   }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public String getAddress() {
       return address;
   }
   public void setAddress(String address) {
       this.address = address;
   }

}

///////////////////////////////////////////////////////////////////////// <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC

   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

   <class name="Event" table="events">
       <id name="id" column="uid" type="long" unsaved-value="null">
           <generator class="assigned"/>
       </id>
       <property name="name" type="string" length="100"/>
       <property name="startDate" column="start_date"
                 type="date"/>
       <property name="duration" type="integer"/>
       <many-to-one name="location" column="location_id"
                    class="Location"/>
   </class>

</hibernate-mapping>


///////////////////////////////////////////////////////////////////////// import java.util.Date; public class Event {

 private Long id;
 private String name;
 private Date startDate;
 private int duration;
   private Location location;
 public void setId(Long id) {
   this.id = id;
 }
 
 public Long getId() {
   return id;
 }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public Date getStartDate() {
       return startDate;
   }
   public void setStartDate(Date startDate) {
       this.startDate = startDate;
   }
   public int getDuration() {
       return duration;
   }
   public void setDuration(int duration) {
       this.duration = duration;
   }
   public Location getLocation() {
       return location;
   }
   public void setLocation(Location location) {
       this.location = location;
   }

}


/////////////////////////////////////////////////////////////////////////

      </source>
   
  
 
  



Simple Query With Parameters

   <source lang="java">

/////////////////////////////////////////////////////////////////////////

import java.util.Date; import java.util.List; import org.hibernate.Session; import org.hibernate.Hibernate; import org.hibernate.Transaction; public class SimpleRetrieveTest {


 public static void main(String[] args) {
   HibernateUtil.setup("create table EVENTS ( uid int, name VARCHAR, start_Date date, duration int, location_id int);");
   HibernateUtil.setup("create table locations ( uid int, name VARCHAR, address VARCHAR);");
   // hibernate code start
   Session session = HibernateUtil.currentSession();
   Transaction tx = session.beginTransaction();
       Location location = new Location();
       location.setName("USA");
       location.setAddress("Address");
       session.save(location);
       Event e= new Event();
       e.setId(11111L);
       e.setName("testSave");
       e.setStartDate(new Date());
       e.setLocation(location);
       e.setName("testSave");
   session.save(e);
       List results = session.createQuery("from Event e where e.name=?").setString(0, "testSave").list();
   
   System.out.println(results.size());
   
   tx.rumit();
   HibernateUtil.closeSession();
   HibernateUtil.sessionFactory.close();
   // hibernate code end
   
 
   HibernateUtil.checkData("select * from events;");
   
 }

}

/////////////////////////////////////////////////////////////////////////

<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC

   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

   <class name="Event" table="events">
       <id name="id" column="uid" type="long" unsaved-value="null">
           <generator class="assigned"/>
       </id>
       <property name="name" type="string" length="100"/>
       <property name="startDate" column="start_date"
                 type="date"/>
       <property name="duration" type="integer"/>
       <many-to-one name="location" column="location_id"
                    class="Location"/>
   </class>

</hibernate-mapping>

///////////////////////////////////////////////////////////////////////// import java.util.Date; public class Event {

 private Long id;
 private String name;
 private Date startDate;
 private int duration;
   private Location location;
 public void setId(Long id) {
   this.id = id;
 }
 
 public Long getId() {
   return id;
 }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public Date getStartDate() {
       return startDate;
   }
   public void setStartDate(Date startDate) {
       this.startDate = startDate;
   }
   public int getDuration() {
       return duration;
   }
   public void setDuration(int duration) {
       this.duration = duration;
   }
   public Location getLocation() {
       return location;
   }
   public void setLocation(Location location) {
       this.location = location;
   }

}


///////////////////////////////////////////////////////////////////////// <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC

   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping >

   <class name="Location" table="locations" lazy="true">
       <id name="id" column="uid" type="long">
           <generator class="native"/>
       </id>
       <property name="name" type="string"/>
       <property name="address" type="string"/>
   </class>

</hibernate-mapping>

///////////////////////////////////////////////////////////////////////// public class Location {

   private Long id;
   private String name;
   private String address;
   public Long getId() {
       return id;
   }
   public void setId(Long id) {
       this.id = id;
   }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
   public String getAddress() {
       return address;
   }
   public void setAddress(String address) {
       this.address = address;
   }

}

///////////////////////////////////////////////////////////////////////// <?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>
       
       <property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
       <property name="connection.url">jdbc:hsqldb:data/tutorial</property>
       <property name="connection.username">sa</property>
       <property name="connection.password"></property>
       
       <property name="connection.pool_size">1</property>
       
       <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
       
       <property name="show_sql">true</property>
       <mapping resource="Event.hbm.xml"/>
       <mapping resource="Location.hbm.xml"/>
       <mapping resource="Speaker.hbm.xml"/>
   </session-factory>

</hibernate-configuration>

      </source>