原生SQL查询 并循环获取其中的值
http://blog.51cto.com/images/editer/InBlock.gif Map mailSizeInfo=new HashMap();http://blog.51cto.com/images/editer/InBlock.gif try{http://blog.51cto.com/images/editer/InBlock.gif String sql =" select count(*) as mailCount,Mail_box_coding as mailCoding from oa_mail where ISSUANCE_ID =:userId group by Mail_box_coding";
http://blog.51cto.com/images/editer/InBlock.gif SQLQuery sqlQuery = (SQLQuery) super.getSession().createSQLQuery(sql).setString("userId",userId);
http://blog.51cto.com/images/editer/InBlock.gif List students = sqlQuery.list();
http://blog.51cto.com/images/editer/InBlock.gif for (Iterator iterator = students.iterator(); iterator.hasNext();) {
http://blog.51cto.com/images/editer/InBlock.gif Object[] mailInfo = iterator.next();
http://blog.51cto.com/images/editer/InBlock.gif logger.info("查询出的结果mailInfo mailCount"+mailInfo+"mailCoding"+mailInfo);
http://blog.51cto.com/images/editer/InBlock.gif mailSizeInfo.put(mailInfo,mailInfo);
http://blog.51cto.com/images/editer/InBlock.gif }
http://blog.51cto.com/images/editer/InBlock.gif }catch(Exception ex){
http://blog.51cto.com/images/editer/InBlock.gif ex.printStackTrace();
http://blog.51cto.com/images/editer/InBlock.gif throw new PageJumpException();
http://blog.51cto.com/images/editer/InBlock.gif }
页:
[1]