Java Code Examples for org.springframework.dao.support.DataAccessUtils#intResult()

/**
 * Returns the number of Product records whose `processed` field is `true`.
 * @param filter an optional additionnal `where` clause (without the "where" token).
 * @param collection_uuid an optional parent collection ID.
 * @return a number of rows in table `PRODUCTS`.
 */
public int count (String filter, final String collection_uuid)
{
   StringBuilder sb = new StringBuilder("select count(*) ");
   if (collection_uuid != null)
   {
         sb.append("from Collection c left outer join c.products p ");
         sb.append("where c.uuid='").append(collection_uuid).append("' and ");
   }
   else
   {
      sb.append("from Product p where ");
   }
   sb.append("p.processed=true");

   if (filter != null && !filter.isEmpty())
   {
      sb.append(" and ").append(filter);
   }

   return DataAccessUtils.intResult(find(sb.toString()));
}
 

@SuppressWarnings ("rawtypes")
private int countOpenSessions ()
{
   return DataAccessUtils.intResult (getHibernateTemplate ().execute (
      new HibernateCallback<List>()
      {
         @Override
         public List doInHibernate(Session session) 
            throws HibernateException, SQLException
         {
            String sql = 
               "SELECT count (*) FROM INFORMATION_SCHEMA.SYSTEM_SESSIONS";
            SQLQuery query = session.createSQLQuery (sql);
            return query.list ();
         }
      }));
}
 

@Override
public int count(String hql, Object... args) throws Exception {
	Query query=this.getCurrentSession().createQuery(hql);
	for (int position=0; args!=null && position<args.length; position++) {
		this.setQueryParams(query, Integer.toString(position), args[position]);
	}
	return DataAccessUtils.intResult(query.list());
}
 

/**
 * 查询指定实体的总记录数
 *
 * @param clazz
 * @return
 */
public int getCount(Class<T> clazz) {

	int count = DataAccessUtils.intResult(getSession().createQuery(
			"select count(*) from " + clazz.getName()).list());
	return count;
}
 

public int countNotDeletedByFilter (String filter)
{
   return DataAccessUtils.intResult (find (
      "select count(*) FROM " + entityClass.getName () +
         " u WHERE u.deleted is false AND (u.username LIKE '%" + filter +
      "%'  OR lower(u.firstname) LIKE '%"+filter.toLowerCase()+ "%'  OR lower(u.lastname) LIKE '%"+filter.toLowerCase()+
      "%'  OR lower(u.email) LIKE '%"+filter.toLowerCase()+ "%') and not u.username='" +
         cfgManager.getAdministratorConfiguration ().getName () + "'" +
         " and not u.username LIKE '"+getPublicData ().getUsername ()+"' "));
}
 

public int countAll (String filter)
{
   return DataAccessUtils.intResult (find (
      "select count(*) FROM " + entityClass.getName () +
         " u WHERE u.username LIKE '%" + filter + "%'" +
         " and not u.username LIKE '" + getPublicData ().getUsername () +
         "' " ));
}
 

public int countNotDeleted (String filter)
{
   return DataAccessUtils.intResult (find (
      "select count(*) FROM " + entityClass.getName () +
         " u WHERE u.deleted is false AND u.username LIKE '%" + filter +
         "%' and " + "not u.username='" +
         cfgManager.getAdministratorConfiguration ().getName () + "'" +
         " and not u.username LIKE '"+getPublicData ().getUsername ()+"' "));
}
 

/**
 * 查询指定实体的总记录数
 * 
 * @param clazz
 * @return
 */
public int getCount(Class<T> clazz) {

	int count = DataAccessUtils.intResult(getSession().createQuery(
			"select count(*) from " + clazz.getName()).list());
	return count;
}
 

public int countByEntityUK(Map<String, Object> ukMap) throws Exception {
	if (ukMap==null || ukMap.size()<1) {
		return 0;
	}		
	Query query=this.getQueryByKeyMap("select count(*)", ukMap);
	return DataAccessUtils.intResult(query.list());
}
 

public int countByPK(Map<String, Object> pkMap) throws Exception {
	if (pkMap==null || pkMap.size()<1) {
		return 0;
	}		
	Query query=this.getQueryByKeyMap("select count(*)", pkMap);
	return DataAccessUtils.intResult(query.list());		
}
 

@SuppressWarnings("unchecked")
public int countByPK(PK pk) throws Exception {
	return DataAccessUtils.intResult(
			this.getCurrentSession().createQuery(
					" select count(*) from "+this.getPersisentName() + 
					" where " + BaseEntityUtil.getPKOneName((BaseEntity<PK>)entityClass.newInstance()) + "=?0 ")
					.setString("0", (String)pk).list());		
}
 

public int countByEntityUK(Map<String, Object> ukMap) throws Exception {
	if (ukMap==null || ukMap.size()<1) {
		return 0;
	}		
	Query query=this.getQueryByKeyMap("select count(*)", ukMap);
	return DataAccessUtils.intResult(query.list());
}
 

public int countByPK(Map<String, Object> pkMap) throws Exception {
	if (pkMap==null || pkMap.size()<1) {
		return 0;
	}		
	Query query=this.getQueryByKeyMap("select count(*)", pkMap);
	return DataAccessUtils.intResult(query.list());		
}
 

@SuppressWarnings("unchecked")
public int countByPK(PK pk) throws Exception {
	return DataAccessUtils.intResult(
			this.getCurrentSession().createQuery(
					" select count(*) from "+this.getPersisentName() + 
					" where " + BaseEntityUtil.getPKOneName((BaseEntity<PK>)entityClass.newInstance()) + "=?0 ")
					.setString("0", (String)pk).list());		
}
 

@Override
public int countForMixData(Map<String, Object> paramMap) throws Exception {		
	Query query = this.getCurrentSession().createQuery(this.getDynamicHql("findKpiMixData-count", paramMap));
	this.setQueryMixDataParameter(query, paramMap);
	return DataAccessUtils.intResult( query.list() );
}
 

@Override
public int countAll()
{
    return DataAccessUtils.intResult(find("select count(*) from " + getClassName()));
}
 

@Override
public int count(String hql) throws Exception {
	return DataAccessUtils.intResult(this.getCurrentSession().createQuery(hql).list()); //this.getHibernateTemplate().find(hql)
}
 

@Override
public int count(String hql) throws Exception {
	return DataAccessUtils.intResult(this.getCurrentSession().createQuery(hql).list());
}
 

/**
 * @Title: countBySql
 * @Description: 根据SQL统计查询结果数，多个参数调用
 * @param @param hql
 * @param @param params
 * @param @return
 * @param @throws DataAccessException
 * @return int
 */
public <T> int countBySql(String sql, Object... params) throws DataAccessException {
	return DataAccessUtils.intResult(executeSQLQuery("select count(*) " + sql.substring(sql.toLowerCase().indexOf("from")), params));
}
 

/**
 * @Title: countByHql
 * @Description: 根据HQL统计查询结果数，多个参数调用
 * @param @param hql
 * @param @param params
 * @param @return
 * @param @throws DataAccessException
 * @return int
 */
public <T> int countByHql(String hql, Object... params) throws DataAccessException {
	return DataAccessUtils.intResult(getHibernateTemplate().find(hql, params));
}