Example usage for org.hibernate Query setParameterList

List of usage examples for org.hibernate Query setParameterList

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.*
  5. Query
  6. setParameterList

Introduction

In this page you can find the example usage for org.hibernate Query setParameterList.

Prototype

Query<R> setParameterList(int position, Object[] values);

Source Link

Usage

From source file:com.viettel.vsaadmin.database.DAO.UsersDAO.java

License:Open Source License

/**
 * action xu ly khoa nguoi dung/*w  ww . j a  v a 2 s.  c o m*/
 *
 * @return
 */
public String onLock() {
    //        try {
    //            UsersDAOHE.removeCache();
    //            Session session = getSession();
    //            HttpServletRequest req = getRequest();
    //            String strUsers = req.getParameter("userId");
    //            String ignore = req.getParameter("ignore");
    //            int succ = 0;
    //            if (StringUtils.validString(strUsers)) {
    //                String hql = " update Users a set a.status = 0 where a.userId in (" + strUsers + ")";
    //                Query q = session.createQuery(hql);
    //                succ = q.executeUpdate();
    //            }
    //            jsonDataGrid = createMsgUpdateStatus(succ, Integer.parseInt(ignore), new String[]{"Kha", "kha"});
    //        } catch (Exception ex) {
    //            System.out.println(ex.getMessage());
    //            jsonDataGrid = createMsgUpdate(0, 2);
    //        }
    //140123 binhnt update
    try {
        UsersDAOHE.removeCache();
        Session session = getSession();
        HttpServletRequest req = getRequest();
        String strUsers = req.getParameter("userId");
        String[] arrUsers = strUsers.split(",");
        List<Long> lstUsers = new ArrayList<Long>();
        if (arrUsers.length > 0) {
            for (int i = 0; i < arrUsers.length; i++) {
                try {
                    Long l = Long.parseLong(arrUsers[i]);
                    lstUsers.add(l);
                } catch (Exception ex) {
                    LogUtil.addLog(ex);//binhnt sonar a160901
                }
            }
        }
        String ignore = req.getParameter("ignore");
        int succ = 0;
        if (StringUtils.validString(strUsers)) {
            String hql = " update Users a set a.status = 0 where a.userId in (:lstUsers)";
            Query q = session.createQuery(hql);
            q.setParameterList("lstUsers", lstUsers);
            succ = q.executeUpdate();
        }
        jsonDataGrid = createMsgUpdateStatus(succ, Integer.parseInt(ignore), new String[] { "Kha", "kha" });
    } catch (Exception ex) {
        LogUtil.addLog(ex);//binhnt sonar a160901
        //            log.error(ex.getMessage());
        jsonDataGrid = createMsgUpdate(0, 2);
    }
    //!binhnt
    return "gridData";
}

From source file:com.viettel.vsaadmin.database.DAO.UsersDAO.java

License:Open Source License

/**
 * Action xu ly mo khoa nguoi dung/* w w  w.  j ava  2  s  .  co m*/
 *
 * @return
 */
public String onUnLock() {
    //        try {
    //            UsersDAOHE.removeCache();
    //            Session session = getSession();
    //            HttpServletRequest req = getRequest();
    //            String strUsers = req.getParameter("userId");
    //            String ignore = req.getParameter("ignore");
    //            int succ = 0;
    //            if (StringUtils.validString(strUsers)) {
    //                String hql = " update Users a set a.status = 1 where a.userId in (" + strUsers + ")";
    //                Query q = session.createQuery(hql);
    //                succ = q.executeUpdate();
    //            }
    //            jsonDataGrid = createMsgUpdateStatusUnlock(succ, Integer.parseInt(ignore), new String[]{"M kha", "hot ng"});
    //        } catch (Exception ex) {
    //            log.error(ex.getMessage());
    //            jsonDataGrid = createMsgUpdate(0, 2);
    //        }
    try {
        UsersDAOHE.removeCache();
        Session session = getSession();
        HttpServletRequest req = getRequest();
        String strUsers = req.getParameter("userId");
        String[] arrUsers = strUsers.split(",");
        List<Long> lstUsers = new ArrayList<Long>();
        if (arrUsers.length > 0) {
            for (int i = 0; i < arrUsers.length; i++) {
                try {
                    Long l = Long.parseLong(arrUsers[i]);
                    lstUsers.add(l);
                } catch (Exception ex) {
                    LogUtil.addLog(ex);//binhnt sonar a160901
                }
            }
        }
        String ignore = req.getParameter("ignore");
        int succ = 0;
        if (StringUtils.validString(strUsers)) {
            String hql = " update Users a set a.status = 1 where a.userId in (:lstUsers)";
            Query q = session.createQuery(hql);
            q.setParameterList("lstUsers", lstUsers);
            succ = q.executeUpdate();
        }
        jsonDataGrid = createMsgUpdateStatusUnlock(succ, Integer.parseInt(ignore),
                new String[] { "M kha", "hot ng" });
    } catch (Exception ex) {
        LogUtil.addLog(ex);//binhnt sonar a160901
        //            log.error(ex.getMessage());
        jsonDataGrid = createMsgUpdate(0, 2);
    }
    return "gridData";
}

From source file:com.viettel.vsaadmin.database.DAO.UsersDAO.java

License:Open Source License

/**
 * Action xu ly xoa bo vai tro cua nguoi dung
 *
 * @return//w  w w.ja v  a2s.c  o m
 */
public String removeRole() {

    try {
        HttpServletRequest req = getRequest();
        Session session = getSession();
        String strRoleId = req.getParameter("roleId");
        String strRoleUserDeptId = req.getParameter("roleUserDeptId");
        Long userId = 0l;

        try {
            userId = Long.parseLong(req.getParameter("userId"));
        } catch (Exception ex) {
            LogUtil.addLog(ex);//binhnt sonar a160901
            //                System.out.print(en.getMessage());
            userId = 0l;
        }

        Users user = null;
        try {
            user = getUserById(userId);
        } catch (Exception ex) {
            LogUtil.addLog(ex);//binhnt sonar a160901
            //                log.error(ex.getMessage());
        }
        //            Long departmentId = 0L;
        if (user != null) {
            user.getDeptId();
        }

        if (userId != null && userId > 0 && strRoleId != null && (!"".equals(strRoleId))) {

            String[] roleUserDeptIdStr = strRoleUserDeptId.split(",");
            List<Long> lstRoleUserDeptIds = new ArrayList<Long>();

            if (roleUserDeptIdStr.length > 0) {
                for (int i = 0; i < roleUserDeptIdStr.length; i++) {
                    try {
                        Long l = Long.parseLong(roleUserDeptIdStr[i]);
                        lstRoleUserDeptIds.add(l);
                    } catch (Exception ex) {
                        LogUtil.addLog(ex);//binhnt sonar a160901
                    }
                }
            }

            String hql = " delete from RoleUserDept a where a.userId = :userId  and a.roleUserDeptId in (:lstRoleUserDept)";
            Query q = session.createQuery(hql);
            q.setParameter("userId", userId);
            q.setParameterList("lstRoleUserDept", lstRoleUserDeptIds);
            q.executeUpdate();
            getSession().flush();

            hql = " delete from RoleUser a where a.userId = :userId  and a.roleId in (:lstRole) and a.roleId not in (select rud.roleId from RoleUserDept rud where rud.isActive = 1 and rud.userId =:userIdOfRUD)";

            String[] roleIdStr = strRoleId.split(",");
            List<Long> lstRoleIds = new ArrayList<Long>();
            if (roleIdStr.length > 0) {
                for (int i = 0; i < roleIdStr.length; i++) {
                    try {
                        Long l = Long.parseLong(roleIdStr[i]);
                        lstRoleIds.add(l);
                    } catch (Exception ex) {
                        LogUtil.addLog(ex);//binhnt sonar a160901
                    }
                }
            }

            q = session.createQuery(hql);
            q.setParameter("userId", userId);

            q.setParameterList("lstRole", lstRoleIds);
            q.setParameter("userIdOfRUD", userId);

            q.executeUpdate();

            GridResult result = getRoleUserDept(userId);
            this.jsonDataGrid.setItems(result.getLstResult());
            this.jsonDataGrid.setTotalRows(result.getnCount().intValue());
        }
    } catch (Exception ex) {
        LogUtil.addLog(ex);//binhnt sonar a160901
        //            log.error(ex.getMessage());
    }
    return "gridData";
}

From source file:com.viettel.vsaadmin.database.DAO.UsersDAO.java

License:Open Source License

/**
 * Action xu ly khoa role cua nguoi dung
 *
 * @return//  w  w w . j a  v a2s .com
 */
public String lockRole() {
    try {
        HttpServletRequest req = getRequest();
        Session session = getSession();
        String strRoleId = req.getParameter("roleId");
        String strRoleUserDeptId = req.getParameter("roleUserDeptId");
        String ignore = req.getParameter("ignore");
        int succ = 0;
        Long userId = Long.parseLong(req.getParameter("userId"));

        if (userId != null && userId > 0 && StringUtils.validString(strRoleId)) {

            String[] roleIdStr = strRoleId.split(",");
            List<Long> lstRoleIds = new ArrayList<Long>();

            if (roleIdStr.length > 0) {
                for (int i = 0; i < roleIdStr.length; i++) {
                    try {
                        Long l = Long.parseLong(roleIdStr[i]);
                        lstRoleIds.add(l);
                    } catch (Exception ex) {
                        LogUtil.addLog(ex);//binhnt sonar a160901
                    }
                }
            }

            String[] roleUserDeptIdStr = strRoleUserDeptId.split(",");
            List<Long> lstRoleUserDeptIds = new ArrayList<Long>();

            if (roleUserDeptIdStr.length > 0) {
                for (int i = 0; i < roleUserDeptIdStr.length; i++) {
                    try {
                        Long l = Long.parseLong(roleUserDeptIdStr[i]);
                        lstRoleUserDeptIds.add(l);
                    } catch (Exception ex) {
                        LogUtil.addLog(ex);//binhnt sonar a160901
                    }
                }
            }

            String hql = " update RoleUserDept a set a.isActive = 0  where a.userId = :userId  and a.roleUserDeptId in (:lstRoleUserDept)";
            Query q = session.createQuery(hql);
            q.setParameter("userId", userId);
            q.setParameterList("lstRoleUserDept", lstRoleUserDeptIds);
            q.executeUpdate();
            getSession().flush();
            //
            // Lock cac role
            //
            hql = " update RoleUser a set a.isActive = 0  where a.userId = :userId  and a.roleId in (:lstRole) and a.roleId not in (select rud.roleId from RoleUserDept rud where rud.isActive = 1 and rud.userId =:userIdOfRUD)";

            q = session.createQuery(hql);
            q.setParameter("userId", userId);

            q.setParameterList("lstRole", lstRoleIds);
            q.setParameter("userIdOfRUD", userId);

            q.executeUpdate();
            //
            // end of lock role
            //

            GridResult result = getRoleUserDept(userId);
            this.jsonDataGrid.setItems(result.getLstResult());
            this.jsonDataGrid.setTotalRows(result.getnCount().intValue());
        }
        jsonDataGrid = createMsgUpdateStatus(succ, Integer.parseInt(ignore), new String[] { "Kha", "kha" });
    } catch (Exception ex) {
        LogUtil.addLog(ex);//binhnt sonar a160901
        //            log.error(ex.getMessage());
        jsonDataGrid = createMsgUpdate(0, 2);
    }
    return "gridData";
}

From source file:com.viettel.vsaadmin.database.DAO.UsersDAO.java

License:Open Source License

/**
 * aciton xu ly mo khoa vai tro cua nguoi dung
 *
 * @return/* w w w  .jav  a 2  s . c  o  m*/
 */
public String unLockRole() {
    try {
        HttpServletRequest req = getRequest();
        Session session = getSession();
        String strRoleId = req.getParameter("roleId");
        String strRoleUserDeptId = req.getParameter("roleUserDeptId");
        String ignore = req.getParameter("ignore");
        int succ = 0;
        Long userId = Long.parseLong(req.getParameter("userId"));

        if (userId != null && userId > 0 && StringUtils.validString(strRoleId)) {

            String[] roleUserDeptIdStr = strRoleUserDeptId.split(",");
            List<Long> lstRoleUserDeptIds = new ArrayList<Long>();

            if (roleUserDeptIdStr.length > 0) {
                for (int i = 0; i < roleUserDeptIdStr.length; i++) {
                    try {
                        Long l = Long.parseLong(roleUserDeptIdStr[i]);
                        lstRoleUserDeptIds.add(l);
                    } catch (Exception ex) {
                        LogUtil.addLog(ex);//binhnt sonar a160901
                    }
                }
            }

            String hql = " update RoleUserDept a set a.isActive = 1  where a.userId = :userId  and a.roleUserDeptId in (:lstRoleUserDept)";
            Query q = session.createQuery(hql);
            q.setParameter("userId", userId);
            q.setParameterList("lstRoleUserDept", lstRoleUserDeptIds);
            q.executeUpdate();
            getSession().flush();

            hql = " update RoleUser a set a.isActive = 1  where a.userId = :userId  and a.roleId in (:lstRole)";

            String[] roleIdStr = strRoleId.split(",");
            List<Long> lstRoleIds = new ArrayList<Long>();
            if (roleIdStr.length > 0) {
                for (int i = 0; i < roleIdStr.length; i++) {
                    try {
                        Long l = Long.parseLong(roleIdStr[i]);
                        lstRoleIds.add(l);
                    } catch (Exception ex) {
                        LogUtil.addLog(ex);//binhnt sonar a160901
                    }
                }
            }

            q = session.createQuery(hql);
            q.setParameter("userId", userId);

            q.setParameterList("lstRole", lstRoleIds);

            q.executeUpdate();

            GridResult result = getRoleUserDept(userId);
            this.jsonDataGrid.setItems(result.getLstResult());
            this.jsonDataGrid.setTotalRows(result.getnCount().intValue());
        }
        jsonDataGrid = createMsgUpdateStatusUnlock(succ, Integer.parseInt(ignore),
                new String[] { "M kha", "hot ng" });
    } catch (Exception ex) {
        LogUtil.addLog(ex);//binhnt sonar a160901
        //            log.error(ex.getMessage());
        jsonDataGrid = createMsgUpdate(0, 2);
    }
    return "gridData";
}

From source file:com.viettel.vsaadmin.database.DAOHibernate.DepartmentDAOHE.java

License:Open Source License

public List<DepartmentForm> searchDeptByIds(String ids) {
    String[] idLst = ids.split(";");
    List<Long> idLstLong = new ArrayList<Long>();
    for (int i = 0; i < idLst.length; i++) {
        if (idLst[i] != null && !"".equals(idLst[i])) {
            idLstLong.add(Long.valueOf(idLst[i]));
        }// ww w .  j  ava2 s. c  om
    }

    String hql = "select d from Department d where d.deptId in (:deptListId)";
    Query query = getSession().createQuery(hql);
    query.setParameterList("deptListId", idLstLong);
    List<Department> lst;
    List<DepartmentForm> result = new ArrayList<DepartmentForm>();
    lst = query.list();

    //escapeHTML
    if (lst != null && lst.size() > 0) {
        for (Department dept : lst) {
            DepartmentForm deptForm = new DepartmentForm(dept);
            result.add(deptForm);
        }
    }
    return result;
}

From source file:com.viettel.vsaadmin.database.DAOHibernate.DepartmentDAOHE.java

License:Open Source License

/**
 *
 * @return//from   w  w w .j a va2  s .com
 */
public List<Department> getDeptListByParentId(Long parentId, List<Long> listDeptId, List<Long> deptTypeIds) {
    StringBuilder strBuilder = new StringBuilder();
    strBuilder.append(" SELECT d FROM Department d");
    strBuilder.append(" WHERE d.status =:ACTIVE");
    if (parentId != null) {
        strBuilder.append(" AND d.parentId =:parentId");
    } else {
        strBuilder.append(" AND d.parentId IS NULL");
    }
    if (listDeptId != null && listDeptId.size() > 0) {
        strBuilder.append(" AND d.deptId IN (:deptIds)");
    }
    if (deptTypeIds != null && deptTypeIds.size() > 0) {
        strBuilder.append(" AND d.deptTypeId IN (:deptTypeIds)");
    }
    strBuilder.append(" order by nlssort(lower(d.deptName),'nls_sort = Vietnamese')");

    Query query = getSession().createQuery(strBuilder.toString());
    query.setParameter("ACTIVE", Constants.Status.ACTIVE);
    if (parentId != null) {
        query.setParameter("parentId", parentId);
    }
    if (listDeptId != null && listDeptId.size() > 0) {
        query.setParameterList("deptIds", listDeptId);
    }
    if (deptTypeIds != null && deptTypeIds.size() > 0) {
        query.setParameterList("deptTypeIds", deptTypeIds);
    }
    //            criterion[1] = Restrictions.ne(idField, entityId);
    return query.list();
}

From source file:com.viettel.vsaadmin.database.DAOHibernate.DepartmentDAOHE.java

License:Open Source License

public List<Long> getDeptTypeIds(String... deptTypeCodes) {
    StringBuilder strBuilder = new StringBuilder();
    strBuilder.append(" SELECT dt.deptTypeId");
    strBuilder.append(" FROM DeptType dt");
    if (deptTypeCodes != null && deptTypeCodes.length > 0) {
        strBuilder.append(" WHERE dt.code IN(:deptTypeCodes) ");
    }//from  w w  w  .j a  v  a 2 s . c  om
    Query query = getSession().createQuery(strBuilder.toString());
    if (deptTypeCodes != null && deptTypeCodes.length > 0) {
        query.setParameterList("deptTypeCodes", deptTypeCodes);
    }
    return (List<Long>) query.list();
}

From source file:com.viettel.vsaadmin.database.DAOHibernate.DepartmentDAOHE.java

License:Open Source License

public List<Department> getSingleTreeDept(Long parentId, Long deptId) {
    try {// w ww.j  a va  2  s .  c  om
        //Lay danh sch cc dept thuc cy n v d?c. (c trong deptPath)
        List<Long> deptLst = new ArrayList<Long>();
        VDepartment vDepartment = (new VDepartmentDAOHE()).findById(deptId, false);
        if (vDepartment != null && vDepartment.getDeptPath() != null) {
            String[] pathStr = vDepartment.getDeptPath().split("/");
            if (pathStr.length != 0) {
                for (String a : pathStr) {
                    if (a != null && !"".equals(a)) {
                        deptLst.add(Long.valueOf(a));
                    }
                }
            }
        }
        Query query = getSession().createQuery(
                " Select de FROM Department de where de.status =1 AND de.parentId =:parentId and de.deptId IN(:deptLst) "
                        + " order by nlssort(lower(de.deptName),'nls_sort = Vietnamese') ");
        query.setParameter("parentId", parentId);
        query.setParameterList("deptLst", deptLst);
        List<Department> lstDepartment = query.list();
        return lstDepartment;
    } catch (Exception ex) {
        LogUtil.addLog(ex);//binhnt sonar a160901
        //            log.error(ex.getMessage());
    }
    return null;
}

From source file:com.viettel.vsaadmin.database.DAOHibernate.UsersDAOHE.java

License:Open Source License

/**
 * tim kiem danh sach nguoi dung cua don vi
 *
 * @param deptId/*from  w  ww  . java 2  s  .c  o  m*/
 * @param userId
 * @return
 */
public List<Users> getUsersOfDept(String deptIds, Long userId) {
    List lstResult = new ArrayList<Users>();
    String sql = "";
    try {
        if (deptIds != null && !"".equals(deptIds)) {
            String[] depts = deptIds.split(";");
            Long[] deptId = new Long[depts.length];
            for (int i = 0; i < depts.length; i++) {
                deptId[i] = Long.parseLong(depts[i]);
            }
            sql = "SELECT u FROM Users u WHERE u.status = :status and (u.deptId IN (:deptIds) "
                    + "OR u.userId in ( SELECT ru.userId FROM RoleUserDept ru WHERE ru.deptId IN (:deptIds2)))"
                    + " order by u.posId desc,nlssort(lower(u.fullName),'nls_sort = Vietnamese') ";

            Query query = getSession().createQuery(sql);
            query.setParameter("status", Constants.Status.ACTIVE);
            query.setParameterList("deptIds", Arrays.asList(deptId));
            query.setParameterList("deptIds2", Arrays.asList(deptId));
            // query.setParameter(2, userId);
            lstResult = query.list();
            if (lstResult != null && !lstResult.isEmpty()) {
                for (int i = 0; i < lstResult.size(); i++) {
                    Users user = (Users) lstResult.get(i);
                    if (user instanceof HibernateProxy) {
                        HibernateProxy proxy = (HibernateProxy) user;
                        Users newUser = (Users) proxy.getHibernateLazyInitializer().getImplementation();
                        lstResult.set(i, newUser);
                    }
                }
            }
        }
    } catch (Exception ex) {
        LogUtil.addLog(ex);//binhnt sonar a160901
        //            e.getMessage();
        return new ArrayList<Users>();
    }
    return lstResult;
}