jtreemodel.java

一个个人信息管理系统

package soft1Method;

import javax.swing.JTree;
import javax.swing.tree.DefaultMutableTreeNode;
import com.borland.dbswing.JdbTree;
import soft1Method.*;
import java.sql.SQLException;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import java.awt.event.ActionEvent;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class JTreeModel {
    public JTreeModel() {
    }

    public JTree jtree() throws ClassNotFoundException, SQLException {

    DefaultMutableTreeNode Root = new DefaultMutableTreeNode("所有工作(类型视图)", true);
    DefaultMutableTreeNode Defau = new DefaultMutableTreeNode ("默认（无）");
    DefaultMutableTreeNode Import = new DefaultMutableTreeNode ("重要");
    DefaultMutableTreeNode Trans = new DefaultMutableTreeNode ("交付");
    DefaultMutableTreeNode Phone = new DefaultMutableTreeNode ("电话");
    DefaultMutableTreeNode Email = new DefaultMutableTreeNode ("邮件");
    DefaultMutableTreeNode Meeti = new DefaultMutableTreeNode ("会议");
    DefaultMutableTreeNode Beawa = new DefaultMutableTreeNode ("出差");
    Root.add (Defau);
    Root.add (Import);
    Root.add (Trans);
    Root.add (Phone);
    Root.add (Email);
    Root.add (Meeti);
    Root.add (Beawa);

    GetValue getvalue=new GetValue();
    Dataset2 dataset2=new Dataset2();

    String sql1="select * from WorkPad where UserName='"+getvalue.Getvalue()+"'and Sort='重要'";
    dataset2.Rs(sql1);
    ResultSet rs1=dataset2.Rs(sql1);
    while(rs1.next()){
    DefaultMutableTreeNode Import1 = new DefaultMutableTreeNode (rs1.getString("Caption"));
    Import.add(Import1);
    }

  String sql2="select * from WorkPad where UserName='"+getvalue.Getvalue()+"'and Sort='无'";
    dataset2.Rs(sql2);
    rs1=dataset2.Rs(sql2);
    while(rs1.next()){
        DefaultMutableTreeNode defau = new DefaultMutableTreeNode (rs1.getString("Caption"));
        Defau.add(defau);
    }

    String sql3="select * from WorkPad where UserName='"+getvalue.Getvalue()+"'and Sort='交付'";
    dataset2.Rs(sql3);
    ResultSet rs3=dataset2.Rs(sql3);
    while(rs3.next()){
        DefaultMutableTreeNode trans = new DefaultMutableTreeNode (rs3.getString("Caption"));
        Trans.add(trans);
    }

  String sql4="select * from WorkPad where UserName='"+getvalue.Getvalue()+"'and Sort='电话'";
    dataset2.Rs(sql4);
    ResultSet rs4=dataset2.Rs(sql4);
    while(rs4.next()){
        DefaultMutableTreeNode phone = new DefaultMutableTreeNode (rs4.getString("Caption"));
        Phone.add(phone);
    }

    String sql5="select * from WorkPad where UserName='"+getvalue.Getvalue()+"'and Sort='邮件'";
    dataset2.Rs(sql5);
    ResultSet rs5=dataset2.Rs(sql5);
    while(rs5.next()){
        DefaultMutableTreeNode email = new DefaultMutableTreeNode (rs5.getString("Caption"));
        Email.add(email);
    }

    String sql6="select * from WorkPad where UserName='"+getvalue.Getvalue()+"'and Sort='会议'";
    dataset2.Rs(sql6);
    ResultSet rs6=dataset2.Rs(sql6);
    while(rs6.next()){
        DefaultMutableTreeNode meeti = new DefaultMutableTreeNode (rs6.getString("Caption"));
        Meeti.add(meeti);
    }

    String sql7="select * from WorkPad where UserName='"+getvalue.Getvalue()+"'and Sort='出差'";
    dataset2.Rs(sql7);
    ResultSet rs7=dataset2.Rs(sql7);
    while(rs7.next()){
        DefaultMutableTreeNode beawa = new DefaultMutableTreeNode (rs7.getString("Caption"));
        Beawa.add(beawa);
    }



    JTree jTree1= new JTree (Root);

    return jTree1;


}
/*public void jdbTree_actionPerformed(ActionEvent e) throws SQLException,
            ClassNotFoundException {
    JTreeModel jt=new JTreeModel();
    JTree jt1=jt.jtree();
    System.out.println(jt1.getSelectionPaths().toString());
    }

*/


}