hibernate 用SQLQuery/HQL查询的 查询 记录是否存在。

SQLQuery 方式:

String sql = "select count(*) from picture_label pl where pl.pic_id = ? and pl.label_id = ?";
		
		SQLQuery query = getCurrentSession().createSQLQuery(sql);
		query.setParameter(0, pid);
		query.setParameter(1, labelId);
		
		BigInteger count =  (BigInteger)query.uniqueResult();
		return count.intValue()>0?true:false;

HQL方式：

String hql = "select count(*) from Label l where l.labelName =  ?";
		Query query = this.createQuery(hql, new Object[]{labelName});
		Long count =  (Long)query.uniqueResult();
		return count>0?true:false;