补充一下,我已经实现查询,并在后台打印出来,但没找到方法把数据显示出来,望高手指点:
public String FindStuError()throws Exception{
String sqlstr=" select aa,bb";
sqlstr+=" from Student aa,StuError bb";
sqlstr+=" where aa.stuNo=bb.stuNo " ;
Query query=getEntityManager().createQuery(sqlstr);
List Student_Errors=query.getResultList();
iterator1 = Student_Errors.iterator();
while (iterator1.hasNext()) {
obj = (Object[]) iterator1.next();
Student s = (Student)obj[0];
StuError e=(StuError)obj[1];
System.out.print(s.getStuNo());
System.out.print(s.getStuName());
System.out.print(e.getError());
System.out.print(s.getHomePhone());
System.out.print(s.getFamilyAddr());
}
return "success";
}
public String FindStuError()throws Exception{
String sqlstr=" select aa,bb";
sqlstr+=" from Student aa,StuError bb";
sqlstr+=" where aa.stuNo=bb.stuNo " ;
Query query=getEntityManager().createQuery(sqlstr);
List Student_Errors=query.getResultList();
iterator1 = Student_Errors.iterator();
while (iterator1.hasNext()) {
obj = (Object[]) iterator1.next();
Student s = (Student)obj[0];
StuError e=(StuError)obj[1];
System.out.print(s.getStuNo());
System.out.print(s.getStuName());
System.out.print(e.getError());
System.out.print(s.getHomePhone());
System.out.print(s.getFamilyAddr());
}
return "success";
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货