<%@ page import="java.sql.*"%>
<jsp:useBean id="db" class="my.beans.DBconnect" scope="page"></jsp:useBean>
String sql_group = "select hykh,count(hykh) as hykh_cnt,sum(xfje) as xfje_sum from mytest group by hykh ";
ResultSet rs_group= db.executeQuery(sql_group);
String hykh_temp="";
String xfje_sum="";
String hykh_count="";
while(rs_group.next())
{
hykh_temp=rs_group.getString("hykh");
hykh_count=rs_group.getString("hykh_cnt");
xfje_sum=rs_group.getString("xfje_sum");
}
rs_group.close();提示错误:java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 无效的游标状态
如果只用if(rs_group.next())取一条记录,可以;
如果去掉分组:String sql_group = "select hykh as xfje_sum from mytest ";
再修改相应的变量就可以?
<jsp:useBean id="db" class="my.beans.DBconnect" scope="page"></jsp:useBean>
String sql_group = "select hykh,count(hykh) as hykh_cnt,sum(xfje) as xfje_sum from mytest group by hykh ";
ResultSet rs_group= db.executeQuery(sql_group);
String hykh_temp="";
String xfje_sum="";
String hykh_count="";
while(rs_group.next())
{
hykh_temp=rs_group.getString("hykh");
hykh_count=rs_group.getString("hykh_cnt");
xfje_sum=rs_group.getString("xfje_sum");
}
rs_group.close();提示错误:java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 无效的游标状态
如果只用if(rs_group.next())取一条记录,可以;
如果去掉分组:String sql_group = "select hykh as xfje_sum from mytest ";
再修改相应的变量就可以?
这条语句写对了么?在数据库里面测试了没,能查到数据?
如果能的话那就是access的问题了
现在几乎没人用access
下面两个方法试一下,不肯定哪个正确的
group by hykh,hykh,xfje
group by hykh,hykh_cnt,xfje_sum
select hykh,count(hykh) as hykh_cnt,sum(xfje) as xfje_sum from mytest group by hykh