frmasset.java~170~

用java实现的固定资产管理系统相信对于初学者可以从中学到一点知识....!

package 固定资产管理系统;

import java.awt.*;
import javax.swing.JInternalFrame;
import javax.swing.*;
import javax.swing.border.TitledBorder;
import javax.swing.table.JTableHeader;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.XYConstraints;
import com.borland.jbcl.layout.*;
import java.sql.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;
import java.util.Calendar;



public class FrmAsset extends JInternalFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    ConnectDataBase cdb = new ConnectDataBase();
    Calendar cal=Calendar.getInstance();
    JPanel jPanelinfo = new JPanel();
    JPanel jPanelcontrol = new JPanel();
    JPanel jPaneltable = new JPanel();
    JButton btnadd = new JButton();
    JButton btndel = new JButton();
    JButton btnrenew = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable(cdb.getAstinfo());
    JTableHeader jTableHeader1 = jTable1.getTableHeader();
    BorderLayout borderLayout2 = new BorderLayout();
    JLabel lblastid = new JLabel();
    JTextField txtastid = new JTextField();
    JLabel lblastname = new JLabel();
    JTextField txtastname = new JTextField();
    JLabel lblcateid = new JLabel();
    JComboBox combcateid = new JComboBox();
    JLabel lblsubcateid = new JLabel();
    JComboBox combsubcateid = new JComboBox();
    JLabel lblmodel = new JLabel();
    JTextField txtmodel = new JTextField();
    JLabel lblprice = new JLabel();
    JTextField txtprice = new JTextField();
    JLabel lbldate = new JLabel();
    JTextField txtdate = new JTextField();
    JLabel lblstatus = new JLabel();
    JComboBox combstatus = new JComboBox();
    JLabel lbluseby = new JLabel();
    JTextField txtuseby = new JTextField();
    JLabel lblremarks = new JLabel();
    JTextField txtremarks = new JTextField();
    XYLayout xYLayout1 = new XYLayout();
    TitledBorder titledBorder1 = new TitledBorder("固定资产信息");
    TitledBorder titledBorder2 = new TitledBorder("固定资产表");
    public FrmAsset() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(borderLayout1);
        btnadd.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btnadd.setText("入库");
        btnadd.addActionListener(new FrmAsset_btnadd_actionAdapter(this));
        btndel.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btndel.setText("报损");
        btndel.addActionListener(new FrmAsset_btndel_actionAdapter(this));
        btnrenew.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btnrenew.setText("更新");
        btnrenew.addActionListener(new FrmAsset_btnrenew_actionAdapter(this));
        jPaneltable.setLayout(borderLayout2);
        jPanelinfo.setLayout(xYLayout1);
        jPanelinfo.setBorder(titledBorder1);
        lblastid.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblastid.setText("资产编号");
        lblastname.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblastname.setText("资产名称");
        lblcateid.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblcateid.setText("大类编号");
        lblsubcateid.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblsubcateid.setText("小类编号");
        lblmodel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblmodel.setText("样式(可空)");
        lblprice.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblprice.setText("  价格");
        lbldate.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lbldate.setText("购入日期");
        java.sql.Date dd=new Date(cal.getTimeInMillis());
        txtdate.setText(String.valueOf(dd));
        lblstatus.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblstatus.setText("  状态");
        lbluseby.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lbluseby.setText("  经手人");
        lblremarks.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblremarks.setText("备注(可空)");
        jPaneltable.setBorder(titledBorder2);
        this.setResizable(true);
        this.setTitle("固定资产管理");
        jTable1.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        jTable1.addKeyListener(new FrmAsset_jTable1_keyAdapter(this));
        jTable1.addMouseListener(new FrmAsset_jTable1_mouseAdapter(this));
        jTableHeader1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 11));
        combcateid.addItemListener(new FrmAsset_combcateid_itemAdapter(this));
        this.getContentPane().add(jPanelcontrol, java.awt.BorderLayout.SOUTH);
        jPanelcontrol.add(btnadd);
        jPanelcontrol.add(btndel);
        jPanelcontrol.add(btnrenew);
        this.getContentPane().add(jPaneltable, java.awt.BorderLayout.CENTER);
        this.getContentPane().add(jPanelinfo, java.awt.BorderLayout.NORTH);
        for (int i = 0;i<cdb.getcateid().size(); i++) {
            combcateid.addItem(String.valueOf(cdb.getcateid().get(i)));
        }
        jPanelinfo.add(combcateid, new XYConstraints(420, 7, 110, 20));
        jPanelinfo.add(txtastname, new XYConstraints(250, 7, 110, 20));
        jPanelinfo.add(lblastname, new XYConstraints(187, 7, 100, 20));
        jPanelinfo.add(lblsubcateid, new XYConstraints(10, 37, 100, 20));
        jPanelinfo.add(combsubcateid, new XYConstraints(70, 37, 110, 20));
        jPanelinfo.add(txtprice, new XYConstraints(420, 37, 110, 20));
        jPanelinfo.add(lblprice, new XYConstraints(367, 37, 100, 20));
        jPanelinfo.add(txtmodel, new XYConstraints(250, 37, 110, 20));
        jPanelinfo.add(txtastid, new XYConstraints(70, 7, 110, 20));
        jPanelinfo.add(lbldate, new XYConstraints(7, 67, 100, 20));
        jPanelinfo.add(txtdate, new XYConstraints(70, 67, 110, 20));
        jPanelinfo.add(txtuseby, new XYConstraints(420, 67, 110, 20));
        jPanelinfo.add(lbluseby, new XYConstraints(367, 67, 100, 20));
        combstatus.addItem("在库");
        combstatus.addItem("领用中");
        jPanelinfo.add(combstatus, new XYConstraints(250, 67, 110, 20));
        jPanelinfo.add(lblstatus, new XYConstraints(187, 67, 100, 20));
        jPanelinfo.add(lblastid, new XYConstraints(7, 7, 100, 20));
        jPaneltable.add(jTableHeader1, java.awt.BorderLayout.NORTH);
        jPaneltable.add(jScrollPane1, java.awt.BorderLayout.CENTER);
        jScrollPane1.getViewport().add(jTable1);
        jPanelinfo.add(txtremarks, new XYConstraints(70, 97, 290, 20));
        jPanelinfo.add(lblmodel, new XYConstraints(187, 37, 100, 20));
        jPanelinfo.add(lblremarks, new XYConstraints(7, 97, 100, 20));
        jPanelinfo.add(lblcateid, new XYConstraints(367, 7, 100, 20));
        jTableHeader1.setReorderingAllowed(false);
    }

    public void btnadd_actionPerformed(ActionEvent e) {
        if (txtastid.getText().equals("") || txtastname.getText().equals("") ||
            txtprice.getText().equals("") || txtdate.getText().equals("") ||
            txtuseby.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "输入的固定资产信息不完整", "错误",
                                          JOptionPane.ERROR_MESSAGE);
        } else if (Float.valueOf(txtprice.getText()).floatValue() < 2000) {
            JOptionPane.showMessageDialog(this, "输入的固定资产价格要不少于2000", "错误",
                                          JOptionPane.ERROR_MESSAGE);
        }else if(combstatus.getSelectedItem().equals("领用中")){
            JOptionPane.showMessageDialog(this, "入库固定资产的状态不能为领用中", "错误",
                                          JOptionPane.ERROR_MESSAGE);
        }else {
            int flag = JOptionPane.showConfirmDialog(this, "确定真的要把当前的资产信息入库吗？",
                    "入库信息", 0);
            if (flag == 0) {
                cdb.astaddinfo(txtastid.getText(), txtastname.getText(),
                               String.valueOf(combcateid.getSelectedItem()),
                               String.valueOf(combsubcateid.getSelectedItem()),
                               txtmodel.getText(),
                               Float.valueOf(txtprice.getText()),
                               txtdate.getText(),
                               String.valueOf(combstatus.getSelectedItem()),
                               txtuseby.getText(), txtremarks.getText());
                jTable1.setModel(cdb.getAstinfo());
            }
        }
    }

    public void btndel_actionPerformed(ActionEvent e) {
            int r;
            r = jTable1.getSelectedRow();
            if (r >= 0) {
                int flag = JOptionPane.showConfirmDialog(this,
                        "确定真的要把当前的资产信息报损吗？",
                        "报损信息", 0);
                if (flag == 0) {
                    String id = jTable1.getValueAt(r, 0).toString();
                    if(cdb.astdelinfo(id));
                    {
                        JOptionPane.showMessageDialog(this,"领用中的资产不能删除!","错误",
                                          JOptionPane.ERROR_MESSAGE);