jtreemodel2.java

一个个人信息管理系统

package soft1Method;

import javax.swing.JTree;
import javax.swing.tree.DefaultMutableTreeNode;
import soft1Method.*;
import java.sql.SQLException;
import java.sql.ResultSet;

public class JTreeModel2 {
    public JTreeModel2() {
    }
        Dataset2 dt = new Dataset2();
        GetValue gv=new GetValue();
     public DefaultMutableTreeNode Root = new DefaultMutableTreeNode("所有工作(类型视图)", true);
      public  JTree JTreeModel2() throws ClassNotFoundException, SQLException {

      String s = "Select * from WorkPadSort ";
           ResultSet rs= dt.Rs(s);
           while (rs.next()) {
               String sort1=rs.getString("Sort");
               DefaultMutableTreeNode node = new DefaultMutableTreeNode(sort1);
               Root.add(node);
               String s2="select * from WorkPad where Sort='"+sort1+"'and UserName='"+gv.Getvalue()+"'";
               ResultSet rs2;
               rs2=dt.Rs(s2);
             while(rs2.next()){
                    DefaultMutableTreeNode node2 = new DefaultMutableTreeNode(rs2.getString("Caption"));
                    node.add(node2);
               }
           }


     JTree jtree1=new JTree(Root);
     return jtree1;
   }

   public  void JtreeRepaind( JTree jt) throws SQLException, ClassNotFoundException {
      jt=JTreeModel2();
   }


}