Examples of com.eforce.baby.auth.vo.UserPrivilegeList

    }
    
    
    public UserPrivilegeList findUserPrivileges(String dsName, String dbType, String userLogin) throws DAOException
    {
        UserPrivilegeList privList = new UserPrivilegeList();
        
        Connection con         = null;
        PreparedStatement stmt = null;
        ResultSet rset         = null;
        
        try
        {
            con = super.createConnection(dsName);
            String sql = QueryManager.getInstance().getFindUserPrivilegesQuery(dbType);
            
            stmt = con.prepareStatement(sql);
            stmt.setString(1, userLogin);
            rset = stmt.executeQuery();        
            
            PrivilegeVO privilegeVO = null;
            
            while (rset.next())
            {
                privilegeVO = new PrivilegeVO();
                privilegeVO.setPrivilegeId(rset.getString(1));
                privilegeVO.setPrivilegeName(rset.getString(2));
                privilegeVO.setPrivilegeType(rset.getString(3));
                privilegeVO.setAccessLevel(rset.getString(4));
                privilegeVO.setDescription(rset.getString(5));
                
                privList.addPrivilege(privilegeVO.getPrivilegeName(), privilegeVO);
            }
    
        }
        catch(SQLException se)
        {

            userSess.setCustomer(cvo); 
            userSess.setDsName(cvo.getDatasourceName());
            userSess.setDbType(cvo.getDatabaseType()); 
            
            // get user privileges
            UserPrivilegeList userPrivileges = userBD.findUserPrivileges(cvo.getDatasourceName(), cvo.getDatabaseType(), userVO.getUserName());
            
            HttpSession session = request.getSession();
            
            if(userSess.getProfileId() == null)
            {

Examples of com.eforce.baby.auth.vo.UserPrivilegeList

Related Classes of com.eforce.baby.auth.vo.UserPrivilegeList