表明用类名比如com.xxx.tb_rz_yhsjxx表示,字段用tb_rz_yhsjxx类的相应属性代替就可以了
解决方案 »
- 求助,读取网络上的PDF内容......
- 求助,关于根据树结构自动生成表的技术和方法
- 很简单:刚入门JAVA的 web project 的 hello.jsp 小问题
- Could not load net/sourceforge/jtds/jdbc/Messages_zh_CN.properties这个错误是怎么回事啊?
- dos运行JAVA 程序时,如果希望显式程序运行的时间,该如何设置??
- java.security.AccessControlException: access denied (java.io.FilePermission webAPPDOC.doc write)
- JSP 中Unable to open location出错
- 如何用logic:iterate实现嵌套?
- hibernate中什么方法能返回查询到的结果数量?
- java如何接入互联网而不是局域网
- struts1.1例子的一些语句不太明白
- 求救各位大哥
session=sf.openSession();
trans=session.beginTransaction();
Iterator it=session.iterate("select yhzh,to_char(logoutdate,'YYYY-MM-DD'),sum(totf) from Tb_rz_yhsjxx group by yhzh,to_char(logoutdate,'YYYY-MM-DD'); ");
if(it.hasNext()){
i=((Integer)it.next()).intValue();
}
trans.commit();
}catch(Exception e){z}
注意,你的Tb_rz_yhsjxx是一个类文件(普通的get,set)。和tb_rz_yhsjxx的字段是对应的
我用Iterator it=session.iterate("select yhzh,to_char(logoutdate,'YYYY-MM-DD'),sum(totf) from Tb_rz_yhsjxx group by yhzh,to_char(logoutdate,'YYYY-MM-DD'); ");
抛出异常:
net.sf.hibernate.QueryException: undefined alias: yhzh [select yhzh,to_char(xx.logoutdate,'YYYY-MM-DD'),sum(xx.totf) from blnkboss.verify.entitybean.TbRzYhsjxx as xx group by xx.yhzh,to_char(xx.logoutdate,'YYYY-MM-DD'); ]
我用 Iterator it=s.iterate("select xx.yhzh,to_char(xx.logoutdate,'YYYY-MM-DD'),sum(xx.totf) from blnkboss.verify.entitybean.TbRzYhsjxx as xx group by xx.yhzh,to_char(xx.logoutdate,'YYYY-MM-DD'); ");抛出异常:
net.sf.hibernate.QueryException: undefined alias: to_char [select xx.yhzh,to_char(xx.logoutdate,'YYYY-MM-DD'),sum(xx.totf) from blnkboss.verify.entitybean.TbRzYhsjxx as xx group by xx.yhzh,to_char(xx.logoutdate,'YYYY-MM-DD'); ]