请教一个LIST,往JSP里面赋值的问题
public List getListall(String hsql) {
Query queryObject = getSession().createSQLQuery(hsql);
List list = queryObject.list();
return list;
}这是底层方法
String hsql = "select (select department from t_department where rwfpb.section=id) as zzcj,";
hsql = hsql+"to_char(rwfpb.zzjhrq,'yyyy-mm') as zzjhrq,";
hsql = hsql+"(select b_gxb.gxname from b_gxb where b_gxb.id = gxmxb.gxname) as gxname,";
hsql = hsql+"rwfpb.rwh,rwfpb.gzh,ljmxb.jh,gxmxb.gxh,gxmxb.djde,de_lx,";
hsql = hsql+"(select mark from dgprocessstatus where rwh = gxmxb.rwh and ";
hsql = hsql+"gzh = rwfpb.gzh and jh = gxmxb.jh and gxh = gxh) as mark,gxmxb.gxcontent ";
hsql = hsql+"from gxmxb,rwfpb,ljmxb ";
hsql = hsql+"where gxmxb.rwh = rwfpb.rwh and";
hsql = hsql+" gxmxb.gzh = rwfpb.gzh and";
hsql = hsql+" ljmxb.rwh = rwfpb.rwh and";
hsql = hsql+" ljmxb.gzh = rwfpb.gzh and";
hsql = hsql+" ljmxb.jh = gxmxb.jh and";
hsql = hsql+" rwfpb.isfinish = '0' and";
hsql = hsql+" gxmxb.wwbz= '0' and gxmxb.djde>0 and";
hsql = hsql+" rwfpb.section like '"+workshop+"'||'%'";
hsql = hsql+" and rwfpb.zzjhmark = '1' and to_char(rwfpb.pzdt,'yyyy-mm') like '"+m_jhyf+"'||'%'";
hsql = hsql+" and rwfpb.gzh like '"+m_gzh+"'||'%' and nvl(rwtype,' ') like '"+m_qr+"'||'%'";
hsql = hsql+" and rwfpb.xb like '"+m_xb+"'||'%' and pzrw like '"+m_pzrw+"'||'%' and gxmxb.finishmark = '0'";
hsql = hsql+" and gxmxb.gxname = '"+m_gxh+"' and de_lx in ('A','B','C')";
rwlist = service.getListall(hsql);这是SQL语句
List rwlist = service.getListall(hsql);
这是得到一个List多行的
for (int i = 0; i < lst.size(); i++) {
wwgzbean o =(wwgzbean) lst.get(i);
System.out.print(o.getJH());
htmlCount.append(" <tr>");
htmlCount.append(" <td>"+o.getRWH()+"</td>");
htmlCount.append(" <td>"+o.getGZH()+"</td>");
htmlCount.append(" <td>"+o.getJH()+"</td>");
htmlCount.append(" <td>"+o.getGXH()+"</td>");
htmlCount.append(" <td>"+o.getGXNAME()+"</td>");
htmlCount.append(" <td>"+o.getDE_LX()+"</td>");
htmlCount.append(" <td>"+o.getDJDE()+"</td>");
htmlCount.append(" <td>"+o.getMARK()+"</td>");
htmlCount.append(" <td>"+o.getZZCJ()+"</td>");
htmlCount.append(" <td>"+o.getZZJHRQ()+"</td>");
htmlCount.append(" </tr>");
}
我如何通过FOR循环放到这个里面