Java tutorial
/** * Abiquo community edition * cloud management application for hybrid clouds * Copyright (C) 2008-2010 - Abiquo Holdings S.L. * * This application is free software; you can redistribute it and/or * modify it under the terms of the GNU LESSER GENERAL PUBLIC * LICENSE as published by the Free Software Foundation under * version 3 of the License * * This software is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * LESSER GENERAL PUBLIC LICENSE v.3 for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the * Free Software Foundation, Inc., 59 Temple Place - Suite 330, * Boston, MA 02111-1307, USA. */ package com.abiquo.server.core.appslibrary; import java.util.Collections; import java.util.List; import javax.persistence.EntityManager; import org.apache.commons.collections.CollectionUtils; import org.apache.commons.collections.ListUtils; import org.hibernate.Criteria; import org.hibernate.Query; import org.hibernate.criterion.Criterion; import org.hibernate.criterion.Order; import org.hibernate.criterion.Restrictions; import org.springframework.stereotype.Repository; import com.abiquo.server.core.common.persistence.DefaultDAOBase; @Repository("jpaTemplateDefinitionDAO") public class TemplateDefinitionDAO extends DefaultDAOBase<Integer, TemplateDefinition> { private final static String FIND_BY_ENTERPRISE = "SELECT temDef FROM TemplateDefinition temDef " // + "WHERE temDef.appsLibrary.enterprise.id = :enterpriseId "; public TemplateDefinitionDAO() { super(TemplateDefinition.class); } public TemplateDefinitionDAO(final EntityManager entityManager) { super(TemplateDefinition.class, entityManager); } public TemplateDefinition findByUrl(final String url) { List<TemplateDefinition> defs = getResultList(createCriteria(sameUrl(url))); return CollectionUtils.isEmpty(defs) ? null : defs.get(0); } @SuppressWarnings("unchecked") public List<TemplateDefinition> findByEnterprise(final Integer enterpriseId) { Query query = getSession().createQuery(FIND_BY_ENTERPRISE); query.setParameter("enterpriseId", enterpriseId); return query.list(); } public List<TemplateDefinition> findByAppsLibrary(final AppsLibrary appsLibrary) { Criteria criteria = createCriteria(sameAppsLibrary(appsLibrary)); criteria.addOrder(Order.asc(TemplateDefinition.NAME_PROPERTY)); return getResultList(criteria); } private static Criterion sameUrl(final String url) { return Restrictions.eq(TemplateDefinition.URL_PROPERTY, url); } private static Criterion sameAppsLibrary(final AppsLibrary appsLibrary) { return Restrictions.eq(TemplateDefinition.APPS_LIBRARY_PROPERTY, appsLibrary); } }