persondaoimpl.java

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

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

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 org.springframework.transaction.annotation.Transactional;

public class PersonDAOImpl extends HibernateDaoSupport implements PersonDAO{
	@SuppressWarnings("unchecked")
	public Person queryById(String id) {
       /*Object obj = getHibernateTemplate().load("Person", id);
        if(obj==null)
            throw new DataRetrievalFailureException("id not found: " + id);
        return (Person) obj;*/
		String hql = "from Person where pid=:pid ";   
    	Session session = null;
    	try{
    		session = this.getSession();
            Query query = session.createQuery(hql);            
            query.setParameter("pid", id,Hibernate.STRING);      
            List<Person> list = query.list();     
            return list.get(0);
    	}catch(Exception e ){
    		return null;
    	}
    }

    @SuppressWarnings("unchecked")
    public List<Person> queryAll() {
        return getHibernateTemplate().find("from Person ");
    }
    @SuppressWarnings("unchecked")
    public List<Person> queryByHql(String hql) {
        return getHibernateTemplate().find(hql);
    }
    
    public void insert(Person data) {
        getHibernateTemplate().save(data);
    }

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

    public void delete(Person data) {
        getHibernateTemplate().delete(
                getHibernateTemplate().load(Person.class, data.getPid()));
    }
    public boolean delete(String userid) {
        getHibernateTemplate().delete(
                getHibernateTemplate().load(Person.class, userid));
        return true;
    }
    @SuppressWarnings("unchecked") 
	public List queryDepts(){
    	String hql = "select distinct dept from Person as p where p.dept !=:space";   
    	Session session = null;
    	try{
    		session = this.getSession();
            Query query = session.createQuery(hql);            
            query.setParameter("space", "",Hibernate.STRING);      
            List<String> list = query.list();     
            return list;
    	}catch(Exception e ){
    		return null;
    	}
		
    }
    @SuppressWarnings("unchecked") 
	public List queryPersonByDept(String dept){
    	String hql = "select p.person_name from Person as p where p.dept =:dept and role !=:jszj ";   
    	Session session = null;
    	try{
    		session = this.getSession();
            Query query = session.createQuery(hql);            
            query.setParameter("dept", dept,Hibernate.STRING);   
            query.setParameter("jszj", "jszj",Hibernate.STRING);  
            List<String> list = query.list();     
            return list;
    	}catch(Exception e ){
    		return null;
    	}
		
    }
    @SuppressWarnings("unchecked") 
	public Person dad(String name1,String password1){
    	String hql = "from Person where person_name=:username and pwd=:password";   
    	Session session = null;
    	try{
    		session = this.getSession();
            Query query = session.createQuery(hql);            
            query.setParameter("username", name1,Hibernate.STRING);      
            query.setParameter("password", password1,Hibernate.STRING);      
            List<Person> list = query.list();     
            return list.get(0);
    	}catch(Exception e ){
    		return null;
    	}
		
    }
    @SuppressWarnings("unchecked")
	public List pcount(String name1,String password1){
    	String hql = "select count(p) from Person as p where p.person_name=:username and p.pwd=:password";   
    	Session session = null;
    	try{
    		session = this.getSession();
            Query query = session.createQuery(hql);            
            query.setParameter("username", name1,Hibernate.STRING);      
            query.setParameter("password", password1,Hibernate.STRING);      
            List count = query.list();     
            return count;
    	}catch(Exception e ){
    		return null;
    	}
		
    }
    
}