author | František Kučera <franta-hg@frantovo.cz> |
Wed, 14 Apr 2010 00:12:32 +0200 | |
changeset 100 | 01be78803f73 |
parent 67 | fa7e30dee3b3 |
child 107 | e8371105fcc8 |
permissions | -rw-r--r-- |
franta-hg@39 | 1 |
package cz.frantovo.nekurak.dao; |
franta-hg@39 | 2 |
|
franta-hg@39 | 3 |
import cz.frantovo.nekurak.dto.Podnik; |
franta-hg@39 | 4 |
import java.util.Collection; |
franta-hg@49 | 5 |
import java.util.Date; |
franta-hg@39 | 6 |
import javax.ejb.LocalBean; |
franta-hg@39 | 7 |
import javax.ejb.Stateless; |
franta-hg@39 | 8 |
import javax.persistence.EntityManager; |
franta-hg@39 | 9 |
import javax.persistence.PersistenceContext; |
franta-hg@39 | 10 |
import javax.persistence.Query; |
franta-hg@39 | 11 |
|
franta-hg@39 | 12 |
/** |
franta-hg@39 | 13 |
* |
franta-hg@39 | 14 |
* @author fiki |
franta-hg@39 | 15 |
*/ |
franta-hg@39 | 16 |
@Stateless |
franta-hg@39 | 17 |
@LocalBean |
franta-hg@48 | 18 |
public class PodnikDAO { |
franta-hg@39 | 19 |
|
franta-hg@67 | 20 |
@PersistenceContext(unitName = DAO.PU) |
franta-hg@39 | 21 |
private EntityManager em; |
franta-hg@39 | 22 |
|
franta-hg@39 | 23 |
public Collection<Podnik> getPodniky() { |
franta-hg@67 | 24 |
Query dotaz = em.createQuery("FROM " + DAO.t(Podnik.class) + " o ORDER BY datum DESC"); |
franta-hg@39 | 25 |
return dotaz.getResultList(); |
franta-hg@39 | 26 |
} |
franta-hg@39 | 27 |
|
franta-hg@100 | 28 |
/** |
franta-hg@100 | 29 |
* @return podniky, které nemají souřadnice (null, null) |
franta-hg@100 | 30 |
*/ |
franta-hg@100 | 31 |
public Collection<Podnik> getPodnikyBezSouradnic() { |
franta-hg@100 | 32 |
Query dotaz = em.createQuery("FROM " + DAO.t(Podnik.class) + " o WHERE sirka IS NULL AND delka IS NULL"); |
franta-hg@100 | 33 |
return dotaz.getResultList(); |
franta-hg@100 | 34 |
} |
franta-hg@100 | 35 |
|
franta-hg@100 | 36 |
public Podnik getPodnik(int id) { |
franta-hg@100 | 37 |
return em.find(Podnik.class, id); |
franta-hg@100 | 38 |
} |
franta-hg@100 | 39 |
|
franta-hg@56 | 40 |
public void zaloz(Podnik p) { |
franta-hg@49 | 41 |
if (p.getDatum() == null) { |
franta-hg@49 | 42 |
p.setDatum(new Date()); |
franta-hg@49 | 43 |
} |
franta-hg@49 | 44 |
|
franta-hg@40 | 45 |
em.persist(p); |
franta-hg@40 | 46 |
} |
franta-hg@40 | 47 |
|
franta-hg@56 | 48 |
public void uloz(Podnik p) { |
franta-hg@56 | 49 |
if (p.getDatum() == null) { |
franta-hg@56 | 50 |
p.setDatum(new Date()); |
franta-hg@56 | 51 |
} |
franta-hg@56 | 52 |
|
franta-hg@56 | 53 |
em.merge(p); |
franta-hg@56 | 54 |
} |
franta-hg@39 | 55 |
} |