guestorderdaohibernate.java

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

/**
 * 
 */
package cn.bway.foreigntrade.order.guestorder.dao;

import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.Expression;
import org.hibernate.criterion.Order;



import cn.bway.common.BwayHibernateException;
import cn.bway.common.DataBaseUtils;
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.myoffice.merchant.model.Merchant;
import cn.bway.foreigntrade.auditmanagement.auditstaff.model.Auditstaff;
import cn.bway.foreigntrade.order.guestorder.model.Guestorder;

/**
 * @author Kson
 * 
 */
public class GuestorderDAOHibernate extends BaseDAOHibernate implements GuestorderDAO {

	public Object findAllGuestorder(QueryVO qvo) throws BwayHibernateException {
		
		return null;
	}
	public Object findAllGuestorder1(QueryVO qvo) throws BwayHibernateException {
		// TODO Auto-generated method stub
		Guestorder guestorder = new Guestorder();
		PageListVO rvo = new PageListVO();
		rvo.setRealPage(qvo.getCurPage());
		rvo.setPageSize(qvo.getPageSize());
		List list = null;
		session = currentSession();
		try {
			Criteria criteria = session.createCriteria(Guestorder.class);
			rvo.setTotalItems(criteria.add(Example.create(guestorder)).list().size());

			criteria.setFirstResult(qvo.getFirstItem());
			criteria.setMaxResults(qvo.getPageSize());

			list = criteria.add(Example.create(guestorder))
					.addOrder(Order.asc("checks"))
					.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 queryAllGuestorder(QueryVO qvo) throws BwayHibernateException {
		// TODO Auto-generated method stub
		Guestorder guestorder= new Guestorder();
		PageListVO rvo = new PageListVO();
		rvo.setRealPage(qvo.getCurPage());
		rvo.setPageSize(qvo.getPageSize());
		List list = null;
		session = currentSession();
		try {
			 Map map= Util.scatterMap(qvo.getScatterMap());
			 String id = "";
			 String address="";
			 log.info(" ###################################  map objct:  "+map);
			 if(map.isEmpty()){
//				 luc
			 }else{
				 if(map.get("address") != null && !"".equals(map.get("address"))||
						 map.get("id") != null && !"".equals(map.get("id"))){
				 id = map.get("id").toString();
				 address = map.get("address").toString();
				 System.out.println("id是：++++"+id+"---------"+address);
//				 guest.setNames(workname.trim());
//				 guest.setCountry(country.trim());
				 }
			 }
			 Criteria criteria = session.createCriteria(Guestorder.class);
			 criteria.add(Expression.like("address", "%"+address+"%"));
			 criteria.add(Expression.like("id", "%"+id+"%"));
			rvo.setTotalItems(criteria.add(Example.create(guestorder)).list().size());
//			criteria.add( Restricti)
			criteria.setFirstResult(qvo.getFirstItem());
			criteria.setMaxResults(qvo.getPageSize());
			list = criteria.add(Example.create(guestorder)).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 queryAllGuestorderNo(QueryVO qvo) throws BwayHibernateException {
		Guestorder guest=new Guestorder();
		PageListVO rvo = new PageListVO();
		rvo.setRealPage(qvo.getCurPage());
		rvo.setPageSize(qvo.getPageSize());
		List list = null;
		session = currentSession();
		try {
			Criteria criteria = session.createCriteria(Guestorder.class);
			criteria.add(Expression.lt("checks","3"));
			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 queryAllGuestorderOk(QueryVO qvo) throws BwayHibernateException {
		Guestorder guest=new Guestorder();
		PageListVO rvo = new PageListVO();
		rvo.setRealPage(qvo.getCurPage());
		rvo.setPageSize(qvo.getPageSize());
		List list = null;
		session = currentSession();
		try {
			Criteria criteria = session.createCriteria(Guestorder.class);
			criteria.add(Expression.eq("checks","3"));
			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;
	}
}