if (!ArrayUtils.isEmpty(params)) { for (Object param : params) { query.setParameter(counter, param, types[counter]); counter++;
public SQLQuery getSqlQueryByMap(SQLQuery sqlQuery,Map<String,Object> params){ if (params != null && !params.isEmpty()) { for (String key : params.keySet()) { Object obj = params.get(key); if (obj instanceof Collection<?>) sqlQuery.setParameterList(key, (Collection<?>) obj); else if (obj instanceof Object[]) sqlQuery.setParameterList(key, (Object[]) obj); else sqlQuery.setParameter(key, obj); } } return sqlQuery; }
if (!ArrayUtils.isEmpty(params)) { for (Object param : params) { query.setParameter(counter, param, types[counter]); counter++;
public Long latestModificationRunByPipeline(final CaseInsensitiveString pipelineName, final Material material) { final long materialId = findMaterialInstance(material).getId(); String key = cacheKeyForLatestPmrForPipelineKey(materialId, pipelineName.toLower()); Long modificationId = (Long) goCache.get(key); if (modificationId == null) { synchronized (key) { modificationId = (Long) goCache.get(key); if (modificationId == null) { modificationId = (Long) getHibernateTemplate().execute((HibernateCallback) session -> { SQLQuery sqlQuery = session.createSQLQuery("SELECT MAX(pmr.toRevisionId) toRevisionId " + "FROM (SELECT torevisionid, pipelineid FROM pipelineMaterialRevisions WHERE materialid = :material_id) AS pmr\n" + "INNER JOIN pipelines p ON ( p.name = :pipeline_name AND p.id = pmr.pipelineId)"); sqlQuery.setParameter("material_id", materialId); sqlQuery.setParameter("pipeline_name", pipelineName.toString()); sqlQuery.addScalar("toRevisionId", new LongType()); return sqlQuery.uniqueResult(); }); if (modificationId == null) { modificationId = -1L; } goCache.put(key, modificationId); } } } return modificationId; }
private EntityMapEnum assertFindEntityMapEnum( EntityMapEnum expected, String query, String queryWithParam, Object param, String nativeQueryCheck) { assertNotEquals( 0, expected.id ); assertNotNull( param ); Session session = openNewSession(); EntityMapEnum found = (EntityMapEnum) session.createQuery( query ).uniqueResult(); //find assetEntityMapEnumEquals( expected, found ); // find with parameter found = (EntityMapEnum) session.createQuery( queryWithParam ) .setParameter( "param", param ).uniqueResult(); assetEntityMapEnumEquals( expected, found ); //native query check SQLQuery sqlQuery = session.createSQLQuery( nativeQueryCheck ); sqlQuery.setParameter( "idEntityMapEnum", expected.id ); Object o = sqlQuery.uniqueResult(); assertNotNull( o ); return found; }
public Long countBySql(String sql, Map<String, Object> params) { SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql); if (params != null && !params.isEmpty()) { for (String key : params.keySet()) { sqlQuery.setParameter(key, params.get(key)); } } return (Long) sqlQuery.uniqueResult(); }
@SuppressWarnings("unchecked") public <T> T getBySql(String sql, Map<String, Object> params) { SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql); if (params != null && !params.isEmpty()) { for (String key : params.keySet()) { sqlQuery.setParameter(key, params.get(key)); } } List<T> ls = sqlQuery.list(); if (ls != null && ls.size() > 0) { return ls.get(0); } return null; }
SQLQuery query = session.createSQLQuery(hql); query.setParameter(0, "asd"); ... query.setParameter(26, "asd2"); Integer result = query.executeUpdate();
private void addConstantsAsParameters(SQLQuery sqlQuery) { if (sqlQuery.getQueryString().contains(":" + TRUE_VALUE_PARAMETER)) { if (useIntegerForBoolean(vendor)) { sqlQuery.setParameter(TRUE_VALUE_PARAMETER, 1); } else { sqlQuery.setParameter(TRUE_VALUE_PARAMETER, true); } } }
@Override public BigInteger getAuthorBooksCount(String username) { BigInteger bookcount = null; try (Session session = sessionFactory.openSession()) { SQLQuery sqlQuery = session.createSQLQuery( "SELECT count(b.title)" + " FROM Book b, Author a where b.author_id = a.id and a.username=:username"); sqlQuery.setParameter("username", username); bookcount = (BigInteger) sqlQuery.uniqueResult(); } return bookcount; }
public int updateSomeParameter(String tableName, String idColumnName, int id, String parameterColumnName, Object newParameterValue) { String sql = "UPDATE " + tableName + " SET " + parameterColumnName + " = :new_value WHERE " + idColumnName + " = :id"; SQLQuery query = session.createSQLQuery(sql); query.setInteger("id", id); query.setParameter("new_value", newParameterValue); return query.executeUpdate(); }
public String doInHibernate(Session arg0) throws HibernateException, SQLException { return (String) arg0.createSQLQuery( "select repo from originalfile where id = ?") .setParameter(0, fileId) .uniqueResult(); }}); if (repo != null) {
public Integer getLatestProcessVersion(String name) { SQLQuery query = getSession().createSQLQuery(QUERY_VERSION + " where name = ?"); query.setParameter(0, name); Object result = query.uniqueResult(); return new Long(ClassHelper.castLong(result)).intValue(); }
public List getStudentSchedule(int a) { Session sessionHb = session.openSession(); String sql = "select stud.firstname,stud.roll,sub.subjectname,cls.classname,exam.exam_name,exam.from_time,exam.to_time,exam.exam_date from Student stud,Subject sub,Classs cls,Exam exam where exam.classs=cls.id and exam.subject=sub.id and sub.classs=cls.id and stud.classs=cls.id and stud.roll= :roll"; SQLQuery query = sessionHb.createSQLQuery(sql); query.setParameter("roll", a); query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP); return query.list(); }
public Object queryCount(String sql, Object... args) { SQLQuery countQuery = getSession().createSQLQuery(sql); if(args.length > 0) { for (int i = 0; i < args.length; i++) { countQuery.setParameter(i, args[i]); } } return countQuery.uniqueResult(); }
@Override public Book getBook(String title) { Book bookDTo = null; try (Session session = sessionFactory.openSession()) { SQLQuery sqlQuery = session .createSQLQuery("SELECT b.title as \"title\", b.price as \"price\"" + " FROM Book b where b.title=:title"); sqlQuery.setParameter("title", title); bookDTo = (Book) sqlQuery.setResultTransformer(Transformers.aliasToBean(Book.class)).uniqueResult(); } return bookDTo; }
@SuppressWarnings("unchecked") public <T> List<T> queryList(Class<T> clazz, String sql, Object... args) { SQLQuery query = getSession().createSQLQuery(sql); query.addEntity(clazz); for(int i = 0; i < args.length; i++) { query.setParameter(i, args[i]); } return (List<T>)query.list(); }
@SuppressWarnings("unchecked") public <T> T queryObject(Class<T> T, String sql, Object... args) { SQLQuery query = getSession().createSQLQuery(sql); query.addEntity(T); for(int i = 0; i < args.length; i++) { query.setParameter(i, args[i]); } return (T)query.uniqueResult(); }
@SuppressWarnings("unchecked") public <T> T queryObject(Class<T> T, String sql, Object... args) { SQLQuery query = getSession().createSQLQuery(sql); query.addEntity(T); for(int i = 0; i < args.length; i++) { query.setParameter(i, args[i]); } return (T)query.uniqueResult(); }
@Override public void markHavingFlows(final Integer nodeId, final Collection<Integer> snmpIfIndexes) { getHibernateTemplate().executeWithNativeSession(session -> session.createSQLQuery("update snmpinterface set hasFlows = true where nodeid = :nodeid and snmpifindex in (:snmpIfIndexes)") .setParameter("nodeid", nodeId) .setParameterList("snmpIfIndexes", snmpIfIndexes) .executeUpdate()); }