Hibernate 参数查询通用方法

//命名参数查询
//设置参数的值 是以键的形式进行赋值
public List search(String hql,HashMap map)
{
           List  list  =new ArrayList();
		Session  session =this.getSession();
		try{
			Query   query=session.createQuery(hql);
			Set  keys=map.keySet();
			Iterator  it=keys.iterator();
			while(it.hasNext())
			{
				String  key=(String)it.next();
				query.setString(key, (String)map.get(key));
			}
			list = query.list();
 //关闭.....

		}catch(Exception ex){
			ex.printStackTrace();
		}
		return list;


}

//使用模板
public List search(String hql, HashMap map) {
		List list = new ArrayList();
		Set keys = map.keySet();
		Iterator it = keys.iterator();
		while (it.hasNext()) {
			String key = (String) it.next();
		list.add(super.getHibernateTemplate().findByNamedParam(hql, key, (String) map.get(key)));
		}
 //关闭.....

		return   	list;	

}


//-----------------------------------------

//参数 查询  按hql,param 条件查询赋值
//参数少，是以下标的形式给 query
public List search(String hql,String[] arg)
{

      List  list  =new ArrayList();
		Session  session =this.getSession();
		try{
			Query   query=session.createQuery(hql);
		    for(int  i=0;i<arg.length;i++)
		    {
		    	query.setString(i, arg[i]);
		    }
			list = query.list();
		}catch(Exception ex){
			ex.printStackTrace();
		}
                    //关闭.....
		return list;

}


public List search(String hql,String[] arg)
{
   return  super.getHibernateTemplate().find(hql, arg);

}