List of usage examples for org.hibernate.criterion DetachedCriteria forClass
public static DetachedCriteria forClass(Class clazz)
From source file:com.cimmyt.model.dao.impl.SampleDetailDAOImpl.java
License:Apache License
public Integer getSamplesByStudyUsedInStorageLocationTotal(Integer labStudyId, List<Integer> excludedSamples) { Integer numberSamples = null; DetachedCriteria criteria = DetachedCriteria.forClass(SampleDetail.class); criteria.add(Restrictions.eq("labstudyid.labstudyid", labStudyId)); criteria.add(Restrictions.eq("selforsend", ShipmentStatus.NO_SELECTED.getId())); if (excludedSamples.size() > 0) { criteria.add(Restrictions.not(Restrictions.in("studysampleid", excludedSamples))); }/*w ww . ja va2 s . c o m*/ criteria.setProjection(Projections.rowCount()); numberSamples = (Integer) getHibernateTemplate().findByCriteria(criteria).get(0); return numberSamples; }
From source file:com.cimmyt.model.dao.impl.SampleIDDAOImpl.java
License:Apache License
@SuppressWarnings("unchecked") public List<SampleID> searchListSampleMixture(final Integer idproject, final Integer gid, final Integer nplanta, final Integer locationid, final Integer seasonid) { List<SampleID> samplesid = null; DetachedCriteria criteria = DetachedCriteria.forClass(SampleID.class); criteria.add(Restrictions.eq("projectid", idproject)); criteria.add(Restrictions.eq("gid", gid)); criteria.add(Restrictions.eq("locationid", locationid)); criteria.add(Restrictions.eq("seasonid", seasonid)); criteria.add(Restrictions.eq("nplant", nplanta)); samplesid = (List<SampleID>) getHibernateTemplate().findByCriteria(criteria); return samplesid; }
From source file:com.cisco.ca.cstg.pdi.dao.CommonDaoServicesImplTest.java
@Test @Transactional//from w w w. j a va 2 s. co m public void listAllWithDetachedCriteria() { License license = getLicense(); daoService.addNew(license); DetachedCriteria criteria = DetachedCriteria.forClass(License.class).addOrder(Order.asc("id")); List<Object> list = daoService.listAll(criteria); assertNotNull(list); }
From source file:com.codefupanda.persistor.util.HibernateUtil.java
License:Open Source License
/** * Convert the API specific criteria to Hibernate DerachedCriteria * //from www.j a v a 2 s. co m * @param searchCriteria * @return */ public static DetachedCriteria convert(SearchCriteria searchCriteria) { DetachedCriteria hCriteria = DetachedCriteria.forClass(searchCriteria.getSearchClass()); for (Criteria criteria : searchCriteria.getCriterias()) { hCriteria.add(convert(criteria)); } return hCriteria; }
From source file:com.db.dao.AbstractFacade.java
public List<T> findByName(String name) { DetachedCriteria detachedCriteria = DetachedCriteria.forClass(entityClass) .add(Restrictions.eq("retired", false)).add(Restrictions.like("name", "%" + name + "%")); return (List<T>) getHibernateTemplate().findByCriteria(detachedCriteria); }
From source file:com.db.dao.AbstractFacade.java
public List<T> findAll() { DetachedCriteria detachedCriteria = DetachedCriteria.forClass(entityClass) .add(Restrictions.eq("retired", false)); List<T> list = (List<T>) getHibernateTemplate().findByCriteria(detachedCriteria); return list;//from ww w . j av a 2 s . c o m }
From source file:com.db.dao.AbstractFacade.java
public List<T> findAll(int max) { DetachedCriteria detachedCriteria = DetachedCriteria.forClass(entityClass) .add(Restrictions.eq("retired", false)).addOrder(Order.asc("id")).add(Limit.by(max)); List<T> list = (List<T>) getHibernateTemplate().findByCriteria(detachedCriteria); return list;// w ww. ja v a 2 s . co m }
From source file:com.db.dao.AbstractFacade.java
public List<T> findAll(int offset, int pagesize) { DetachedCriteria detachedCriteria = DetachedCriteria.forClass(entityClass) .add(Restrictions.eq("retired", false)).addOrder(Order.asc("id")); List<T> list = (List<T>) getHibernateTemplate().findByCriteria(detachedCriteria, offset, pagesize); return list;/*from w w w. j a v a 2s .c o m*/ }
From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateScanDao.java
License:Mozilla Public License
private Criteria getBasicMapCriteria() { DetachedCriteria detachedCriteria = DetachedCriteria.forClass(StatisticsCounter.class) .createAlias("scanRepeatFindingMap", "mapAlias").add(Restrictions.isNotNull("scanRepeatFindingMap")) .setProjection(property("mapAlias.id")); return sessionFactory.getCurrentSession().createCriteria(ScanRepeatFindingMap.class) .add(Property.forName("id").notIn(detachedCriteria)); }
From source file:com.denksoft.springstarter.util.security.CustomUserDetailsServiceWrapper.java
License:Open Source License
public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException, DataAccessException { Assert.notEmpty(userInfoObjectTypes); UserDetails userDetails = userDetailsService.loadUserByUsername(username); for (Class clazz : userInfoObjectTypes) { DetachedCriteria query = DetachedCriteria.forClass(clazz) .add(Restrictions.eq("user.username", username)); try {// w w w . j a v a 2 s. c o m Object info = getHibernateTemplate().findByCriteria(query).get(0); return new CustomUserDetailsWrapper(userDetails, roleHierarchy, info); } catch (IndexOutOfBoundsException ex) { //log Not necessary, for informational purpose only log.info("Did not find any " + clazz.getSimpleName() + " objects"); } } return new CustomUserDetailsWrapper(userDetails, roleHierarchy); }