changshitree.java

基于Java的仓库信息管理系统。本系统主要完成对超市仓库的库存管理

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*;
import javax.swing.tree.*;

class ChangshiTree extends JFrame implements TreeSelectionListener
{
	Statement s;
	ResultSet rs,rs1;
	DefaultTableModel dtm;
	String[] title;
	JTree tree;
	JTable table;
	DefaultTreeModel treeModel=null;
	JScrollPane scroll,scroll2;
	JSplitPane splitPane;
	public ChangshiTree()
	{
		try{
		
		  String url="jdbc:odbc:Test";
	      Connection con=DriverManager.getConnection(url);
		  s=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		  DefaultMutableTreeNode root=new DefaultMutableTreeNode("专业");
		  
		  treeModel=new DefaultTreeModel(root);
		  initTree(root,0);
		  tree=new JTree(treeModel);
		  scoll=new JScrollPane(tree);
		  tree.addTreeSelectionListener(this);
		  rs=s.executeQuery("select tj.spbh as 商品编号 where tj.spxz=spxz.性质名称");
		  ResultSetMetaData dbmd=rs.getMetaData();
		  title=new String[dbmd.getColumnCount()];
		  for(int i=1;i<=dbmd.getColumnCount();i++)
		  title[i-1]=dbmd.getColumnName(i);
		  dtm=new DefaultTableModel(null,title);
		  table=new new JTable(dtm);
		  scoll2=new JScrollPane(table);
		  initTable();
		  splitPane=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,scoll,scroll2);
		  
		  splitPane.setOneTouchExpandable(true);
		  splitPane.setDividerLocation(200);
		  this.getContentPane().add(splitPane,null);
		  }//////try
		  catch(Exception eee)
		  {
		  	
		  }
		  super.setTitle("统计查询");
		  super.setSize(500,400);
		  super.setVisible(true);
		  

	}
	
	
	
	void initTree(DefaultMutableTreeNode root,int id)
	{
		DefaultMutableTreeNode node=null;
		
	}
}