Example usage for org.hibernate.criterion Projections property

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections property.

Prototype

public static PropertyProjection property(String propertyName) 

Source Link

Document

A property value projection

Usage

From source file:com.nitish.project.springfirst.entity.DAO.impl.VideoDAOImpl.java

@Override
public boolean CheckVideoname(String videoname) {
    Criteria return_VideoName = session.createCriteria(Video.class);
    List<String> Videoname_List = return_VideoName.setProjection(Projections.property("videoname")).list();
    for (int i = 0; i < Videoname_List.size(); i++) {
        if (videoname.equals(Videoname_List.get(i))) {

            return true;

        }/*from w  w w  .  j av  a 2s .c o  m*/
    }

    return false;
}

---

From source file:com.nitish.project.springfirst.entity.DAO.impl.VideoDAOImpl.java

@Override
public String getFolder(int id) {
    List<String> extension_list = session.createCriteria(Video.class)
            .setProjection(Projections.property("file_type")).list();
    List<String> pathlist = session.createCriteria(Video.class).setProjection(Projections.property("FilePath"))
            .list();//from ww w.ja  va  2s.c  o m
    List<Integer> id_list = session.createCriteria(Video.class).setProjection(Projections.property("id"))
            .list();
    for (int i = 0; i < id_list.size(); i++) {
        if (id_list.get(i) == id) {
            return (pathlist.get(i) + ";" + ("video/" + extension_list.get(i)));
        }
    }
    session.close();
    return "problem";
}

---

From source file:com.ongame.pokerstore.model.HibernateStoreDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<String> getOutOfStockProductIds() {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Product.class);
    criteria.add(Restrictions.le("inventory", 0L)).setProjection(Projections.property("id"));
    return (List<String>) criteria.list();
}

---

From source file:com.opiframe.DAO.TeacherDAO.java

public static List<Object[]> getTeacherCourses(String name) {
    List<Object[]> lst = null;
    try {//ww w .j av a2s. c o  m
        ProjectionList projList = Projections.projectionList();
        Session session = HibernateUtil.getSessionFactory().openSession();
        Criteria criteria = session.createCriteria(Teachers.class, "teach");
        criteria.createCriteria("teach.courseses", "courseses");
        projList.add(Projections.property("courseses.courseName"));
        projList.add(Projections.property("courseses.courseId"));
        criteria.setProjection(projList);
        criteria.add(Restrictions.eq("teach.teacherName", name));
        lst = criteria.list();
        session.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return lst;
}

---

From source file:com.orig.gls.admin.role.dao.Role.java

public static int getRoleId(String roleDesc) {
    int roleid = 0;
    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction tx = null;//from  ww  w . j  a v a2  s  . com
    try {
        tx = session.beginTransaction();
        Criteria cr = session.createCriteria(RoleProfileTable.class);
        cr.add(Restrictions.eq("roleDesc", roleDesc));
        roleid = (Integer) cr.setProjection(Projections.property("roleId")).uniqueResult();
        tx.commit();
    } catch (HibernateException asd) {
        log.debug(asd.getMessage());
        if (tx != null) {
            tx.rollback();
        }
    } finally {
        session.close();
    }
    return roleid;

}

---

From source file:com.orig.gls.group.dao.Group.java

public static int getGroupId(String groupCode, String groupName) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction tx = null;/*from   w w w.  j  ava  2 s  .c  om*/
    int groupid = 0;
    try {
        tx = session.beginTransaction();
        Criteria cr = session.createCriteria(GroupsTable.class);
        cr.add(Restrictions.eq("groupCode", groupCode));
        cr.add(Restrictions.eq("groupName", groupName));
        groupid = (Integer) cr.setProjection(Projections.property("groupId")).uniqueResult();
        tx.commit();
    } catch (Exception asd) {
        log.debug(asd.getMessage());
        if (tx != null) {
            tx.rollback();
        }
    } finally {
        session.close();
    }
    return groupid;
}

---

From source file:com.orig.gls.group.dao.Group.java

public static ArrayList getAllVerifiedGroups() {
    ArrayList arr = new ArrayList();
    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction tx = null;//from  w w  w.  ja  va  2 s  .c  o  m
    List<GroupsTable> list;
    try {
        tx = session.beginTransaction();
        DetachedCriteria subquery = DetachedCriteria.forClass(GroupsTableMod.class);
        subquery.setProjection(Projections.property("groupId"));
        Criteria cr = session.createCriteria(GroupsTable.class);
        cr.add(Subqueries.propertyNotIn("groupId", subquery));
        list = cr.list();
        for (GroupsTable group : list) {
            ArrayList one = new ArrayList();
            one.add(group.getGroupCode());
            one.add(String.valueOf(group.getGroupId()));
            one.add(group.getGroupName());
            one.add(sdf.format(group.getRcreTime()));
            one.add(group.getRcreUserId());
            one.add(String.valueOf(group.getSolId()));//5
            one.add(group.getBranchName());//6
            one.add(group.getGrpMgrId());//7
            one.add(group.getGrpRegNo());//8
            one.add(sdf.format(group.getFormationDate()));//9
            one.add(group.getGpRegion());//10
            one.add(group.getGroupCenter());//11
            one.add(group.getGroupVillage());//12
            one.add(group.getGroupAddress());//13
            one.add(group.getGroupPhone());//14
            one.add(sdf.format(group.getFirstMeetDate()));//15
            one.add(sdf.format(group.getNxtMeetDate()));//16
            one.add(group.getMeetTime());//17
            one.add(group.getMeetPlace());//18
            one.add(String.valueOf(group.getMaxAllowedMembers()));//19
            one.add(String.valueOf(group.getMaxAllowedSubGrps()));//20
            String groupchair = "";
            String grouptre = "";
            String groupsec = "";
            if (group.getGpChair() != null) {
                groupchair = group.getGpChair();
            }
            if (group.getGpTreasurer() != null) {
                grouptre = group.getGpTreasurer();
            }
            if (group.getGpSecretary() != null) {
                groupsec = group.getGpSecretary();
            }
            one.add(groupchair);//21
            one.add(grouptre);//22
            one.add(groupsec);//23
            one.add(group.getGpStatus());//24
            one.add(group.getGpStatusCode());//25
            one.add(String.valueOf(group.getNoOfMembers()));//26
            one.add(group.getMeetFrequency());//27
            one.add(String.valueOf(group.getSavingAccounts()));//28
            one.add(String.valueOf(group.getSavingsAmt()));//29
            one.add(String.valueOf(group.getLoanAccounts()));//30
            one.add(String.valueOf(group.getOutstandingBal()));//31
            arr.add(one);
        }
        tx.commit();
    } catch (Exception asd) {
        log.debug(asd.getMessage());
        if (tx != null) {
            tx.rollback();
        }
    } finally {
        session.close();
    }
    return arr;
}

---

From source file:com.orig.gls.subgroup.dao.SubGroup.java

public static int getsubGroupId(String groupCode, String groupName) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction tx = null;//from  w w w . ja va2 s .c om
    int groupid = 0;
    try {
        tx = session.beginTransaction();
        Criteria cr = session.createCriteria(SubGrpTable.class);
        cr.add(Restrictions.eq("subGroupCode", groupCode));
        cr.add(Restrictions.eq("subGroupName", groupName));
        groupid = (Integer) cr.setProjection(Projections.property("subGroupId")).uniqueResult();
        tx.commit();
    } catch (Exception asd) {
        log.debug(asd.getMessage());
        if (tx != null) {
            tx.rollback();
        }
    } finally {
        session.close();
    }
    return groupid;
}

---

From source file:com.orig.gls.subgroup.dao.SubGroup.java

public static ArrayList getAllVerifiedSubGroups() {
    ArrayList arr = new ArrayList();
    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction tx = null;/* w w w . j  a v a 2 s  . co  m*/
    List<SubGrpTable> list;
    try {
        tx = session.beginTransaction();
        DetachedCriteria subquery = DetachedCriteria.forClass(SubGrpTableMod.class);
        subquery.setProjection(Projections.property("subGroupId"));
        Criteria cr = session.createCriteria(SubGrpTable.class);
        cr.add(Subqueries.propertyNotIn("subGroupId", subquery));
        list = cr.list();
        for (SubGrpTable group : list) {
            ArrayList one = new ArrayList();
            one.add(group.getSubGroupCode());
            one.add(String.valueOf(group.getSubGroupId()));
            one.add(group.getSubGroupName());
            one.add(sdf.format(group.getRcreTime()));
            one.add(group.getRcreUserId());
            one.add(String.valueOf(group.getSolId()));//5
            one.add(group.getBranchName());//6
            one.add(group.getSubGrpMgrId());//7
            one.add(group.getSubGrpRegNo());//8
            one.add(sdf.format(group.getFormationDate()));//9
            one.add(group.getSubGpRegion());//10
            one.add(group.getSubGroupCenter());//11
            one.add(group.getSubGroupVillage());//12
            one.add(group.getSubGroupAddress());//13
            one.add(group.getSubGroupPhone());//14
            one.add(sdf.format(group.getFirstMeetDate()));//15
            one.add(sdf.format(group.getNxtMeetDate()));//16
            one.add(group.getMeetTime());//17
            one.add(group.getMeetPlace());//18
            one.add(String.valueOf(group.getMaxAllowedMembers()));//19
            String groupchair = "";
            String grouptre = "";
            String groupsec = "";
            if (group.getSubGpChair() != null) {
                groupchair = group.getSubGpChair();
            }
            if (group.getSubGpTreasurer() != null) {
                grouptre = group.getSubGpTreasurer();
            }
            if (group.getSubGpSecretary() != null) {
                groupsec = group.getSubGpSecretary();
            }
            one.add(groupchair);//21
            one.add(grouptre);//22
            one.add(groupsec);//23
            one.add(group.getSubGpStatus());//24
            one.add(group.getSubGpStatusCode());//25
            one.add(String.valueOf(group.getNoOfMembers()));//26
            one.add(group.getMeetFrequency());//27
            one.add(String.valueOf(group.getSavingAccounts()));//28
            one.add(String.valueOf(group.getSavingsAmt()));//29
            one.add(String.valueOf(group.getLoanAccounts()));//30
            one.add(String.valueOf(group.getOutstandingBal()));//31
            List<GroupsTable> lgs = Group.getgroupDetails(group.getGroupId());
            String groupcode = "";
            String groupname = "";
            for (GroupsTable lg : lgs) {
                groupcode = lg.getGroupCode();
                groupname = lg.getGroupName();
            }
            one.add(groupcode);
            one.add(groupname);
            arr.add(one);
        }
        tx.commit();
    } catch (Exception asd) {
        log.debug(asd.getMessage());
        if (tx != null) {
            tx.rollback();
        }
    } finally {
        session.close();
    }
    return arr;
}

---

From source file:com.painiu.core.dao.hibernate.PhotoDAOHibernate.java

License:Open Source License

static Criteria buildPhotoCriteria(final Session session, User user, String[] tags, boolean taggedAll,
        String text, Relation relation, boolean count) {
    Criteria criteria = session.createCriteria(Photo.class);

    if (user != null) {
        criteria.add(Restrictions.eq("user", user));

        if (relation != null) {
            criteria.add(/*from   w w  w.  j av a2 s .  c  om*/
                    Restrictions.sqlRestriction(" {alias}.privacy & ? > 0", relation, UserTypes.relation()));
        }
    } else {
        criteria.add(
                Restrictions.sqlRestriction(" {alias}.privacy & ? > 0", Relation.NONE, UserTypes.relation()));

        criteria.setFetchMode("user", FetchMode.JOIN);
    }

    //if (user == null && group == null) {
    if (user == null) {
        Disjunction disjState = Restrictions.disjunction();

        disjState.add(Restrictions.eq("state", Photo.State.USER_POPULAR));
        disjState.add(Restrictions.eq("state", Photo.State.USER_COMMENDATORY));
        disjState.add(Restrictions.eq("state", Photo.State.USER_SENIOR));

        criteria.add(disjState);
    }

    //if (album != null) {
    //   criteria.createAlias("albumPhotos", "ap");
    //   criteria.add( Restrictions.eq("ap.album", album) );
    //}

    //if (group != null) {
    //   criteria.createAlias("groupPhotos", "gp");
    //   criteria.add( Restrictions.eq("gp.group", group) );
    //}

    if ((tags != null && tags.length > 0) || text != null) {
        Criteria subCriteria = criteria.createCriteria("photoTags", "tags");

        if (tags != null && tags.length > 0) {
            if (taggedAll) {
                Conjunction conj = Restrictions.conjunction();
                for (int i = 0; i < tags.length; i++) {
                    conj.add(Restrictions.eq("tagName", tags[i]));
                }
                subCriteria.add(conj);
            } else {
                Disjunction disj = Restrictions.disjunction();
                for (int i = 0; i < tags.length; i++) {
                    disj.add(Restrictions.eq("tagName", tags[i]));
                }
                subCriteria.add(disj);
            }
        }

        if (text != null) {
            Disjunction disj = Restrictions.disjunction();

            disj.add(Restrictions.like("title", text, MatchMode.ANYWHERE));
            disj.add(Restrictions.like("description", text, MatchMode.ANYWHERE));
            disj.add(Restrictions.eq("tags.tagName", text));

            criteria.add(disj);
        }
    }

    // TODO order parameters
    if (!count) {
        /*if (album != null) {
           criteria.addOrder(Order.asc("ap.position"));
        } else*/
        /*if (group != null) {
           criteria.addOrder(Order.asc("gp.position"));
        } else {*/
        criteria.addOrder(Order.desc("timestamp"));
        //}
    }
    // distinct ?
    if ((tags != null && tags.length > 1) || text != null) {
        ProjectionList proj = Projections.projectionList();

        proj.add(Projections.property("id")).add(Projections.property("title"))
                .add(Projections.property("width")).add(Projections.property("height"))
                .add(Projections.property("address.host")).add(Projections.property("address.dir"))
                .add(Projections.property("address.filename")).add(Projections.property("address.secret"))
                .add(Projections.property("address.username")).add(Projections.property("address.fileKey"));

        if (user == null) {
            criteria.createAlias("user", "user");
            proj.add(Projections.property("user.id")).add(Projections.property("user.username"))
                    .add(Projections.property("user.nickname")).add(Projections.property("user.buddyIcon.host"))
                    .add(Projections.property("user.buddyIcon.dir"))
                    .add(Projections.property("user.buddyIcon.filename"))
                    .add(Projections.property("user.buddyIcon.username"))
                    .add(Projections.property("user.buddyIcon.fileKey"));
        }

        criteria.setProjection(Projections.distinct(proj));

        criteria.setResultTransformer(new PhotoBeanResultTransformer());
    }

    return criteria;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »