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 from dgprocessstatus where rwh = gxmxb.rwh and ";
hsql = hsql+"gzh = rwfpb.gzh and jh = gxmxb.jh and gxh = gxh) as ,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.zzjh = '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.finish = '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循环放到这个里面
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 from dgprocessstatus where rwh = gxmxb.rwh and ";
hsql = hsql+"gzh = rwfpb.gzh and jh = gxmxb.jh and gxh = gxh) as ,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.zzjh = '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.finish = '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循环放到这个里面
正确的话,
用 JSP<%%> 脚本就行.
把你这个htmlCount.toString();
保存在request.setAttribute(); 或者 保存在 session.setAttribute();中
然后转发到 JSP页面 执行. 就OK了.
LZ 是这个意思不?
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循环吗 那样就可以了吧
private String ZZCJ;
public String getZZCJ() {
return ZZCJ;
}
public void setZZCJ(String zzcj) {
ZZCJ = zzcj;
}
public String getZZJHRQ() {
return ZZJHRQ;
}
public void setZZJHRQ(String zzjhrq) {
ZZJHRQ = zzjhrq;
}
public String getGXNAME() {
return GXNAME;
}
public void setGXNAME(String gxname) {
GXNAME = gxname;
}
public String getRWH() {
return RWH;
}
public void setRWH(String rwh) {
RWH = rwh;
}
public String getGZH() {
return GZH;
}
public void setGZH(String gzh) {
GZH = gzh;
}
public String getJH() {
return JH;
}
public void setJH(String jh) {
JH = jh;
}
public String getGXH() {
return GXH;
}
public void setGXH(String gxh) {
GXH = gxh;
}
public String getDJDE() {
return DJDE;
}
public void setDJDE(String djde) {
DJDE = djde;
}
public String getDE_LX() {
return DE_LX;
}
public void setDE_LX(String de_lx) {
DE_LX = de_lx;
}
public String getMARK() {
return MARK;
}
public void setMARK(String ) {
MARK = ;
}
public String getGXCONTENT() {
return GXCONTENT;
}
public void setGXCONTENT(String gxcontent) {
GXCONTENT = gxcontent;
}
private String ZZJHRQ;
private String GXNAME;
private String RWH;
private String GZH;
private String JH;
private String GXH;
private String DJDE;
private String DE_LX;
private String MARK;
private String GXCONTENT;
}
都写好了的
List<Object[]> rwlist = null;
String hsql = "select kind,gzh,rwh,gzkind from rwfpb where plan = '0'";
List lst = new ArrayList();
rwlist = service.getListall(hsql);
recbean rec=new recbean ();
for(Object[] objs :rwlist){
rec.setRw_kind((String) objs[0]);
rec.setRw_gzh((String) objs[1]);
rec.setRw_rwh((String) objs[2]);
lst.add(rec);
}
这是一个简化版 ,大体意思就是我自己写了个BEAN 然后先把得到的值SET进去 然后lst.add(rec);
科室传递到JSP里面的话 就任务号都一样了,事实上市部一样的
List<Object[]> rwlist = null;
String hsql = "select kind,gzh,rwh,gzkind from rwfpb where plan = '0'";
List lst = new ArrayList();
rwlist = service.getListall(hsql);
recbean rec=new recbean ();for(Object[] objs :rwlist){rec.setRw_kind((String) objs[0]);
rec.setRw_gzh((String) objs[1]);
rec.setRw_rwh((String) objs[2]);lst.add(rec);
}
这是一个简化版 ,大体意思就是我自己写了个BEAN 然后先把得到的值SET进去 然后lst.add(rec);
科室传递到JSP里面的话 就任务号都一样了,事实上市部一样的
底层最开始方法是这个public List getListall(String hsql) {
Query queryObject = getSession().createSQLQuery(hsql);
List<Object[]> list = queryObject.list();
return list;
我ACTION最后的
是 RETURN NULL;的 不FORWARD任何页的
String hsql = "select kind,gzh,rwh,gzkind from rwfpb where plan = '0'";
List lst = new ArrayList();
rwlist = service.getListall(hsql);
recbean rec=new recbean ();for(Object[] objs :rwlist){rec.setRw_kind((String) objs[0]);
rec.setRw_gzh((String) objs[1]);
rec.setRw_rwh((String) objs[2]);lst.add(rec);
}
这么短的代码 就是这里的问题了 我跟踪了 LST里面是37行 这是没问题的,每行都是一个recbean
里面任务号都不一样啊
你构造了一个recbean 对象之后 开辟了一块内存
所以你添加的其实是同一块内存里的recbean
就是说你后面的内容把前面的内容覆盖了
你的问题是不是输出的都是同样的内容??
放到for循环里去就可以了