publicdaoimpl.java

仿招聘网站 SSH框架 ajax功能

package com.chinahr.dao.impl;

import java.util.*;


import org.hibernate.SessionFactory;
import org.hibernate.Session;
import org.hibernate.Transaction;

import org.hibernate.Query;

import com.chinahr.dao.PublicDAO;
import com.chinahr.pojo.*;
import java.lang.reflect.Method;
import org.hibernate.*;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
public class PublicDAOImpl extends HibernateDaoSupport implements PublicDAO {

	String returnType;
	Session session=null;
	//用于删除
	public boolean delete(Class cls,java.io.Serializable id)
	{
		
		
			this.getHibernateTemplate().delete(this.getHibernateTemplate().load(cls, new Integer(id.toString())));
			
		return true;
	}
	//添加
	public boolean add(Object item)
	{
		this.getHibernateTemplate().save(item);
		return true;
	}
	//修改
	public boolean update(Object item)
	{
		this.getHibernateTemplate().save(item);
		return true;
	}
	//查询
	public List getInfo(String queryString)
	{
		return this.getHibernateTemplate().find(queryString);
	}
	
	

	/*
	 * 关于地点字典的联结查询
	 * */
	public List getInfoByOne(Integer id)
	{
		List list=new ArrayList();
		Session session=this.getSession();
		try
		{
			TabPovince city=(TabPovince)session.load(TabPovince.class, id);
			String hql="select t from TabCity t where t.tabPovince.id='"+city.getProvinceId()+"'";
			list=this.getHibernateTemplate().find(hql);
			
//			Iterator areas=city.getTabCities().iterator();
//			while(areas.hasNext())
//			{
//				TabCity area=(TabCity)areas.next();
//				list.add(area);
//			}
			
			
		}catch(Exception ex)
		{
			System.out.println("error:"+ex.getMessage());
		}finally
		{
		}
		return list;
	}
//	根据起始序号以及要取的条数，获得对应的数据
	public List getListByPage(int index,int rownum,String hql)
	{
		List list=new ArrayList();
		try {
			session = this.getSession();
			System.out.println(hql);
			Query  query=session.createQuery(hql);
			query.setFirstResult(index);
			query.setMaxResults(rownum);
			list=query.list();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
//			sf.close();
		}
		return list;
	}
	
	public int getcountRecord(String hql)     //获取记录总数
	{
		int count=0;
		try {
			session = this.getSession();
			System.out.println(hql);
			Query  query=session.createQuery(hql);
			count=(Integer)query.uniqueResult();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
		  //sf.close();
		}
		return count;
	}
	
}