Java Restrictions.eq方法代码示例

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
public Page<SurveyDirectory> findByGroup(String groupId1,String groupId2,Page<SurveyDirectory> page) {
	
	
	List<Criterion> criterions = new ArrayList<Criterion>();
	if(groupId1!=null && !"".equals(groupId1)){
		Criterion cri1=Restrictions.eq("groupId1", groupId1);
		criterions.add(cri1);
	}
	if(groupId2!=null && !"".equals(groupId2)){
		Criterion cri1_2=Restrictions.eq("groupId2", groupId2);
		criterions.add(cri1_2);
	}
    
    Criterion cri2=Restrictions.eq("visibility", 1);
    Criterion cri4=Restrictions.eq("surveyModel", 4);

    criterions.add(cri2);
    criterions.add(cri4);
    page.setOrderBy("createDate");
	page.setOrderDir("desc");
	
    return surveyDirectoryDao.findPage(page,criterions.toArray(new Criterion[criterions.size()]) );
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
@Override
public List<SurveyDirectory> findByIndex() {
    Criterion cri1=Restrictions.eq("visibility", 1);
    Criterion cri2=Restrictions.eq("parentId", "402880e5428a2dca01428a2f1f290000");
    Criterion cri3=Restrictions.eq("surveyTag", 1);
    Criterion cri4=Restrictions.isNull("sid");
    Page<SurveyDirectory> page=new Page<SurveyDirectory>();
    page.setOrderBy("createDate");
	page.setOrderDir("desc");
	page.setPageSize(10);
    List<SurveyDirectory> surveys = surveyDirectoryDao.findPage(page, cri1,cri2,cri3,cri4).getResult();
    return surveys;
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
public Pg getPg(String nums, String tbk, String proms){
	logger.debug("IN - nums: {}, tbk: {}, proms: {}", nums, tbk , proms);
	Criterion whereNums = Restrictions.eq("nums", nums);
	Criterion whereTbk = Restrictions.eq("tbk", tbk).ignoreCase();
	Criterion whereProms = Restrictions.eq("proms", proms);
	
	Pg pg = (Pg) getSession()
			.createCriteria(Pg.class)
			.add(whereNums)
			.add(whereTbk)
			.add(whereProms)
			.uniqueResult();
	return pg;
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
public int getOrderById(String quId){
	Criterion criterion=Restrictions.eq("quId", quId);
	QuChenOption quChenOption=quChenOptionDao.findFirst("orderById", false, criterion);
	if(quChenOption!=null){
		return quChenOption.getOrderById();
	}
	return 0;
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
@Override
@Transactional(propagation = Propagation.REQUIRED)
public void revokeAcceptance(Item item, String userID)
{
	Criterion c1 = Restrictions.eq("item", item);
	Criterion c2 = Restrictions.eq("user", userID);
	delete(c1, c2);
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
@Override
public SurveyDirectory getSurveyBySid(String sid) {
	Criterion criterion=Restrictions.eq("sid", sid);
	SurveyDirectory surveyDirectory = surveyDirectoryDao.findUnique(criterion);
	getSurveyDetail(surveyDirectory.getId(),surveyDirectory);
	return surveyDirectory;
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
@Override
public List<TLEGroup> search(String query)
{
	Criterion c1 = Restrictions.ilike("name", query.replace('*', '%'));
	Criterion c2 = Restrictions.eq("institution", CurrentInstitution.get());

	return dao.findAllByCriteria(Order.asc("name"), -1, c1, c2);
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
public int getOrderById(String quId){
	Criterion criterion=Restrictions.eq("quId", quId);
	QuScore quRadio=quScoreDao.findFirst("orderById", false, criterion);
	if(quRadio!=null){
		return quRadio.getOrderById();
	}
	return 0;
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
public long countRole(RoleEnum role){
	logger.debug("IN - rôle: {}", role.name());
	
	Criterion whereRole = Restrictions.eq("role", role.name());
	
	return (long)getSession()
			.createCriteria(Role.class)
			.add(whereRole)
			.setProjection(Projections.rowCount()).uniqueResult();
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
@Override
@Transactional
public void userDeletedEvent(UserDeletedEvent event)
{
	Criterion c1 = Restrictions.eq("key.userID", event.getUserID());
	Criterion c2 = Restrictions.eq("key.institution", CurrentInstitution.get().getDatabaseId());

	for( UserPreference pref : userPreferencesDao.findAllByCriteria(c1, c2) )
	{
		userPreferencesDao.delete(pref);
	}
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
@Override
public Map<String, String> getPreferenceForAllUsers(String key)
{
	Map<String, String> prefMap = Maps.newHashMap();
	Criterion c1 = Restrictions.eq("key.preferenceID", key);
	Criterion c2 = Restrictions.eq("key.institution", CurrentInstitution.get().getDatabaseId());
	for( UserPreference pref : userPreferencesDao.findAllByCriteria(c1, c2) )
	{
		prefMap.put(pref.getKey().getUserID(), pref.getData());
	}
	return prefMap;
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
@Override
public void restricions() {
	Session ses=null;
	//get the session
	ses=HibernateUtil.getSession();
	
		System.out.println("\n\tPRICE Less than 500");
		//create criteria
	Criteria c=ses.createCriteria(product.class);
	//create criterion objects for the restriction methods
	Criterion lt=Restrictions.lt("price", 500f);
	//add restriction to criteria
	c.add(lt);
	//execute the Criteria
	List<product> list=c.list();
	//display the list
		list.forEach(row->{
			System.out.println(row);
		});
		
	System.out.println("\n\tPRICE Greater than 500");
	
	Criteria c1=ses.createCriteria(product.class);
	
	Criterion gt=Restrictions.gt("price", 500f);
	c1.add(gt);
	List<product> list1=c1.list();
		list1.forEach(row->{
			System.out.println(row);
		});
		
System.out.println("\n\tPRICE Less than or Equal 500");
		Criteria c2=ses.createCriteria(product.class);
		
		Criterion le=Restrictions.le("price", 500f);
		c2.add(le);
		List<product> list2=c2.list();
			list2.forEach(row->{
				System.out.println(row);
			});
			
			System.out.println("\n\tPRICE Greater than or Equal 500");
					Criteria c3=ses.createCriteria(product.class);
					
					Criterion ge=Restrictions.ge("price", 500f);
					c3.add(ge);
					List<product> list3=c3.list();
						list3.forEach(row->{
							System.out.println(row);
						});
						
						
								Criteria c4=ses.createCriteria(product.class);
								
								Criterion eq=Restrictions.eq("price", 500f);
								c4.add(eq);
								List<product> list4=c4.list();
								System.out.println("\n\tPRICE  Equal 500");
									list4.forEach(row->{
										System.out.println(row);
									});
									//close the session
									HibernateUtil.closeSession(ses);
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
@Override
public T findUniqueBy(final String propertyName, final Object value) {
	AssertUtils.hasText(propertyName, "propertyName不能为空");
	Criterion criterion = Restrictions.eq(propertyName, value);
	return (T) createCriteria(criterion).uniqueResult();
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
@Override
public List<AnCompChenRadio> findAnswer(String belongAnswerId, String quId) {//belongAnswerId quId
	Criterion criterion1=Restrictions.eq("belongAnswerId", belongAnswerId);
	Criterion criterion2=Restrictions.eq("quId", quId);
	return anCompChenRadioDao.find(criterion1,criterion2);
}
 

import org.hibernate.criterion.Restrictions; //导入方法依赖的package包/类
@Override
public String exportXLS(String surveyId, String savePath) {
	String basepath = surveyId + "";
	String urlPath = "/file/" + basepath + "/";// 下载所用的地址
	String path = urlPath.replace("/", File.separator);// 文件系统路径
	// File.separator +
	// "file" +
	// File.separator+basepath
	// + File.separator;
	savePath = savePath + path;
	File file = new File(savePath);
	if (!file.exists())
		file.mkdirs();

	SurveyDirectory surveyDirectory = directoryManager.getSurvey(surveyId);
	String fileName = surveyId + "_exportSurvey.xls";

	XLSExportUtil exportUtil = new XLSExportUtil(fileName, savePath);
	Criterion cri1 = Restrictions.eq("surveyId",surveyId);
	Page<SurveyAnswer> page = new Page<SurveyAnswer>();
	page.setPageSize(5000);
	try {
		page = findPage(page,cri1);
		int totalPage = page.getTotalPage();
		List<SurveyAnswer> answers = page.getResult();
		List<Question> questions = questionManager.findDetails(surveyId,"2");
		exportXLSTitle(exportUtil, questions);
		int answerListSize = answers.size();
		for (int j = 0; j < answerListSize; j++) {
			SurveyAnswer surveyAnswer = answers.get(j);
			String surveyAnswerId = surveyAnswer.getId();
			exportUtil.createRow(j+1);
			exportXLSRow(exportUtil, surveyAnswerId, questions, surveyAnswer);
			System.out.println(j+1+"/"+answerListSize);
		}
		exportUtil.exportXLS();
	} catch (Exception e) {
		e.printStackTrace();
	}
	return urlPath + fileName;
}