selectpanel.java

用java编写的人事管理系统,很好的 学习下吧

/**
 * 源文件：SelectPanel.java
 * 作用：查询窗体
 */
package mypro;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.table.*;
import java.awt.print.*;

public class SelectPanel extends JPanel implements ItemListener,ActionListener
{
	private JLabel labTag,labTitle;
	private JComboBox comTable;
	private JButton btnSelect,btnPrint;
	private JCheckBox chkModel,chkState,chkColor;
	private JRadioButton rbtIom,rbtImei,rbtMsn,rbtSupp,rbtUsers,rbtCust,rbtPrice,rbtBig,rbtSmall,rbtEqual;
	private JTextField txtImei,txtMsn,txtModel,txtState,txtColor,txtSupplierBrief,txtUsersCode,txtCustomerCode,txtPrice;
	private ButtonGroup bg,bg1,bg2;
	private JScrollPane spTable;
	private JTable tabShow;
	private DatabaseOperate odb;
	private String strLandCode;
	private SelectData sd;
	private String strTabname;
	private SelectOperate sop;
	private String strMark="";
	public SelectPanel()
	{
		odb = new DatabaseOperate();
		strLandCode = LandFrame.strCode;
		labTag = new JLabel("请选择查询的表：");
		labTitle = new JLabel("查询条件选择区");
		if(strLandCode.equals("A000"))
		{
			comTable = new JComboBox(odb.getAllTabelName());
		}
		else
		{
			comTable = new JComboBox(odb.getAllTabelNameExceptUsers());
		}
		btnPrint = new JButton("打印");
		btnSelect = new JButton("查询");
		chkModel = new JCheckBox("型号");
    	chkState = new JCheckBox("状态");
   		chkColor = new JCheckBox("颜色");
   		rbtIom = new JRadioButton("IMEI/品牌");
	    rbtImei = new JRadioButton("IMEI");
	    rbtMsn = new JRadioButton("品牌");
	    rbtSupp = new JRadioButton("供货商代码");
	    rbtUsers = new JRadioButton("员工编号");
	    rbtCust = new JRadioButton("顾客编号");
	    rbtPrice = new JRadioButton("单价");
	    rbtBig = new JRadioButton("大于等于");
	    rbtSmall = new JRadioButton("小于等于");
	    rbtEqual = new JRadioButton("等于单价");
	    bg = new ButtonGroup();
	    bg1 = new ButtonGroup();
	    bg2 = new ButtonGroup();
   		txtImei = new JTextField();
	    txtMsn = new JTextField();
	    txtModel = new JTextField();
	    txtState = new JTextField();
	    txtColor = new JTextField();
	    txtSupplierBrief = new JTextField();
	    txtUsersCode = new JTextField();
	    txtCustomerCode = new JTextField();
	    txtPrice = new JTextField();
		spTable = new JScrollPane();
		tabShow = new JTable();
		
		labTag.setBounds(new Rectangle(38, 42, 112, 23));
		labTitle.setBounds(new Rectangle(541, 40, 170, 23));
		labTitle.setFont(new java.awt.Font("华文新魏", Font.BOLD | Font.ITALIC, 20));
        labTitle.setHorizontalAlignment(SwingConstants.CENTER);
        comTable.setBounds(new Rectangle(184, 42, 141, 23));
        btnPrint.setBounds(new Rectangle(358, 42, 81, 23));
        btnPrint.setActionCommand("print");
        btnPrint.setToolTipText("打印出表格数据");
        btnSelect.setBounds(new Rectangle(595, 584, 100, 32));
        btnSelect.setActionCommand("select");
        btnSelect.setToolTipText("查找符合条件的信息");
        chkModel.setBounds(new Rectangle(525, 189, 61, 15));
        chkModel.setEnabled(false);
        chkState.setBounds(new Rectangle(525, 261, 61, 15));
        chkState.setEnabled(false);
        chkColor.setBounds(new Rectangle(525, 225, 61, 15));
        chkColor.setEnabled(false);
        rbtImei.setBounds(new Rectangle(525, 117, 61, 15));
        rbtImei.setSelected(true);
        rbtMsn.setBounds(new Rectangle(525, 153, 61, 15));
        rbtIom.setBounds(new Rectangle(503, 89, 97, 13));
        rbtIom.setSelected(true);
        rbtSupp.setBounds(new Rectangle(503, 427, 97, 13));
        rbtCust.setBounds(new Rectangle(503, 327, 97, 13));
        rbtUsers.setBounds(new Rectangle(503, 377, 97, 13));
        rbtPrice.setBounds(new Rectangle(503, 477, 97, 13));
        rbtBig.setBounds(new Rectangle(518, 514, 80, 27));
        rbtBig.setEnabled(false);
        rbtBig.setSelected(true);
        rbtEqual.setBounds(new Rectangle(619, 514, 80, 27));
        rbtEqual.setEnabled(false);
        rbtSmall.setBounds(new Rectangle(716, 514, 80, 27));
        rbtSmall.setEnabled(false);
        txtImei.setBounds(new Rectangle(606, 117, 146, 27));
        txtMsn.setBounds(new Rectangle(606, 153, 146, 27));
        txtMsn.setEditable(false);
        txtModel.setBounds(new Rectangle(606, 189, 146, 27));
        txtModel.setEditable(false);
        txtState.setBounds(new Rectangle(606, 261, 146, 27));
        txtState.setEditable(false);
        txtColor.setBounds(new Rectangle(606, 225, 146, 27));
        txtColor.setEditable(false);
        txtCustomerCode.setBounds(new Rectangle(606, 327, 146, 27));
        txtCustomerCode.setEditable(false);
        txtUsersCode.setBounds(new Rectangle(606, 377, 146, 27));
        txtUsersCode.setEditable(false);
        txtSupplierBrief.setBounds(new Rectangle(606, 427, 146, 27));
        txtSupplierBrief.setEditable(false);
        txtPrice.setBounds(new Rectangle(606, 477, 146, 27));
        txtPrice.setEditable(false);
        spTable.setBounds(new Rectangle(6, 76, 488, 541));
	
		setLayout(null);
		add(labTag);
        add(labTitle);
		add(comTable);
        add(btnPrint);
        add(btnSelect);
        add(chkModel);
        add(chkState);
        add(chkColor);
        add(rbtImei);
        add(rbtMsn);
        add(rbtIom);
        add(rbtSupp);
        add(rbtCust);
        add(rbtUsers);
        add(rbtPrice);
        add(rbtBig);
        add(rbtEqual);
        add(rbtSmall);
        add(txtImei);
        add(txtMsn);
        add(txtModel);
        add(txtState);
        add(txtColor);
        add(txtCustomerCode);
        add(txtUsersCode);
        add(txtSupplierBrief);
        add(txtPrice);
        add(spTable);
        bg.add(rbtImei);
        bg.add(rbtMsn);
        bg1.add(rbtIom);
        bg1.add(rbtSupp);
        bg1.add(rbtCust);
        bg1.add(rbtUsers);
        bg1.add(rbtPrice);
        bg2.add(rbtBig);
        bg2.add(rbtEqual);
        bg2.add(rbtSmall);
        spTable.getViewport().add(tabShow);
        
        rbtImei.addItemListener(this);
        rbtMsn.addItemListener(this);
        rbtIom.addItemListener(this);
        rbtSupp.addItemListener(this);
        rbtCust.addItemListener(this);
        rbtUsers.addItemListener(this);
        rbtPrice.addItemListener(this);
        chkModel.addItemListener(this);
        chkColor.addItemListener(this);
        chkState.addItemListener(this);
        comTable.addItemListener(this);
        btnPrint.addActionListener(this);
        btnSelect.addActionListener(this);
        
        
	}
	public void itemStateChanged(ItemEvent ie)
	{
		if (ie.getStateChange() == ItemEvent.SELECTED)
        {
        	strTabname=(String)comTable.getSelectedItem();
        	tableShowByModel(odb.getDataByTabname(strTabname),odb.getColumnNamesByTabname(strTabname));	
        }
		if(rbtIom.isSelected())
		{
			rbtImei.setEnabled(true);
			rbtMsn.setEnabled(true);
			txtSupplierBrief.setEditable(false);
			txtCustomerCode.setEditable(false);
			txtUsersCode.setEditable(false);
			txtPrice.setEditable(false);
			rbtBig.setEnabled(false);
			rbtEqual.setEnabled(false);
			rbtSmall.setEnabled(false);
			if(rbtImei.isSelected())
			{
				txtImei.setEditable(true);
				chkModel.setEnabled(false);
				chkState.setEnabled(false);
				chkColor.setEnabled(false);
				txtModel.setEditable(false);
				txtState.setEditable(false);
				txtColor.setEditable(false);
				txtMsn.setEditable(false);	
			}
			else if(rbtMsn.isSelected())
			{
				txtMsn.setEditable(true);
				chkModel.setEnabled(true);
				chkState.setEnabled(true);
				chkColor.setEnabled(true);
				txtImei.setEditable(false);
				if(chkModel.isSelected())
				{
					txtModel.setEditable(true);
				}
				else
				{
					txtModel.setEditable(false);
				}
				if(chkState.isSelected())
				{
					txtState.setEditable(true);
				}
				else
				{
					txtState.setEditable(false);
				}
				if(chkColor.isSelected())
				{
					txtColor.setEditable(true);
				}
				else
				{
					txtColor.setEditable(false);
				}
			}
		}
		else if(rbtSupp.isSelected())
		{
			rbtImei.setEnabled(false);
			rbtMsn.setEnabled(false);
			chkModel.setEnabled(false);
			chkState.setEnabled(false);
			chkColor.setEnabled(false);
			txtImei.setEditable(false);
			txtMsn.setEditable(false);
			txtModel.setEditable(false);
			txtState.setEditable(false);
			txtColor.setEditable(false);
			txtCustomerCode.setEditable(false);
			txtUsersCode.setEditable(false);
			txtPrice.setEditable(false);
			rbtBig.setEnabled(false);
			rbtEqual.setEnabled(false);
			rbtSmall.setEnabled(false);
			txtSupplierBrief.setEditable(true);
		}
		else if(rbtCust.isSelected())
		{
			rbtImei.setEnabled(false);
			rbtMsn.setEnabled(false);
			chkModel.setEnabled(false);
			chkState.setEnabled(false);
			chkColor.setEnabled(false);
			txtImei.setEditable(false);
			txtMsn.setEditable(false);
			txtModel.setEditable(false);
			txtState.setEditable(false);
			txtColor.setEditable(false);
			txtSupplierBrief.setEditable(false);
			txtUsersCode.setEditable(false);
			txtPrice.setEditable(false);
			rbtBig.setEnabled(false);
			rbtEqual.setEnabled(false);
			rbtSmall.setEnabled(false);
			txtCustomerCode.setEditable(true);
		}
		else if(rbtUsers.isSelected())
		{
			rbtImei.setEnabled(false);
			rbtMsn.setEnabled(false);
			chkModel.setEnabled(false);
			chkState.setEnabled(false);
			chkColor.setEnabled(false);
			txtImei.setEditable(false);
			txtMsn.setEditable(false);
			txtModel.setEditable(false);
			txtState.setEditable(false);
			txtColor.setEditable(false);
			txtSupplierBrief.setEditable(false);
			txtCustomerCode.setEditable(false);
			txtPrice.setEditable(false);
			rbtBig.setEnabled(false);
			rbtEqual.setEnabled(false);
			rbtSmall.setEnabled(false);
			txtUsersCode.setEditable(true);
		}
		else if(rbtPrice.isSelected())
		{
			rbtImei.setEnabled(false);
			rbtMsn.setEnabled(false);
			chkModel.setEnabled(false);
			chkState.setEnabled(false);
			chkColor.setEnabled(false);
			txtImei.setEditable(false);
			txtMsn.setEditable(false);
			txtModel.setEditable(false);
			txtState.setEditable(false);
			txtColor.setEditable(false);