浏览 832 次
|
该帖已经被评为新手帖
|
|
|---|---|
| 作者 | 正文 |
|
最后更新时间:2006-12-10
Hibernate 连表查询,我想在Jsp页面取他应该怎么取HashMap ** :oops: 不要用标签!!
public HashMap queryFundAccountByNumberedAccount(String numberedAccount) throws HibernateException{ HashMap queryFunds; Session session=null; try{ session=HibernateSessionFactory.getSession(); Query q=session.createQuery("select funds.numberedAccount," + "funds.amountOfMoney,funds.accountOpenTime," + "cust.customerId,cust.name " + "from FundsAccount as funds " + "join funds.customers as cust " + "where funds.numberedAccount= '"+numberedAccount+"'"); List li=q.list(); Iterator it=li.iterator(); if(it.hasNext()){ Object[] bean =(Object[])it.next(); String numberedAc=(String)bean[0]; Double prise=(Double)bean[1]; Date dateTime=(Date)bean[2]; Integer id=(Integer)bean[3]; String name=(String)bean[4]; queryFunds=new HashMap(); queryFunds.put("numberedAccount", numberedAc); queryFunds.put("accountOfMoney", prise); queryFunds.put("accountOpenTime", dateTime); queryFunds.put("customerId", id); queryFunds.put("name", name); }else{ queryFunds=null; } }catch(HibernateException he){ throw he; }finally{ HibernateSessionFactory.closeSession(); } return queryFunds; } 声明:JavaEye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
|
|
| 返回顶楼 | |


