Examples of org.apache.turbine.util.db.Criteria.addJoin()

Class org.apache.turbine.util.db.Criteria

Examples of org.apache.turbine.util.db.Criteria.addJoin()

org.apache.turbine.util.db.Criteria.addJoin()
This is the way that you should add a join of two tables. For example:
AND PROJECT.PROJECT_ID=FOO.PROJECT_ID
left = PROJECT.PROJECT_ID right = FOO.PROJECT_ID @param left A String with the left side of the join. @param right A String with the right side of the join. @return A modified Criteria object.

        criteria.add(up.getFullColumnName(UserPeer.USERNAME), 
                     user.getUserName());
        criteria.add(UserGroupRolePeer.GROUP_ID, 
                     ((Persistent)group).getPrimaryKey());


        criteria.addJoin(up.getFullColumnName(UserPeer.USER_ID), 
                         UserGroupRolePeer.USER_ID);
        criteria.addJoin(UserGroupRolePeer.ROLE_ID, RolePeer.ROLE_ID);
        return retrieveSet(criteria);
    }

View Full Code Here

        criteria.add(UserGroupRolePeer.GROUP_ID, 
                     ((Persistent)group).getPrimaryKey());


        criteria.addJoin(up.getFullColumnName(UserPeer.USER_ID), 
                         UserGroupRolePeer.USER_ID);
        criteria.addJoin(UserGroupRolePeer.ROLE_ID, RolePeer.ROLE_ID);
        return retrieveSet(criteria);
    }


    /**
     * Issues a select based on a criteria.

View Full Code Here

        throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.add(RolePermissionPeer.ROLE_ID, 
                     ((TurbineRole)role).getPrimaryKey());
        criteria.addJoin(RolePermissionPeer.PERMISSION_ID, 
                         PermissionPeer.PERMISSION_ID);
        return retrieveSet(criteria);
    }


    /**

View Full Code Here

    public static PermissionSet retrieveSet( Role role )
        throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.add(RolePermissionPeer.ROLE_ID, ((TurbineRole)role).getPrimaryKey());
        criteria.addJoin(RolePermissionPeer.PERMISSION_ID, PermissionPeer.PERMISSION_ID);
        return retrieveSet(criteria);
    }


    /**
     * Issues a select based on a criteria.

View Full Code Here

        UserPeer up = ((DBSecurityService)TurbineSecurity.getService())
            .getUserPeerInstance();
        
        criteria.add(up.getFullColumnName(UserPeer.USERNAME), user.getUserName());
        criteria.add(GroupPeer.NAME, group.getName());
        criteria.addJoin(up.getFullColumnName(UserPeer.USER_ID), UserGroupRolePeer.USER_ID);


        criteria.addJoin(GroupPeer.GROUP_ID, UserGroupRolePeer.GROUP_ID);
        criteria.addJoin(UserGroupRolePeer.ROLE_ID, RolePeer.ROLE_ID);
        return retrieveSet(criteria);
    }

View Full Code Here

        
        criteria.add(up.getFullColumnName(UserPeer.USERNAME), user.getUserName());
        criteria.add(GroupPeer.NAME, group.getName());
        criteria.addJoin(up.getFullColumnName(UserPeer.USER_ID), UserGroupRolePeer.USER_ID);


        criteria.addJoin(GroupPeer.GROUP_ID, UserGroupRolePeer.GROUP_ID);
        criteria.addJoin(UserGroupRolePeer.ROLE_ID, RolePeer.ROLE_ID);
        return retrieveSet(criteria);
    }


    /**

View Full Code Here

        criteria.add(up.getFullColumnName(UserPeer.USERNAME), user.getUserName());
        criteria.add(GroupPeer.NAME, group.getName());
        criteria.addJoin(up.getFullColumnName(UserPeer.USER_ID), UserGroupRolePeer.USER_ID);


        criteria.addJoin(GroupPeer.GROUP_ID, UserGroupRolePeer.GROUP_ID);
        criteria.addJoin(UserGroupRolePeer.ROLE_ID, RolePeer.ROLE_ID);
        return retrieveSet(criteria);
    }


    /**
     * Issues a select based on a criteria.

View Full Code Here

        throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.add(RolePermissionPeer.ROLE_ID, 
                     ((TurbineRole)role).getPrimaryKey());
        criteria.addJoin(RolePermissionPeer.PERMISSION_ID, 
                         PermissionPeer.PERMISSION_ID);
        return retrieveSet(criteria);
    }


    /**

View Full Code Here

        criteria.add(up.getFullColumnName(UserPeer.USERNAME), 
                     user.getUserName());
        criteria.add(UserGroupRolePeer.GROUP_ID, 
                     ((Persistent)group).getPrimaryKey());


        criteria.addJoin(up.getFullColumnName(UserPeer.USER_ID), 
                         UserGroupRolePeer.USER_ID);
        criteria.addJoin(UserGroupRolePeer.ROLE_ID, RolePeer.ROLE_ID);
        return retrieveSet(criteria);
    }

View Full Code Here

        criteria.add(UserGroupRolePeer.GROUP_ID, 
                     ((Persistent)group).getPrimaryKey());


        criteria.addJoin(up.getFullColumnName(UserPeer.USER_ID), 
                         UserGroupRolePeer.USER_ID);
        criteria.addJoin(UserGroupRolePeer.ROLE_ID, RolePeer.ROLE_ID);
        return retrieveSet(criteria);
    }


    /**
     * Issues a select based on a criteria.

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.