/** 첫번째 낙서를 찾아서 삭제한다. 첫번째 낙서는 가장 낮은 id 를 가진 Graffiti 를 기준으로 한다. */
 public void deleteFirstGraffiti() throws DataAccessException {
   deleteById(
       (Integer)
           getCurrentSession()
               .createCriteria(Graffiti.class)
               .setProjection(Projections.min("id"))
               .uniqueResult());
 }
 @Override
 public Object findMin(String min, Map<String, Object> Map) {
   Criteria criteria = createCriteria();
   for (Iterator<String> i = Map.keySet().iterator(); i.hasNext(); ) {
     String name = i.next();
     if (filterProperty(name)) {
       criteria.add(Restrictions.eq(name, Map.get(name)));
     } else {
       log.error("Could not resolve property:" + name);
     }
   }
   return criteria.setProjection(Projections.min(min)).uniqueResult();
 }
  @Override
  public Projection buildProjection(
      String projectionField, ProjectionType projectionType, Iterator argsIterator) {
    Projection projection = new Projection();

    projection.setField(projectionField);

    switch (projectionType) {
      case RowCount:
        projection.setDetails(Projections.rowCount());
        break;

      case Count:
        projection.setDetails(Projections.count(projectionField));
        break;

      case CountDistinct:
        projection.setDetails(Projections.countDistinct(projectionField));
        break;

      case Maximum:
        projection.setDetails(Projections.max(projectionField));
        break;

      case Minimum:
        projection.setDetails(Projections.min(projectionField));
        break;

      case Average:
        projection.setDetails(Projections.avg(projectionField));
        break;

      case Sum:
        projection.setDetails(Projections.sum(projectionField));
        break;

      default:
        throw new RuntimeException("Unexpected projection type: " + projectionType);
    }

    return projection;
  }
Example #4
0
  public static void main(String... args) {
    final String[] columns = {"max", "min", "sum", "avg"};
    try {
      Session session = HibernateUtil.getSession();

      Transaction tx = session.beginTransaction();
      Criteria criteria = session.createCriteria(Product.class);
      ProjectionList projList = Projections.projectionList();
      projList.add(Projections.max("price"));
      projList.add(Projections.min("price"));
      projList.add(Projections.sum("price"));
      projList.add(Projections.avg("price"));
      criteria.setProjection(projList);
      Object[] results = (Object[]) criteria.uniqueResult();
      tx.commit();

      for (int i = 0, n = results.length; i < n; i++) {
        Object res = results[i];
        System.out.printf("%s = %s%n", columns[i], res);
      }
    } finally {
      HibernateUtil.cleanUp();
    }
  }