basedao.java

负责公文的传输及一些处理功能

package com.example.basedao;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.orm.hibernate3.SessionFactoryUtils;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.springframework.orm.hibernate3.HibernateTemplate;
import com.example.businessmodel.*;
import com.example.gw.attachment.Attachment;
import com.example.gw.attachment.IAttachmentManager;
import com.example.util.PageUtil;
public abstract class BaseDao extends HibernateDaoSupport{
    public void save(Object object){
    	getHibernateTemplate().merge(object);
    }
    public void delete(Object object){
    	getHibernateTemplate().delete(object);
    }
    public void update(Object object){
    	getHibernateTemplate().update(object);
    }
    public List find(String where){
    	return getHibernateTemplate().find(where);
    }
    public Object findById(Class cla,Integer id){
    	return getHibernateTemplate().get(cla,id);
    }
    public void saveOrUpdate(Object object){
    	HibernateTemplate hibernateTemplate = getHibernateTemplate();
    	hibernateTemplate.saveOrUpdate(object);
    	hibernateTemplate.flush();
    }

    public Session openSession() {
        return SessionFactoryUtils.getSession(getSessionFactory(),true);
    }
    
    public Page loadPage(final String hsql, final int start, final int page_size)
			throws Exception {
		int total_count = 0;
		List items = new ArrayList();
		Session session = getSession();
		Query query = session.createQuery(hsql);
		try {
			total_count = (query.list()).size();
			int rowNum = page_size;
            if(start>total_count){
              	query.setFirstResult((total_count/rowNum)*rowNum);
            }else{
			    query.setFirstResult(start - 1);
            }
			query.setMaxResults(rowNum);
			items = query.list();
		} finally {
			return new Page(items, start, total_count, page_size);
		}
	}   
    
    public String loadPageXml(final String hsql,final int start,final int page_size,List propertiesList)throws Exception{
        int total_count=0;          
        List items=new ArrayList();     
        Session session = getSession();        
        Query query = session.createQuery(hsql); 
        PageUtil pageUtil = new PageUtil();
        try{
            total_count=(query.list()).size(); 
            int rowNum=page_size;    
            query.setFirstResult((start == 1)?0:(start-1)*rowNum);    
            query.setMaxResults(rowNum);  
            items = query.list();
       }finally{
            return pageUtil.getRetXml(items,start,total_count,page_size,propertiesList);
       }
    }

}