hibernate中关联映射后如何查询
- 作者: -楠er
- 来源: 51数据库
- 2021-01-30
@Override
public?ChannelTalkItem[]?findByPage(final?String?channelID,?final?int?startPos,
final?int?pageCount)?{
List?itemList?=?this.getHibernateTemplate().execute(new?HibernateCallback<>>(){
@Override
public?List?doInHibernate(Session?session)
throws?HibernateException,?SQLException?{
Query?query?=?session.createQuery("from?ChannelTalkItem?c?where?c.channelID?=:channelId?order?by?c.talkTime?asc");
query.setString(?"channelId",?channelID);
query.setFirstResult(startPos);
query.setMaxResults(pageCount);
return?query.list();
}
});
ChannelTalkItem[]?rets?=?new?ChannelTalkItem[itemList.size()];
itemList.toArray(rets);
return?rets;
}可以参考一下
你说呢...
public?ChannelTalkItem[]?findByPage(final?String?channelID,?final?int?startPos,
final?int?pageCount)?{
List
@Override
public?List
throws?HibernateException,?SQLException?{
Query?query?=?session.createQuery("from?ChannelTalkItem?c?where?c.channelID?=:channelId?order?by?c.talkTime?asc");
query.setString(?"channelId",?channelID);
query.setFirstResult(startPos);
query.setMaxResults(pageCount);
return?query.list();
}
});
ChannelTalkItem[]?rets?=?new?ChannelTalkItem[itemList.size()];
itemList.toArray(rets);
return?rets;
}可以参考一下
你说呢...
推荐阅读
