List of usage examples for org.hibernate.criterion DetachedCriteria forClass
public static DetachedCriteria forClass(Class clazz)
From source file:co.utb.softeng.contactsapp.dao.impl.CitaDAOImpl.java
@Override public List<Cita> getByContactName(String contactName) { DetachedCriteria subQuery = DetachedCriteria.forClass(Contact.class).createCriteria("citas") .add(Restrictions.ilike("name", contactName, MatchMode.ANYWHERE)).setProjection(Projections.id()); Criteria mainCriteria = getSession().createCriteria(Cita.class).add(Subqueries.propertyIn("id", subQuery)) .setFetchMode("contacts", FetchMode.JOIN); return mainCriteria.list(); }
From source file:co.utb.softeng.contactsapp.dao.impl.ContactDAOImpl.java
@Override public List<Contact> getByCitaName(String citaName) { Criterion crit1 = Restrictions.ilike("asunto", citaName, MatchMode.ANYWHERE); Criterion crit2 = Restrictions.ilike("lugar", citaName, MatchMode.ANYWHERE); DetachedCriteria subQuery = DetachedCriteria.forClass(Contact.class).createCriteria("citas") .add(Restrictions.or(crit1, crit2)).setProjection(Projections.id()); Criteria mainCriteria = getSession().createCriteria(Contact.class) .add(Subqueries.propertyIn("id", subQuery)).setFetchMode("citas", FetchMode.JOIN); return mainCriteria.list(); }
From source file:com.apress.progwt.server.dao.hibernate.SchoolDAOHibernateImpl.java
License:Apache License
public List<School> getAllSchools(int start, int max) { DetachedCriteria crit = DetachedCriteria.forClass(School.class).addOrder(Order.desc("popularityCounter")); // .add(/*from w ww . j av a 2 s . com*/ // Expression.and(Expression.gt("id", 890l), // Expression.eq("latitude", -1d))); List<School> list = getHibernateTemplate().findByCriteria(crit, start, max); return list; }
From source file:com.apress.progwt.server.dao.hibernate.SchoolDAOHibernateImpl.java
License:Apache License
public List<ProcessType> getDefaultProcessTypes() { DetachedCriteria crit = DetachedCriteria.forClass(ProcessType.class) .add(Expression.eq("useByDefault", true)).addOrder(Order.asc("id")); return getHibernateTemplate().findByCriteria(crit); }
From source file:com.apress.progwt.server.dao.hibernate.SchoolDAOHibernateImpl.java
License:Apache License
public List<RatingType> getDefaultRatingTypes() { DetachedCriteria crit = DetachedCriteria.forClass(RatingType.class).add(Expression.eq("useByDefault", true)) .addOrder(Order.asc("id")); return getHibernateTemplate().findByCriteria(crit); }
From source file:com.apress.progwt.server.dao.hibernate.SchoolDAOHibernateImpl.java
License:Apache License
public ProcessType getProcessForName(String string) { DetachedCriteria crit = DetachedCriteria.forClass(ProcessType.class).add(Expression.eq("name", string)); return (ProcessType) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(crit)); }
From source file:com.apress.progwt.server.dao.hibernate.SchoolDAOHibernateImpl.java
License:Apache License
public List<School> getSchoolsMatching(String match, int start, int max, MatchMode matchMode) { DetachedCriteria crit = DetachedCriteria.forClass(School.class) .add(Expression.ilike("name", match, matchMode)).addOrder(Order.asc("name")); List<School> list = getHibernateTemplate().findByCriteria(crit, start, max); return list;//from w w w.j av a2 s . c o m }
From source file:com.apress.progwt.server.dao.hibernate.SchoolDAOHibernateImpl.java
License:Apache License
public List<ProcessType> matchProcessType(String queryString) { DetachedCriteria crit = DetachedCriteria.forClass(ProcessType.class) .add(Expression.ilike("name", queryString, MatchMode.ANYWHERE)).addOrder(Order.asc("name")); List<ProcessType> list = getHibernateTemplate().findByCriteria(crit, 0, autoCompleteMax); return list;//from w w w.j a va 2 s . co m }
From source file:com.apress.progwt.server.dao.hibernate.SchoolDAOHibernateImpl.java
License:Apache License
public PostsList getPostsForThread(ForumPost post, int start, int max) { DetachedCriteria crit = DetachedCriteria.forClass(ForumPost.class) .add(Expression.or(Expression.eq("threadPost.id", post.getId()), Expression.eq("id", post.getId()))) .addOrder(Order.asc("date")); List<ForumPost> posts = getHibernateTemplate().findByCriteria(crit, start, max); PostsList rtn = new PostsList(posts, getRowCount(crit)); return rtn;//from ww w .ja v a 2 s .c o m }
From source file:com.apress.progwt.server.dao.hibernate.UserDAOHibernateImpl.java
License:Apache License
public List<User> getAllUsers(int max) { DetachedCriteria crit = DetachedCriteria.forClass(User.class); List<User> posts = getHibernateTemplate().findByCriteria(crit, 0, max); return posts; }