shippingmarkdaohibernate.java

这是本人曾经在公司里用的,内部开发框架,基于struts+hibernate今天分享给大家

/**
 * 
 */
package cn.bway.foreigntrade.commondata.shippingmark.dao;

import java.util.List;
import java.util.Map;

import org.hibernate.Criteria;

import org.hibernate.criterion.Example;

import org.hibernate.criterion.Order;

import cn.bway.common.BwayHibernateException;

import cn.bway.common.Util;

import cn.bway.common.dao.BaseDAOHibernate;
import cn.bway.common.vo.PageListVO;
import cn.bway.common.vo.QueryVO;
import cn.bway.foreigntrade.commondata.shippingmark.model.Shippingmark;

import org.hibernate.criterion.Expression;

/**
 * @author Kson
 *
 */
public class ShippingmarkDAOHibernate extends BaseDAOHibernate implements
		ShippingmarkDAO {
	
//	public Object findAllContract()
//	{
//		
//		
//		return null;
//	}

	public Object findAllShippingmark(QueryVO qvo) throws BwayHibernateException {
		// TODO Auto-generated method stub
		Shippingmark guest= new Shippingmark();
		PageListVO rvo=new PageListVO();
		rvo.setRealPage(qvo.getCurPage());
		rvo.setPageSize(qvo.getPageSize());
		List list=null;
		session=currentSession();
		try {
	    	Criteria criteria=session.createCriteria(Shippingmark.class);
	    	rvo.setTotalItems(criteria.add(Example.create(guest)).list().size());
	    	
	    	criteria.setFirstResult(qvo.getFirstItem());
	    	criteria.setMaxResults(qvo.getPageSize());
			list=criteria.add(Example.create(guest))
			.addOrder(Order.desc("id"))
			.list();
	    	
	    	rvo.setretVO(list);
		} catch (Exception ex)	{
			ex.printStackTrace();
			log.error(this.getClass().getName()+".updateObject(Object obj)"+ex);
		}finally{
			closeSession();
		}
    	return rvo;
	}

	public Object findAllShippingmark1(QueryVO qvo) throws BwayHibernateException {
		// TODO Auto-generated method stub
		PageListVO rvo=new PageListVO();
		Shippingmark guest =new Shippingmark();
		rvo.setRealPage(qvo.getCurPage());
		rvo.setPageSize(qvo.getPageSize());
		List list = null;
		session = currentSession();
		try {
			
			//鏌ヨ鏉′欢
			 Map map= Util.scatterMap(qvo.getScatterMap());
			 String ids = "";
			 String country="";
			 log.info(" ###################################  map objct:  "+map);
			 if(map.isEmpty()){
//				 luc
			 }else{
				 if(map.get("ids") != null && !"".equals(map.get("ids"))||
						 map.get("country") != null && !"".equals(map.get("country"))){
				 ids = map.get("ids").toString();
//				 country = map.get("country").toString();
//				 guest.setId(ids.trim());
//				 guest.setCountry(country.trim());
				 }
			 }
			 Criteria criteria = session.createCriteria(Shippingmark.class);
//			 criteria.add(Expression.like("country", "%"+country+"%"));
			 criteria.add(Expression.like("id", "%"+ids+"%"));
			rvo.setTotalItems(criteria.add(Example.create(guest)).list().size());
//			criteria.add( Restricti)
			criteria.setFirstResult(qvo.getFirstItem());
			criteria.setMaxResults(qvo.getPageSize());
			list = criteria.add(Example.create(guest)).addOrder(Order.desc("id"))
					.list();

			rvo.setretVO(list);
		} catch (Exception ex) {
			ex.printStackTrace();
			log.error(this.getClass().getName() + ".updateObject(Object obj)"
					+ ex);
		} finally {
			closeSession();
		}
		return rvo;
	}

}