rightinfoservice.java

这是本人曾经在公司里用的,内部开发框架,基于struts+hibernate今天分享给大家

/**
 * 
 */
package cn.bway.admin.dao;

import java.sql.*;
import java.util.*;
import org.apache.log4j.*;

import cn.bway.admin.vo.RoleAndRightVO;
import cn.bway.admin.vo.StaffInfoVO;
import cn.bway.common.BwayHibernateException;
import cn.bway.common.dao.BaseDAOHibernate;

/**
 * @author Kson
 *
 */
public class RightInfoService extends BaseDAOHibernate {
	protected final Logger log = LogManager.getLogger(getClass());
	
    /**
     * ��ѯָ���û����е�Ȩ��
     * @param vo StaffInfoVO
     * @return List
     * @throws SQLException 
     * @throws PlatformException
     */
    public Map queryRightInfoByStaff(StaffInfoVO vo,Connection conn) throws
        BwayHibernateException, SQLException
    {
        List arrayList = new ArrayList();
        List menuList = new ArrayList();
        Map rightMap = new HashMap();
//        Connection conn = null;
        try {
//            conn = currentSession().connection();
            conn.setAutoCommit(false);
            RightInfoDAO dao = new RightInfoDAO(conn);
            Map resultMap = dao.queryRightInfoByStaff(vo);
            
            arrayList = (List) resultMap.get("list");
            String rightIds = resultMap.get("rightIds") == null ? "" : resultMap.get("rightIds").toString();
            rightIds = rightIds.substring(0, rightIds.lastIndexOf(","));
            
            RightInfoDAO dao1 = new RightInfoDAO(conn);
            menuList = dao1.queryRightListByStaff(rightIds);
            conn.commit();
            rightMap.put("rightList", arrayList);
            rightMap.put("menuList", menuList);
            
        } catch (BwayHibernateException ex) {
        	 try {
                 conn.rollback();
             } catch (SQLException ex1) {
             }
            log.info("��ѯָ���û����е�Ȩ�޳��:" + ex.getMessage());
            throw ex;
        } catch (Exception ex2) {
            log.info("��ѯָ���û����е�Ȩ�޳��: "+ex2.getMessage());
        }
//        finally {
//        	closeSession();
//        }
        return rightMap;
    }

    /**
     * ��ݽ�ɫID��ѯ�ý�ɫ���е�Ȩ���б� added by liuwei 2006/08/20
     * @param vo RoleAndRightVO
     * @return List
     * @throws BwayHibernateException
     */
    public List queryRightFromRoleId(RoleAndRightVO vo) throws
        BwayHibernateException
    {
        List lst = null;
        Connection conn = null;
        try {
            conn = currentSession().connection();
            RightInfoDAO dao = new RightInfoDAO(conn);
            lst = dao.queryRightFromRoleId(vo);
        } catch (BwayHibernateException ex) {
            log.error("��ѯ�ý�ɫ���е�Ȩ���б��쳣 :"+ ex.getMessage());
            throw ex;
        } catch (Exception ex) {
            log.error("��ѯ�ý�ɫ���е�Ȩ���б��쳣 :"+ ex.getMessage());
        }
        finally {
        	closeSession();
        }
        return lst;
    }

    /**
     * ��ݽ�ɫID��ѯ�ý�ɫ�����е�Ȩ���б� added by liuwei 2006/08/20
     * @param vo RoleAndRightVO
     * @return List
     * @throws BwayHibernateException
     */
    public List queryRightExceptRoleId(RoleAndRightVO vo) throws
        BwayHibernateException
    {
        List lst = null;
        Connection conn = null;
        try {
            conn =currentSession().connection();
            RightInfoDAO dao = new RightInfoDAO(conn);
            lst = dao.queryRightExceptRoleId(vo);
        } catch (BwayHibernateException ex) {
            log.error("��ѯ�ý�ɫ�����Ȩ���б��쳣: "+ex.getMessage());
        } catch (Exception ex2) {
            log.error("��ѯ�ý�ɫ�����Ȩ���б��쳣: "+ex2.getMessage());
        }
        finally {
        	closeSession();
        }
        return lst;
    }

    /**
     * �޸Ľ�ɫ��Ȩ�޵Ĺ�ϵ added by liuwei 2006-8-17
     * @param relationlst ArrayList
     * @return int
     * @throws BwayHibernateException
     */
    public int UpdateRoleAndRightRelation(ArrayList relationlst) throws  BwayHibernateException  {
        int ret = 0;
        Connection conn = null;
        try {
        	conn =currentSession().connection();
            conn.setAutoCommit(false);
            RightInfoDAO dao = new RightInfoDAO(conn);
            if (null != relationlst) {
                RoleAndRightVO rVo = (RoleAndRightVO) relationlst.get(0);
                //�鿴Ȩ���Ƿ��ڴ�
                if(dao.checkRoleAndRightRelation(rVo)){
                	//ɾ��ԭ�н�ɫ��Ȩ�޵Ĺ�ϵ
                    dao.deleteRoleAndRightRelation(rVo);
                }
                Iterator iter = relationlst.iterator();
                //���²����ɫ��Ȩ�޵Ĺ�ϵ
                while (iter.hasNext()) {
                    RoleAndRightVO vo = (RoleAndRightVO)iter.next();
                    dao.saveRoleAndRightRelation(vo);
                    ret++;
                }
                conn.commit();
            }
        } catch (BwayHibernateException ex) {
            try {
                conn.rollback();
            } catch (SQLException ex1) {
            }
            log.error("�޸Ľ�ɫ��Ȩ�޵Ĺ�ϵ�쳣: "+ex.getMessage());
            throw ex;
        } catch (Exception ex2) {
            log.error("�޸Ľ�ɫ��Ȩ�޵Ĺ�ϵ�쳣��"+ex2.getMessage());
        }
        finally {
        	closeSession();
        }
        return ret;
    }
    
	
}