Mercurial > lada > lada-server
diff src/main/java/de/intevation/data/LProbeRepository.java @ 14:de959fc71eda
Added class to handle getting values from the database for the LProben model.
author | Torsten Irländer <torsten.irlaender@intevation.de> |
---|---|
date | Thu, 18 Apr 2013 17:02:21 +0200 |
parents | |
children | 00ed8e5b05b6 |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/main/java/de/intevation/data/LProbeRepository.java Thu Apr 18 17:02:21 2013 +0200 @@ -0,0 +1,61 @@ +/* + * JBoss, Home of Professional Open Source + * Copyright 2012, Red Hat, Inc. and/or its affiliates, and individual + * contributors by the @authors tag. See the copyright.txt in the + * distribution for a full listing of individual contributors. + * + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ +package de.intevation.data; + +import javax.enterprise.context.ApplicationScoped; +import javax.inject.Inject; +import javax.persistence.EntityManager; +import javax.persistence.criteria.CriteriaBuilder; +import javax.persistence.criteria.CriteriaQuery; +import javax.persistence.criteria.Root; +import java.util.List; + +import de.intevation.model.LProbe; + +@ApplicationScoped +public class LProbeRepository { + + @Inject + private EntityManager em; + + public LProbe findById(Long id) { + return em.find(LProbe.class, id); + } + + //public LProbe findByEmail(String email) { + // CriteriaBuilder cb = em.getCriteriaBuilder(); + // CriteriaQuery<LProbe> criteria = cb.createQuery(LProbe.class); + // Root<LProbe> member = criteria.from(LProbe.class); + // // Swap criteria statements if you would like to try out type-safe criteria queries, a new + // // feature in JPA 2.0 + // // criteria.select(member).where(cb.equal(member.get(LProbe_.name), email)); + // criteria.select(member).where(cb.equal(member.get("email"), email)); + // return em.createQuery(criteria).getSingleResult(); + //} + + public List<LProbe> findAll() { + CriteriaBuilder cb = em.getCriteriaBuilder(); + CriteriaQuery<LProbe> criteria = cb.createQuery(LProbe.class); + Root<LProbe> member = criteria.from(LProbe.class); + // Swap criteria statements if you would like to try out type-safe criteria queries, a new + // feature in JPA 2.0 + // criteria.select(member).orderBy(cb.asc(member.get(LProbe_.name))); + //criteria.select(member).orderBy(cb.asc(member.get("name"))); + criteria.select(member); + return em.createQuery(criteria).getResultList(); + } +}