sql语句:
select w.operator as operator,a.activityname as activityname,count(*) as daysum,(select count(w.closed) from works w,ceb_ecm.activity a where w.activity=a.activityid and w.closed='1' and w.operator='dmadmin' and a.activityid='8a8130a50bd017fb010bd0181d300389' and to_char(w.receivetime,'yyyy-mm-dd')='2006-07-19') as daydeal,(select count(w.closed) from works w,ceb_ecm.activity a where w.activity=a.activityid and w.closed='0' and w.operator='dmadmin' and a.activityid='8a8130a50bd017fb010bd0181d300389' and to_char(w.receivetime,'yyyy-mm-dd')='2006-07-19') as daystore,to_char(w.receivetime,'yyyy-mm-dd') as receivedate from works w,ceb_ecm.activity a where w.activity=a.activityid and w.operator='dmadmin' and a.activityid='8a8130a50bd017fb010bd0181d300389' and to_char(w.receivetime,'yyyy-mm-dd')='2006-07-19' group by w.operator, to_char(w.receivetime,'yyyy-mm-dd'),a.activityname
数据库可以查询结果:
    OPERATOR ACTIVITYNAME DAYSUM DAYDEAL DAYSTORE RECEIVEDATE
dmadmin 身份信息           1 1 0 2006-07-19程序里:
while (resultSet != null && resultSet.next()) {
  System.out.println("rs.getString(1)="+rs.getString(1));
  System.out.println("rs.getString(2)="+rs.getString(2));
  System.out.println("rs.getString(3)="+rs.getString(3));
  System.out.println("rs.getString(4)="+rs.getString(4));
  System.out.println("rs.getString(5)="+rs.getString(5));
  System.out.println("rs.getString(6)="+rs.getString(6));
  worksActivityForm.setOperator(rs.getString(1));
  worksActivityForm.setActivityName(rs.getString(2));
  worksActivityForm.setDaysum(rs.getString(3));
  worksActivityForm.setDaydeal(rs.getString(4));
  worksActivityForm.setDaystore(rs.getString(5));
  worksActivityForm.setReceiveDate(rs.getString(6));
  list.add(worksActivityForm);
}后台:
rs.getString(1)=dmadmin
rs.getString(2)=8a8130a50bd017fb010bd0181d300389
rs.getString(3)=2006-07-19
javax.servlet.ServletException: 无效的列索引为什么会出现这个问题?