admindaoimpl.java

前期开发时开发的新闻发布系统

package com.xh369.daoimpl;

import com.xh369.actions.HibernateSessionFactory;
import com.xh369.dao.AdminDAO;
import com.xh369.dto.Admin;
import java.util.List;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.support.*;

public class AdminDAOimpl extends HibernateDaoSupport implements AdminDAO
{

    //��¼
    public int getLogin(Admin admin)
    {    
        try 
        {
        	Session session = HibernateSessionFactory.getSession();
            String hql = "select count(*) from Admin as admin where admin.username=? and admin.pwd=?";            
            return session.createQuery(hql)
            			  .setParameter(0, admin.getUsername())
            			  .setParameter(1, admin.getPwd())
            			  .list()
            			  .size();
        } 
        catch(Exception ex) 
        {
            ex.printStackTrace();
            return -1;
        }
    }

    //��ѯ������Ա�б�
    public List getAdminList()
    {
         try 
         {
             return getHibernateTemplate().find("from Admin as admin");
         } 
         catch(Exception ex) 
         {
             ex.printStackTrace();
             return null;
         }
     }

    //��ӹ�����Ա
    public boolean insertAdmin(Admin admin)
    {
        try
        {
            getHibernateTemplate().save(admin);
            return true;
        } 
        catch(Exception ex)
        {
            ex.printStackTrace();
            return false;
        }
    }
    
    //��ѯ�û���ӵ�е�Ȩ��
	public Admin getPopedom(Integer id) 
	{
		try 
		{
			return  (Admin) getHibernateTemplate().load(Admin.class, id);
		} 
		catch(Exception e) 
		{
			e.printStackTrace();
			return null;
		}
	}
	
	//��ѯȨ��
	public List getAllPopedom() 
	{		
		try 
		{
			String hql = "from Popedom as popedom";
			return getHibernateTemplate().find(hql);
		} 
		catch(Exception e) 
		{
			e.printStackTrace();
			return null;
		}
	}
	
	//�޸��û�Ȩ��
	public boolean updatePopedom(Integer id, StringBuffer sb) 
	{		
		try 
		{
			Admin admin = (Admin) getHibernateTemplate().load(Admin.class, id);
			admin.setLevel(sb.toString());
			getHibernateTemplate().update(admin);
			return true;
		} 
		catch(Exception e) 
		{
			return false;
		}
	}

	//ɾ���û�
	public boolean delAdmin(Integer id) 
	{		
		try 
		{
			Admin admin = (Admin) getHibernateTemplate().load(Admin.class, id);
			getHibernateTemplate().delete(admin);
			return true;
		} 
		catch(Exception e) 
		{
			e.printStackTrace();
			return false;
		}
	}
}