deptassesdaoimpl.java

java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经

package com.hbmDAO.impl;
import com.model.DeptAsses;
import com.model.Person;
import com.hbmDAO.*;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;

import org.hibernate.Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.dao.DataRetrievalFailureException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.hbmDAO.DeptAssesDAO;

public class DeptassesDAOImpl  extends HibernateDaoSupport implements DeptAssesDAO {

	public DeptAsses queryById(String id) {
        Object obj = getHibernateTemplate().load(DeptAsses.class, id);
        if(obj==null)
            throw new DataRetrievalFailureException("id not found: " + id);
        return (DeptAsses) obj;
    }

    @SuppressWarnings("unchecked")
    public List<DeptAsses> queryAll() {
        return getHibernateTemplate().find("from DeptAsses ");
    }

    public List<DeptAsses> queryByHql(String hql) {
        return getHibernateTemplate().find(hql);
    }
    @SuppressWarnings("unchecked")
    public List getCount(String sql) {
//        return getHibernateTemplate().getSessionFactory().getCurrentSession().createSQLQuery("select count(*) from person_asses").list();
    	List<String> list=new ArrayList<String>();
    	try{
    	Session session = null;
		session = this.getSession();
		Connection con = session.connection();
		Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY,
				ResultSet.CONCUR_READ_ONLY);
		ResultSet rs = stmt.executeQuery(sql);
		while (rs.next()) {
			list.add(rs.getString(1));
		}
//		session.disconnect();
    }catch(Exception ex){}
		return list;
    }
    public void insert(DeptAsses data) {
        getHibernateTemplate().save(data);
    }

    public void update(DeptAsses data) {
        getHibernateTemplate().update(data);
    }

    public void delete(DeptAsses data) {
        getHibernateTemplate().delete(
                getHibernateTemplate().load(DeptAsses.class, data.getDaid()));
    }
    public List getDeptMonthPoint(String year, String month){
    	
    	String hql = "from DeptAsses  where year(asses_date)=:year and month(asses_date)=:month order by dept_name";   
    	Session session = null;
    	try{
    		session = this.getSession();
            Query query = session.createQuery(hql);            
            query.setParameter("year", year,Hibernate.STRING);      
            query.setParameter("month", month,Hibernate.STRING);      
            List<DeptAsses> list = query.list();     
            return list;
    	}catch(Exception e ){
    		return null;
    	}
    	
    }
}