SSH--hibernateTemplate通过Criteria、Restrictions条件限制查询

亦凉 2024-02-18 15:39 71阅读 0赞

//部分方法的实现：

@Override
    	public List searchSalerOutOrBuyerIn(Goods condition,Users users) {
    		Session session = super.getHibernateTemplate().getSessionFactory().getCurrentSession();
    		Criteria criteria = session.createCriteria(Goods.class);
    		if(condition!=null){
    			if(condition.getGoodsStatus()!=null && !condition.getGoodsStatus().equals("")){
    				criteria.add(Restrictions.eq("goodsStatus",condition.getGoodsStatus()));
    			}
    			if(users==condition.getSaler()){
    				criteria.add(Restrictions.eq("saler", condition.getSaler()));
    			}else 
    				if(users==condition.getBuyers()){
    					criteria.add(Restrictions.eq("buyers", condition.getBuyers()));
    				}
    		}
    		return criteria.list();
    	}

@Override
    	public List search(final Goods goods) { 
    		return super.getHibernateTemplate().execute(new HibernateCallback() {
    			@Override
    			public Object doInHibernate(Session session) throws HibernateException {
    				Criteria criteria = session.createCriteria(Goods.class);
    				if(null!=goods){
    					if(goods.getGoodsStatus()!=null&&!goods.getGoodsStatus().equals("")){
    						criteria.add(Restrictions.eq("goodsStatus", goods.getGoodsStatus()));
    					}
    					if(goods.getSaler()!=null){
    						criteria.add(Restrictions.eq("saler", goods.getSaler()));
    					}
    				}
    				return criteria.list();
    			}
    		});
    	}

@Override
    	public List search(Users users) {
    		Session session= super.getHibernateTemplate().getSessionFactory().getCurrentSession();
    		Criteria criteria = session.createCriteria(Users.class);
    		if(null!=users){
    			criteria.add(Restrictions.eq("userName", users.getUserName())); //添加查询条件
    			criteria.add(Restrictions.eq("password", users.getPassword()));
    		}
    		return criteria.list();
    	}

/*
    	 * 当用户注册时判断该用户是否存在
    	 */
    	@SuppressWarnings({ "rawtypes", "unchecked" })
    	@Override
    	public List judgeExistUsers(final Users users) {
    		return super.getHibernateTemplate().execute(new HibernateCallback() {
    			@Override
    			public Object doInHibernate(Session session) throws HibernateException {
    				Criteria criteria = session.createCriteria(Users.class);
    				if(null!=users){
    					criteria.add(Restrictions.eq("userName", users.getUserName()));
    				}
    				return criteria.list();
    			}
    		});
    	}