dao.java

一个框架

package com.dao;

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

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.exception.GenericJDBCException;

public class Dao {
	
	private Session session;
	//分页
	public List query(String hql, int page, int pageSize )
	{
		session = AppSession.getSession();
		Query query = session.createQuery(hql);
		query.setFirstResult(page*pageSize);
		query.setMaxResults(pageSize);
		List list =null;
		try 
		{
			 list = query.list();
		}
		catch(GenericJDBCException e)
		{
			list = new ArrayList();
		}
		
		return list;
	}
	
	public void delete(List list)
	{
		session = AppSession.getSession();
		Transaction  tx = session.beginTransaction();
		int lens = list.size();
		for(int i=0;i<lens;i++)
		{
			Object obj = list.get(i);
			session.delete(obj);
			tx.commit();
		}
	}
	
	public static void main(String [] args)
	{
		String hql="from com.entity.dept.DeptEntity ";
		String hql2 ="select count(d.dept_id) from com.entity.dept.DeptEntity d";
		
		Dao dao = new Dao();
		List list = dao.query(hql2);
		
		int totalSize= (Integer) list.get(0);
		System.out.println(" totalSize = "+ totalSize);
		
		
//		int page =1;
//		int pageSize=10;
//		Dao dao = new Dao();
//		List list = dao.query(hql,page,pageSize);
//		System.out.println("list.size() " + list.size());
	}
	//not parameter
	public List query(String hql)
	{
		session = AppSession.getSession();
		Query query = session.createQuery(hql);
		List list = query.list();		
		return list;
	}
	// hava parameter
	public List query(String hql, List list)
	{
		session = AppSession.getSession();
		Query query = session.createQuery(hql);
		int lens = list.size();
		for(int i=0;i<lens;i++)
		{
			Param p = (Param) list.get(i);
			if(p.getType()==1) // 1= string 
			{
				query.setString(i, (String) p.getValue());
			}
			else
			{
				// 2 =int
				query.setInteger(i, (Integer) p.getValue());
			}
		}
		List list_ =query.list();
		
		return list_;
	}
	
	public Object queryById( Class cla , String id ){
			
			Session session = AppSession.getSession();
			Object obj = session.load( cla , id );
	
			return obj;
		}

	

	
	public void add(Object o)
	{
		session = AppSession.getSession();
		Transaction  tx = session.beginTransaction();
		session.save(o);
		tx.commit();
		
	}
	
	public void edit(Object o)
	{
		session = AppSession.getSession();	
		Transaction  tx = session.beginTransaction();
		session.update(o);
		tx.commit();
			
	}
	
	public void delete(Object o)
	{
		session = AppSession.getSession();	
		Transaction  tx = session.beginTransaction();
		session.delete(o);
		tx.commit();
			
		
	}

}