chjframe.java

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

        jControlPanel.add(jPanel1);
        jPanel1.setBounds(10, 10, 410, 50);

        jPanel2.setLayout(null);

        jPanel2.setBorder(new javax.swing.border.EtchedBorder());
        jPanel2.add(dateChooser1);
        dateChooser1.setLocation(85,8);
        dateChooser1.setSize(100,25);
        jLabel3.setText("\u8d39\u7528\u6708\u4efd:");
        jPanel2.add(jLabel3);
        jLabel3.setBounds(30, 10, 60, 15);

        jControlPanel.add(jPanel2);
        jPanel2.setBounds(10, 70, 410, 40);

        SFTable.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"
            }
        ));
        SFTable.setEnabled(false);
        SFData=new DefaultTableModel();
        SFData.addColumn("费用月份");
        SFData.addColumn("项目名称");
        SFData.addColumn("费用金额");
        SFTable.setModel(SFData);
        SFTable.setCellSelectionEnabled(false);
        jScrollPane2.setViewportView(SFTable);

        jControlPanel.add(jScrollPane2);
        jScrollPane2.setBounds(10, 120, 410, 160);

        jPanel3.setLayout(null);

        charge.setText("\u4ea4\u8d39");
        charge.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                chargeActionPerformed(evt);
            }
        });

        jPanel3.add(charge);
        charge.setBounds(30, 10, 57, 23);

        ok.setText("\u786e\u5b9a");
        ok.setEnabled(false);
        ok.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                okActionPerformed(evt);
            }
        });

        jPanel3.add(ok);
        ok.setBounds(130, 10, 57, 23);

        dispose.setText("\u653e\u5f03");
        dispose.setEnabled(false);
        dispose.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                disposeActionPerformed(evt);
            }
        });

        jPanel3.add(dispose);
        dispose.setBounds(230, 10, 57, 23);

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

        jPanel3.add(quit);
        quit.setBounds(330, 10, 57, 23);

        jControlPanel.add(jPanel3);
        jPanel3.setBounds(10, 370, 410, 50);

        jPanel4.setLayout(null);

        jPanel4.setBorder(new javax.swing.border.EtchedBorder());
        jLabel4.setText("\u8d39\u7528\u6708\u4efd:");
        jPanel4.add(jLabel4);
        jLabel4.setBounds(10, 10, 60, 15);

        month.setEnabled(false);
        jPanel4.add(month);
        month.setBounds(70, 10, 60, 20);

        jLabel5.setText("\u8d39\u7528\u603b\u548c:");
        jPanel4.add(jLabel5);
        jLabel5.setBounds(250, 10, 54, 15);

        sum.setEnabled(false);
        jPanel4.add(sum);
        sum.setBounds(320, 10, 70, 20);

        jLabel6.setText("\u8d39\u7528\u7b14\u6570:");
        jPanel4.add(jLabel6);
        jLabel6.setBounds(140, 10, 54, 15);

        count.setEnabled(false);
        jPanel4.add(count);
        count.setBounds(200, 10, 40, 20);

        jControlPanel.add(jPanel4);
        jPanel4.setBounds(10, 290, 410, 40);

        jPanel5.setLayout(null);

        jPanel5.setBorder(new javax.swing.border.EtchedBorder());
        jPanel5.add(dateChooser2);
        dateChooser2.setLocation(70,8);
        dateChooser2.setSize(100,25);
        dateChooser2.setEnabled(false);
        jLabel7.setText("\u6536\u6b3e\u65e5\u671f:");
        jPanel5.add(jLabel7);
        jLabel7.setBounds(10, 10, 60, 15);

        jControlPanel.add(jPanel5);
        jPanel5.setBounds(10, 330, 410, 40);

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

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

    private void disposeActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_disposeActionPerformed
// TODO 将在此处添加您的处理代码：
        dateChooser2.setEnabled(false);
        charge.setEnabled(true);
        ok.setEnabled(false);
        dispose.setEnabled(false);
    }//GEN-LAST:event_disposeActionPerformed

    private void okActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_okActionPerformed
// TODO 将在此处添加您的处理代码：
        int row1= KHTable.getSelectedRow();       
        String key1=KHData.getValueAt(row1,1).toString();        
        String date=dateChooser1.getText().trim()+"-01";
        dateChooser2.setEnabled(false);
        charge.setEnabled(true);
        ok.setEnabled(false);
        dispose.setEnabled(false);
        update(key1,date);  
        updateSFTable();
    }//GEN-LAST:event_okActionPerformed

    private void chargeActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_chargeActionPerformed
// TODO 将在此处添加您的处理代码：
        dateChooser2.setEnabled(true);
        charge.setEnabled(false);
        ok.setEnabled(true);
        dispose.setEnabled(true);        
    }//GEN-LAST:event_chargeActionPerformed

    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 KHTableMouseReleased(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_KHTableMouseReleased
// TODO 将在此处添加您的处理代码：
        int row1= KHTable.getSelectedRow();       
        String key1=KHData.getValueAt(row1,1).toString();        
        String date=dateChooser1.getText().trim()+"-01";
        String key2=dateChooser1.getText().substring(6,7)+"月";
        query1(key1);
        updateSFTable();
        query2(key1,date);        
        month.setText(key2);        
        count.setText(new Integer(SFData.getRowCount()).toString());
        sum.setText(new Double(total()).toString());                       
    }//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 CHJFrame().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JTable KHTable;
    private javax.swing.JTable SFTable;
    private javax.swing.JButton charge;
    private javax.swing.JTextField clientName;
    private javax.swing.JTextField count;
    private javax.swing.JButton dingwei;
    private javax.swing.JButton dispose;
    private javax.swing.JPanel jControlPanel;
    private javax.swing.JPanel jIndexPanel;
    private javax.swing.JLabel jLabel1;
    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.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 jQueryPanel;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JPanel jStatusPanel;
    private javax.swing.JComboBox keyword;
    private javax.swing.JTextField month;
    private javax.swing.JButton ok;
    private javax.swing.JButton quit;
    private javax.swing.JTextField roomCode;
    private javax.swing.JLabel status;
    private javax.swing.JTextField sum;
    // 变量声明结束//GEN-END:variables
    
}