wxmanage.java

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

        jLabel6.setText("\u7ef4\u4fee\u7c7b\u522b:");
        jPanel1.add(jLabel6);
        jLabel6.setBounds(10, 40, 54, 15);

        wxKind.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "其他", "电器维修", "水管维修" }));
        wxKind.setEnabled(false);
        jPanel1.add(wxKind);
        wxKind.setBounds(70, 40, 80, 20);

        jLabel7.setText("\u8054\u7cfb\u4eba:");
        jPanel1.add(jLabel7);
        jLabel7.setBounds(160, 40, 42, 15);

        contactName.setEnabled(false);
        jPanel1.add(contactName);
        contactName.setBounds(210, 40, 80, 20);

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

        tel.setEnabled(false);
        jPanel1.add(tel);
        tel.setBounds(360, 40, 100, 20);

        jLabel9.setText("\u6545\u969c\u65f6\u95f4:");
        jPanel1.add(jLabel9);
        jLabel9.setBounds(10, 70, 60, 15);

        errorTime.setEnabled(false);
        jPanel1.add(errorTime);
        errorTime.setBounds(70, 70, 80, 20);

        jLabel10.setText("\u7ef4\u4fee\u4eba\u5458:");
        jPanel1.add(jLabel10);
        jLabel10.setBounds(160, 70, 60, 15);

        wxName.setEnabled(false);
        jPanel1.add(wxName);
        wxName.setBounds(220, 70, 80, 20);

        jLabel11.setText("\u6545\u969c\u73b0\u8c61:");
        jPanel1.add(jLabel11);
        jLabel11.setBounds(10, 100, 60, 15);

        wxContent.setEnabled(false);
        jScrollPane2.setViewportView(wxContent);

        jPanel1.add(jScrollPane2);
        jScrollPane2.setBounds(70, 100, 390, 50);

        jLabel12.setText("\u5904\u7406\u7ed3\u679c:");
        jPanel1.add(jLabel12);
        jLabel12.setBounds(10, 160, 54, 15);

        wxResult.setEnabled(false);
        jScrollPane3.setViewportView(wxResult);

        jPanel1.add(jScrollPane3);
        jScrollPane3.setBounds(70, 160, 390, 50);

        jLabel13.setText("\u9700\u8981\u8d39\u7528:");
        jPanel1.add(jLabel13);
        jLabel13.setBounds(310, 70, 60, 15);

        wxFee.setEnabled(false);
        jPanel1.add(wxFee);
        wxFee.setBounds(370, 70, 90, 20);

        getContentPane().add(jPanel1);
        jPanel1.setBounds(10, 230, 510, 220);

        jPanel2.setLayout(null);

        add.setText("\u6dfb\u52a0");
        add.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                addActionPerformed(evt);
            }
        });

        jPanel2.add(add);
        add.setBounds(20, 10, 57, 23);

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

        jPanel2.add(modify);
        modify.setBounds(100, 10, 57, 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);
            }
        });

        jPanel2.add(save);
        save.setBounds(180, 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);
            }
        });

        jPanel2.add(dispose);
        dispose.setBounds(260, 10, 57, 23);

        delete.setText("\u5220\u9664");
        delete.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                deleteActionPerformed(evt);
            }
        });

        jPanel2.add(delete);
        delete.setBounds(340, 10, 57, 23);

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

        jPanel2.add(quit);
        quit.setBounds(420, 10, 57, 23);

        getContentPane().add(jPanel2);
        jPanel2.setBounds(10, 450, 510, 40);

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

    private void searchActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_searchActionPerformed
// TODO 将在此处添加您的处理代码：
        WXData.setRowCount(0);
	WXData.fireTableDataChanged();
        int key=kind.getSelectedIndex();
        String sql="";
        switch(key){
            case 0:sql="select * from wxInfo";break;
            case 1:sql="select * from wxInfo where wxKind=0";break;
            case 2:sql="select * from wxInfo where wxKind=1";break;
            case 3:sql="select * from wxInfo where wxKind=2";break;
        }          
        try{
            String data[]=new String[7];
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            while(rs.next()){
                data[0]=new Integer(rs.getInt("wxCode")).toString();
                data[1]=wxKind.getItemAt(rs.getInt("wxKind")).toString();
                data[2]=rs.getString("wxTitle");
                data[3]=rs.getString("roomCode");
                data[4]=rs.getString("contactName");
                data[5]=rs.getString("errorTime");
                data[6]=rs.getString("wxName");
                WXData.addRow(data);                
            }
        }
        catch(Exception e){
            System.out.println("搜索表格显示异常:"+e);
        }    
    }//GEN-LAST:event_searchActionPerformed

    private void deleteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_deleteActionPerformed
// TODO 将在此处添加您的处理代码：
        int key=Integer.valueOf(wxCode.getText()).intValue();
        int i=JOptionPane.showConfirmDialog(this,"删除提示","是否确认删除",JOptionPane.YES_NO_CANCEL_OPTION,JOptionPane.QUESTION_MESSAGE);
        if(i==JOptionPane.YES_OPTION){
            delete(key);
            WXData.setRowCount(0);
	    WXData.fireTableDataChanged();
            displayTable();
        }         
    }//GEN-LAST:event_deleteActionPerformed

    private void WXTableMouseReleased(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_WXTableMouseReleased
// TODO 将在此处添加您的处理代码：
        int row = WXTable.getSelectedRow();
        int key=Integer.valueOf(WXData.getValueAt(row,0).toString()).intValue();
        query(key); 
    }//GEN-LAST:event_WXTableMouseReleased

    private void disposeActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_disposeActionPerformed
// TODO 将在此处添加您的处理代码：
        if(addFlag==true){
            disabledTools();
            add.setEnabled(true);modify.setEnabled(true);delete.setEnabled(true);
            save.setEnabled(false);dispose.setEnabled(false);
            addFlag=false;                        
        }
        if(modifyFlag==true){
            disabledTools();
            add.setEnabled(true);modify.setEnabled(true);delete.setEnabled(true);
            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(check()){
            if(addFlag==true){            
                disabledTools();
                insert();
                WXData.setRowCount(0);
	        WXData.fireTableDataChanged();
                displayTable();
                addFlag=false;
                
           }
           if(modifyFlag==true){            
                disabledTools();
                update();          
                modifyFlag=false; 
                WXData.setRowCount(0);
	        WXData.fireTableDataChanged();
                displayTable();
           }
           add.setEnabled(true);modify.setEnabled(true);delete.setEnabled(true);
           save.setEnabled(false);dispose.setEnabled(false);
        }
    }//GEN-LAST:event_saveActionPerformed

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

    private void addActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_addActionPerformed
// TODO 将在此处添加您的处理代码：
        addFlag=true;
        enabledTools();
        clearTools();
        wxCode.setText("自动编码");
        errorTime.setText(submitTime);        
        add.setEnabled(false);modify.setEnabled(false);delete.setEnabled(false);
        save.setEnabled(true);dispose.setEnabled(true);
    }//GEN-LAST:event_addActionPerformed

    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 WXManage().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JTable WXTable;
    private javax.swing.JButton add;
    private javax.swing.JTextField contactName;
    private javax.swing.JButton delete;
    private javax.swing.JButton dispose;
    private javax.swing.JTextField errorTime;
    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 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 jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JPanel jSearchPanel;
    private javax.swing.JComboBox kind;
    private javax.swing.JButton modify;
    private javax.swing.JButton quit;
    private javax.swing.JTextField roomCode;
    private javax.swing.JButton save;
    private javax.swing.JButton search;
    private javax.swing.JTextField tel;
    private javax.swing.JTextField wxCode;
    private javax.swing.JTextArea wxContent;
    private javax.swing.JTextField wxFee;
    private javax.swing.JComboBox wxKind;
    private javax.swing.JTextField wxName;
    private javax.swing.JTextArea wxResult;
    private javax.swing.JTextField wxTitle;
    // 变量声明结束//GEN-END:variables
    
}