informationdaohibernate.java

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

/**
 * 
 */
package cn.bway.foreigntrade.information.dao;

import java.math.BigInteger;
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.Session;
import org.hibernate.Transaction;
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.dao.HibernateSessionFactory;
import cn.bway.common.vo.PageListVO;
import cn.bway.common.vo.QueryVO;
import cn.bway.myoffice.merchant.model.Merchant;
import cn.bway.foreigntrade.auditmanagement.auditorder.model.Auditorder;
import cn.bway.foreigntrade.auditmanagement.auditstaff.model.Auditstaff;
import cn.bway.foreigntrade.auditmanagement.audittable.model.Audittable;
import cn.bway.foreigntrade.information.model.Information;
import cn.bway.foreigntrade.operation.countryport.model.Countryport;
import cn.bway.foreigntrade.operation.units.model.Units;
import cn.bway.foreigntrade.order.exportclient.model.Exportclient;

/**
 * @author Kson
 *
 */
public class InformationDAOHibernate extends BaseDAOHibernate implements
		InformationDAO {
	public Object findAllInformation(QueryVO qvo) throws BwayHibernateException {
       return null;
	}
	public Object findAllInformation1(QueryVO qvo,String user) throws BwayHibernateException {
		// TODO Auto-generated method stub
		Information e= new Information();
		PageListVO rvo=new PageListVO();
		rvo.setRealPage(qvo.getCurPage());
		rvo.setPageSize(qvo.getPageSize());
		List list=null;
		session=currentSession();
		try {
	    	Criteria criteria=session.createCriteria(Information.class);
			criteria.add(Expression.eq("inforget",user));	
	    	rvo.setTotalItems(criteria.add(Example.create(e)).list().size());    	
	    	criteria.setFirstResult(qvo.getFirstItem());
	    	criteria.setMaxResults(qvo.getPageSize());
	    	
			list=criteria.add(Example.create(e))			
			.addOrder(Order.asc("isaudit"))
			.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 queryAllInformation(QueryVO qvo) throws BwayHibernateException {
		Information Information= new Information();
		PageListVO rvo = new PageListVO();
		rvo.setRealPage(qvo.getCurPage());
		rvo.setPageSize(qvo.getPageSize());
		List list = null;
		session = currentSession();
		try {
			Criteria criteria = session.createCriteria(Information.class);
			
			//查询条件
			 Map map= Util.scatterMap(qvo.getScatterMap());
			 String type = "";
			 if(map.isEmpty()){
				 
			 }else{
				 String ordername=map.get("ordername").toString();
				 criteria.add(Expression.like("ordername", "%"+ordername+"%"));
			 }
			rvo.setTotalItems(criteria.add(Example.create(Information)).list().size());
			criteria.setFirstResult(qvo.getFirstItem());
			criteria.setMaxResults(qvo.getPageSize());
			list = criteria.add(Example.create(Information)).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 getItem(QueryVO qvo, String inforid) throws BwayHibernateException {
		
		return null;
	}
	public Object getItemProduct(QueryVO qvo, String inforid) throws BwayHibernateException {
		// TODO Auto-generated method stub
		return null;
	}
	public Object getOrderexplain(String ordername) throws BwayHibernateException {
		Auditorder order=new Auditorder();
		session=currentSession();
		Criteria criter=session.createCriteria(Auditorder.class);
		criter.add(Expression.eq("ordername",ordername));//类型配套
		List list=criter.list();
		for(int i=0;i<list.size();i++){
			order=(Auditorder) list.get(i);
		}
		return order;
	}
}