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: 无效的列索引为什么会出现这个问题?
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: 无效的列索引为什么会出现这个问题?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货