hql获取记录条数
String hql = "select count(ci.channelid) as count from ChannelInfo ci";
query = arg0.createQuery(hql);
count = ((Number) query.iterate().next())
.intValue();
Criteria获取记录条数
totalPage = ((Number) crit.setProjection(
Projections.rowCount()).uniqueResult())
.intValue();
sql获取记录条数
String sql = "select count(ca.CATALOGLID) as count from PLATFORM_CATALOG_INFO ca, PLATFORM_CHANNEL_INFO ch where ch.CHANNELID= '"
+ channelid
+ "' and ca.CHANNELID = ch.CHANNELID order by ca.CATALOGLID";
return session.createSQLQuery(sql).addScalar("count",
Hibernate.INTEGER).uniqueResult();