List of usage examples for org.hibernate SQLQuery setParameterList
@Override NativeQuery<T> setParameterList(String name, Object[] values);
From source file:com.cms.dao.CustomerDAO.java
License:Open Source License
public List<CustomerDTO> getCustomerFromIHTKK(List<String> lstTaxCodes) { List<CustomerDTO> lstCustomers = null; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.append(" SELECT DISTINCT a.tin taxCode, a.norm_name name, a.tran_prov taxAuthority "); sqlQuery.append(" FROM IHTKK_MV_PAYER a WHERE 1=1 "); if (!DataUtil.isListNullOrEmpty(lstTaxCodes)) { sqlQuery.append(" AND a.tin IN "); sqlQuery.append("( :idx").append(String.valueOf(0)).append(" )"); if (lstTaxCodes.size() > 1) { for (int index = 1; index < lstTaxCodes.size(); index++) { sqlQuery.append(" OR a.tin IN "); sqlQuery.append("( :idx").append(String.valueOf(index)).append(" )"); }//w w w. ja v a 2 s .c o m } SQLQuery query; query = getSession().createSQLQuery(sqlQuery.toString()); try { //Thuc hien chuyen du lieu lay ve thanh thanh doi tuong query.setResultTransformer(Transformers.aliasToBean(CustomerDTO.class)); query.addScalar("taxCode", new StringType()); query.addScalar("name", new StringType()); query.addScalar("taxAuthority", new StringType()); for (int index = 0; index < lstTaxCodes.size(); index++) { query.setParameterList("idx" + String.valueOf(index), DataUtil.parseInputListString(lstTaxCodes.get(index))); } lstCustomers = query.list(); } catch (Exception e) { e.printStackTrace(); lstCustomers = null; } } return lstCustomers; }
From source file:com.cms.dao.TaxAuthorityDAO.java
License:Open Source License
public List<TaxAuthorityDTO> getListTaxAuthorityFromMineName(String mineName, Map<String, String> map) { String startFromDate = map.get("startFromDate"); String provider = map.get("provider"); String endFromDate = map.get("endFromDate"); String startToDate = map.get("startToDate"); String endToDate = map.get("endToDate"); String fromDateRegister = map.get("fromDateRegister"); String toDateRegister = map.get("toDateRegister"); List<TaxAuthorityDTO> lstTaxAuthorities = null; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.append(" SELECT ID id, "); sqlQuery.append(" MA_CQT maCqt, "); sqlQuery.append(" MA_QUAN_HUYEN maQuanHuyen, "); sqlQuery.append(" MA_TINH maTinh, "); sqlQuery.append(" STATUS status, "); sqlQuery.append(" TEN_CQT tenCqt "); sqlQuery.append(" FROM TAX_AUTHORITY ta "); sqlQuery.append(" WHERE ta.MA_CQT = ANY "); sqlQuery.append(" ( SELECT DISTINCT c.TAX_AUTHORITY "); sqlQuery.append(" FROM CUSTOMER c "); sqlQuery.append(" JOIN TERM_INFORMATION ti ON ti.TAX_CODE = c.TAX_CODE "); sqlQuery.append(" WHERE ti.IS_CONTACT_INFO is NULL AND ti.MINE_NAME = ANY (:mineName) "); if (!DataUtil.isStringNullOrEmpty(provider)) { sqlQuery.append(" and lower(ti.PROVIDER) = ANY (:provider) "); }/*from w w w.j a v a 2 s. co m*/ if (!DataUtil.isStringNullOrEmpty(startFromDate)) { sqlQuery.append(" and ti.START_TIME >= TO_DATE(:startFromDate,'dd/MM/yyyy') - 1 "); } if (!DataUtil.isStringNullOrEmpty(endFromDate)) { sqlQuery.append(" and ti.START_TIME <= TO_DATE(:endFromDate,'dd/MM/yyyy') + 1 "); } if (!DataUtil.isStringNullOrEmpty(startToDate)) { sqlQuery.append(" and ti.END_TIME >= TO_DATE(:startToDate,'dd/MM/yyyy') - 1 "); } if (!DataUtil.isStringNullOrEmpty(endToDate)) { sqlQuery.append(" and ti.END_TIME <= TO_DATE(:endToDate,'dd/MM/yyyy') + 1 "); } if (!DataUtil.isStringNullOrEmpty(fromDateRegister)) { sqlQuery.append(" AND ti.DATE_REGISTER >= TO_DATE(:fromDateRegister,'dd/MM/yyyy') - 1 "); } if (!DataUtil.isStringNullOrEmpty(toDateRegister)) { sqlQuery.append(" AND ti.DATE_REGISTER <= TO_DATE(:toDateRegister,'dd/MM/yyyy') + 1"); } sqlQuery.append(" AND NOT " + " EXISTS ( " + " SELECT " + " cs.tax_code, " + " cs.mine_name " + " FROM " + " customer_status cs" + " WHERE " + " cs.tax_code = ti.tax_code " + " AND " + " cs.mine_name = ti.mine_name " + " ) "); sqlQuery.append(" ) "); sqlQuery.append(" ORDER BY ta.TEN_CQT asc "); SQLQuery query; try { query = getSession().createSQLQuery(sqlQuery.toString()); //Thuc hien chuyen du lieu lay ve thanh thanh doi tuong query.setResultTransformer(Transformers.aliasToBean(TaxAuthorityDTO.class)); query.addScalar("id", new StringType()); query.addScalar("maCqt", new StringType()); query.addScalar("maQuanHuyen", new StringType()); query.addScalar("maTinh", new StringType()); query.addScalar("status", new StringType()); query.addScalar("tenCqt", new StringType()); query.setParameterList("mineName", DataUtil.parseInputListString(mineName)); if (!DataUtil.isStringNullOrEmpty(provider)) { query.setParameterList("provider", DataUtil.parseInputListString(provider.toLowerCase())); } if (!DataUtil.isStringNullOrEmpty(startFromDate)) { query.setString("startFromDate", startFromDate); } if (!DataUtil.isStringNullOrEmpty(endFromDate)) { query.setString("endFromDate", endFromDate); } if (!DataUtil.isStringNullOrEmpty(startToDate)) { query.setString("startToDate", startToDate); } if (!DataUtil.isStringNullOrEmpty(endToDate)) { query.setString("endToDate", endToDate); } if (!DataUtil.isStringNullOrEmpty(fromDateRegister)) { query.setString("fromDateRegister", fromDateRegister); } if (!DataUtil.isStringNullOrEmpty(toDateRegister)) { query.setString("toDateRegister", toDateRegister); } lstTaxAuthorities = query.list(); } catch (Exception e) { e.printStackTrace(); } return lstTaxAuthorities; }
From source file:com.cms.dao.TaxAuthorityDAO.java
License:Open Source License
public List<TaxAuthorityDTO> getListTaxAuthorityFromMineName(String mineName, String staffCode) { List<TaxAuthorityDTO> lstTaxAuthorities = null; if (DataUtil.isStringNullOrEmpty(staffCode)) { return getListTaxAuthorityFromMineName(mineName); }//from www . j a v a 2 s . c om StringBuilder sqlQuery = new StringBuilder(); sqlQuery.append(" SELECT ID id, "); sqlQuery.append(" MA_CQT maCqt, "); sqlQuery.append(" MA_QUAN_HUYEN maQuanHuyen, "); sqlQuery.append(" MA_TINH maTinh, "); sqlQuery.append(" STATUS status, "); sqlQuery.append(" TEN_CQT tenCqt "); sqlQuery.append(" FROM TAX_AUTHORITY "); sqlQuery.append(" WHERE MA_CQT IN "); sqlQuery.append(" ( SELECT DISTINCT cs.TAX_AUTHORITY "); sqlQuery.append(" FROM customer_status cs "); sqlQuery.append(" WHERE 1=1 "); if (!DataUtil.isStringNullOrEmpty(mineName)) { if (mineName.contains(",")) { sqlQuery.append(" AND cs.mine_name IN (:mineName) "); } else { sqlQuery.append(" AND cs.mine_name = :mineName "); } // sqlQuery.append(" AND cs.mine_name = :mineName "); } if (!DataUtil.isStringNullOrEmpty(staffCode)) { sqlQuery.append(" AND cs.staff_code = :staffCode "); } sqlQuery.append(" ) ORDER BY maCqt"); SQLQuery query; try { query = getSession().createSQLQuery(sqlQuery.toString()); //Thuc hien chuyen du lieu lay ve thanh thanh doi tuong query.setResultTransformer(Transformers.aliasToBean(TaxAuthorityDTO.class)); query.addScalar("id", new StringType()); query.addScalar("maCqt", new StringType()); query.addScalar("maQuanHuyen", new StringType()); query.addScalar("maTinh", new StringType()); query.addScalar("status", new StringType()); query.addScalar("tenCqt", new StringType()); if (!DataUtil.isStringNullOrEmpty(mineName)) { if (mineName.contains(",")) { query.setParameterList("mineName", DataUtil.parseInputListString(mineName)); } else { query.setParameter("mineName", mineName); } } if (!DataUtil.isStringNullOrEmpty(staffCode)) { query.setParameter("staffCode", staffCode); } lstTaxAuthorities = query.list(); } catch (Exception e) { e.printStackTrace(); } return lstTaxAuthorities; }
From source file:com.cms.dao.TaxAuthorityDAO.java
License:Open Source License
public List<TaxAuthorityDTO> getListTaxAuthorityFromMineNameAndStaffCodeAndProvider(String mineName, String staffCode, String provider, String status) { if (DataUtil.isStringNullOrEmpty(staffCode)) { return getListTaxAuthorityFromMineNameAndProvider(mineName, provider, status); }//from w w w.j a va2s. c o m List<TaxAuthorityDTO> lstTaxAuthorities = null; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.append(" SELECT ID id, "); sqlQuery.append(" MA_CQT maCqt, "); sqlQuery.append(" MA_QUAN_HUYEN maQuanHuyen, "); sqlQuery.append(" MA_TINH maTinh, "); sqlQuery.append(" STATUS status, "); sqlQuery.append(" TEN_CQT tenCqt "); sqlQuery.append(" FROM TAX_AUTHORITY "); sqlQuery.append(" WHERE MA_CQT IN "); sqlQuery.append(" ( SELECT DISTINCT cs.TAX_AUTHORITY "); sqlQuery.append(" FROM customer_status cs "); if (!DataUtil.isStringNullOrEmpty(provider) || !DataUtil.isStringNullOrEmpty(mineName)) { sqlQuery.append(" JOIN term_information ti ON ti.TAX_CODE = cs.TAX_CODE "); } sqlQuery.append(" WHERE 1=1 "); if (!DataUtil.isStringNullOrEmpty(mineName)) { if (mineName.contains(",")) { sqlQuery.append(" AND cs.mine_name IN (:mineName) "); } else { sqlQuery.append(" AND cs.mine_name = :mineName "); } } if (!DataUtil.isStringNullOrEmpty(staffCode)) { sqlQuery.append(" AND cs.staff_code = :staffCode "); } if (!DataUtil.isStringNullOrEmpty(provider)) { sqlQuery.append(" AND lower(ti.provider) = ANY (:provider) "); } if (!DataUtil.isStringNullOrEmpty(status)) { sqlQuery.append(" AND cs.status = ANY (:status) "); } sqlQuery.append(" ) ORDER BY maCqt"); SQLQuery query; try { System.out.println(sqlQuery.toString()); query = getSession().createSQLQuery(sqlQuery.toString()); //Thuc hien chuyen du lieu lay ve thanh thanh doi tuong query.setResultTransformer(Transformers.aliasToBean(TaxAuthorityDTO.class)); query.addScalar("id", new StringType()); query.addScalar("maCqt", new StringType()); query.addScalar("maQuanHuyen", new StringType()); query.addScalar("maTinh", new StringType()); query.addScalar("status", new StringType()); query.addScalar("tenCqt", new StringType()); if (!DataUtil.isStringNullOrEmpty(mineName)) { if (mineName.contains(",")) { query.setParameterList("mineName", DataUtil.parseInputListString(mineName)); } else { query.setParameter("mineName", mineName); } } if (!DataUtil.isStringNullOrEmpty(provider)) { query.setParameterList("provider", DataUtil.parseInputListString(provider.toLowerCase())); } if (!DataUtil.isStringNullOrEmpty(status)) { query.setParameterList("status", DataUtil.parseInputListString(status)); } if (!DataUtil.isStringNullOrEmpty(staffCode)) { query.setParameter("staffCode", staffCode); } lstTaxAuthorities = query.list(); } catch (Exception e) { e.printStackTrace(); } return lstTaxAuthorities; }
From source file:com.cms.dao.TaxAuthorityDAO.java
License:Open Source License
public List<TaxAuthorityDTO> getListTaxAuthorityFromMineName(String mineName) { List<TaxAuthorityDTO> lstTaxAuthorities = null; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.append(" SELECT ID id, "); sqlQuery.append(" MA_CQT maCqt, "); sqlQuery.append(" MA_QUAN_HUYEN maQuanHuyen, "); sqlQuery.append(" MA_TINH maTinh, "); sqlQuery.append(" STATUS status, "); sqlQuery.append(" TEN_CQT tenCqt "); sqlQuery.append(" FROM TAX_AUTHORITY "); sqlQuery.append(" WHERE MA_CQT IN "); sqlQuery.append(" ( SELECT DISTINCT cs.TAX_AUTHORITY "); sqlQuery.append(/*from w ww . j a v a 2 s. co m*/ " FROM CUSTOMER cs INNER JOIN TERM_INFORMATION ti ON ti.TAX_CODE = cs.TAX_CODE "); sqlQuery.append(" WHERE 1=1 AND ti.IS_CONTACT_INFO is NULL "); if (!DataUtil.isStringNullOrEmpty(mineName)) { if (mineName.contains(",")) { sqlQuery.append(" AND ti.mine_name IN (:mineName) "); } else { sqlQuery.append(" AND ti.mine_name = :mineName "); } } sqlQuery.append(" ) ORDER BY maCqt"); SQLQuery query; try { query = getSession().createSQLQuery(sqlQuery.toString()); //Thuc hien chuyen du lieu lay ve thanh thanh doi tuong query.setResultTransformer(Transformers.aliasToBean(TaxAuthorityDTO.class)); query.addScalar("id", new StringType()); query.addScalar("maCqt", new StringType()); query.addScalar("maQuanHuyen", new StringType()); query.addScalar("maTinh", new StringType()); query.addScalar("status", new StringType()); query.addScalar("tenCqt", new StringType()); if (!DataUtil.isStringNullOrEmpty(mineName)) { if (mineName.contains(",")) { query.setParameterList("mineName", DataUtil.parseInputListString(mineName)); } else { query.setParameter("mineName", mineName); } } lstTaxAuthorities = query.list(); } catch (Exception e) { e.printStackTrace(); } return lstTaxAuthorities; }
From source file:com.cms.dao.TaxAuthorityDAO.java
License:Open Source License
public List<TaxAuthorityDTO> getListTaxAuthorityFromMineNameAndProvider(String mineName, String provider, String status) {// ww w .j a va 2 s .com List<TaxAuthorityDTO> lstTaxAuthorities = null; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.append(" SELECT ID id, "); sqlQuery.append(" MA_CQT maCqt, "); sqlQuery.append(" MA_QUAN_HUYEN maQuanHuyen, "); sqlQuery.append(" MA_TINH maTinh, "); sqlQuery.append(" STATUS status, "); sqlQuery.append(" TEN_CQT tenCqt "); sqlQuery.append(" FROM TAX_AUTHORITY "); sqlQuery.append(" WHERE MA_CQT IN "); sqlQuery.append(" ( SELECT DISTINCT c.TAX_AUTHORITY "); sqlQuery.append(" FROM CUSTOMER c "); if (!DataUtil.isStringNullOrEmpty(provider)) { sqlQuery.append(" INNER JOIN TERM_INFORMATION ti ON ti.TAX_CODE = c.TAX_CODE "); } if (!DataUtil.isStringNullOrEmpty(mineName) || !DataUtil.isStringNullOrEmpty(status)) { sqlQuery.append(" INNER JOIN CUSTOMER_STATUS cs ON c.TAX_CODE = cs.TAX_CODE "); } sqlQuery.append(" WHERE 1=1 "); if (!DataUtil.isStringNullOrEmpty(provider)) { sqlQuery.append(" AND ti.IS_CONTACT_INFO is NULL "); } if (!DataUtil.isStringNullOrEmpty(mineName)) { if (mineName.contains(",")) { sqlQuery.append(" AND cs.mine_name IN (:mineName) "); } else { sqlQuery.append(" AND cs.mine_name = :mineName "); } } if (!DataUtil.isStringNullOrEmpty(provider)) { sqlQuery.append(" AND lower(ti.provider) = ANY (:provider) "); } if (!DataUtil.isStringNullOrEmpty(status)) { sqlQuery.append(" AND cs.STATUS = :status "); } sqlQuery.append(" ) ORDER BY maCqt"); SQLQuery query; try { query = getSession().createSQLQuery(sqlQuery.toString()); //Thuc hien chuyen du lieu lay ve thanh thanh doi tuong query.setResultTransformer(Transformers.aliasToBean(TaxAuthorityDTO.class)); query.addScalar("id", new StringType()); query.addScalar("maCqt", new StringType()); query.addScalar("maQuanHuyen", new StringType()); query.addScalar("maTinh", new StringType()); query.addScalar("status", new StringType()); query.addScalar("tenCqt", new StringType()); if (!DataUtil.isStringNullOrEmpty(mineName)) { if (mineName.contains(",")) { query.setParameterList("mineName", DataUtil.parseInputListString(mineName)); } else { query.setParameter("mineName", mineName); } } if (!DataUtil.isStringNullOrEmpty(provider)) { query.setParameterList("provider", DataUtil.parseInputListString(provider.toLowerCase())); } if (!DataUtil.isStringNullOrEmpty(status)) { query.setParameter("status", status); } lstTaxAuthorities = query.list(); } catch (Exception e) { e.printStackTrace(); } return lstTaxAuthorities; }
From source file:com.duroty.application.files.manager.FilesManager.java
License:Open Source License
/** * DOCUMENT ME!//ww w. j a v a2s. c o m * * @param hsession DOCUMENT ME! * @param repositoryName DOCUMENT ME! * @param folderName DOCUMENT ME! * @param page DOCUMENT ME! * @param messagesByPage DOCUMENT ME! * @param order DOCUMENT ME! * @param orderType DOCUMENT ME! * * @return DOCUMENT ME! * * @throws FilesException DOCUMENT ME! */ public Vector getFiles(Session hsession, String repositoryName, String folderName, int label, int page, int messagesByPage, int order, String orderType) throws FilesException { Vector files = new Vector(); try { Users user = getUser(hsession, repositoryName); Locale locale = new Locale(user.getUseLanguage()); TimeZone timeZone = TimeZone.getDefault(); Date now = new Date(); Calendar calendar = Calendar.getInstance(timeZone, locale); calendar.setTime(now); SimpleDateFormat formatter1 = new SimpleDateFormat("MMM dd", locale); SimpleDateFormat formatter2 = new SimpleDateFormat("HH:mm:ss", locale); SimpleDateFormat formatter3 = new SimpleDateFormat("MM/yy", locale); Query hquery = null; String[] folderNameList = new String[0]; try { folderName = parseFolder(folderName); folderNameList = new String[] { folderName }; if (folderName.equals(this.folderAll) || folderName.equals(this.folderHidden)) { folderNameList = new String[] { this.folderAll, this.folderDraft, this.folderHidden, this.folderImportant, this.folderInbox, this.folderSent }; } } catch (Exception ex) { } if ((folderNameList.length == 0) && (label <= 0)) { hquery = hsession.getNamedQuery("attachments"); } else if ((folderNameList.length > 0) && (label <= 0)) { hquery = hsession.getNamedQuery("attachments-by-folder"); } else if ((folderNameList.length == 0) && (label > 0)) { hquery = hsession.getNamedQuery("attachments-by-label"); } else if ((folderNameList.length > 0) && (label > 0)) { hquery = hsession.getNamedQuery("attachments-by-folder-label"); } String aux = hquery.getQueryString(); switch (order) { case ORDER_BY_SIZE: if (orderType.equals("ASC")) { aux += " order by att_size asc"; } else { aux += " order by att_size desc"; } break; case ORDER_BY_DATE: if (orderType.equals("ASC")) { aux += " order by mes_date asc"; } else { aux += " order by mes_date desc"; } break; case ORDER_BY_TYPE: if (orderType.equals("ASC")) { aux += " order by att_content_type asc"; } else { aux += " order by att_content_type desc"; } break; default: if (!orderType.equals("ASC")) { aux += " order by att_name desc"; } else { aux += " order by att_name asc"; } break; } SQLQuery h2query = hsession.createSQLQuery(aux); if ((folderNameList.length == 0) && (label <= 0)) { h2query.setParameterList("no_boxes", new String[] { this.folderTrash, this.folderChat, this.folderSpam, FOLDER_DELETE }); h2query.setInteger("user", getUser(hsession, repositoryName).getUseIdint()); } else if ((folderNameList.length > 0) && (label <= 0)) { h2query.setParameterList("boxes", folderNameList); h2query.setInteger("user", getUser(hsession, repositoryName).getUseIdint()); } else if ((folderNameList.length == 0) && (label > 0)) { h2query.setInteger("label", label); h2query.setParameterList("no_boxes", new String[] { this.folderTrash, this.folderChat, this.folderSpam, FOLDER_DELETE }); h2query.setInteger("user", getUser(hsession, repositoryName).getUseIdint()); } else if ((folderNameList.length > 0) && (label > 0)) { h2query.setInteger("label", label); h2query.setParameterList("boxes", folderNameList); h2query.setInteger("user", getUser(hsession, repositoryName).getUseIdint()); } h2query.setFirstResult(page * messagesByPage); h2query.setMaxResults(messagesByPage); h2query.addEntity("testo", AttachmentWithDate.class); ScrollableResults scroll = h2query.scroll(); while (scroll.next()) { AttachmentWithDate attachment = (AttachmentWithDate) scroll.get(0); AttachmentObj obj = new AttachmentObj(); obj.setContentType(attachment.getAttContentType()); Date date = attachment.getAttDate(); if (date != null) { Calendar calendar2 = Calendar.getInstance(timeZone, locale); calendar2.setTime(date); if ((calendar.get(Calendar.YEAR) == calendar2.get(Calendar.YEAR)) && (calendar.get(Calendar.MONTH) == calendar2.get(Calendar.MONTH)) && (calendar.get(Calendar.DATE) == calendar2.get(Calendar.DATE))) { obj.setDateStr(formatter2.format(calendar2.getTime())); } else if (calendar.get(Calendar.YEAR) == calendar2.get(Calendar.YEAR)) { obj.setDateStr(formatter1.format(calendar2.getTime())); } else { obj.setDateStr(formatter3.format(calendar2.getTime())); } } obj.setDate(date); obj.setDate(date); obj.setIdint(attachment.getAttIdint()); obj.setName(attachment.getAttName()); obj.setPart(attachment.getAttPart()); int size = attachment.getAttSize(); size /= 1024; if (size > 1024) { size /= 1024; obj.setSize(size + " MB"); } else { obj.setSize(((size > 0) ? (size + "") : "<1") + " kB"); } String extension = (String) this.extensions.get(attachment.getAttContentType()); if (StringUtils.isBlank(extension)) { extension = "generic"; } obj.setExtension(extension); Message message = attachment.getMessage(); if (message.isMesFlagged()) { obj.setFlagged(true); } else { obj.setFlagged(false); } if (message.getLabMeses() != null) { Iterator it = message.getLabMeses().iterator(); StringBuffer lab = new StringBuffer(); while (it.hasNext()) { if (lab.length() > 0) { lab.append(", "); } LabMes labMes = (LabMes) it.next(); lab.append(labMes.getId().getLabel().getLabName()); } if (lab.length() > 0) { obj.setLabel(lab.toString()); } else { } } obj.setBox(message.getMesBox()); obj.setMid(message.getMesName()); files.addElement(obj); } return files; } catch (Exception e) { throw new FilesException(e); } finally { GeneralOperations.closeHibernateSession(hsession); } }
From source file:com.g3.framework.orm.SimpleHibernateDao.java
License:Apache License
public SQLQuery createSQLQuery(String sql, Map<String, Object> parameters) { sql = sql.toUpperCase();// w w w . ja v a 2s . c o m Assert.hasText(sql, "queryString?"); SQLQuery query = getSession().createSQLQuery(sql); if (parameters != null) { for (String key : parameters.keySet()) { Object value = parameters.get(key); //System.out.println(key + "<::>" + value); if (value instanceof Collection) { query.setParameterList(key.toUpperCase(), (Collection) value); } else if (value instanceof Integer) { query.setInteger(key.toUpperCase(), ((Integer) value).intValue()); } else { query.setParameter(key.toUpperCase(), value); } } } return query; }
From source file:com.globalsight.everest.workflow.WorkflowJbpmUtil.java
License:Apache License
public static List<Long> getRejectedTaskIds(List<TaskInstance> tasks, String p_userId) { JbpmContext ctx = WorkflowConfiguration.getInstance().getCurrentContext(); List<Long> allIds = new ArrayList<Long>(); if (tasks == null || tasks.size() == 0) { return allIds; }/*from w w w. ja v a2 s .c om*/ for (TaskInstance task : tasks) { allIds.add(task.getId()); } String idsString = allIds.toString(); idsString = idsString.substring(1, idsString.length() - 1); StringBuffer sql = new StringBuffer("select vi.TASKINSTANCE_ID "); sql.append("from JBPM_GS_VARIABLE vi "); sql.append("where vi.NAME = :name and vi.VALUE = :value "); sql.append("and vi.CATEGORY = 'reject' and vi.TASKINSTANCE_ID in (:ids);"); SQLQuery query = null; Session session = ctx.getSession(); query = session.createSQLQuery(sql.toString()); query.setString("name", WorkflowConstants.VARIABLE_IS_REJECTED); query.setString("value", p_userId); query.setParameterList("ids", allIds); List<Long> ids = new ArrayList<Long>(); for (Object id : query.list()) { // id is BigInteger ids.add(Long.parseLong(id.toString())); } return ids; }
From source file:com.globalsight.persistence.hibernate.HibernateUtil.java
License:Apache License
/** * Execute sql, return the result.// w ww. j a v a 2s . c o m * * @param sql * @param params * @return */ public static List<?> searchWithSqlWithIn(String sql, Map<String, ?> params, Map<String, List<Object>> ins) throws HibernateException { Session session = getSession(); SQLQuery query = session.createSQLQuery(sql); if (params != null) { Iterator<String> iterator = params.keySet().iterator(); while (iterator.hasNext()) { String key = iterator.next(); query.setParameter(key, params.get(key)); } } if (ins != null) { Iterator<String> iterator = ins.keySet().iterator(); while (iterator.hasNext()) { String key = iterator.next(); query.setParameterList(key, ins.get(key)); } } List<?> result = query.list(); return result; }