急急急，为什么这段代码会抛出result is closed异常。。。在读取一轮之后

Question

void showTree(){
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }catch(ClassNotFoundException ce){
            System.out.println(ce);
        }
        try{
            root.removeAllChildren();
            Connection con=DriverManager.getConnection("jdbc:odbc:assetManage");
            Statement s=con.createStatement();
            ResultSet rs1=s.executeQuery("select classOne from assetSort group by classOne");            
            String name;
            while(rs1.next()){
                name=rs1.getString(1);
                DefaultMutableTreeNode parent = new DefaultMutableTreeNode(name);
                treeModel.insertNodeInto(parent,root,0);               
                ResultSet rs2=s.executeQuery("select classTwo from assetSort where classOne='"+name+"'");
                while(rs2.next()){
                    DefaultMutableTreeNode leaf = new DefaultMutableTreeNode(rs2.getString(1));
                    treeModel.insertNodeInto(leaf,parent,0);
                }
                treeModel.reload(root);
            }           
        }catch(SQLException se){
            System.out.println(se);
        }
    }

Answer 1

此回复为自动发出,仅用于显示而已，并无任何其他特殊作用
楼主【yuyistar】截止到2008-07-04 20:45:38的历史汇总数据(不包括此帖)：
发帖的总数量:66                       发帖的总分数:980                      
结贴的总数量:55                       结贴的总分数:720                      
无满意结贴数:19                       无满意结贴分:490                      
未结的帖子数:11                       未结的总分数:260                      
结贴的百分比:83.33 %               结分的百分比:73.47 %                  
无满意结贴率:34.55 %               无满意结分率:68.06 %                  
楼主加油

Answer 2

void showTree(){ 
        try{ 
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
        }catch(ClassNotFoundException ce){ 
            System.out.println(ce); 
        } 
        try{ 
            root.removeAllChildren(); 
            Connection con=DriverManager.getConnection("jdbc:odbc:assetManage"); 
            Statement s=con.createStatement(); 
            ResultSet rs1=s.executeQuery("select classOne from assetSort group by classOne");            
            String name; 
            while(rs1.next()){ 
                name=rs1.getString(1); 
                DefaultMutableTreeNode parent = new DefaultMutableTreeNode(name); 
                treeModel.insertNodeInto(parent,root,0);              
                ResultSet rs2=s.executeQuery("select classTwo from assetSort where classOne='"+name+"'"); 
                while(rs2.next()){ 
                    DefaultMutableTreeNode leaf = new DefaultMutableTreeNode(rs2.getString(1)); 
                    treeModel.insertNodeInto(leaf,parent,0); 
                } 
                treeModel.reload(root); 
            }          
        }catch(SQLException se){ 
            System.out.println(se); 
        } 
    }
你通过同一个 Statement 打开第二个结果集时第一个就自动关了。

Answer 3

你可以打开两个 statment或者 把第一次的 ResultSet 中想要的结果放到List或别的什么中存起来，再循环