Hibernate多表关联的特殊问题。

Question

现在有两张表account和department，两张表当中没有任何关联。现在要执行这样的查询：select a.accountCode,a.accountPassword,a.regDate,a.endReg,d.department from Account a,Department d where a.department = d.id这个语句在MySQL数据库里面能够实现功能。将查询的结果放到一个list里面，但是不能够将数据显示到前台页面。（前台页面使用struts标签）而且报错误：严重: Servlet.service() for servlet jsp threw exception
java.lang.NumberFormatException: For input string: "id"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)我在前台页面有个标签是：<logic:iterate id="account" name="account">
<tr>
<td>
   ${account.id }
</td>有人说是没有设置结果集，我查阅资料以后，发现毫无关联的2个表无法设置结果集。请问，要解决此问题，应该怎么样去做？

Answer 1

a.accountCode,a.accountPassword,a.regDate,a.endReg,d.department
只知道，上面的属性要是显示出来得把他们转换成Object[]

Answer 2

楼上的兄弟，你的意思是不是说这样做：String queryString = "select a.accountCode,a.accountPassword,a.regDate,a.endReg,d.department 
from Account a,Department d where a.department = d.id";ArrayList list = (ArrayList) this.getHibernateTemplate().find(queryString);

Object[] o;

Iterator iterator1 = list.iterator();

while (iterator1.hasNext()) {

o = (Object[]) iterator1.next();

Account account = (Account) o[0];

Department department = (Department) o[1];

System.out.println(account.getId()+"***"+department.getDepartment());

}可是这样做结果报错了。错误信息是：ERROR - Dispatch[/account] to method 'accountFindAll' returned an exception
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.Error: Unresolved compilation problem: 
Type mismatch: cannot convert from Object to List at com.inspur.ssh.spring.service.AccountService.accountFindAll(AccountService.java:35)
at com.inspur.ssh.struts.action.AccountAction.accountFindAll(AccountAction.java:75)
... 24 more
请问这样怎么办呢？