org.hibernate.criterion.Example Java Examples

@Override
@SuppressWarnings({"unchecked", "deprecation"})
public <T> List<T> findByExample(
		@Nullable final String entityName, final T exampleEntity, final int firstResult, final int maxResults)
		throws DataAccessException {

	Assert.notNull(exampleEntity, "Example entity must not be null");
	return nonNull(executeWithNativeSession((HibernateCallback<List<T>>) session -> {
		Criteria executableCriteria = (entityName != null ?
				session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass()));
		executableCriteria.add(Example.create(exampleEntity));
		prepareCriteria(executableCriteria);
		if (firstResult >= 0) {
			executableCriteria.setFirstResult(firstResult);
		}
		if (maxResults > 0) {
			executableCriteria.setMaxResults(maxResults);
		}
		return executableCriteria.list();
	}));
}
 

@SuppressWarnings("unchecked")
@Override
public List<T> findByExample(T exampleInstance, String... excludeProperty) {
	try {
		Criteria crit = getSession().createCriteria(getPersistentClass());
		Example example = Example.create(exampleInstance);
		for (String exclude : excludeProperty) {
			example.excludeProperty(exclude);
		}
		crit.add(example);
		return crit.list();
	} catch (Exception e) {
		// e.printStackTrace();
		getTransaction().rollback();
		return null;
	}
}
 

/**
 * @Title: countByExample
 * @Description: 根据模型统计
 * @param @param entityBean
 * @param @return
 * @return int
 */
public <T> int countByExample(final T obj) {
	return (Integer) getHibernateTemplate().executeWithNativeSession(new HibernateCallback<Integer>() {
		public Integer doInHibernate(Session s) throws HibernateException, SQLException {
			// 组装属性
			Criteria criteria = s.createCriteria(obj.getClass()).setProjection(Projections.projectionList().add(Projections.rowCount()))
					.add(Example.create(obj));
			if (getHibernateTemplate().isCacheQueries()) {
				criteria.setCacheable(true);
				if (getHibernateTemplate().getQueryCacheRegion() != null)
					criteria.setCacheRegion(getHibernateTemplate().getQueryCacheRegion());
			}
			if (getHibernateTemplate().getFetchSize() > 0)
				criteria.setFetchSize(getHibernateTemplate().getFetchSize());
			if (getHibernateTemplate().getMaxResults() > 0)
				criteria.setMaxResults(getHibernateTemplate().getMaxResults());
			SessionFactoryUtils.applyTransactionTimeout(criteria, getSessionFactory());
			return (Integer) criteria.uniqueResult();
		}
	});
}
 

public void testJunctionNotExpressionQBE() throws Exception {
    deleteData();
    initData();
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Componentizable master = getMaster("hibernate", null, "ope%");
    Criteria crit = s.createCriteria(Componentizable.class);
    Example ex = Example.create(master).enableLike();

    crit.add(Expression.or(Expression.not(ex), ex));

    List result = crit.list();
    assertNotNull(result);
    assertEquals(2, result.size());
    t.commit();
    s.close();

}
 

public void testSimpleQBE() throws Exception {
	deleteData();
    initData();

    Session s = openSession();

    Transaction t = s.beginTransaction();
    Componentizable master = getMaster("hibernate", "open sourc%", "open source1");
    Criteria crit = s.createCriteria(Componentizable.class);
    Example ex = Example.create(master).enableLike();
    crit.add(ex);
    List result = crit.list();
    assertNotNull(result);
    assertEquals(1, result.size());

    t.commit();
    s.close();
}
 

@Override
@SuppressWarnings({"unchecked", "deprecation"})
public <T> List<T> findByExample(
		@Nullable final String entityName, final T exampleEntity, final int firstResult, final int maxResults)
		throws DataAccessException {

	Assert.notNull(exampleEntity, "Example entity must not be null");
	return nonNull(executeWithNativeSession((HibernateCallback<List<T>>) session -> {
		Criteria executableCriteria = (entityName != null ?
				session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass()));
		executableCriteria.add(Example.create(exampleEntity));
		prepareCriteria(executableCriteria);
		if (firstResult >= 0) {
			executableCriteria.setFirstResult(firstResult);
		}
		if (maxResults > 0) {
			executableCriteria.setMaxResults(maxResults);
		}
		return executableCriteria.list();
	}));
}
 

@Override
public <T> List<T> findByExample(
		final String entityName, final T exampleEntity, final int firstResult, final int maxResults)
		throws DataAccessException {

	Assert.notNull(exampleEntity, "Example entity must not be null");
	return executeWithNativeSession(new HibernateCallback<List<T>>() {
		@Override
		@SuppressWarnings("unchecked")
		public List<T> doInHibernate(Session session) throws HibernateException {
			Criteria executableCriteria = (entityName != null ?
					session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass()));
			executableCriteria.add(Example.create(exampleEntity));
			prepareCriteria(executableCriteria);
			if (firstResult >= 0) {
				executableCriteria.setFirstResult(firstResult);
			}
			if (maxResults > 0) {
				executableCriteria.setMaxResults(maxResults);
			}
			return executableCriteria.list();
		}
	});
}
 

@Override
public <T> List<T> findByExample(
		final String entityName, final T exampleEntity, final int firstResult, final int maxResults)
		throws DataAccessException {

	Assert.notNull(exampleEntity, "Example entity must not be null");
	return executeWithNativeSession(new HibernateCallback<List<T>>() {
		@Override
		@SuppressWarnings("unchecked")
		public List<T> doInHibernate(Session session) throws HibernateException {
			Criteria executableCriteria = (entityName != null ?
					session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass()));
			executableCriteria.add(Example.create(exampleEntity));
			prepareCriteria(executableCriteria);
			if (firstResult >= 0) {
				executableCriteria.setFirstResult(firstResult);
			}
			if (maxResults > 0) {
				executableCriteria.setMaxResults(maxResults);
			}
			return executableCriteria.list();
		}
	});
}
 

@Override
public <T> List<T> findByExample(
		final String entityName, final T exampleEntity, final int firstResult, final int maxResults)
		throws DataAccessException {

	Assert.notNull(exampleEntity, "Example entity must not be null");
	return executeWithNativeSession(new HibernateCallback<List<T>>() {
		@Override
		@SuppressWarnings("unchecked")
		public List<T> doInHibernate(Session session) throws HibernateException {
			Criteria executableCriteria = (entityName != null ?
					session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass()));
			executableCriteria.add(Example.create(exampleEntity));
			prepareCriteria(executableCriteria);
			if (firstResult >= 0) {
				executableCriteria.setFirstResult(firstResult);
			}
			if (maxResults > 0) {
				executableCriteria.setMaxResults(maxResults);
			}
			return executableCriteria.list();
		}
	});
}
 

@Override
public <T> List<T> findByExample(
		final String entityName, final T exampleEntity, final int firstResult, final int maxResults)
		throws DataAccessException {

	Assert.notNull(exampleEntity, "Example entity must not be null");
	return executeWithNativeSession(new HibernateCallback<List<T>>() {
		@Override
		@SuppressWarnings("unchecked")
		public List<T> doInHibernate(Session session) throws HibernateException {
			Criteria executableCriteria = (entityName != null ?
					session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass()));
			executableCriteria.add(Example.create(exampleEntity));
			prepareCriteria(executableCriteria);
			if (firstResult >= 0) {
				executableCriteria.setFirstResult(firstResult);
			}
			if (maxResults > 0) {
				executableCriteria.setMaxResults(maxResults);
			}
			return executableCriteria.list();
		}
	});
}
 

@Override
@SuppressWarnings("deprecation")
public <T> List<T> findByExample(
		final String entityName, final T exampleEntity, final int firstResult, final int maxResults)
		throws DataAccessException {

	Assert.notNull(exampleEntity, "Example entity must not be null");
	return executeWithNativeSession(new HibernateCallback<List<T>>() {
		@Override
		@SuppressWarnings("unchecked")
		public List<T> doInHibernate(Session session) throws HibernateException {
			Criteria executableCriteria = (entityName != null ?
					session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass()));
			executableCriteria.add(Example.create(exampleEntity));
			prepareCriteria(executableCriteria);
			if (firstResult >= 0) {
				executableCriteria.setFirstResult(firstResult);
			}
			if (maxResults > 0) {
				executableCriteria.setMaxResults(maxResults);
			}
			return executableCriteria.list();
		}
	});
}
 

@Override
public <T> List<T> findByExample(
		final String entityName, final T exampleEntity, final int firstResult, final int maxResults)
		throws DataAccessException {

	Assert.notNull(exampleEntity, "Example entity must not be null");
	return executeWithNativeSession(new HibernateCallback<List<T>>() {
		@Override
		@SuppressWarnings("unchecked")
		public List<T> doInHibernate(Session session) throws HibernateException {
			Criteria executableCriteria = (entityName != null ?
					session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass()));
			executableCriteria.add(Example.create(exampleEntity));
			prepareCriteria(executableCriteria);
			if (firstResult >= 0) {
				executableCriteria.setFirstResult(firstResult);
			}
			if (maxResults > 0) {
				executableCriteria.setMaxResults(maxResults);
			}
			return executableCriteria.list();
		}
	});
}
 

/**
 * Get a hibernate Example object that excludes zeroes values and excludes
 * all boolean -primitive and wrapper class- attributes of a given object.  
 * @param instance given object for a build a Example object.
 * @return a hibernate Example object.
 */
public static Example excludeBooleanFields (Object instance) {
	Example result = Example.create(instance).excludeZeroes();
	Set<String> fieldNames = getFieldNamesByType(instance, Boolean.class);
	fieldNames.addAll(getFieldNamesByType(instance, Boolean.TYPE));
	for (String fieldName : fieldNames) {
		result.excludeProperty(fieldName);
	}
	return result;
}
 

/**
 * @see org.sakaiproject.api.common.edu.person.SakaiPersonManager#findSakaiPerson(org.sakaiproject.api.common.edu.person.SakaiPerson)
 */
public List findSakaiPerson(final SakaiPerson queryByExample)
{
	if (log.isDebugEnabled())
	{
		log.debug("findSakaiPerson(SakaiPerson {})", queryByExample);
	}
	if (queryByExample == null) throw new IllegalArgumentException("Illegal queryByExample argument passed!");

	final HibernateCallback hcb = new HibernateCallback()
	{
		public Object doInHibernate(Session session) throws HibernateException
		{
			Criteria criteria = session.createCriteria(queryByExample.getClass());
			criteria.add(Example.create(queryByExample));
			// criteria.setCacheable(cacheFindSakaiPersonSakaiPerson);
			return criteria.list();
		}
	};

	log.debug("return getHibernateTemplate().executeFind(hcb);");
	List hb = (List) getHibernateTemplate().execute(hcb);
	if (photoService.overRidesDefault()) {
		return getDiskPhotosForList(hb);
	} else {
		return hb;
	}
}
 

/**
 * @see org.sakaiproject.api.common.edu.person.SakaiPersonManager#findSakaiPerson(org.sakaiproject.api.common.edu.person.SakaiPerson)
 */
public List findSakaiPerson(final SakaiPerson queryByExample)
{
	if (log.isDebugEnabled())
	{
		log.debug("findSakaiPerson(SakaiPerson {})", queryByExample);
	}
	if (queryByExample == null) throw new IllegalArgumentException("Illegal queryByExample argument passed!");

	final HibernateCallback hcb = new HibernateCallback()
	{
		public Object doInHibernate(Session session) throws HibernateException
		{
			Criteria criteria = session.createCriteria(queryByExample.getClass());
			criteria.add(Example.create(queryByExample));
			// criteria.setCacheable(cacheFindSakaiPersonSakaiPerson);
			return criteria.list();
		}
	};

	log.debug("return getHibernateTemplate().executeFind(hcb);");
	List hb = (List) getHibernateTemplate().execute(hcb);
	if (photoService.overRidesDefault()) {
		return getDiskPhotosForList(hb);
	} else {
		return hb;
	}
}
 

public List findByExample(Course instance) {
	log.debug("finding Course instance by example");
	try {
		List results = getSession()
				.createCriteria(Course.class)
				.add(Example.create(instance)).list();
		log.debug("find by example successful, result size: "
				+ results.size());
		return results;
	} catch (RuntimeException re) {
		log.error("find by example failed", re);
		throw re;
	}
}
 

public List findByExample(Student instance) {
	log.debug("finding Student instance by example");
	try {
		List results = getSession()
				.createCriteria(Student.class)
				.add(Example.create(instance)).list();
		log.debug("find by example successful, result size: "
				+ results.size());
		return results;
	} catch (RuntimeException re) {
		log.error("find by example failed", re);
		throw re;
	}
}
 

public List findByExample(SignInfo instance) {
	log.debug("finding SignInfo instance by example");
	try {
		List results = getSession()
				.createCriteria(SignInfo.class)
				.add(Example.create(instance)).list();
		log.debug("find by example successful, result size: "
				+ results.size());
		return results;
	} catch (RuntimeException re) {
		log.error("find by example failed", re);
		throw re;
	}
}
 

/**
 * 根据实体模版查找
 *
 * @param entityName
 * @param exampleEntity
 * @return
 */

public List findByExample(final String entityName,
		final Object exampleEntity) {
	Assert.notNull(exampleEntity, "Example entity must not be null");
	Criteria executableCriteria = (entityName != null ? getSession()
			.createCriteria(entityName) : getSession().createCriteria(
			exampleEntity.getClass()));
	executableCriteria.add(Example.create(exampleEntity));
	return executableCriteria.list();
}
 

public List findByExample(StudentSheet instance) {
	log.debug("finding StudentSheet instance by example");
	try {
		List results = getSession()
				.createCriteria(StudentSheet.class)
				.add(Example.create(instance)).list();
		log.debug("find by example successful, result size: "
				+ results.size());
		return results;
	} catch (RuntimeException re) {
		log.error("find by example failed", re);
		throw re;
	}
}
 

public List findByExample(User instance) {
	log.debug("finding User instance by example");
	try {
		List results = getSession().createCriteria(User.class)
				.add(Example.create(instance)).list();
		log.debug("find by example successful, result size: "
				+ results.size());
		return results;
	} catch (RuntimeException re) {
		log.error("find by example failed", re);
		throw re;
	}
}
 

@Override
@SuppressWarnings("unchecked")
public List<ISoapBoxEntity> find(ISoapBoxEntity entity) {
	EntityManager manager = ConnectionDB.getManager();
	manager.clear();
	Session sessao = (Session) manager.getDelegate();
	Example example = Example.create(entity);
	example.excludeZeroes();
	Criteria criteria = sessao.createCriteria(entity.getClass());
	criteria.add(example);
	return criteria.list();
}
 

@GET
@Produces("application/json")
@Path("/get")
public List<HibernateEntity> get() {
    final Session session = sessionFactory.openSession();

    Criteria criteria = session.createCriteria(HibernateEntity.class)
                               .add(Example.create(HibernateEntity.builder()
                               .name("test")
                               .build()));

    return criteria.list();

}
 

/**
 * 根据实体模版查找
 * 
 * @param entityName
 * @param exampleEntity
 * @return
 */

public List findByExample(final String entityName,
		final Object exampleEntity) {
	Assert.notNull(exampleEntity, "Example entity must not be null");
	Criteria executableCriteria = (entityName != null ? getSession()
			.createCriteria(entityName) : getSession().createCriteria(
			exampleEntity.getClass()));
	executableCriteria.add(Example.create(exampleEntity));
	return executableCriteria.list();
}
 

/**
 * Demonstrates query by example
 */
public void viewAuctionsByDescription(String description, int condition) throws Exception {
	String msg = "Viewing auctions containing: " + description;
	if (condition>0) msg += " with condition: " + condition + "/10";

	AuctionItem item = new AuctionItem();
	item.setDescription(description);
	item.setCondition(condition);

	Session s = factory.openSession();
	Transaction tx=null;
	try {
		tx = s.beginTransaction();

		Iterator iter = s.createCriteria(AuctionItem.class)
			.add( Example.create(item)
				.enableLike(MatchMode.ANYWHERE)
				.ignoreCase()
				.excludeZeroes()
			)
			.list()
			.iterator();

		System.out.println(msg);
		while ( iter.hasNext() ) {
			item = (AuctionItem) iter.next();
			System.out.println("Item: " + item.getId() + " - " + item.getDescription() );
		}
		System.out.println();

		tx.commit();
	}
	catch (Exception e) {
		if (tx!=null) tx.rollback();
		throw e;
	}
	finally {
		s.close();
	}
}
 

public void testEscapeCharacter() {
	Session session = openSession();
	Transaction t = session.beginTransaction();
	Course c1 = new Course();
	c1.setCourseCode( "course-1" );
	c1.setDescription( "%1" );
	Course c2 = new Course();
	c2.setCourseCode( "course-2" );
	c2.setDescription( "%2" );
	Course c3 = new Course();
	c3.setCourseCode( "course-3" );
	c3.setDescription( "control" );
	session.persist( c1 );
	session.persist( c2 );
	session.persist( c3 );
	session.flush();
	session.clear();

	// finds all courses which have a description equal to '%1'
	Course example = new Course();
	example.setDescription( "&%1" );
	List result = session.createCriteria( Course.class )
			.add( Example.create( example ).ignoreCase().enableLike().setEscapeCharacter( new Character( '&' ) ) )
			.list();
	assertEquals( 1, result.size() );
	// finds all courses which contain '%' as the first char in the description 
	example.setDescription( "&%%" );
	result = session.createCriteria( Course.class )
			.add( Example.create( example ).ignoreCase().enableLike().setEscapeCharacter( new Character( '&' ) ) )
			.list();
	assertEquals( 2, result.size() );

	session.createQuery( "delete Course" ).executeUpdate();
	t.commit();
	session.close();
}
 

public void testExcludingQBE() throws Exception {
    deleteData();
    initData();
    Session s = openSession();
    Transaction t = s.beginTransaction();
    Componentizable master = getMaster("hibernate", null, "ope%");
    Criteria crit = s.createCriteria(Componentizable.class);
    Example ex = Example.create(master).enableLike()
        .excludeProperty("component.subComponent");
    crit.add(ex);
    List result = crit.list();
    assertNotNull(result);
    assertEquals(3, result.size());

    master = getMaster("hibernate", "ORM tool", "fake stuff");
    crit = s.createCriteria(Componentizable.class);
    ex = Example.create(master).enableLike()
        .excludeProperty("component.subComponent.subName1");
    crit.add(ex);
    result = crit.list();
    assertNotNull(result);
    assertEquals(1, result.size());
    t.commit();
    s.close();


}
 

public List<Users> search(Users users) {
	
	Object execute =  super.getHibernateTemplate().execute(new HibernateCallback<Object>() {

		public Object doInHibernate(Session session) throws HibernateException {
			Criteria criteria = session.createCriteria(Users.class);
			if(users != null)
				criteria.add(Example.create(users));
			return criteria.list();
		}
	});
	
	return (List<Users>) execute;
}
 

public void testExample() throws Exception {

		Session s = openSession();
		Transaction t = s.beginTransaction();
		Master m = new Master();
		m.setName("name");
		m.setX(5);
		m.setOtherMaster(m);
		s.save(m);
		t.commit();
		s.close();

		s = openSession();
		t = s.beginTransaction();
		Master m1 = (Master) s.createCriteria(Master.class)
			.add( Example.create(m).enableLike().ignoreCase().excludeProperty("bigDecimal") )
			.uniqueResult();
		assertTrue( m1.getOtherMaster()==m1 );
		m1 = (Master) s.createCriteria(Master.class)
			.add( Expression.eq("name", "foobar") )
			.uniqueResult();
		assertTrue( m1==null );
		m1 = (Master) s.createCriteria(Master.class)
			.add( Example.create(m).excludeProperty("bigDecimal") )
			.createCriteria("otherMaster")
				.add( Example.create(m).excludeZeroes().excludeProperty("bigDecimal") )
			.uniqueResult();
		assertTrue( m1.getOtherMaster()==m1 );
		Master m2 = (Master) s.createCriteria(Master.class)
			.add( Example.create(m).excludeNone().excludeProperty("bigDecimal") )
			.uniqueResult();
		assertTrue( m2==m1 );
		m.setName(null);
		m2 = (Master) s.createCriteria(Master.class)
			.add( Example.create(m).excludeNone().excludeProperty("bigDecimal") )
			.uniqueResult();
		assertTrue( null==m2 );
		if (getDialect() instanceof HSQLDialect) { m1.setOtherMaster(null); s.flush(); }
		s.delete(m1);
		t.commit();
		s.close();
	}
 

private List<Entity> searchByName(String name) {
	final Session session = sf.openSession();
	
	Criteria criteria = session.createCriteria(Entity.class)
							.add(Example.create(new Entity(name)));
	
	return criteria.list();
	
}