在需要将数据导出的地方,由于数据量大,将数据放到内存会导致内存爆掉,所以不能使用list直接导出。
方法1、分页方式,一页一页到查询,每次用完也个对象,记得session.evict(obj),避免持久对象堆积
方法2、使用iterator,会产生N+1查询问题
Query query = session.createQuery(sql);
Iterator iterator = query.iterate();
out = response.getWriter();
StringBuffer bf = new StringBuffer(1000);
while(iterator.hasNext())
{
row++;
Vo obj = (Vo) iterator.next();
temp = obj.getA()+","+ obj.getB();
bf.append("\r\n" ).append(temp);
if(row % 100 == 0)
{
temp = bf.toString();
out.print(temp);
out.flush();
bf.delete(0, bf.length());
}
session.evict(obj);
}
方法3、使用ScrollableResults,这个有点类似于ResultSet,不过mysql驱动不支持,因为mysql的connect/j驱动还是会将所有数据一次性加载到内存中
public List<StockRequisition> getAllBillList(){
Session session=HibernateSessionFactory.getSession();
ScrollableResults srs=null;
String hql="select distinct s.billNumber,s.billDate,s.billState,s.department from StockRequisition as s";
List<StockRequisition> list=new ArrayList<StockRequisition>();
try{
Query q=session.createQuery(hql);
srs=q.scroll();
while(srs.next()){
StockRequisition stock=new StockRequisition();
stock.setBillNumber(srs.getString(0));
stock.setBillDate(srs.getDate(1));
stock.setBillState(srs.getString(2));
stock.setDepartment((Department)srs.get(3));
list.add(stock);
}
}catch(Exception e){
e.printStackTrace();
}finally{
srs.close();
session.close();
}
return list;
}