selectusefrm.java

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

package asset;

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

/**
 * <p>Title: 固定资产管理系统</p>
 *
 * <p>查询员工信息 </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: HackCity</p>
 *
 * @author NightEagle
 * @version 1.0
 */
public class selectUseFrm extends JFrame {
    pesonelBean objPesonelBean = new pesonelBean();
    userRule objuserRule;
    public selectUseFrm() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        objuserRule = new userRule();
        getContentPane().setLayout(null);
        this.setResizable(false);
        this.setBounds(470, 250, 480, 360);
        setSize(new Dimension(480, 360));
        setTitle("固定资产管理系统  --  员工查询");
        labSelectInfo.setFont(new java.awt.Font("黑体", Font.PLAIN, 25));
        labSelectInfo.setForeground(Color.blue);
        labSelectInfo.setText("员工信息查询");
        labSelectInfo.setBounds(new Rectangle(155, 12, 158, 33));
        tabAllInfo.setToolTipText("");
        jTableHeader1.setFont(new java.awt.Font("黑体", Font.PLAIN, 12));
        jTableHeader1.setBounds(new Rectangle(40, 50, 385, 23));
        bntSelPes.setBounds(new Rectangle(282, 241, 79, 26));
        bntSelPes.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        bntSelPes.setBorder(null);
        bntSelPes.setText("分类查询");
        bntSelPes.addActionListener(new selectUseFrm_bntSelPes_actionAdapter(this));
        bntSelAll.setBounds(new Rectangle(340, 274, 79, 26));
        bntSelAll.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        bntSelAll.setBorder(null);
        bntSelAll.setText("全部查询");
        bntSelAll.addActionListener(new selectUseFrm_bntSelAll_actionAdapter(this));
        scrPesonel.setBounds(new Rectangle(39, 46, 389, 175));
        labthelitterPes.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        labthelitterPes.setText("查询方式");
        labthelitterPes.setBounds(new Rectangle(63, 273, 56, 19));
        cboSelectLike.setBounds(new Rectangle(133, 271, 108, 20));
        //------------------------查询的COMBOBOX模型-----------------------------
        ComboBoxModel selectCM = new DefaultComboBoxModel(objuserRule.isSecLike());
        cboSelectLike.setModel(selectCM);
        //----------------------------------------------------------------------
        labSelectPesLitter.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        labSelectPesLitter.setText("关键字");
        labSelectPesLitter.setBounds(new Rectangle(63, 237, 49, 23));
        txtSelectPesLitter.setBounds(new Rectangle(133, 238, 106, 20));

        this.getContentPane().add(labSelectInfo);
        this.getContentPane().add(jTableHeader1);
        this.getContentPane().add(tabAllInfo);
        this.getContentPane().add(scrPesonel);
        this.getContentPane().add(labSelectPesLitter);
        this.getContentPane().add(labthelitterPes);
        this.getContentPane().add(cboSelectLike);
        this.getContentPane().add(txtSelectPesLitter);
        this.getContentPane().add(bntSelPes);
        this.getContentPane().add(bntSelAll);
        tabAllInfo.setBounds(new Rectangle(40, 74, 386, 150));

    }

    JLabel labSelectInfo = new JLabel();
    JTable tabAllInfo = new JTable();
    JTableHeader jTableHeader1 = tabAllInfo.getTableHeader();
    JButton bntSelPes = new JButton();
    JButton bntSelAll = new JButton();
    JScrollPane scrPesonel = new JScrollPane();
    JLabel labthelitterPes = new JLabel();
    JComboBox cboSelectLike = new JComboBox();
    JLabel labSelectPesLitter = new JLabel();
    JTextField txtSelectPesLitter = new JTextField();
    public void bntSelAll_actionPerformed(ActionEvent e) {
        TableModel objTableModel = null;
        try {
            objTableModel = new DefaultTableModel(objuserRule.
                                                  SelectEveryoneInfo(),
                                                  objuserRule.tableHeard());
        } catch (SQLException ex) {
        }
        tabAllInfo.setModel(objTableModel);
        scrPesonel.getViewport().add(tabAllInfo, jTableHeader1);
    }

    //分类查询
    public void bntSelPes_actionPerformed(ActionEvent e) throws SQLException {
        String selected = this.cboSelectLike.getSelectedItem().toString();
        String litter = this.txtSelectPesLitter.getText();
        if (litter.length() == 0) {
            JOptionPane.showMessageDialog(this, "请输入要查询的关键字");
            return;
        }
        if (selected.equals("--请选择--")) {
            JOptionPane.showMessageDialog(this, "请选择查询方式!!");
            return;
        }
        if (selected.equals("按编号查询")) {
            String id = this.txtSelectPesLitter.getText();
            objPesonelBean.setPesonelID(id);
            TableModel objTMselectID = null;
            objTMselectID = new DefaultTableModel(objuserRule.SelectAsID(
                    objPesonelBean), objuserRule.tableHeard());
            tabAllInfo.setModel(objTMselectID);
            scrPesonel.getViewport().add(tabAllInfo, jTableHeader1);
            //----------------查询完成后请空TEXT.并重新加载COMBOBOX----------------
            this.txtSelectPesLitter.setText("");
            ComboBoxModel selectCM = new DefaultComboBoxModel(objuserRule.
                    isSecLike());
            cboSelectLike.setModel(selectCM);
            //--------------------以上是按编号查询--------------------------------
        } else {
            if (selected.equals("按部门查询")) {
                String pesonel = this.txtSelectPesLitter.getText();
                objPesonelBean.setPesonel(pesonel);
                TableModel objTMselectPes = null;
                objTMselectPes = new DefaultTableModel(objuserRule.
                        SelectAsPesonel(
                                objPesonelBean), objuserRule.tableHeard());
                tabAllInfo.setModel(objTMselectPes);
                scrPesonel.getViewport().add(tabAllInfo, jTableHeader1);
                //----------------查询完成后请空TEXT.并重新加载COMBOBOX----------------
                this.txtSelectPesLitter.setText("");
                ComboBoxModel selectCM = new DefaultComboBoxModel(objuserRule.
                        isSecLike());
                cboSelectLike.setModel(selectCM);
                //--------------------以上是按部门查询--------------------------------
            } else {
                if (selected.equals("按已借查询")) {
                    String onuse = this.txtSelectPesLitter.getText();
                    objPesonelBean.setOnuse(onuse);
                    TableModel objTMselectPes = null;
                    objTMselectPes = new DefaultTableModel(objuserRule.SelectAsOnuse(
                                    objPesonelBean), objuserRule.tableHeard());
                    tabAllInfo.setModel(objTMselectPes);
                    scrPesonel.getViewport().add(tabAllInfo, jTableHeader1);
                    //----------------查询完成后请空TEXT.并重新加载COMBOBOX----------------
                    this.txtSelectPesLitter.setText("");
                    ComboBoxModel selectCM = new DefaultComboBoxModel(
                            objuserRule.
                            isSecLike());
                    cboSelectLike.setModel(selectCM);
                    //--------------------以上是按部门查询--------------------------------

                }
            }
        }
    }


    class selectUseFrm_bntSelPes_actionAdapter implements ActionListener {
        private selectUseFrm adaptee;
        selectUseFrm_bntSelPes_actionAdapter(selectUseFrm adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            try {
                adaptee.bntSelPes_actionPerformed(e);
            } catch (SQLException ex) {
            }
        }
    }


    class selectUseFrm_bntSelAll_actionAdapter implements ActionListener {
        private selectUseFrm adaptee;
        selectUseFrm_bntSelAll_actionAdapter(selectUseFrm adaptee) {
            this.adaptee = adaptee;
        }

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