publicclass.java

本系统为符合订单管理 精确使用了账号分层用户管理 可进行主订单 次订单的增加 删除功能 实现了全密浏览用品的功能！

package com.hz.hibernate;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;

public class PublicClass extends HibernateSessionFactory{
	//此公共类继承HibernateSessionFactory
	public void insert(Object POJOName){
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		session.save(POJOName) ;
		session.beginTransaction().commit() ;
		session.close() ;
	}
	
	public void delete(Object POJOName){
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		session.delete(POJOName) ;
		session.beginTransaction().commit() ;
		session.close() ;
	}
	
	public void delete(String className,String idName,String[] ids){
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		if(ids!=null){
			Query query=session.createQuery("delete from "+className+" where "+idName+" = ?") ;
			for(int i=0;i<ids.length;i++){
				query.setString(0,ids[i]);
				query.executeUpdate();
			}
		}
		session.beginTransaction().commit() ;
		session.close() ;
	}
	
	public void update(Object POJOName){
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		session.update(POJOName) ;
		session.beginTransaction().commit() ;
		session.close() ;
	}
	
	public List queryAll(String className){
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		Query query=session.createQuery("from "+className) ;
		List list = query.list() ;
		session.close() ;
		return list;
	}
	
	public List queryAll(String mainClassName,String subClassName){
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		Query query=session.createQuery("from "+mainClassName) ;
		query.list();
		query=session.createQuery("from "+subClassName) ;
		List list = query.list() ;
		session.close() ;
		return list;
	}
	
	public List queryByPage(Class className,int pageNo,int perPageCount){
		Criteria crite= HibernateSessionFactory.getSessionFactory().openSession().createCriteria(className);
		int beiginIndex = (pageNo-1)*perPageCount ;
		crite.setFirstResult(beiginIndex);
		crite.setMaxResults(perPageCount);
		return crite.list();
	}
	
	public int queryRowCount(String className){
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		Query query=session.createQuery("from "+className) ;
		int count = query.list().size() ;
		session.close() ;
		return count ;
	}
	
	public int queryRowCount(String mainClassName,String subClassName){
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		Query query=session.createQuery("from "+mainClassName) ;
		query.list();
		query=session.createQuery("from "+subClassName) ;
		int count = query.list().size() ;
		session.close() ;
		return count ;
	}
	
	public Object queryById(String className,String idName,int idValue){
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		Query query=session.createQuery("from "+className+" where "+idName+"=?") ;
		query.setInteger(0,idValue);
		List list=query.list();
		Object obj=null;
		if(list.size()>0){
			obj=list.get(0);
		}
		session.close() ;
		return obj;
	}
	
	public Object queryById(String mainClassName,String subClassName,String idName,int idValue){
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		Query query=session.createQuery("from "+mainClassName) ;
		query.list();
		query=session.createQuery("from "+subClassName+" where "+idName+"=?") ;
		query.setInteger(0,idValue);
		List list=query.list();
		Object obj=null;
		if(list.size()>0){
			obj=list.get(0);
		}
		session.close() ;
		return obj;
	}

	public void delete(String className, String idName, int idValue) {
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		Query query=session.createQuery("delete from "+className+" where "+idName+" = ?") ;
		query.setInteger(0,idValue) ;
		query.executeUpdate() ;
		session.beginTransaction().commit() ;
		session.close() ;
	}

	public List queryByProperty(String className,String propertyName, Object value) {
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		String queryString = "from "+className+" as model where model."+ propertyName + "= ?";
		Query queryObject = session.createQuery(queryString);
		queryObject.setParameter(0, value);
		List list = queryObject.list() ;
		session.close() ;
		return list ;
	}
	
	public List queryByProperty(String mainClassName,String subClassName,String propertyName, Object value) {
		Session session = HibernateSessionFactory.getSessionFactory().openSession() ;
		String queryString = "from "+subClassName+" as model where model."+ propertyName + "= ?";
		Query queryObject = session.createQuery("from "+mainClassName);
		queryObject.list();
		queryObject = session.createQuery(queryString);
		queryObject.setParameter(0, value);
		List list = queryObject.list() ;
		session.close() ;
		return list ;
	}
}