使用hibernate3.1,strut1.2,数据库用mssqlserver2000
在执行 String hql=" FROM Oauser as a " ;
Vector myList1=new Vector();
ArrayList result1 = new ArrayList();
Transaction t = null;
t = this.session.beginTransaction();
Query q = this.session.createQuery(hql);
result1 = (ArrayList) q.list();
t.commit();
Iterator myIterator1= result1.iterator();
Oauser oauser=new Oauser();
while (myIterator1.hasNext())
{
Object[] o = (Object[]) myIterator1.next();
oauser=(Oauser) o[0];
System.out.println(oauser.getPoliceid());
}
后,报错:java.lang.ClassCastException: java.lang.String cannot be cast to [Ljava.lang.Obj
ect;
at common.db.dboperation.DbOperation.sendMessages(DbOperation.java:494)
at org.apache.jsp.oa.oapad.send_jsp._jspService(send_jsp.java:228)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:384)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
20)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:228)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:216)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:634)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
5)
at java.lang.Thread.run(Thread.java:619)
困扰我几天了 但是前面有个查询,可以照常使用,没有提示字符类型不匹配问题。
急救!!
在执行 String hql=" FROM Oauser as a " ;
Vector myList1=new Vector();
ArrayList result1 = new ArrayList();
Transaction t = null;
t = this.session.beginTransaction();
Query q = this.session.createQuery(hql);
result1 = (ArrayList) q.list();
t.commit();
Iterator myIterator1= result1.iterator();
Oauser oauser=new Oauser();
while (myIterator1.hasNext())
{
Object[] o = (Object[]) myIterator1.next();
oauser=(Oauser) o[0];
System.out.println(oauser.getPoliceid());
}
后,报错:java.lang.ClassCastException: java.lang.String cannot be cast to [Ljava.lang.Obj
ect;
at common.db.dboperation.DbOperation.sendMessages(DbOperation.java:494)
at org.apache.jsp.oa.oapad.send_jsp._jspService(send_jsp.java:228)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:384)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
20)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:228)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:216)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:634)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
5)
at java.lang.Thread.run(Thread.java:619)
困扰我几天了 但是前面有个查询,可以照常使用,没有提示字符类型不匹配问题。
急救!!
{
//Object[] o = (Object[]) myIterator1.next();
oauser=(Oauser) myIterator1.next();
System.out.println(oauser.getPoliceid());
}
还有前面直接用List接口就可以了
没有必要转为ArrayList试下把。
直接就可以了
oauser=(Oauser) myIterator1.next();
oauser=(Oauser) o[0]; 按你的思路改成这样应该也可以
Object o = myIterator1.next();
oauser=(Oauser) o;
看看这句String hql=" FROM Oauser as a " ;
查出的是Oauser该类的所有属性的数组object[]
比如Oauser类里有name,password等
并且name是String类型
那么你取出的时候
就应该这样去定义String name=(String)object[0]
再看看这句异常java.lang.ClassCastException: java.lang.String cannot be cast to [Ljava.lang.Obj
ect; 一个String类型的变量不能付给这个oauser;
所以的话如果你想取到oauser;
就这样Object o = myIterator1.next();
oauser=(Oauser) o;
========================
List result1 = this.session.createQuery(hql).list();
Iterator myIterator1= result1.iterator();
Oauser oauser=new Oauser();
while (myIterator1.hasNext())
{
里面直接list便利就可以了
}
返回的是一个List这没错,但List里装的是Oauser实体类,也就是说
Oauser oauser=(Oarser)myIterator1.next();
但如果是:select a.col1,a.col2 From Oauser as a这样返回List里面是Ojbect[]
改成
Object o = (Object) myIterator1.next();
就可以了
改成
Object o = (Object) myIterator1.next();
就可以了