sfijframe.java

小区物业管理系统（java版） java swing + access 2003

        jQueryPanel = new javax.swing.JPanel();
        jLabel14 = new javax.swing.JLabel();
        keyword = new javax.swing.JComboBox();
        dingwei = new javax.swing.JButton();
        jControlPanel = new javax.swing.JPanel();
        operates = new javax.swing.JPanel();
        jTabbedPane1 = new javax.swing.JTabbedPane();
        jPanel1 = new javax.swing.JPanel();
        jPanel3 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        addNData = new javax.swing.JButton();
        jLabel4 = new javax.swing.JLabel();
        addChargeItem1 = new javax.swing.JComboBox();
        jScrollPane2 = new javax.swing.JScrollPane();
        NTable = new javax.swing.JTable();
        jPanel5 = new javax.swing.JPanel();
        jLabel3 = new javax.swing.JLabel();
        queryChargeItem1 = new javax.swing.JComboBox();
        queryButton1 = new javax.swing.JButton();
        jPanel6 = new javax.swing.JPanel();
        jLabel6 = new javax.swing.JLabel();
        operator1 = new javax.swing.JTextField();
        jPanel2 = new javax.swing.JPanel();
        jPanel4 = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        addZBData = new javax.swing.JButton();
        jLabel5 = new javax.swing.JLabel();
        addChargeItem2 = new javax.swing.JComboBox();
        jLabel7 = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        firstNo = new javax.swing.JTextField();
        jLabel9 = new javax.swing.JLabel();
        secondNo = new javax.swing.JTextField();
        jLabel10 = new javax.swing.JLabel();
        operator2 = new javax.swing.JTextField();
        jScrollPane3 = new javax.swing.JScrollPane();
        ZBTable = new javax.swing.JTable();
        jPanel7 = new javax.swing.JPanel();
        edit = new javax.swing.JButton();
        stopEdit = new javax.swing.JButton();
        quit = new javax.swing.JButton();
        jPanel8 = new javax.swing.JPanel();
        jLabel11 = new javax.swing.JLabel();
        queryChargeItem2 = new javax.swing.JComboBox();
        queryButton2 = new javax.swing.JButton();

        getContentPane().setLayout(null);

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setResizable(false);
        jMainPanel.setLayout(null);

        jMainPanel.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
        jIndexPanel.setLayout(null);

        jIndexPanel.setBorder(new javax.swing.border.EtchedBorder());
        KHTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        KHData=new DefaultTableModel();
        KHData.addColumn("大楼");
        KHData.addColumn("房间代码");
        KHData.addColumn("客户描述");
        KHTable.setModel(KHData);
        KHTable.setCellSelectionEnabled(false);
        KHTable.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseReleased(java.awt.event.MouseEvent evt) {
                KHTableMouseReleased(evt);
            }
        });

        jScrollPane1.setViewportView(KHTable);

        jIndexPanel.add(jScrollPane1);
        jScrollPane1.setBounds(0, 0, 220, 270);

        jMainPanel.add(jIndexPanel);
        jIndexPanel.setBounds(10, 110, 220, 270);

        jStatusPanel.setLayout(null);

        jStatusPanel.setBorder(new javax.swing.border.EtchedBorder());
        jStatusPanel.add(status);
        status.setBounds(0, 0, 220, 30);

        jMainPanel.add(jStatusPanel);
        jStatusPanel.setBounds(10, 390, 220, 30);

        jQueryPanel.setLayout(null);

        jQueryPanel.setBorder(new javax.swing.border.EtchedBorder());
        jLabel14.setText("\u6240\u5728\u5927\u697c:");
        jQueryPanel.add(jLabel14);
        jLabel14.setBounds(20, 30, 60, 20);

        keyword.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "A", "B", "C" }));
        jQueryPanel.add(keyword);
        keyword.setBounds(80, 30, 90, 20);

        dingwei.setText("\u5b9a\u4f4d");
        dingwei.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                dingweiActionPerformed(evt);
            }
        });

        jQueryPanel.add(dingwei);
        dingwei.setBounds(110, 60, 60, 23);

        jMainPanel.add(jQueryPanel);
        jQueryPanel.setBounds(10, 10, 220, 90);

        getContentPane().add(jMainPanel);
        jMainPanel.setBounds(0, 0, 240, 430);

        jControlPanel.setLayout(null);

        jControlPanel.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
        operates.setLayout(null);

        jPanel1.setLayout(null);

        jPanel3.setLayout(null);

        jPanel3.setBorder(new javax.swing.border.EtchedBorder());
        jPanel3.add(dateChooser1);
        dateChooser1.setLocation(80,20);
        dateChooser1.setSize(100,25);

        jLabel1.setText("\u8d39\u7528\u65f6\u95f4:");
        jPanel3.add(jLabel1);
        jLabel1.setBounds(20, 20, 60, 15);

        addNData.setText("\u6dfb\u52a0\u8d39\u7528");
        addNData.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                addNDataActionPerformed(evt);
            }
        });

        jPanel3.add(addNData);
        addNData.setBounds(380, 20, 80, 25);

        jLabel4.setText("\u8d39\u7528\u9879\u76ee:");
        jPanel3.add(jLabel4);
        jLabel4.setBounds(200, 20, 54, 15);

        addChargeItem1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "停车费", "管理费" }));
        jPanel3.add(addChargeItem1);
        addChargeItem1.setBounds(270, 20, 90, 20);

        jPanel1.add(jPanel3);
        jPanel3.setBounds(10, 10, 480, 60);

        NTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        NTable.setEnabled(false);
        NTable.setFocusable(false);
        NData=new DefaultTableModel();
        NData.addColumn("房间代码");
        NData.addColumn("费用月份");
        NData.addColumn("项目名称");
        NData.addColumn("费用金额");
        NData.addColumn("操作员");
        NTable.setModel(NData);
        NTable.setCellSelectionEnabled(false);
        jScrollPane2.setViewportView(NTable);

        jPanel1.add(jScrollPane2);
        jScrollPane2.setBounds(10, 130, 480, 240);

        jPanel5.setLayout(null);

        jPanel5.setBorder(new javax.swing.border.EtchedBorder());
        jLabel3.setText("\u67e5\u8be2\u8d39\u7528\u9879\u76ee:");
        jPanel5.add(jLabel3);
        jLabel3.setBounds(20, 20, 80, 15);

        queryChargeItem1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "停车费", "管理费" }));
        jPanel5.add(queryChargeItem1);
        queryChargeItem1.setBounds(110, 20, 90, 20);

        queryButton1.setText("\u67e5\u8be2");
        queryButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                queryButton1ActionPerformed(evt);
            }
        });

        jPanel5.add(queryButton1);
        queryButton1.setBounds(230, 20, 57, 23);

        jPanel1.add(jPanel5);
        jPanel5.setBounds(10, 70, 320, 60);

        jPanel6.setLayout(null);

        jPanel6.setBorder(new javax.swing.border.EtchedBorder());
        jLabel6.setText("\u64cd\u4f5c\u5458:");
        jPanel6.add(jLabel6);
        jLabel6.setBounds(10, 20, 42, 15);

        jPanel6.add(operator1);
        operator1.setBounds(60, 20, 80, 20);

        jPanel1.add(jPanel6);
        jPanel6.setBounds(330, 70, 160, 60);

        jTabbedPane1.addTab("\u5e38\u89c4\u7c7b\u8d39\u7528", jPanel1);

        jPanel2.setLayout(null);

        jPanel4.setLayout(null);

        jPanel4.setBorder(new javax.swing.border.EtchedBorder());
        jPanel4.add(dateChooser2);
        dateChooser2.setLocation(80,20);
        dateChooser2.setSize(100,25);

        jLabel2.setText("\u8d39\u7528\u65f6\u95f4:");
        jPanel4.add(jLabel2);
        jLabel2.setBounds(10, 20, 60, 15);

        addZBData.setText("\u6dfb\u52a0\u8d39\u7528");
        addZBData.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                addZBDataActionPerformed(evt);
            }
        });

        jPanel4.add(addZBData);
        addZBData.setBounds(390, 50, 81, 25);

        jLabel5.setText("\u8d39\u7528\u9879\u76ee:");
        jPanel4.add(jLabel5);
        jLabel5.setBounds(200, 20, 54, 15);

        addChargeItem2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "水费", "电费" }));
        jPanel4.add(addChargeItem2);
        addChargeItem2.setBounds(270, 20, 90, 20);

        jLabel7.setText("\u524d\u6b21\u8bfb\u6570:");
        jPanel4.add(jLabel7);
        jLabel7.setBounds(10, 50, 60, 15);

        jPanel4.add(jLabel8);
        jLabel8.setBounds(200, 50, 0, 0);

        jPanel4.add(firstNo);
        firstNo.setBounds(70, 50, 50, 20);

        jLabel9.setText("\u672c\u6b21\u8bfb\u6570:");
        jPanel4.add(jLabel9);
        jLabel9.setBounds(130, 50, 60, 15);

        jPanel4.add(secondNo);
        secondNo.setBounds(190, 50, 50, 20);

        jLabel10.setText("\u64cd\u4f5c\u5458:");
        jPanel4.add(jLabel10);
        jLabel10.setBounds(250, 50, 42, 15);