diff -r 715acc59d67d -r 769816825525 java/HibernateDemo1/HibernateDemo1-ejb/src/java/cz/frantovo/hibernateDemo1/CilDAOBean.java
--- a/java/HibernateDemo1/HibernateDemo1-ejb/src/java/cz/frantovo/hibernateDemo1/CilDAOBean.java	Sat Mar 14 22:22:46 2009 +0100
+++ b/java/HibernateDemo1/HibernateDemo1-ejb/src/java/cz/frantovo/hibernateDemo1/CilDAOBean.java	Sat Mar 14 22:55:11 2009 +0100
@@ -5,6 +5,7 @@
 import javax.ejb.Stateless;
 import javax.persistence.EntityManager;
 import javax.persistence.PersistenceContext;
+import javax.persistence.Query;
 
 /**
  *
@@ -12,13 +13,17 @@
  */
 @Stateless
 public class CilDAOBean implements CilDAORemote {
-    
-    public static final String PU = "HibernateDemo1-PU";
 
+    private static final String PU = "HibernateDemo1-PU";
     @PersistenceContext(unitName = PU)
     private EntityManager em;
 
     public Collection<Cil> getCile() {
-        throw new UnsupportedOperationException("Not supported yet.");
+        Query dotaz = em.createQuery("from " + t(Cil.class) + " o order by nazev");
+        return dotaz.getResultList();
+    }
+
+    private static String t(Class trida) {
+        return trida.getSimpleName();
     }
 }