浏览 2766 次
该帖已经被评为新手帖
|
|
---|---|
作者 | 正文 |
发表时间:2006-12-10
![]() 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; } 声明:ITeye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
推荐链接
|
|
返回顶楼 | |