zhuyao.java

这是我写的产品管理系统

package deng.shaoxiao;
import xiao.xiaoshouxiaoshou.*;
import sun.BuMenXiaoShou.*;
import sn.ChangPingXiaoShou.*;
import yuan.xiaoshou.*;
import com.yonghuxiaoshou.*;
import cn.KeKuXiaoShao.*;

import java.awt.*;
import javax.swing.*;
import javax.swing.tree.*;
import java.sql.*;
import javax.swing.JMenuBar;
import java.util.ArrayList;
import java.util.*;
import java.awt.event.*;
import javax.swing.table.*;
import javax.swing.ImageIcon;
//编写树的按纽事件
import javax.swing.event.TreeModelEvent;
import javax.swing.event.TreeModelListener;
import javax.swing.event.TreeSelectionEvent;
import javax.swing.event.TreeSelectionListener;

public class ZhuYao {
	DefaultTableModel model=null;//new DefaultTableModel(columns,0);//声明表格模型对象
	JTable table=new JTable(model);//声明表格对象
	ZhuYao(){
		 JFrame jframe = new JFrame();
		 jframe.setTitle("员工管理系统");
		 Container cont = jframe.getContentPane();
		 //定义一个一级菜单
		 JMenuBar jb = new JMenuBar();
		 //定义一个二级菜单
		 JMenu jm = new JMenu("部门管理");
		 
		 JMenu jmt = new JMenu("员工管理"); 
		 
		 JMenu jmti = new JMenu("销售管理");
		 
		 JMenu jmtt = new JMenu("产品管理");
		 
		 JMenu jmii = new JMenu("客户管理");
		 //定义一个三级菜单
		 JMenuItem jm1 = new JMenuItem("部门查询");
		 jm1.addActionListener(new bucha());
		 JMenuItem jm2 = new JMenuItem("部门增加");
		 jm2.addActionListener(new buzeng());
		 JMenuItem jm3 = new JMenuItem("部门修改");
		 jm3.addActionListener(new buxiu());
		 JMenuItem jm4 = new JMenuItem("部门删除");
		 jm4.addActionListener(new bushan());
		 
		 JMenuItem jmt1 = new JMenuItem("员工分类查询");
		 jmt1.addActionListener(new yuangongcha());
		 
		 JMenuItem jmt2 = new JMenuItem("员工增加");
		 jmt2.addActionListener(new tian());
		 JMenuItem jmt3 = new JMenuItem("员工修改");
		 jmt3.addActionListener(new xiu());
		 JMenuItem jmt4 = new JMenuItem("员工删除");
		 jmt4.addActionListener(new shan());
		 
		 JMenuItem jmti1 = new JMenuItem("销售情况查询");
		 jmti1.addActionListener(new xiaocha());
		 JMenuItem jmti2 = new JMenuItem("销售情况增加");
		 jmti2.addActionListener(new xiaozeng());
		 JMenuItem jmti3 = new JMenuItem("销售情况修改");
		 jmti3.addActionListener(new xiaogai());
		 JMenuItem jmti4 = new JMenuItem("销售情况删除");
		 jmti4.addActionListener(new xiaoshan());
		 
		 JMenuItem jmtt1 = new JMenuItem("产品查询");
		 jmtt1.addActionListener(new chancha());
		 JMenuItem jmtt2 = new JMenuItem("产品增加");
		 jmtt2.addActionListener(new chanZeng());
		 JMenuItem jmtt3 = new JMenuItem("产品修改");
		 jmtt3.addActionListener(new chanxiu());
		 JMenuItem jmtt4 = new JMenuItem("产品删除");
		 jmtt4.addActionListener(new chanshan());
		 
		 JMenuItem jmii1 = new JMenuItem("客户查询");
		 jmii1.addActionListener(new kecha());
		 JMenuItem jmii2 = new JMenuItem("客户增加");
		 jmii2.addActionListener(new kezeng());
		 JMenuItem jmii3 = new JMenuItem("客户修改");
		 jmii3.addActionListener(new kexiu());
		 JMenuItem jmii4 = new JMenuItem("客户删除");
		 jmii4.addActionListener(new keshan());
		 
		 //把三级菜单添加到二级菜单
		 jm.add(jm1);
		 jm.addSeparator();
		 jm.add(jm2);
		 jm.addSeparator();
		 jm.add(jm3);
		 jm.addSeparator();
		 jm.add(jm4);
		 
		 jmt.add(jmt1);
		 jmt.addSeparator();
		 jmt.add(jmt2);
		 jmt.addSeparator();
		 jmt.add(jmt3);
		 jmt.addSeparator();
		 jmt.add(jmt4);
		 
		 jmti.add(jmti1);
		 jmti.addSeparator();
		 jmti.add(jmti2);
		 jmti.addSeparator();
		 jmti.add(jmti3);
		 jmti.addSeparator();
		 jmti.add(jmti4);
		 
		 jmtt.add(jmtt1);
		 jmtt.addSeparator();
		 jmtt.add(jmtt2);
		 jmtt.addSeparator();
		 jmtt.add(jmtt3);
		 jmtt.addSeparator();
		 jmtt.add(jmtt4);
		 
		 jmii.add(jmii1);
		 jmii.addSeparator();
		 jmii.add(jmii2);
		 jmii.addSeparator();
		 jmii.add(jmii3);
		 jmii.addSeparator();
		 jmii.add(jmii4);
		 
		 jb.add(jm);
		 jb.add(jmt);
		 jb.add(jmti);
		 jb.add(jmtt);
		 jb.add(jmii);
		 
		 //定义一课树
		 JTree tree = null;
		 DefaultMutableTreeNode root = new DefaultMutableTreeNode("员工管理系统");
		 
		 DefaultMutableTreeNode dmt = new DefaultMutableTreeNode("部门管理");
		 DefaultMutableTreeNode dmt1 = new DefaultMutableTreeNode("部门查询");
		 DefaultMutableTreeNode dmt2 = new DefaultMutableTreeNode("部门增加");
		 DefaultMutableTreeNode dmt3 = new DefaultMutableTreeNode("部门修改");
		 DefaultMutableTreeNode dmt4 = new DefaultMutableTreeNode("部门删除");
		 dmt.add(dmt1);
		 dmt.add(dmt2);
		 dmt.add(dmt3);
		 dmt.add(dmt4);
		 
		 DefaultMutableTreeNode dm = new DefaultMutableTreeNode("员工管理");
		 
		 DefaultMutableTreeNode dm1 = new DefaultMutableTreeNode("员工分类查询");
		 DefaultMutableTreeNode dm2 = new DefaultMutableTreeNode("员工增加");
		 DefaultMutableTreeNode dm3 = new DefaultMutableTreeNode("员工修改");
		 DefaultMutableTreeNode dm4 = new DefaultMutableTreeNode("员工删除");
		 dm.add(dm1);
		 dm.add(dm2);
		 dm.add(dm3);
		 dm.add(dm4);
		 
		 DefaultMutableTreeNode dt = new DefaultMutableTreeNode("销售管理");
		 
		 DefaultMutableTreeNode dm11 = new DefaultMutableTreeNode("销售情况查询");
		 DefaultMutableTreeNode dm22 = new DefaultMutableTreeNode("销售情况增加");
		 DefaultMutableTreeNode dm33 = new DefaultMutableTreeNode("销售情况修改");
		 DefaultMutableTreeNode dm44 = new DefaultMutableTreeNode("销售情况删除");
		 dt.add(dm11);
		 dt.add(dm22);
		 dt.add(dm33);
		 dt.add(dm44);
		 
		 DefaultMutableTreeNode d = new DefaultMutableTreeNode("产品管理");
		 
		 DefaultMutableTreeNode d1 = new DefaultMutableTreeNode("产品查询");
		 DefaultMutableTreeNode d2 = new DefaultMutableTreeNode("产品增加");
		 DefaultMutableTreeNode d3 = new DefaultMutableTreeNode("产品修改");
		 DefaultMutableTreeNode d4 = new DefaultMutableTreeNode("产品删除");
		 d.add(d1);
		 d.add(d2);
		 d.add(d3);
		 d.add(d4);
		 
		 DefaultMutableTreeNode dd = new DefaultMutableTreeNode("客户管理");
		 
		 DefaultMutableTreeNode dd1 = new DefaultMutableTreeNode("客户查询");
		 DefaultMutableTreeNode dd2 = new DefaultMutableTreeNode("客户增加");
		 DefaultMutableTreeNode dd3 = new DefaultMutableTreeNode("客户修改");
		 DefaultMutableTreeNode dd4 = new DefaultMutableTreeNode("客户删除");
		 dd.add(dd1);
		 dd.add(dd2);
		 dd.add(dd3);
		 dd.add(dd4);
		 
		 root.add(dmt);
		 root.add(dm);
		 root.add(dt);
		 root.add(d);
		 root.add(dd);
		 tree = new JTree(root);
		 //定义两个滚动框
		 JScrollPane leftpane = new JScrollPane(tree);
		 
		 table.setEnabled(false);
	     JScrollPane rightpane = new JScrollPane(table);
		 rightpane.setBackground(Color.red);
		  //定义一个分割滚动框
		 JSplitPane jsp = new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,true,leftpane,rightpane);
		 jsp.setDividerLocation(130);
		 jsp.setOneTouchExpandable(true);
		 //把所有的容器全部添加到顶级容器中
		 cont.add(jb,BorderLayout.NORTH);
		 cont.add(jsp,BorderLayout.CENTER);
		 ImageIcon image = new ImageIcon("e:\\大一项目\\产品销售管理系统\\button1.jpg");
		 jframe.setIconImage(image.getImage());
		 jframe.setUndecorated(true);
		 jframe.getRootPane().setWindowDecorationStyle(JRootPane.FRAME);
		 jframe.setSize(700,400);
		 jframe.setResizable(false);
		 jframe.setVisible(true);
	}
	
	//员工查询方法
	public DefaultTableModel yuancha(){		
		String[] str = {"用户编号","姓名","所属部门编号","性别","居住地址","年龄","电话号码"};
		model = new DefaultTableModel(str,0);	
		ResultSet rst = YuanGong.select();
		try{
			while(rst.next()){
				String sr = ""+ rst.getInt(1);
				String sr1 = rst.getString(2);
				String sr2 = ""+rst.getString(3);
				String sr3 = rst.getString(4);
				String sr4 = rst.getString(5);
				String sr5 = ""+rst.getInt(6);
				String sr6 = ""+rst.getString(7);
				String[] s ={sr,sr1,sr2,sr3,sr4,sr5,sr6};
				model.addRow(s);	 
			}
		}
		catch(SQLException e){
			System.out.println (e.getMessage());
		}
		return model;
	}
	//添加对员工管理查询事件
	class yuangongcha implements ActionListener{
		public void actionPerformed(ActionEvent e){
			table.setModel(yuancha());
			table.setBackground(Color.red);
		} 
	}
	//添加员工增加事件
	class tian implements ActionListener{
		public void actionPerformed(ActionEvent e){
			YuanTian yt = new YuanTian();
		}
	}
	//员工修改事件
	class xiu implements ActionListener{
		public void actionPerformed(ActionEvent e){
			YuanXiu yx = new YuanXiu();
		}
	}
	//员工删除事件
	class shan implements ActionListener{
		public void actionPerformed(ActionEvent e){
			YuanShan ys = new YuanShan();
		}
	}
	//部门查询方法
	public DefaultTableModel mencha(){		
	//	BuLian bl = new BuLian();
		String[] str = {"部门编号","部门名称","部门介绍"};
		JTable jtable = null;
		model = new DefaultTableModel(str,0);	
		ResultSet rst = BuLian.select();
		try{
			while(rst.next()){
				String sr = ""+ rst.getInt(1);
				String sr1 = rst.getString(2);
				String sr2 = rst.getString(3);
				String[] s ={sr,sr1,sr2};
				model.addRow(s);	 
			}
		}
		catch(SQLException e){
			System.out.println (e.getMessage());
		}
		return model;
	}
	
	//部门查询事件
	class bucha implements ActionListener{
		public void actionPerformed(ActionEvent e){
			table.setModel(mencha());
			table.setBackground(Color.pink);
		}
	}
	//部门增加事件
	class buzeng implements ActionListener{
		public void actionPerformed(ActionEvent e){
			BuZeng bz = new BuZeng();
			//table.setModel(mencha());
		}
	}
	//部门删除事件
	class bushan implements ActionListener{
		public void actionPerformed(ActionEvent e){
			BuShan bs = new BuShan();
		}
	}
	//部门修改事件
	class buxiu implements ActionListener{
		public void actionPerformed(ActionEvent e){
			BuXiu bx = new BuXiu();
		}
	}
	
	//产品查询方法
	public DefaultTableModel chancha(){		
	//	BuLian bl = new BuLian();
		String[] str = {"产品编号","产品名称","产品价格","产品描述"};
		JTable jtable = null;
		model = new DefaultTableModel(str,0);	
		ResultSet rst = ChanPing.select();
		try{
			while(rst.next()){
				String sr = ""+ rst.getInt(1);
				String sr1 = rst.getString(2);
				String sr2 = rst.getString(3);
				String sr3 = rst.getString(4);
				String[] s ={sr,sr1,sr2,sr3};
				model.addRow(s);	 
			}
		}
		catch(SQLException e){
			System.out.println (e.getMessage());
		}
		return model;
	}	
	//产品查询
	class chancha implements ActionListener{
		public void actionPerformed(ActionEvent e){
			table.setModel(chancha());
			table.setBackground(Color.yellow);
		}
	}
	//产品增加事件
	class chanZeng implements ActionListener{
		public void actionPerformed(ActionEvent e){
			ChanZeng cz = new ChanZeng();
		}
	}
	//产品修改事件
	class chanxiu implements ActionListener{
		public void actionPerformed(ActionEvent e){
			ChanXiu cx = new ChanXiu();
		}
	}
	//产品删除事件
	class chanshan implements ActionListener{
		public void actionPerformed(ActionEvent e){
			ChanShan cx = new ChanShan();
		}
	}
	
	//销售查询方法
	public DefaultTableModel xiaocha(){		
		String[] str1 = {"部门编号","用户编号","产品编号","销售数量","客户名称","销售日期"};
		JTable jtable = null;
		model = new DefaultTableModel(str1,0);	
		ResultSet rst = XiaoKu.select();
		try{
			while(rst.next()){
				String sr = ""+ rst.getInt(1);
				String sr1 = ""+rst.getInt(2);
				String sr2 = ""+rst.getInt(3);
				String sr3 = ""+rst.getInt(4);
				String sr4 = rst.getString(5);
				String sr5 = rst.getString(6);
				String[] s ={sr,sr1,sr2,sr3,sr4,sr5};
				model.addRow(s);	 
			}
		}
		catch(SQLException e){
			System.out.println (e.getMessage());
		}
		return model;
	}
	
	//销售查询
	class xiaocha implements ActionListener{
		public void actionPerformed(ActionEvent e){
			table.setModel(xiaocha());
			table.setBackground(Color.green);
		}
	}
	//销售增加事件
	class xiaozeng implements ActionListener{
		public void actionPerformed(ActionEvent e){
			XiaoZeng xz = new XiaoZeng();
		}
	}
	//销售删除事件
	class xiaoshan implements ActionListener{
		public void actionPerformed(ActionEvent e){
			XiaoShan xs = new XiaoShan();
		}
	}
	//销售修改事件
	class xiaogai implements ActionListener{
		public void actionPerformed(ActionEvent e){
			XiaoGai xg = new XiaoGai();
		}
	}
	
	//客户查询方法
	public DefaultTableModel kecha(){		
		String[] str = {"客户编号","客户名称","客户地址","客户电话","备注"};
		JTable jtable = null;
		model = new DefaultTableModel(str,0);	
		ResultSet rst = KeKu.select();
		try{
			while(rst.next()){
				String sr = ""+ rst.getInt(1);
				String sr1 = rst.getString(2);
				String sr2 = rst.getString(3);
				String sr3 = rst.getString(4);
				String sr4 = rst.getString(5);
				String[] s ={sr,sr1,sr2,sr3,sr4};
				model.addRow(s);	 
			}
		}
		catch(SQLException e){
			System.out.println (e.getMessage());
		}
		return model;
	}
	//客户查询事件
	class kecha implements ActionListener{
		public void actionPerformed(ActionEvent e){
			table.setModel(kecha());
			table.setBackground(Color.orange);
		}
	}
	//客户增加事件
	class kezeng implements ActionListener{
		public void actionPerformed(ActionEvent e){
			KeZeng kz = new KeZeng();
		}
	}
	//客户修改事件
	class kexiu implements ActionListener{
		public void actionPerformed(ActionEvent e){
			KeXiu kz = new KeXiu();
		}
	}
	//客户删除事件
	class keshan implements ActionListener{
		public void actionPerformed(ActionEvent e){
			KeShan ks = new KeShan();
		}
	}	
}