树.java

第一学期编写的JAVA程序

package 固定资产管理系统;

import java.awt.BorderLayout;

import javax.swing.JPanel;
import javax.swing.JTree;
import java.awt.*;
import javax.swing.JScrollPane;
import javax.swing.*;
import javax.swing.tree.DefaultTreeModel;
import javax.swing.tree.DefaultMutableTreeNode;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.event.TreeSelectionEvent;
import javax.swing.event.TreeSelectionListener;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class 树 extends JPanel
{
    JScrollPane jScrollPane1 = new JScrollPane();
    JButton btn查询类别 = new JButton();
    JTree jTree1 = new JTree();
    DefaultMutableTreeNode root=new DefaultMutableTreeNode("根节点");
    DefaultMutableTreeNode parent0=new DefaultMutableTreeNode();
    DefaultMutableTreeNode parent1=new DefaultMutableTreeNode();
    DefaultMutableTreeNode parent2=new DefaultMutableTreeNode();

    public 树() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception
    {
        this.setLayout(null);
        jScrollPane1.setHorizontalScrollBarPolicy(JScrollPane.
                                                  HORIZONTAL_SCROLLBAR_ALWAYS);
        jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
        jScrollPane1.setBounds(new Rectangle(0, 1, 163, 280));
        jTree1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jTree1.addTreeSelectionListener(new 树_jTree1_treeSelectionAdapter(this));

        btn查询类别.setBounds(new Rectangle(20, 297,90, 30));
        btn查询类别.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        btn查询类别.setText("查询类别");
        btn查询类别.addActionListener(new 树_btn查询类别_actionAdapter(this));
        this.add(jScrollPane1);
        jScrollPane1.getViewport().add(jTree1);
        this.add(btn查询类别);
        jScrollPane1.setVisible(true);
        this.setVisible(true);
    }

    public void btn查询类别_actionPerformed(ActionEvent e) {
        连接 l=new 连接();
        Connection con=l.ver();
        DefaultMutableTreeNode node=(DefaultMutableTreeNode)jTree1.getLastSelectedPathComponent();
        String name= node.getParent().toString();
        try {
            PreparedStatement pst=con.prepareStatement("select subcatename from category资产类别表 where catename=?");
            pst.setString(1,name);
            ResultSet rs=pst.executeQuery();
            rs.next();
            DefaultMutableTreeNode leaf_00 = new DefaultMutableTreeNode(rs.getString("subcatename").trim());
            parent0.add(leaf_00);
            root.add(parent0);
            DefaultTreeModel mode = new DefaultTreeModel(root);
            jTree1.setModel(mode);
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    public void shu()
    {
        连接 l=new 连接();
        Connection con = l.ver();
        try {
            PreparedStatement pst = con.prepareStatement( "select distinct catename from category资产类别表");
            ResultSet rs = pst.executeQuery();
            int i=0;
           while(rs.next())
           {
               DefaultMutableTreeNode parent_i=new DefaultMutableTreeNode(rs.getString("catename"));
               root.add(parent_i);
               i++;
           }
            DefaultTreeModel mode = new DefaultTreeModel(root);
            jTree1.setModel(mode);
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public void jTree1_valueChanged(TreeSelectionEvent e) {
        DefaultMutableTreeNode node=(DefaultMutableTreeNode)jTree1.getLastSelectedPathComponent();
        Object nodeInfo=node.getUserObject();
    }


}


class 树_jTree1_treeSelectionAdapter implements TreeSelectionListener {
    private 树 adaptee;
    树_jTree1_treeSelectionAdapter(树 adaptee) {
        this.adaptee = adaptee;
    }

    public void valueChanged(TreeSelectionEvent e) {
        adaptee.jTree1_valueChanged(e);
    }
}


class 树_btn查询类别_actionAdapter implements ActionListener {
    private 树 adaptee;
    树_btn查询类别_actionAdapter(树 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btn查询类别_actionPerformed(e);
    }
}