khjframe.java

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

        jPanel2.setBorder(new javax.swing.border.EtchedBorder());
        jLabel4.setText("\u4e1a\u4e3b\u4ee3\u7801:");
        jPanel2.add(jLabel4);
        jLabel4.setBounds(10, 10, 54, 15);

        clientCode.setEnabled(false);
        jPanel2.add(clientCode);
        clientCode.setBounds(70, 10, 80, 20);

        jLabel5.setText("\u4e1a\u4e3b\u540d\u79f0:\n");
        jPanel2.add(jLabel5);
        jLabel5.setBounds(160, 10, 60, 15);

        clientName.setEnabled(false);
        jPanel2.add(clientName);
        clientName.setBounds(220, 10, 70, 20);

        jLabel6.setText("\u6027\u522b:");
        jPanel2.add(jLabel6);
        jLabel6.setBounds(300, 10, 30, 15);

        sex.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "", "男", "女" }));
        sex.setEnabled(false);
        jPanel2.add(sex);
        sex.setBounds(340, 10, 37, 20);

        jLabel7.setText("\u5165\u4f4f\u65f6\u95f4:");
        jPanel2.add(jLabel7);
        jLabel7.setBounds(10, 40, 60, 15);

        inTime.setEnabled(false);
        jPanel2.add(inTime);
        inTime.setBounds(70, 40, 80, 20);

        jLabel8.setText("\u8054\u7cfb\u7535\u8bdd:");
        jPanel2.add(jLabel8);
        jLabel8.setBounds(160, 40, 60, 15);

        phone.setEnabled(false);
        jPanel2.add(phone);
        phone.setBounds(220, 40, 160, 20);

        jLabel9.setText("\u7c4d\u8d2f:");
        jPanel2.add(jLabel9);
        jLabel9.setBounds(10, 70, 30, 15);

        np.setEnabled(false);
        jPanel2.add(np);
        np.setBounds(70, 70, 310, 20);

        jLabel10.setText("\u8bc1\u4ef6\u540d\u79f0:");
        jPanel2.add(jLabel10);
        jLabel10.setBounds(10, 100, 60, 15);

        idKind.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "", "身份证", "军官证", "护照" }));
        idKind.setEnabled(false);
        jPanel2.add(idKind);
        idKind.setBounds(70, 100, 80, 20);

        jLabel11.setText("\u8bc1\u4ef6\u53f7\u7801:");
        jPanel2.add(jLabel11);
        jLabel11.setBounds(160, 100, 60, 15);

        idNo.setEnabled(false);
        jPanel2.add(idNo);
        idNo.setBounds(220, 100, 160, 20);

        jLabel13.setText("\u5907\u6ce8:");
        jPanel2.add(jLabel13);
        jLabel13.setBounds(10, 130, 30, 15);

        jPanel3.setLayout(null);

        jPanel3.setBorder(new javax.swing.border.EtchedBorder());
        remark.setEnabled(false);
        remark.setPreferredSize(new java.awt.Dimension(10, 19));
        jScrollPane2.setViewportView(remark);

        jPanel3.add(jScrollPane2);
        jScrollPane2.setBounds(0, 0, 310, 100);

        jPanel2.add(jPanel3);
        jPanel3.setBounds(70, 130, 310, 100);

        operates.add(jPanel2);
        jPanel2.setBounds(10, 120, 390, 240);

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

        buttons.setLayout(null);

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

        buttons.add(modify);
        modify.setBounds(20, 10, 60, 23);

        save.setText("\u4fdd\u5b58");
        save.setEnabled(false);
        save.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                saveActionPerformed(evt);
            }
        });

        buttons.add(save);
        save.setBounds(100, 10, 60, 23);

        clear.setText("\u6e05\u9664");
        clear.setEnabled(false);
        clear.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                clearActionPerformed(evt);
            }
        });

        buttons.add(clear);
        clear.setBounds(260, 10, 60, 23);

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

        buttons.add(quit);
        quit.setBounds(340, 10, 60, 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);
            }
        });

        buttons.add(dispose);
        dispose.setBounds(180, 10, 60, 23);

        jControlPanel.add(buttons);
        buttons.setBounds(10, 380, 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 将在此处添加您的处理代码：
        if(modifyFlag==true){
            disabledTools();
            modify.setEnabled(true);clear.setEnabled(false);
            save.setEnabled(false);dispose.setEnabled(false);
            modifyFlag=false;
        }       
    }//GEN-LAST:event_disposeActionPerformed

    private void saveActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_saveActionPerformed
// TODO 将在此处添加您的处理代码：
        if(modifyFlag==true){
            disabledTools();
            save.setEnabled(false);dispose.setEnabled(false);
            clear.setEnabled(false);modify.setEnabled(true);
            update();
            modifyFlag=false;          
        }
    }//GEN-LAST:event_saveActionPerformed

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

    private void modifyActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_modifyActionPerformed
// TODO 将在此处添加您的处理代码：
        modifyFlag=true;
        enabledTools();
        save.setEnabled(true);dispose.setEnabled(true);
        clear.setEnabled(true);modify.setEnabled(false);
    }//GEN-LAST:event_modifyActionPerformed

    private void KHTableMouseReleased(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_KHTableMouseReleased
// TODO 将在此处添加您的处理代码：
        int row = KHTable.getSelectedRow();
        String key=KHData.getValueAt(row,1).toString();
        query(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
        
    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
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new KHJFrame().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JTable KHTable;
    private javax.swing.JPanel buttons;
    private javax.swing.JButton clear;
    private javax.swing.JTextField clientCode;
    private javax.swing.JTextField clientName;
    private javax.swing.JButton dingwei;
    private javax.swing.JButton dispose;
    private javax.swing.JComboBox idKind;
    private javax.swing.JTextField idNo;
    private javax.swing.JTextField inTime;
    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 jLabel12;
    private javax.swing.JLabel jLabel13;
    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 jQueryPanel;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JPanel jStatusPanel;
    private javax.swing.JComboBox keyword;
    private javax.swing.JButton modify;
    private javax.swing.JTextField np;
    private javax.swing.JPanel operates;
    private javax.swing.JTextField phone;
    private javax.swing.JButton quit;
    private javax.swing.JTextArea remark;
    private javax.swing.JTextField roomCode;
    private javax.swing.JComboBox roomStatus;
    private javax.swing.JButton save;
    private javax.swing.JComboBox sex;
    private javax.swing.JLabel status;
    private javax.swing.JTextField zone;
    // 变量声明结束//GEN-END:variables
    
}