Example usage for org.hibernate.criterion Projections max

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections max.

Prototype

public static AggregateProjection max(String propertyName)

Source Link

Document

A property maximum value projection

Usage

From source file:com.uniminuto.ejercicio2.dao.EmployeeDaoImpl.java

public int maximoSalario(String palabra) {
    long count;/*  w w  w.  j av  a  2 s. com*/
    SessionFactory sf = HibernateUtil.getSessionFactory();
    Session session = sf.openSession();
    Criteria cr = session.createCriteria(Employee.class);
    cr.add(Restrictions.like("nombre", "%" + palabra + "%"));
    cr.setProjection(Projections.max("salario"));
    return cr.list().get(0).hashCode();
}

From source file:com.ust.coppel.incentivos.repository.impl.ConnectionRepositoryImpl.java

@Transactional
@Override//from www .  java  2s  . com
public void add(CatConexiones connection) {

    Session session = sessionFactory.getCurrentSession();

    Criteria criteria = session.createCriteria(CatConexiones.class)
            .setProjection(Projections.max("iduConexion"));
    Integer max = ((Integer) criteria.uniqueResult());
    if (max != null)
        max += 1;
    else
        max = 1;
    connection.setIduConexion(max);
    session.save(connection);

}

From source file:com.ust.coppel.incentivos.repository.impl.MenuRepositoryImpl.java

@Transactional
@Override//from   w w  w . j  a  v a  2 s .com
public void add(CatMenu menu) {

    Session session = sessionFactory.getCurrentSession();

    Criteria criteria = session.createCriteria(CatMenu.class).setProjection(Projections.max("iduMenu"));
    Integer max = ((Integer) criteria.uniqueResult());
    if (max != null)
        max += 1;
    else
        max = 1;
    menu.setIduMenu(max);
    session.save(menu);

}

From source file:dao.DaoImplementProductos.java

public int getUltimoProducto() {
    Session session = HibernateUtil.getSessionFactory().openSession();
    session.beginTransaction();//www  .  ja  v  a  2  s .  c  o m
    Criteria criteria = session.createCriteria(Productos.class);
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.max("idproducto"));
    criteria.setProjection(projList);
    List results = criteria.list();
    Iterator iterator = results.iterator();
    int ultReg = 0;
    while (iterator.hasNext()) {
        ultReg = Integer.parseInt(iterator.next().toString());
    }
    session.close();
    return ultReg;
}

From source file:dao.ManualBlockDAO.java

public ManualBlock getLastBlock(String rowId) throws DAOException {
    ManualBlock manualBlock = null;/*w  w  w . j  av  a 2s .  c  om*/
    try {
        DetachedCriteria rows = DetachedCriteria.forClass(ManualBlock.class)
                .setProjection(Projections.max("blockOrder")).add(Restrictions.eq("manualRow", rowId));

        Criteria blocks = session.createCriteria(ManualBlock.class).add(Property.forName("blockOrder").eq(rows))
                .add(Restrictions.eq("manualRow", rowId));

        List<ManualBlock> blockList = blocks.list();
        if (blockList.size() > 0) {
            manualBlock = blockList.get(0);
        }
    } catch (Exception e) {
        DAOValidator.errorOnSelect("Manual's block", e);
    }
    return manualBlock;
}

From source file:dao.ManualPageDAO.java

public ManualPage getLastPage(int manual) throws DAOException {
    ManualPage manualPage = null;//ww w .  j a  v  a2 s . c  o  m
    try {
        DetachedCriteria maxPage = DetachedCriteria.forClass(ManualPage.class)
                .setProjection(Projections.max("pageOrder")).add(Restrictions.eq("manualId", manual));

        Criteria pages = session.createCriteria(ManualPage.class).add(Property.forName("pageOrder").eq(maxPage))
                .add(Restrictions.eq("manualId", manual));

        List<ManualPage> pageList = pages.list();
        if (pageList.size() == 1) {
            manualPage = pageList.get(0);
        }
    } catch (Exception e) {
        DAOValidator.errorOnSelect("Manual's page", e);
    }
    return manualPage;
}

From source file:dao.ManualRowDAO.java

public ManualRow getLastRow(String manualPage) throws DAOException {
    ManualRow manualRow = null;/*  w  ww .j  av a 2  s. com*/
    try {
        DetachedCriteria maxRow = DetachedCriteria.forClass(ManualRow.class)
                .setProjection(Projections.max("rowOrder")).add(Restrictions.eq("manualPage", manualPage));
        Criteria rows = session.createCriteria(ManualRow.class).add(Property.forName("rowOrder").eq(maxRow))
                .add(Restrictions.eq("manualPage", manualPage));

        List<ManualRow> rowList = rows.list();
        if (rowList.size() == 1) {
            manualRow = rowList.get(0);
        }
    } catch (Exception e) {
        DAOValidator.errorOnSelect("Manual's row", e);
    }
    return manualRow;
}

From source file:dao.Transaction.java

License:Open Source License

public int getInvoice() {
    session = getSession();//from   w  w  w.  jav a2s .  c o  m
    Criteria criteria = session.createCriteria(TillTape.class).setProjection(Projections.max("invoice"));
    Integer maxInvoice = (Integer) criteria.uniqueResult();
    int invoice = maxInvoice + 1;
    return invoice;
}

From source file:data.dao.parent.Dao.java

public List<T> findMax(String name) {
    DetachedCriteria maxId = DetachedCriteria.forClass(getSupportedClass())
            .setProjection(Projections.max(name));
    Criteria cr = currentSession().createCriteria(getSupportedClass());
    cr.add(Property.forName(name).eq(maxId));
    return cr.list();
}

From source file:de.forsthaus.backend.dao.impl.CustomerDAOImpl.java

License:Open Source License

@Override
public int getMaxCustomerId() {
    DetachedCriteria criteria = DetachedCriteria.forClass(Customer.class);
    criteria.setProjection(Projections.projectionList().add(Projections.max("id")));

    long max = DataAccessUtils.longResult(getHibernateTemplate().findByCriteria(criteria));
    return (int) max;
}