sampledocumentdaohibernate.java

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

/**
 * 
 */
package cn.bway.foreigntrade.repertory.sample.document.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 test.test1.model.Test;

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.operation.units.model.Units;
import cn.bway.foreigntrade.order.exportproduct.model.Exportproduct;
import cn.bway.foreigntrade.repertory.cancel.document.model.Canceldocument;
import cn.bway.foreigntrade.repertory.cancel.product.model.Cancelproduct;
import cn.bway.foreigntrade.repertory.incasement.document.model.Incasementdocument;
import cn.bway.foreigntrade.repertory.incasement.product.model.Incasementproduct;
import cn.bway.foreigntrade.repertory.instore.document.model.Instoredocument;
import cn.bway.foreigntrade.repertory.instore.product.model.Instoreproduct;
import cn.bway.foreigntrade.repertory.outstore.document.model.Outstoredocument;
import cn.bway.foreigntrade.repertory.outstore.product.model.Outstoreproduct;
import cn.bway.foreigntrade.repertory.sample.document.model.Sampledocument;

/**
 * @author Kson
 * 
 */
public class SampledocumentDAOHibernate extends BaseDAOHibernate implements SampledocumentDAO {

	/*
	 * (non-Javadoc)
	 * 
	 * @see cn.bway.myoffice.merchant.dao.MerchantDAO#findAllMerchant(cn.bway.common.vo.QueryVO)
	 */
	public Object findAllSampledocument(QueryVO qvo) throws BwayHibernateException {
		
		return null;
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see cn.bway.myoffice.merchant.dao.MerchantDAO#findAllMerchant1(cn.bway.common.vo.QueryVO)
	 */
	public Object findAllSampledocument1(QueryVO qvo) throws BwayHibernateException {
		// TODO Auto-generated method stub
		Sampledocument Sampledocument = new Sampledocument();
		PageListVO rvo = new PageListVO();
		rvo.setRealPage(qvo.getCurPage());
		rvo.setPageSize(qvo.getPageSize());
		List list = null;
		session = currentSession();
		try {
			Criteria criteria = session.createCriteria(Sampledocument.class);
			rvo.setTotalItems(criteria.add(Example.create(Sampledocument)).list().size());
			criteria.setFirstResult(qvo.getFirstItem());
			criteria.setMaxResults(qvo.getPageSize());

			list = criteria.add(Example.create(Sampledocument))
			.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 queryAllSampledocument(QueryVO qvo,String id) throws BwayHibernateException {
		
		Sampledocument Sampledocument = new Sampledocument();
		PageListVO rvo = new PageListVO();
		rvo.setRealPage(qvo.getCurPage());
		rvo.setPageSize(qvo.getPageSize());
		List list = null;
		session = currentSession();
		 int start=0;
		 int end=0;
		 String startTime = "";
		 String endTime="";
		try {
			
			//鏌ヨ鏉′欢
			 Map map= Util.scatterMap(qvo.getScatterMap());
			
		
			 log.info(" ###################################  map objct:  "+map);
			 if(map.isEmpty()){
//				 luc
			 }else{
				 if(map.get("starttime") != null && !"".equals(map.get("starttime"))||
						 map.get("endtime") != null && !"".equals(map.get("endtime"))){
				 startTime = map.get("starttime").toString();
				 endTime = map.get("endtime").toString();
				 System.out.println("startTime是：++++"+startTime+"---------");
				 System.out.println("endTime是：++++"+endTime);
				 start=startTime.length();
				  end=endTime.length();

				 }
			 }
			
			 
			 Criteria criteria = session.createCriteria(Sampledocument.class);
//			 criteria.add(Expression.like("address", "%"+endTime+"%"));
//			 criteria.add(Expression.like("id", "%"+startTime+"%"));
			 if( start>3&&end>3	)
			 {
			 criteria.add(Expression.gt("times",startTime));
			 criteria.add(Expression.lt("times",endTime));
			 System.out.println("两 个不为空");
			 System.out.println("strat是："+start + "___"+end);
		
			 }
			 else if( "".equals(endTime)|| endTime==null&&startTime!=null){
				 criteria.add(Expression.gt("times",startTime));
				 System.out.println("endTime是空");
				 }
			 else if( "".equals(startTime)||startTime==null&& endTime!=null){
				 criteria.add(Expression.lt("times",endTime));
				 System.out.println("startTime是空");
				 }
			 else
			 {};
			rvo.setTotalItems(criteria.add(Example.create(Sampledocument)).list().size());
//			criteria.add( Restricti)
			criteria.setFirstResult(qvo.getFirstItem());
			criteria.setMaxResults(qvo.getPageSize());
			list = criteria.add(Example.create(Sampledocument)).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;
	}
	
}