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;
hibernate查询结果是否存在于数据库中
最新推荐文章于 2024-04-18 03:43:49 发布