Java Query.uniqueResult方法代码示例

import org.hibernate.Query; //导入方法依赖的package包/类
/**
 * 获取冻结未冻结用户的总数
 */
@Override
public long getUsersNumOfFrozenOrUnfrozen(int is_frozen) {
	 long num =0l;
	 Session session = HibernateUtils.getSession();//生成Session实例
	 Transaction tx = session.beginTransaction();//生成事务实例 
	 try { 
	    Query query = session.createQuery("SELECT count(*) from User where is_frozen = ?"); 
		    query.setInteger(0, is_frozen);
	    num = (long) query.uniqueResult();
	     //调用session的get()方法，找到此用户到内存中
	    tx.commit();//提交事务
	} catch (Exception e) {
		e.printStackTrace();
		tx.rollback();//事务回滚
	}finally{
		HibernateUtils.closeSession();//关闭session实例
	}   
	 return num;
}
 

import org.hibernate.Query; //导入方法依赖的package包/类
@Override
   public long getPendingNotificationCount(Long lessonId, Integer userId) {
String query = EventDAOHibernate.COUNT_PENDING_NOTIFICATIONS;
if (lessonId != null) {
    query += " AND s.event.eventSessionId = ?";
}
Query queryObject = getSession().createQuery(query);
queryObject.setInteger(0, userId);
if (lessonId != null) {
    queryObject.setLong(1, lessonId);
}
return (Long) queryObject.uniqueResult();
   }
 

import org.hibernate.Query; //导入方法依赖的package包/类
@Override
public boolean isExists(String marketName, short catalog, int subCatalog) {
    Query query = getSession()
            .createQuery(
                    "select count(id) from CatalogConvertor where   catalog= :catalog and marketName= :marketName and subCatalog =:subCatalog")
            .setInteger("catalog", catalog)
            .setString("marketName", StringUtils.defaultIfEmpty(marketName, "").trim())
            .setInteger("subCatalog", subCatalog);
    Object o = query.uniqueResult();
    return Integer.valueOf(o.toString()) > 0;
}
 

import org.hibernate.Query; //导入方法依赖的package包/类
/**
    * @see org.lamsfoundation.lams.lesson.dao.ILessonDAO#getActiveLearnerByLesson(long) Note: Hibernate 3.1
    *      query.uniqueResult() returns Integer, Hibernate 3.2 query.uniqueResult() returns Long
    */
   @Override
   public Integer getCountActiveLearnerByLesson(long lessonId) {
Query query = getSession().createQuery(LessonDAO.COUNT_ACTIVE_LEARNERS);
query.setLong("lessonId", lessonId);
Object value = query.uniqueResult();
return new Integer(((Number) value).intValue());
   }
 

import org.hibernate.Query; //导入方法依赖的package包/类
public Order getOrderDetails(int orderId){
	String sql = "from Order where orderId=:orderId";
	Session session = this.sessionFactory.openSession();
	Query query = session.createQuery(sql);
	query.setParameter("orderId", orderId);
	
	Order order = (Order) query.uniqueResult();
	session.close();
	return order;
	
}
 

import org.hibernate.Query; //导入方法依赖的package包/类
@Override
public long countDownloads(Session session, String marketName) {
    Query query = session.createQuery("select sum(downloads) from MarketApp where marketName =:marketName");
    query.setParameter("marketName", marketName);
    Object o = query.uniqueResult();
    if (o != null) {
        return Long.valueOf(o.toString());
    }
    return 0;
}
 

import org.hibernate.Query; //导入方法依赖的package包/类
@Override
public int getAppsRollRecommendNum() {
    Query query = getSession().createQuery("select intValue from SysDictionary where name = 'recommendCount'");
    Object o = query.uniqueResult();
    if (o != null) {
        return ((Integer) o).intValue();
    }
    return 0;
}
 

import org.hibernate.Query; //导入方法依赖的package包/类
@Override
   public Float getQuestionResultMark(Long assessmentUid, Long userId, int questionSequenceId) {
Query q = getSession().createQuery(GET_ANSWER_MARK);
q.setParameter(0, assessmentUid);
q.setParameter(1, userId);
q.setParameter(2, questionSequenceId);
q.setMaxResults(1);
Object result = q.uniqueResult();
return result != null ? ((Number) result).floatValue() : null;

   }
 

import org.hibernate.Query; //导入方法依赖的package包/类
@Override
   public int getCountUsers(String searchPhrase) {
StringBuilder queryBuilder = new StringBuilder("SELECT count(*) FROM User user WHERE user.disabledFlag=0 ");
// support for custom search from a toolbar
UserDAO.addNameSearch(queryBuilder, "user", searchPhrase);

Query query = getSession().createQuery(queryBuilder.toString());

Number count = (Number) query.uniqueResult();
return count == null ? 0 : count.intValue();
   }
 

import org.hibernate.Query; //导入方法依赖的package包/类
@Override
   public Float getLastTotalScoreByUser(Long assessmentUid, Long userId) {

Query q = getSession().createQuery(LAST_ASSESSMENT_RESULT_GRADE);
q.setParameter(0, userId);
q.setParameter(1, assessmentUid);
Object lastTotalScore = q.uniqueResult();

return (lastTotalScore == null) ? 0 : (Float)lastTotalScore;
   }
 

import org.hibernate.Query; //导入方法依赖的package包/类
@Override
public boolean exists(String name) {
    String queryString = "select count(id) from Keyword where name = :name ";
    Query q = getSession().createQuery(queryString);
    q.setParameter("name", name);
    Long count = (Long) q.uniqueResult();
    if (count != null && count.longValue() > 0L) {
        return true;
    }
    return false;
}
 

import org.hibernate.Query; //导入方法依赖的package包/类
@Override
public long count(String type) {
    StringBuilder queryString = new StringBuilder("select count(id) from ").append(getType().getName());
    queryString.append(" where type = :type and hidden = 0");
    Query query = getSession().createQuery(queryString.toString());
    query.setParameter("type", type);
    Object o = query.uniqueResult();
    return Long.valueOf(o.toString());
}
 

import org.hibernate.Query; //导入方法依赖的package包/类
@Override
public long count() {
    Query query = getSession().createQuery("select count(id) from App");
    Object o = query.uniqueResult();
    return Long.valueOf(o.toString());
}
 

import org.hibernate.Query; //导入方法依赖的package包/类
@Override
public long count() {
    Query query = getSession().createQuery("select count(id) from App where hidden = 0");
    Object o = query.uniqueResult();
    return Long.valueOf(o.toString());
}
 

import org.hibernate.Query; //导入方法依赖的package包/类
@Override
public Object findUniObjs(String hql,Object... values ) {
	Query q = createQuery(hql, values);
	return q.uniqueResult();
}