%BROADCASTMESSAGE%

	TWiki > Catch0405 > KaisersrotPersistenz > SoftwareVersions > ImplementierungInKaisersrot > RetrieveDataFromDbKaisersrotsupermix	TWiki webs: Admin| Aizo | Archinf | BIP | Bgyalex | Brandhub | Catch0405 | Cityscan05 | CommunityMedia | Control | Curtain | Easa005 | Easydb | Education | Extern | Extern0405 | Freudenhaus | Fund | Game0405 | Game05 | Gamearch | Luise | MAS0506 | MAS0506stu | Mas0506 | Mas0506stu | Maschinen0405 | Menz | Mill | Mill0405 | NDS | NDS0405 | NDS0405stu | Plugins | Qwipp | RZM | Replay | Replay0405 | Research | Second | Trash | Udintern | Urbandesign |
	Catch0405 . { Changes | Index | Search | Go }

import java.util.Iterator;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.Transaction;
import net.sf.hibernate.cfg.Configuration;

/*
 * Created on Jan 3, 2005
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

/**
 * @author denis
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class RetrieveData {
   
   RetrieveData(){
      
      this.select();
   
   }

   void select() {

      try {

         //Create the SessionFactory
         Configuration cfg = new Configuration().addClass(StoreTupel.class);
         SessionFactory factory = cfg.buildSessionFactory();
         //Create the Session
         Session session = factory.openSession();
         //Create the Transaction               
         Transaction tx = session.beginTransaction();
         
         Query query = session               
                 .createQuery("select c from StoreTupel as c where anzahl like :anzahl");

         query.setString("anzahl", "%");
         for (Iterator it = query.iterate(); it.hasNext();) {
            StoreTupel storeTupel = (StoreTupel) it.next();
            System.out.println("searched tupel is: " + storeTupel.getAnzahl());                  
         }

         tx.commit();

      } catch (HibernateException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
      }
   }
}

-- OtherDenisRaschpichler - 03 Jan 2005