sfijframe.java

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

        jPanel4.add(operator2);
        operator2.setBounds(300, 50, 60, 20);

        jPanel2.add(jPanel4);
        jPanel4.setBounds(10, 10, 480, 80);

        jScrollPane3.setViewportBorder(new javax.swing.border.EtchedBorder());
        ZBTable.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"
            }
        ));
        ZBTable.setEnabled(false);
        ZBData=new DefaultTableModel();
        ZBData.addColumn("房间代码");
        ZBData.addColumn("费用月份");
        ZBData.addColumn("项目名称");
        ZBData.addColumn("前次读数");
        ZBData.addColumn("本次读数");
        ZBData.addColumn("操作员");
        ZBTable.setModel(ZBData);
        ZBTable.setCellSelectionEnabled(false);
        jScrollPane3.setViewportView(ZBTable);

        jPanel2.add(jScrollPane3);
        jScrollPane3.setBounds(10, 140, 480, 190);

        jPanel7.setLayout(null);

        edit.setText("\u7f16\u8f91");
        edit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                editActionPerformed(evt);
            }
        });

        jPanel7.add(edit);
        edit.setBounds(70, 10, 57, 23);

        stopEdit.setText("\u505c\u6b62\u7f16\u8f91");
        stopEdit.setEnabled(false);
        stopEdit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                stopEditActionPerformed(evt);
            }
        });

        jPanel7.add(stopEdit);
        stopEdit.setBounds(200, 10, 81, 23);

        quit.setText("\u9000\u51fa");
        quit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                quitActionPerformed(evt);
            }
        });

        jPanel7.add(quit);
        quit.setBounds(350, 10, 57, 23);

        jPanel2.add(jPanel7);
        jPanel7.setBounds(10, 340, 480, 40);

        jPanel8.setLayout(null);

        jPanel8.setBorder(new javax.swing.border.EtchedBorder());
        jLabel11.setText("\u67e5\u8be2\u8d39\u7528\u9879\u76ee:");
        jPanel8.add(jLabel11);
        jLabel11.setBounds(10, 10, 78, 15);

        queryChargeItem2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "水费", "电费" }));
        jPanel8.add(queryChargeItem2);
        queryChargeItem2.setBounds(100, 10, 90, 20);

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

        jPanel8.add(queryButton2);
        queryButton2.setBounds(230, 10, 57, 23);

        jPanel2.add(jPanel8);
        jPanel8.setBounds(10, 90, 480, 50);

        jTabbedPane1.addTab("\u8d70\u8868\u7c7b\u8d39\u7528", jPanel2);

        operates.add(jTabbedPane1);
        jTabbedPane1.setBounds(0, 0, 500, 410);

        jControlPanel.add(operates);
        operates.setBounds(10, 10, 500, 410);

        getContentPane().add(jControlPanel);
        jControlPanel.setBounds(240, 0, 520, 430);

        pack();
    }
    // </editor-fold>//GEN-END:initComponents

    private void queryButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_queryButton2ActionPerformed
// TODO 将在此处添加您的处理代码：
        int row = KHTable.getSelectedRow();
        String key1=KHData.getValueAt(row,1).toString();
        String key2=Integer.valueOf(queryChargeItem2.getSelectedIndex()+1).toString();
        updateZBTable();
        queryKind2(key1, key2);
    }//GEN-LAST:event_queryButton2ActionPerformed

    private void stopEditActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_stopEditActionPerformed
// TODO 将在此处添加您的处理代码：
        addZBData.setEnabled(true);
        firstNo.setEnabled(true);
        secondNo.setEnabled(true);
        addChargeItem2.setEnabled(true);
        operator2.setEnabled(true);
        stopEdit.setEnabled(false);
        edit.setEnabled(true);
        ZBTable.setEnabled(false);
        update();
        
    }//GEN-LAST:event_stopEditActionPerformed

    private void addZBDataActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_addZBDataActionPerformed
// TODO 将在此处添加您的处理代码：
        updateZBTable();
        insert2();
    }//GEN-LAST:event_addZBDataActionPerformed

    private void editActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_editActionPerformed
// TODO 将在此处添加您的处理代码：
        addZBData.setEnabled(false);
        firstNo.setEnabled(false);
        secondNo.setEnabled(false);
        addChargeItem2.setEnabled(false);
        operator2.setEnabled(false);
        stopEdit.setEnabled(true);
        ZBTable.setEnabled(true);
        edit.setEnabled(false);
    }//GEN-LAST:event_editActionPerformed

    private void quitActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_quitActionPerformed
// TODO 将在此处添加您的处理代码：
        dispose();
        try{
            db.close();
        }
        catch(Exception e){
            System.out.println("数据库关闭异常"+e);
        }
    }//GEN-LAST:event_quitActionPerformed

    private void addNDataActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_addNDataActionPerformed
// TODO 将在此处添加您的处理代码：
        updateNTable();
        insert1();
    }//GEN-LAST:event_addNDataActionPerformed

    private void queryButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_queryButton1ActionPerformed
// TODO 将在此处添加您的处理代码：
        int row = KHTable.getSelectedRow();
        String key1=KHData.getValueAt(row,1).toString();
        String key2=Integer.valueOf(queryChargeItem1.getSelectedIndex()+3).toString();
        updateNTable();
        queryKind1(key1, key2);
        
    }//GEN-LAST:event_queryButton1ActionPerformed

    private void KHTableMouseReleased(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_KHTableMouseReleased
// TODO 将在此处添加您的处理代码：
        int row = KHTable.getSelectedRow();
        String key=KHData.getValueAt(row,1).toString();
        updateNTable();updateZBTable();
        query1(key);query2(key);
    }//GEN-LAST:event_KHTableMouseReleased

    private void dingweiActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_dingweiActionPerformed
// TODO 将在此处添加您的处理代码：
        String key=keyword.getSelectedItem().toString();
        String sql="select * from roomInfo,clientInfo where roomInfo.clientCode=clientInfo.clientCode And zone='"+key+"'";
        KHData.setRowCount(0);
	KHData.fireTableDataChanged();
        try{
               String data[]=new String[3];
               db.setSql(sql);
               db.executeQuery();
               rs=db.getRs();
               while(rs.next()){
                   data[0]=rs.getString("zone");
                   data[1]=rs.getString("roomCode");
                   data[2]=rs.getString("clientName");
                   KHData.addRow(data);
               }
               status.setText("选定房间数："+KHData.getRowCount());
        }
        catch(Exception e){
               System.out.println("客户信息表格显示异常:"+e);
        }
        
        
    }//GEN-LAST:event_dingweiActionPerformed
            
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new SFIJFrame().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JTable KHTable;
    private javax.swing.JTable NTable;
    private javax.swing.JTable ZBTable;
    private javax.swing.JComboBox addChargeItem1;
    private javax.swing.JComboBox addChargeItem2;
    private javax.swing.JButton addNData;
    private javax.swing.JButton addZBData;
    private javax.swing.JButton dingwei;
    private javax.swing.JButton edit;
    private javax.swing.JTextField firstNo;
    private javax.swing.JPanel jControlPanel;
    private javax.swing.JPanel jIndexPanel;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JPanel jMainPanel;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JPanel jPanel6;
    private javax.swing.JPanel jPanel7;
    private javax.swing.JPanel jPanel8;
    private javax.swing.JPanel jQueryPanel;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JPanel jStatusPanel;
    private javax.swing.JTabbedPane jTabbedPane1;
    private javax.swing.JComboBox keyword;
    private javax.swing.JPanel operates;
    private javax.swing.JTextField operator1;
    private javax.swing.JTextField operator2;
    private javax.swing.JButton queryButton1;
    private javax.swing.JButton queryButton2;
    private javax.swing.JComboBox queryChargeItem1;
    private javax.swing.JComboBox queryChargeItem2;
    private javax.swing.JButton quit;
    private javax.swing.JTextField secondNo;
    private javax.swing.JLabel status;
    private javax.swing.JButton stopEdit;
    // 变量声明结束//GEN-END:variables
    
}