addfacilityframe.java~189~

是我写的一些关于设备基础管理的一些代码程序

package 设备管理系统2;

import java.text.NumberFormat;
import javax.swing.JFrame;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import javax.swing.JTree;
import java.awt.*;
import javax.swing.JLabel;
import javax.swing.JButton;
import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
import java.util.Vector;
import java.sql.ResultSet;
import javax.swing.table.AbstractTableModel;
import javax.swing.text.DateFormatter;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

public class AddFacilityFrame extends JFrame implements ActionListener {
    final static String ss = "设备登记";
    final static String sd = "设备登记结果显示";
   DateFormat format1 =DateFormat.getDateInstance(DateFormat.MEDIUM) ;
   // DateFormat format = new SimpleDateFormat("yyyy/MM/dd");
   // DateFormatter df = new DateFormatter(format);
    JPanel contentJpane;

    JLabel facilityNoJLabel = new JLabel();
    JTextField nameJTextField = new JTextField();
    JLabel fileNoJLabel = new JLabel();
    JLabel nameJLabel = new JLabel();
    JTextField fileNoJTextField = new JTextField();
    JLabel categoryJLabel = new JLabel();
    JTextField categoryJTextField = new JTextField();
    JTextField typeJTextField = new JTextField();
    JLabel typeJLabel = new JLabel();
    JTextField facilityNoJTextField = new JTextField();
    JTextField useDepartmentJTextField = new JTextField();
    JLabel factoryJLabel = new JLabel();
    JTextField factoryJTextField = new JTextField();
    JLabel makeDateJLabel = new JLabel();
    JLabel useDateJLabel = new JLabel();
    JFormattedTextField paraJFJTextField = new JFormattedTextField(
            NumberFormat.getNumberInstance());
    JLabel paraDFJLabel = new JLabel();
    JLabel paraJFJLabel = new JLabel();
    JFormattedTextField makeDateJTextField = new JFormattedTextField(format1);
    JLabel valueJLabel = new JLabel();
    JFormattedTextField valueJTextField = new JFormattedTextField(
            NumberFormat.getNumberInstance());
    JLabel useSpeedYearJLabel = new JLabel();
    JFormattedTextField useSpeedYearJTextField = new JFormattedTextField(
            NumberFormat.getNumberInstance());
    JLabel useRateJLabel = new JLabel();
    JFormattedTextField useRateJTextField = new JFormattedTextField(
            NumberFormat.getNumberInstance());
    JLabel motorNoJLabel = new JLabel();
    JFormattedTextField motorNoJTextField = new JFormattedTextField(
            NumberFormat.getNumberInstance());
    JLabel powerJLabel = new JLabel();
    JFormattedTextField powerJTextField = new JFormattedTextField(
            NumberFormat.getNumberInstance());
    JLabel useDepartmentJLabel = new JLabel();
    JFormattedTextField useDateJTextField = new JFormattedTextField(format1);
    JLabel remarkJLabel = new JLabel();
    JTextArea remarkJTextArea = new JTextArea();
    JLabel showFacilityJLabel = new JLabel();
    XYLayout xYLayout1 = new XYLayout();
    JButton sureJButton = new JButton();
    JButton quitJButton = new JButton();
    JFormattedTextField paraDFJTextField = new JFormattedTextField(
            NumberFormat.getNumberInstance());
    Vector vector;
    JTable table;
    AbstractTableModel tm;
    String[] arrField = {"档案编号", "设备名称", "设备编码", "投产年月", "设备类别",
                        "设备型号", "制造年月", "年折旧率", "使用部门", "制造厂家",
                        "复杂系数DF", "复杂系数JF", "设备原值", "折旧年限", "电机台数",
                        "总功率KW", "备注"};
    Object[][] arrtmp = {};
    ResultSet re = null;
    JLabel addFacilityJLabel;

    public AddFacilityFrame() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        Facility.initialize();
        contentJpane = (JPanel) getContentPane();
        contentJpane.setLayout(xYLayout1);
        facilityNoJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        facilityNoJLabel.setText("设备编码");
        addFacilityJLabel = new JLabel();
        nameJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        fileNoJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        fileNoJLabel.setText("档案编号");
        nameJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        nameJLabel.setToolTipText("");
        nameJLabel.setText("设备名称");
        fileNoJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        fileNoJTextField.setText("");
        categoryJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        categoryJLabel.setText("设备类别");
        categoryJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        categoryJTextField.setText("");
        typeJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        typeJTextField.setText("");
        typeJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        typeJLabel.setText("设备型号");
        facilityNoJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        facilityNoJTextField.setText("");
        useDepartmentJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN,
                15));
        useDepartmentJTextField.setText("");
        factoryJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        factoryJLabel.setText("制造厂家");
        factoryJTextField.setText("");
        makeDateJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        makeDateJLabel.setText("制造年月");
        useDateJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        useDateJLabel.setText("投产年月");
        paraJFJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        paraDFJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        paraDFJLabel.setText("复杂系数DF");
        paraJFJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        paraJFJLabel.setText("复杂系数JF");
        makeDateJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        makeDateJTextField.setValue(new Date());
        valueJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        valueJLabel.setText("设备原值");
        valueJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        valueJTextField.setText("");
        useSpeedYearJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        useSpeedYearJLabel.setText("折旧年限");
        useSpeedYearJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN,
                15));
        useSpeedYearJTextField.setText("");
        useRateJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        useRateJLabel.setText("年折旧率");
        useRateJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        motorNoJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        motorNoJLabel.setText("电机台数");
        motorNoJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        motorNoJTextField.setText("");
        powerJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        powerJLabel.setText("总功率KW");
        powerJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        powerJTextField.setText("");
        useDepartmentJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        useDepartmentJLabel.setText("使用部门");
        useDateJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        useDateJTextField.setValue(format1.format(new Date()));
        remarkJLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        remarkJLabel.setText("备注");
        remarkJTextArea.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        remarkJTextArea.setText("");
        showFacilityJLabel.setFont(new java.awt.Font("华文行楷", Font.ITALIC, 22));
        showFacilityJLabel.setToolTipText("");
        showFacilityJLabel.setText("输入结果显示：");
        sureJButton.setText("添加");
        sureJButton.addActionListener(this);
        quitJButton.setText("取消");
        quitJButton.addActionListener(this);
        paraDFJTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));

        addFacilityJLabel.setFont(new java.awt.Font("华文行楷", Font.ITALIC, 22));
        addFacilityJLabel.setToolTipText("");
        addFacilityJLabel.setText("添加设备记录：");
       // tabelJScrollPane.setBorder(BorderFactory.createRaisedBevelBorder());
        contentJpane.add(motorNoJLabel, new XYConstraints(20, 220, 60, 25));
        contentJpane.add(motorNoJTextField, new XYConstraints(90, 220, 120, 25));
        contentJpane.add(valueJLabel, new XYConstraints(20, 180, 60, 25));
        contentJpane.add(valueJTextField, new XYConstraints(90, 180, 120, 25));
        contentJpane.add(useSpeedYearJLabel, new XYConstraints(220, 180, 60, 25));
        contentJpane.add(factoryJLabel, new XYConstraints(220, 140, 60, 25));
        contentJpane.add(useDepartmentJTextField,
                         new XYConstraints(90, 140, 120, 25));
        contentJpane.add(categoryJLabel, new XYConstraints(20, 100, 60, 25));
        contentJpane.add(categoryJTextField,