Examples of org.hibernate.Criteria.createAlias()

org.hibernate.Criteria.createAlias()
Join an association, assigning an alias to the joined association.
Functionally equivalent to {@link #createAlias(String,String,JoinType)} using{@link JoinType#INNER_JOIN} for the joinType. @param associationPath A dot-seperated property path @param alias The alias to assign to the joined association (for later reference). @return this (for method chaining) @throws HibernateException Indicates a problem creating the sub criteria

            throw new RollerException("website is null");
        
        try {
            Session session = ((HibernatePersistenceStrategy)this.strategy).getSession();
            Criteria criteria = session.createCriteria(WeblogCategoryAssoc.class);
            criteria.createAlias("category","c");
            
            criteria.add(Expression.eq("c.website", website));
            criteria.add(Expression.isNull("ancestorCategory"));
            criteria.add(Expression.eq("relation", WeblogCategoryAssoc.PARENT));

View Full Code Here

        if (includeRoot) return getWeblogCategories(website);
        
        try {
            Session session = ((HibernatePersistenceStrategy)this.strategy).getSession();
            Criteria criteria = session.createCriteria(WeblogCategoryAssoc.class);
            criteria.createAlias("category", "c");
            criteria.add(Expression.eq("c.website", website));
            criteria.add(Expression.isNotNull("ancestorCategory"));
            criteria.add(Expression.eq("relation", "PARENT"));
            Iterator assocs = criteria.list().iterator();
            List cats = new ArrayList();

View Full Code Here

            Criteria criteria = session.createCriteria(WeblogEntryData.class);
            
            if (website != null) {
                criteria.add(Expression.eq("website", website));
            } else {
                criteria.createAlias("website","w");
                criteria.add(Expression.eq("w.enabled", Boolean.TRUE));
            }
            
            if (startDate != null) {
                criteria.add(

View Full Code Here

        {
            List sameNames;
            try {
                Session session = ((HibernatePersistenceStrategy)this.strategy).getSession();
                Criteria criteria = session.createCriteria(WeblogCategoryAssoc.class);
                criteria.createAlias("category", "c");
                criteria.add(Expression.eq("c.name", cat.getName()));
                criteria.add(Expression.eq("ancestorCategory", parent));
                criteria.add(Expression.eq("relation", Assoc.PARENT));
                sameNames = criteria.list();
            } catch (HibernateException e) {

View Full Code Here

        if (website == null)
            throw new RollerException("website is null");
        try {
            Session session = ((HibernatePersistenceStrategy) strategy).getSession();
            Criteria criteria = session.createCriteria(FolderAssoc.class);
            criteria.createAlias("folder", "f");
            criteria.add(Expression.eq("f.website", website));
            criteria.add(Expression.isNull("ancestorFolder"));
            criteria.add(Expression.eq("relation", FolderAssoc.PARENT));
            List results = criteria.list();
            if (results.size() > 1) {

View Full Code Here

        if (null != parent) {
            List sameNames;
            try {
                Session session = ((HibernatePersistenceStrategy) strategy).getSession();
                Criteria criteria = session.createCriteria(FolderAssoc.class);
                criteria.createAlias("folder", "f");
                criteria.add(Expression.eq("f.name", folder.getName()));
                criteria.add(Expression.eq("ancestorFolder", parent));
                criteria.add(Expression.eq("relation", Assoc.PARENT));
                sameNames = criteria.list();
            } catch (HibernateException e) {

View Full Code Here

        
        try {
            Session session = ((HibernatePersistenceStrategy)this.strategy).getSession();
            Criteria criteria = session.createCriteria(UserData.class);
            if (website != null) {
                criteria.createAlias("permissions","permissions");
                criteria.add(Expression.eq("permissions.website", website));
            }
            if (enabled != null) {
                criteria.add(Expression.eq("enabled", enabled));
            }

View Full Code Here

        
        try {
            Session session = ((HibernatePersistenceStrategy)this.strategy).getSession();
            Criteria criteria = session.createCriteria(WebsiteData.class);
            if (user != null) {
                criteria.createAlias("permissions","permissions");
                criteria.add(Expression.eq("permissions.user", user));
                criteria.add(Expression.eq("permissions.pending", Boolean.FALSE));
            }
            if (enabled != null) {
                criteria.add(Expression.eq("enabled", enabled));

View Full Code Here

    public List<Account> findEmployeesByCriteria(UserSearchCriteria searchCriteria) {
        final Session session = (Session) entityManager.getDelegate();
        final Criteria criteria = session.createCriteria(Account.class);


        criteria.setFetchMode("employee", FetchMode.JOIN);
        criteria.createAlias("employee", "Employee");
        if (searchCriteria.isIsFirstNameSet()) {
            criteria.add(Restrictions.like("Employee.firstName", "%" + searchCriteria.getFirstName() + "%"));
        }
        if (searchCriteria.isIsLastNameSet()) {
            criteria.add(Restrictions.like("Employee.lastName", "%" + searchCriteria.getLastName() + "%"));

View Full Code Here

        if (searchCriteria.isIsParentNameSet()) {
            criteria.add(Restrictions.like("Employee.parentName", "%" + searchCriteria.getParentName() + "%"));
        }
        if (searchCriteria.isIsOfficeSet()) {
            criteria.setFetchMode("Employee.office", FetchMode.JOIN);
            criteria.createAlias("Employee.office", "Offic");
            criteria.add(Restrictions.like("Offic.title", "%" + searchCriteria.getOffice() + "%"));
        }


        return (List<Account>) criteria.list();
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.