stmt = conn.createStatement();
String totsql = "select AcctStartTime, count(*) as number from radacct group by day(AcctStartTime)";
rs=stmt.executeQuery(totsql);
String sql2="select AcctStartTime,usergroup.userstate,count(*) as num from radacct,usergroup where radacct.UserName=usergroup.UserName group by (day(AcctStartTime)),usergroup.userstate";
rs1=stmt.executeQuery(sql2);
这样写有错吗?
为什么抛异常java.sql.SQLException: Operation not allowed after ResultSet closed
String totsql = "select AcctStartTime, count(*) as number from radacct group by day(AcctStartTime)";
rs=stmt.executeQuery(totsql);
String sql2="select AcctStartTime,usergroup.userstate,count(*) as num from radacct,usergroup where radacct.UserName=usergroup.UserName group by (day(AcctStartTime)),usergroup.userstate";
rs1=stmt.executeQuery(sql2);
这样写有错吗?
为什么抛异常java.sql.SQLException: Operation not allowed after ResultSet closed
写两个Statement就行了.
异常抛出:
不允许在结果集关闭后进行操作。
关闭连接最好在finally里做吧