Java tutorial
/* * Copyright (C) 2015 Arthur Gregorio, AG.Software * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program 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 General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ package br.com.webbudget.domain.model.repository.miscellany; import br.com.webbudget.domain.model.entity.miscellany.Closing; import br.com.webbudget.domain.model.repository.GenericRepository; import java.math.BigDecimal; import org.hibernate.Criteria; import org.hibernate.criterion.DetachedCriteria; import org.hibernate.criterion.Projections; import org.hibernate.criterion.Property; /** * * @author Arthur Gregorio * * @version 1.2.0 * @since 1.0.0, 22/04/2014 */ public class ClosingRepository extends GenericRepository<Closing, Long> implements IClosingRepository { /** * * @return */ @Override public BigDecimal findLastAccumulated() { final Criteria criteria = this.createCriteria(); final DetachedCriteria mostRecent = DetachedCriteria.forClass(Closing.class) .setProjection(Projections.max("closingDate")); criteria.add(Property.forName("closingDate").eq(mostRecent)); criteria.setProjection(Projections.sum("accumulated")); return (BigDecimal) criteria.uniqueResult(); } }