assetselectfrm.java

固定资产管理系统 （1）单用户系统

package asset;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import java.awt.*;
import javax.swing.JTable;
import javax.swing.table.TableModel;
import javax.swing.table.DefaultTableModel;
import javax.swing.JTextField;
import javax.swing.JComboBox;
import javax.swing.ComboBoxModel;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import Rule.assetRule;
import Bean.assetBean;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.table.JTableHeader;
import javax.swing.JScrollPane;

/**
 * <p>Title: 固定资产管理系统</p>
 *
 * <p>资产查询 </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: HackCity</p>
 *
 * @author NightEagle
 * @version 1.0
 */
public class assetSelectFrm extends JFrame {
    assetBean objassetBean = new assetBean();
    assetRule objassetRule;
    public assetSelectFrm() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        objassetRule = new assetRule();
        getContentPane().setLayout(null);
        this.setResizable(false);
        this.setBounds(470, 250, 480, 360);
        setSize(new Dimension(480, 360));
        setTitle("固定资产管理系统  --  资产查询");
        labassetSelectMain.setFont(new java.awt.Font("黑体", Font.PLAIN, 25));
        labassetSelectMain.setForeground(Color.blue);
        labassetSelectMain.setText("资产查询");
        labassetSelectMain.setBounds(new Rectangle(182, 6, 106, 39));
        labassetLitter.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        txtassetSecectLitter.setText("");
        txtassetSecectLitter.setBounds(new Rectangle(113, 239, 96, 19));
        labassetSectool.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        labassetSectool.setText("查询方式");
        labassetSectool.setBounds(new Rectangle(45, 268, 62, 22));
        cobassetSelecttool.setBounds(new Rectangle(112, 267, 99, 20));
        //这是查询方式的COMBOBOX
        ComboBoxModel objtypeComboBox = new DefaultComboBoxModel(objassetRule.
                SelectAllComboBox());
        cobassetSelecttool.setModel(objtypeComboBox);
        //----------------------------------------------------------------------
        btnassetSelectool.setBounds(new Rectangle(275, 241, 74, 25));
        btnassetSelectool.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        btnassetSelectool.setBorder(null);
        btnassetSelectool.setText("分类查询");
        btnassetSelectool.addActionListener(new
                                            assetSelectFrm_btnassetSelectool_actionAdapter(this));
        btnassetSelectAll.setBounds(new Rectangle(323, 279, 74, 25));
        btnassetSelectAll.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        btnassetSelectAll.setBorder(null);
        btnassetSelectAll.setText("全部查询");
        btnassetSelectAll.addActionListener(new
                                            assetSelectFrm_btnassetSelectAll_actionAdapter(this));
        jTableHeader1.setFont(new java.awt.Font("黑体", Font.PLAIN, 13));
        jTableHeader1.setBounds(new Rectangle(16, 53, 449, 28));
        jScrAssetSelectAll.setBounds(new Rectangle(16, 53, 449, 162));
        this.getContentPane().add(labassetSelectMain);
        labassetLitter.setText("关键字");
        labassetLitter.setBounds(new Rectangle(61, 241, 48, 20));
        this.getContentPane().add(labassetLitter);
        this.getContentPane().add(labassetSectool);
        this.getContentPane().add(cobassetSelecttool);
        this.getContentPane().add(txtassetSecectLitter);
        this.getContentPane().add(btnassetSelectool);
        this.getContentPane().add(btnassetSelectAll);
        this.getContentPane().add(tabassetSelect);
        this.getContentPane().add(jTableHeader1);
        this.getContentPane().add(jScrAssetSelectAll);
        this.getContentPane().add(tabassetSelect);
        tabassetSelect.setBounds(new Rectangle(16, 74, 448, 135));

    }

    JLabel labassetSelectMain = new JLabel();
    JTable tabassetSelect = new JTable();
    JLabel labassetLitter = new JLabel();
    JTextField txtassetSecectLitter = new JTextField();
    JLabel labassetSectool = new JLabel();
    JComboBox cobassetSelecttool = new JComboBox();
    JButton btnassetSelectool = new JButton();
    JButton btnassetSelectAll = new JButton();
    JTableHeader jTableHeader1 = tabassetSelect.getTableHeader();
    JScrollPane jScrAssetSelectAll = new JScrollPane();
    public void btnassetSelectAll_actionPerformed(ActionEvent e) {
        TableModel objassetAllCM = null;
        try {
            objassetAllCM = new DefaultTableModel(objassetRule.SelectAllAsset(),
                                                  objassetRule.listTableHeard());
        } catch (SQLException ex) {
        }
        tabassetSelect.setModel(objassetAllCM);
        jScrAssetSelectAll.getViewport().add(tabassetSelect);
    }

    public void btnassetSelectool_actionPerformed(ActionEvent e) {
        String id, tools;
        TableModel objassetAllCM = null;
        id = this.txtassetSecectLitter.getText();
        tools = this.cobassetSelecttool.getSelectedItem().toString();
        if (id.length() == 0) {
            JOptionPane.showMessageDialog(this, "请输入查询关键字!!");
            return;
        }
        if (tools.equals("--请选择--")) {
            JOptionPane.showMessageDialog(this, "请选择查询条件!!");
            return;
        }
        if (tools.equals("按编号查询")) {
            try {
                objassetBean.setAssetID(id);
                objassetAllCM = new DefaultTableModel(objassetRule.
                        SelectAssetAsID(objassetBean),
                        objassetRule.listTableHeard());
            } catch (SQLException ex) {
            }
            tabassetSelect.setModel(objassetAllCM);
            jScrAssetSelectAll.getViewport().add(tabassetSelect);

            //清空并重新加载COMBOBOX!!
            this.txtassetSecectLitter.setText("");
            ComboBoxModel objtypeComboBox = new DefaultComboBoxModel(
                    objassetRule.
                    SelectAllComboBox());
            cobassetSelecttool.setModel(objtypeComboBox);
            //-------------------------------------------------------------
            return;
        }
        if (tools.equals("按大类别查询")) {
            try {
                objassetBean.setAssetTypeB(id);
                objassetAllCM = new DefaultTableModel(objassetRule.
                        SelectAssetAsTypeB(objassetBean),
                        objassetRule.listTableHeard());
            } catch (SQLException ex) {
            }
            tabassetSelect.setModel(objassetAllCM);
            jScrAssetSelectAll.getViewport().add(tabassetSelect);

            //清空并重新加载COMBOBOX!!
            this.txtassetSecectLitter.setText("");
            ComboBoxModel objtypeComboBox = new
                                            DefaultComboBoxModel(
                    objassetRule.
                    SelectAllComboBox());
            cobassetSelecttool.setModel(objtypeComboBox);
            //-------------------------------------------------------------
            return;
        }
        if (tools.equals("按状态查询")) {
            try {
                objassetBean.setAssetOnuse(id);
                objassetAllCM = new DefaultTableModel(objassetRule.
                        SelectAsOnuse(objassetBean),
                        objassetRule.listTableHeard());
            } catch (SQLException ex) {
            }
            tabassetSelect.setModel(objassetAllCM);
            jScrAssetSelectAll.getViewport().add(tabassetSelect);

            //清空并重新加载COMBOBOX!!
            this.txtassetSecectLitter.setText("");
            ComboBoxModel objtypeComboBox = new
                                            DefaultComboBoxModel(
                    objassetRule.
                    SelectAllComboBox());
            cobassetSelecttool.setModel(objtypeComboBox);
            //-------------------------------------------------------------
            return;
        }

    }
}


class assetSelectFrm_btnassetSelectool_actionAdapter implements
        ActionListener {
    private assetSelectFrm adaptee;
    assetSelectFrm_btnassetSelectool_actionAdapter(assetSelectFrm adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnassetSelectool_actionPerformed(e);
    }
}


class assetSelectFrm_btnassetSelectAll_actionAdapter implements ActionListener {
    private assetSelectFrm adaptee;
    assetSelectFrm_btnassetSelectAll_actionAdapter(assetSelectFrm adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnassetSelectAll_actionPerformed(e);
    }
}