dao层实现类的常见写法

记录下一个dao层类的写法，方便以后的使用。

package com.bupt.auth.dao.impl;

import java.util.ArrayList;
import java.util.HashSet;
import java.util.List;
import java.util.Set;
import java.util.concurrent.CopyOnWriteArraySet;

import org.springframework.stereotype.Repository;

import com.bupt.auth.dao.RoleDao;
import com.bupt.auth.dao.base.BaseDaoImpl;
import com.bupt.auth.entity.Permission;
import com.bupt.auth.entity.Role;
import com.bupt.auth.exception.MyException;

@Repository("roleDao")
public class RoleDaoImpl extends BaseDaoImpl<Role> implements RoleDao {

    @Override
    public Role findRoleAdminByUserId(Long id) {
        // TODO Auto-generated method stub
        Role role = this.findRoleByRoleNameAndUserId(id, "administrator");
        
        return role;
    }

    @SuppressWarnings("unchecked")
    @Override
    public List<Role> findRoleByUserId(Long id) {
        // TODO Auto-generated method stub
        String sql = "select r from Role r inner join fetch r.ownerUser u inner join fetch r.accessTokens left join fetch r.permissions where u.id = :id";
        List<Role> list = getSession().createQuery(sql).setLong("id", id).list();
        
        if(list == null || list.size() == 0)
            return null;
        
        List<Role> result = new ArrayList<Role>();
        for(Role role:list){
            if(!result.contains(role))
                result.add(role);
        }
        
        return result;
    }

    @SuppressWarnings("unchecked")
    @Override
    public Role findRoleByRoleNameAndUserId(Long id, String rolename) {
        // TODO Auto-generated method stub
        String sql = "select r from Role r inner join fetch r.ownerUser u inner join fetch r.accessTokens where u.id = :id and r.name = :rolename";
        List<Role> list = getSession().createQuery(sql).setLong("id", id).setString("rolename", rolename).list();
        
        if(list == null || list.size() == 0)
            return null;
        
        return list.get(0);
    }


    @SuppressWarnings("unchecked")
    @Override
    public List<Role> findRoleByPermId(Long id) {
        // TODO Auto-generated method stub
        String sql = "select r from Role r inner join fetch r.ownerUser inner join fetch r.accessTokens inner join fetch r.permissions p where p.id = :id";
        List<Role> list = getSession().createQuery(sql).setLong("id", id).list();
        
        if(list == null || list.size() == 0)
            return null;
        
        List<Role> result = new ArrayList<Role>();
        for(Role role:list){
            if(!result.contains(role))
                result.add(role);
        }
        
        return result;
    }

    @SuppressWarnings("unchecked")
    @Override
    public boolean deleteRolesPermissionByRoleIdAndPermId(Role role,
            Long permid) throws MyException {
        // TODO Auto-generated method stub
        //Role role = this.loadRoleByRoleId(roleid);    
        if(role == null)
            throw new MyException("Role Not Found", "301");
        
        Set<Permission> pset = role.getPermissions();
        
        if(pset == null){
            throw new MyException("Role has no permissions", "");
        }
        if(pset.size() != 0)
        {
            Set<Permission> psetCopy = new HashSet<Permission>(pset);
            
            for(Permission p : psetCopy)
            {
                if(p.getId().longValue() == permid.longValue()){
                    pset.remove(p);
                }
            }
        }
        
        
        this.update(role);
        
        return true;
    }
    
    @Override
    public Set<String> findAccessTokensByRoleId(Long roleid) {
        // TODO Auto-generated method stub
        Role role = this.loadRoleByRoleId(roleid);
        
        if(role == null)
            return null;
        
        return role.getAccessTokens();
    }

    @Override
    public boolean deleteAccessTokenByRoleIdAndTokenString(Long roleid,
            String accessToken) throws MyException {
        // TODO Auto-generated method stub
        Role role = this.loadRoleByRoleId(roleid);
        
        if(role == null)
            throw new MyException("Role Not Found!", "301");
        
        Set<String> accessTokens = role.getAccessTokens();
        accessTokens.remove(accessToken);
        this.update(role);
        
        return true;
    }
    
    @Override
    public Role loadRoleByRoleId(Long roleid){
        String sql = "select r from Role r inner join fetch r.ownerUser inner join fetch r.permissions inner join fetch r.accessTokens where r.id = :id";
        List<Role> list = this.getSession().createQuery(sql).setLong("id", roleid).list();
        
        if(list == null || list.size() == 0){
            String sql2 = "select r from Role r inner join fetch r.ownerUser inner join fetch r.accessTokens where r.id = :id";
            List<Role> list2 = this.getSession().createQuery(sql2).setLong("id", roleid).list();
            
            if(list2 == null || list2.size() == 0){
                return null;
            }
            
            return list2.get(0);
        }
        
        return list.get(0);
    }
}