showtree.java

用java写的固定资产管理系统原代码 这可是自己小组做的哦

package com.cn.szhaccp.sill;

import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import javax.swing.JTree;
import javax.swing.JOptionPane;
import javax.swing.event.TreeSelectionEvent;
import javax.swing.event.TreeSelectionListener;
import javax.swing.tree.DefaultMutableTreeNode;

/**
 * @(#)ShowTree.java
 *
 *
 * @author 
 * @version 1.00 2007/4/27
 */


public class ShowTree {
    
    public ShowTree() {
    }

    public void ShowTrees() {
    	dbc = new DatabaseConnection();
    	try {
    		stmt = dbc.getConn().createStatement();
    		stmt1 = dbc.getConn().createStatement();
    		rs = stmt.executeQuery("SELECT Sort FROM AssetInfo GROUP BY Sort HAVING COUNT(Sort) >= 1");
    		tree = new JTree(parent);
    		while(rs.next()) {
    			leaf = new DefaultMutableTreeNode(rs.getString("Sort"));
    			parent.add(leaf);
    			rs1 = stmt1.executeQuery("SELECT Name FROM AssetInfo WHERE Sort = '" + rs.getString("Sort") + "'  GROUP BY Name");
    			while(rs1.next()) {
    				leaf.add(new DefaultMutableTreeNode(rs1.getString("Name")));
    			}
    			leaf = null;
    		}
    		stmt.close();
    		stmt1.close();
    	} catch(SQLException e) {
    		e.printStackTrace();
    	}

    	tree.addTreeSelectionListener(new TreeSelectionListener() {
    		public void valueChanged(TreeSelectionEvent eg) {
    			try {
    				stmt = dbc.getConn().createStatement();
    				selected = (DefaultMutableTreeNode) tree.getLastSelectedPathComponent();
    				if(selected.isRoot()) {
    					rs = dbc.getRs();
    				} else if(selected.isLeaf()) {
    					rs = stmt.executeQuery("SELECT Code 编号,Name 资产名称,Sort 资产类别,Model 资产型号,Merit 资产价值,BuyDate 购买日期,State 当前状态,UserName 借用者,Remark 备注 FROM AssetInfo WHERE Name = '" + tree.getLastSelectedPathComponent().toString() + "'");
    				} else {
    					rs = stmt.executeQuery("SELECT Code 编号,Name 资产名称,Sort 资产类别,Model 资产型号,Merit 资产价值,BuyDate 购买日期,State 当前状态,UserName 借用者,Remark 备注 FROM AssetInfo WHERE Sort = '" + tree.getLastSelectedPathComponent().toString() + "'");
    				}
                                MainFrame.rm.refresh();
    				MainFrame.rm.setResult(rs);
    			} catch(SQLException e) {
    				System.out.println(e);
    			} catch(Exception ex) {
    				System.out.println(ex);
    			}
    		}
   		});
    }
    
    public JTree getTree() {
    	return tree;
    }
    
    private DatabaseConnection dbc;
    private JTree tree;
    private DefaultMutableTreeNode parent = new DefaultMutableTreeNode("全部资产");
    private DefaultMutableTreeNode selected;
    private DefaultMutableTreeNode leaf;
    private Statement stmt;
    private Statement stmt1;
    private ResultSet rs;
    private ResultSet rs1;
}