public Integer getCountUserValidate(String staffPiority) {
Criteria criteria = getSession().createCriteria(User.class);
criteria.add(Restrictions.eq("validateStu", 0));
criteria.add(Restrictions.like("piority", "%" + staffPiority + "%"));
ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.count("validateStu"));
criteria.setProjection(projectionList);
Integer count = (Integer) criteria.uniqueResult();
closeSession();
return count;
}
public Plantel getPlantelById() {
Session session = HibernateUtil.getSessionFactory().openSession();
Plantel plantel = null;
ProjectionList plist = Projections.projectionList();
plist.add(Projections.property("p.nombre").as("nombre"));
Criteria criteria =
session
.createCriteria(Plantel.class, "p")
.setProjection(plist)
.setResultTransformer(new AliasToBeanResultTransformer(Plantel.class))
.addOrder(Order.asc("nombre"));
plantel = (Plantel) criteria.uniqueResult();
session.close();
return plantel;
}