Hibernate分页时的一个查找方法:
public List findAll(int start, int maxResult) {
Session session = sessionfactory.openSession();
List list=null;
try {
ApplicationContext context= new ClassPathXmlApplicationContext("applicationContext.xml");
SessionFactory sessionfactory =(SessionFactory)context.getBean("sessionfactory"); Transaction tran=session.beginTransaction();
Criteria criteria=session.createCriteria(Fund.class);
criteria.setFirstResult(start);
criteria.setMaxResults(maxResult);
list=criteria.list();
tran.commit();
return list;
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return list;
}
}
//////////////////////////////////////////////////////////////////////////////////////
以下是配置文件 Fund.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
<class name="com.alece.pojo.Fund" table="FUND" schema="SCOTT">
<id name="fundNo" type="java.lang.Long">
<column name="FUND_NO" precision="20" scale="0" />
<generator class="assigned" />
</id>
<property name="fundName" type="java.lang.String">
<column name="FUND_NAME" length="20" unique="true" />
</property>
<property name="price" type="java.lang.String">
<column name="PRICE" />
</property>
<property name="description" type="java.lang.String">
<column name="DESCRIPTION" length="50" />
</property>
<property name="status" type="java.lang.String">
<column name="STATUS" length="10" />
</property>
<property name="createdDate" type="java.util.Date">
<column name="CREATED_DATE" length="7" />
</property>
<set name="fundAccounts" inverse="true">
<key>
<column name="FUND_NO" precision="20" scale="0" />
</key>
<one-to-many class="com.alece.pojo.FundAccount" />
</set>
</class>
</hibernate-mapping>查找方法返回的LIST为NULL??
请教高人帮忙
楼主【wangweirong1205】截止到2008-07-12 00:37:16的历史汇总数据(不包括此帖):
发帖的总数量:2 发帖的总分数:40 每贴平均分数:20
回帖的总数量:0 得分贴总数量:0 回帖的得分率:0%
结贴的总数量:0 结贴的总分数:0
无满意结贴数:0 无满意结贴分:0
未结的帖子数:2 未结的总分数:40
结贴的百分比:0.00 % 结分的百分比:0.00 %
无满意结贴率:---------------------无满意结分率:---------------------
如何结贴请参考这里:http://topic.csdn.net/u/20080501/09/ef7ba1b3-6466-49f6-9d92-36fe6d471dd1.html
List list = session.createQuery(hql).setFirstResult(start).setMaxResults(maxResult).list();