Java如何使用hibernate最小，最大，平均和总和投影？
下面演示的代码使用Projections.min()，Projections.max()，Projections.avg()和Projections.sum()。
package org.nhooo.example.hibernate.criteria;
import org.hibernate.SessionFactory;
import org.hibernate.Session;
import org.hibernate.HibernateException;
import org.hibernate.Criteria;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Projections;
import org.nhooo.example.hibernate.model.Track;
public class MinMaxAvgSumProjectionsDemo {
public static Session getSession() throws HibernateException {
String cfg = "hibernate.cfg.xml";
SessionFactory sessionFactory = new Configuration().configure(cfg)
.buildSessionFactory();
return sessionFactory.openSession();
}
public static void main(String[] args) {
try (Session session = getSession()) {
Criteria criteria = session.createCriteria(Track.class)
.setProjection(Projections.max("duration"));
Integer maxDuration = (Integer) criteria.uniqueResult();
System.out.println("Max Track Duration = " + maxDuration);
criteria.setProjection(Projections.min("duration"));
Integer minDuration = (Integer) criteria.uniqueResult();
System.out.println("Min Track Duration = " + minDuration);
criteria.setProjection(Projections.avg("duration"));
Double avgDuration = (Double) criteria.uniqueResult();
System.out.println("Avg Track Duration = " + avgDuration);
criteria.setProjection(Projections.sum("duration"));
Long totalDuration = (Long) criteria.uniqueResult();
System.out.println("Total Track Duration = " + totalDuration);
}
}
}
热门推荐
10 诗词送行祝福语大全简短
11 新房开工吉日祝福语简短
12 50多岁生日简短祝福语
13 安徽疫情祝福语简短英语
14 农民朋友发财祝福语简短
15 对生活祝福语简短精辟
16 搬家词简短祝福语朋友
17 女神结婚快乐祝福语简短
18 文学短句祝福语大全简短