Example usage for org.hibernate.criterion DetachedCriteria forClass

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria forClass.

Prototype

public static DetachedCriteria forClass(Class clazz)

Source Link

Document

Static builder to create a DetachedCriteria for the given entity, by its Class.

Usage

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 ww. ja v  a 2s .com*/
    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 ArrayList getAllVerifiedSubGroups() {
    ArrayList arr = new ArrayList();
    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction tx = null;//from   www  .j a  v  a  2 s  .  c o  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.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public void addEmployeeGroupMap(String employeeId, String groupId) throws ExceptionWrapper {
    try {// w ww . ja  va  2  s .co  m

        DetachedCriteria criteria = DetachedCriteria.forClass(Employee.class);
        criteria.add(Restrictions.eq("employeeId", Long.parseLong(employeeId.trim())));
        Employee employee = (Employee) hibernateTemplate.findByCriteria(criteria).get(0);

        criteria = DetachedCriteria.forClass(Groups.class);
        criteria.add(Restrictions.eq("groupId", Integer.valueOf(groupId.trim())));
        Groups groups = (Groups) hibernateTemplate.findByCriteria(criteria).get(0);

        Employeegroupmap employeegroupmap = new Employeegroupmap(employee, groups);
        hibernateTemplate.save(employeegroupmap);
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public ArrayList<Employeegroupmap> getEmployeegroupmapByEmployeeID(String employeeId) throws ExceptionWrapper {
    ArrayList<Employeegroupmap> employeegroupmapArrayList = new ArrayList<Employeegroupmap>();
    try {//ww w . ja v a 2s.  co  m
        DetachedCriteria criteria = DetachedCriteria.forClass(Employeegroupmap.class);
        criteria.createAlias("employee", "emp");
        criteria.add(Restrictions.eq("emp.employeeId", Long.valueOf(employeeId)));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("groups", FetchMode.JOIN);
        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            employeegroupmapArrayList.add((Employeegroupmap) item);
        }
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return employeegroupmapArrayList;
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public void addEmployeeLicenseMap(String employeeId, String licenseId) throws ExceptionWrapper {
    try {//  www  . ja v  a  2  s .c o m
        DetachedCriteria criteria = DetachedCriteria.forClass(Employee.class);
        criteria.add(Restrictions.eq("employeeId", Long.parseLong(employeeId.trim())));
        Employee employee = (Employee) hibernateTemplate.findByCriteria(criteria).get(0);

        criteria = DetachedCriteria.forClass(Licensemaster.class);
        criteria.add(Restrictions.eq("licenseTypeId", Long.valueOf(licenseId.trim())));
        Licensemaster licensemaster = (Licensemaster) hibernateTemplate.findByCriteria(criteria).get(0);
        Employeelicensemapping employeelicensemapping = new Employeelicensemapping(employee, licensemaster);
        hibernateTemplate.save(employeelicensemapping);
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public ArrayList<Employeelicensemapping> getEmployeeLicenseMapByEmployeeId(String employeeId)
        throws ExceptionWrapper {
    ArrayList<Employeelicensemapping> employeelicensemappingArrayList = new ArrayList<Employeelicensemapping>();
    try {//from   w ww  . j  a v  a  2 s. co m
        DetachedCriteria criteria = DetachedCriteria.forClass(Employeelicensemapping.class);
        criteria.createAlias("employee", "emp");
        criteria.add(Restrictions.eq("emp.employeeId", Long.valueOf(employeeId)));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("licensemaster", FetchMode.JOIN);
        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            employeelicensemappingArrayList.add((Employeelicensemapping) item);
        }
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return employeelicensemappingArrayList;
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public void updateEmployee(EmployeeBO employeeBO) throws ExceptionWrapper {
    try {/*  w  ww . ja v  a 2  s.c om*/
        DetachedCriteria criteria = DetachedCriteria.forClass(Employee.class);
        criteria.add(Restrictions.eq("employeeId", Long.parseLong(employeeBO.getEmployeeId())));
        criteria.setFetchMode("employeelicensemappings", FetchMode.JOIN);
        criteria.setFetchMode("employeegroupmaps", FetchMode.JOIN);
        criteria.setFetchMode("employeerolemappings", FetchMode.JOIN);

        Employee employee = (Employee) hibernateTemplate.findByCriteria(criteria).get(0);

        employee.setEmail(employeeBO.getEmail());
        employee.setEmployeeName(employeeBO.getEmployeeName());
        employee.setEmployeeUid(employeeBO.getEmployeeUid());
        employee.setJobTitle(employeeBO.getJobTitle());
        employee.setMobileNumber(employeeBO.getMobileNumber());
        employee.setManager(employeeBO.getManager());
        employee.setManagerEmail(employeeBO.getManagerEmail());
        //employee.setExtensionNum(employeeBO.getExtensionNum());
        //employee.setWorkspace(employeeBO.getWorkspace());
        employee.setIsActive(employeeBO.isActive());
        hibernateTemplate.update(employee);
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public LinkedHashMap<Long, EmployeeBO> getAllEmployeesByTemplate() throws ExceptionWrapper {
    LinkedHashMap<Long, EmployeeBO> employeeLinkedHashMap = new LinkedHashMap<Long, EmployeeBO>();

    try {// w ww.  ja  va2s.  c om
        DetachedCriteria criteria = DetachedCriteria.forClass(Employee.class);
        criteria.add(Restrictions.eq("isActive", true));
        criteria.addOrder(Order.asc("employeeName"));

        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            Employee employee = (Employee) item;
            EmployeeBO employeeBO = new EmployeeBO(employee);

            //Get the group information for the employee
            for (Object obj : employee.getEmployeegroupmaps()) {
                Employeegroupmap employeegroupmap = (Employeegroupmap) obj;
                employeegroupmap = hibernateTemplate.get(Employeegroupmap.class,
                        employeegroupmap.getEmployeeGroupMappingId());
                GroupBO groupBO = new GroupBO(employeegroupmap.getGroups());
                employeeBO.getGroups().add(groupBO);
            }
            //==================================================================================================================
            //Get the license info for the employee
            for (Object obj : employee.getEmployeelicensemappings()) {
                Employeelicensemapping employeelicensemapping = (Employeelicensemapping) obj;
                LicenseBO licenseBO = new LicenseBO(employeelicensemapping.getLicensemaster());
                employeeBO.getLicenses().add(licenseBO);
            }
            //==================================================================================================================
            employeeLinkedHashMap.put(Long.valueOf(employee.getEmployeeId()), employeeBO);
        }

    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return employeeLinkedHashMap;
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.ImageNowLicenseDataAccessor.java

public LinkedHashMap<String, Imagenowlicenses> getAllImageNowLicenses() throws ExceptionWrapper {
    LinkedHashMap<String, Imagenowlicenses> imagenowlicensesLinkedHashMap = new LinkedHashMap<String, Imagenowlicenses>();
    try {//from w  w  w.j  av  a2s  .  c o m
        DetachedCriteria criteria = DetachedCriteria.forClass(Imagenowlicenses.class);
        criteria.createAlias("employeeByRequestedByEmployeeId", "emp");
        criteria.createAlias("groups", "group");
        criteria.addOrder(Order.asc("licenseRequestedOn"));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("group", FetchMode.JOIN);
        criteria.addOrder(Order.asc("licenseRequestedOn"));
        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            Imagenowlicenses imagenowlicenses = (Imagenowlicenses) item;
            imagenowlicensesLinkedHashMap.put(imagenowlicenses.getImageNowLicenseRequestId(), imagenowlicenses);
        }
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return imagenowlicensesLinkedHashMap;
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.ImageNowLicenseDataAccessor.java

public LinkedHashMap<String, Imagenowlicenses> getAllImageNowLicensesByRequestor(String employeeUID)
        throws ExceptionWrapper {
    LinkedHashMap<String, Imagenowlicenses> imagenowlicensesLinkedHashMap = new LinkedHashMap<String, Imagenowlicenses>();
    try {/*from  w  ww. ja v  a 2  s  .  c  om*/
        DetachedCriteria criteria = DetachedCriteria.forClass(Imagenowlicenses.class);
        criteria.createAlias("employeeByRequestedByEmployeeId", "emp");
        criteria.createAlias("groups", "group");
        criteria.add(Restrictions.eq("emp.employeeUid", employeeUID));
        criteria.addOrder(Order.asc("licenseRequestedOn"));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("group", FetchMode.JOIN);
        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            Imagenowlicenses imagenowlicenses = (Imagenowlicenses) item;
            imagenowlicensesLinkedHashMap.put(imagenowlicenses.getImageNowLicenseRequestId(), imagenowlicenses);
        }
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return imagenowlicensesLinkedHashMap;
}