tsmanage.java

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

        roomCode.setBounds(360, 10, 100, 20);

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

        tsKind.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "治安", "卫生", "其他" }));
        tsKind.setEnabled(false);
        jPanel1.add(tsKind);
        tsKind.setBounds(70, 40, 70, 20);

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

        tsName.setEnabled(false);
        jPanel1.add(tsName);
        tsName.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("\u6295\u8bc9\u65f6\u95f4:");
        jPanel1.add(jLabel9);
        jLabel9.setBounds(10, 70, 60, 15);

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

        jLabel10.setText("\u63a5\u5f85\u4eba:");
        jPanel1.add(jLabel10);
        jLabel10.setBounds(160, 70, 42, 15);

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

        jLabel11.setText("\u6295\u8bc9\u5185\u5bb9:");
        jPanel1.add(jLabel11);
        jLabel11.setBounds(10, 100, 60, 15);

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

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

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

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

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

        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 将在此处添加您的处理代码：
        TSData.setRowCount(0);
	TSData.fireTableDataChanged();
        int key=kind.getSelectedIndex();
        String sql="";
        switch(key){
            case 0:sql="select * from tsInfo";break;
            case 1:sql="select * from tsInfo where tsKind=0";break;
            case 2:sql="select * from tsInfo where tsKind=1";break;
            case 3:sql="select * from tsInfo where tsKind=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("tsCode")).toString();
                data[1]=tsKind.getItemAt(rs.getInt("tsKind")).toString();
                data[2]=rs.getString("tsTitle");
                data[3]=rs.getString("roomCode");
                data[4]=rs.getString("tsName");
                data[5]=rs.getString("tsTime");
                data[6]=rs.getString("jdName");
                TSData.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(tsCode.getText()).intValue();
        int i=JOptionPane.showConfirmDialog(this,"删除提示","是否确认删除",JOptionPane.YES_NO_CANCEL_OPTION,JOptionPane.QUESTION_MESSAGE);
        if(i==JOptionPane.YES_OPTION){
            delete(key);
            TSData.setRowCount(0);
	    TSData.fireTableDataChanged();
            displayTable();
        }         
    }//GEN-LAST:event_deleteActionPerformed

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

    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();
                TSData.setRowCount(0);
	        TSData.fireTableDataChanged();
                displayTable();
                addFlag=false;
                
           }
           if(modifyFlag==true){            
                disabledTools();
                update();          
                modifyFlag=false; 
                TSData.setRowCount(0);
	        TSData.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();
        tsTime.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();
        tsCode.setText("自动编码");
        tsTime.setText(submitTime);
        tsTime.setEnabled(false);
        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 TSManage().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JTable TSTable;
    private javax.swing.JButton add;
    private javax.swing.JButton delete;
    private javax.swing.JButton dispose;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    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.JTextField jdName;
    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 tsCode;
    private javax.swing.JTextArea tsContent;
    private javax.swing.JComboBox tsKind;
    private javax.swing.JTextField tsName;
    private javax.swing.JTextArea tsResult;
    private javax.swing.JTextField tsTime;
    private javax.swing.JTextField tsTitle;
    // 变量声明结束//GEN-END:variables
    
}