assetselectfrm.java~9~

一个不错的固定资产管理系统,jbuilder和SQL环境下制作

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.*;

/**
 * <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));
        jTextField1.setText("");
        jTextField1.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("分类查询");
        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));
        this.getContentPane().add(labassetSelectMain);
        labassetLitter.setText("关键字");
        labassetLitter.setBounds(new Rectangle(61, 241, 48, 20));
        this.getContentPane().add(tabassetSelect);
        this.getContentPane().add(labassetLitter);
        this.getContentPane().add(labassetSectool);
        this.getContentPane().add(cobassetSelecttool);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(btnassetSelectool);
        this.getContentPane().add(btnassetSelectAll);
        tabassetSelect.setBounds(new Rectangle(25, 70, 422, 152));

    }

    JLabel labassetSelectMain = new JLabel();
    JTable tabassetSelect = new JTable();
    JLabel labassetLitter = new JLabel();
    JTextField jTextField1 = new JTextField();
    JLabel labassetSectool = new JLabel();
    JComboBox cobassetSelecttool = new JComboBox();
    JButton btnassetSelectool = new JButton();
    JButton btnassetSelectAll = new JButton();

    public void btnassetSelectAll_actionPerformed(ActionEvent e) {
        ComboBoxModel objAllCM = null;
        try {
            objAllCM = new DefaultComboBoxModel(objassetRule.
                    SelectAllAsset());

        } catch (SQLException ex) {
        }
         tabassetSelect.setModel(objAllCM);
    }
}


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);
    }
}