administratorinterface.java

Java编写的物业管理系统

/*
 * AdministratorInterface.java
 *
 * Created on 2001年1月15日, 上午10:59
 */


package zc.face;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.io.*;
import java.sql.*;

/**
 *
 * @author  Administrator
 * @version 
 */
public class AdministratorInterface extends javax.swing.JFrame {

    /** Creates new form AdministratorInterface */
    public AdministratorInterface() {
        initComponents ();
        pack ();
    }

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the FormEditor.
     */
    private void initComponents() {//GEN-BEGIN:initComponents
        jMenuBar1 = new javax.swing.JMenuBar();
        jMenu3 = new javax.swing.JMenu();
        jMenuItem2 = new javax.swing.JMenuItem();
        jMenuItem3 = new javax.swing.JMenuItem();
        jMenuItem4 = new javax.swing.JMenuItem();
        jMenuItem16 = new javax.swing.JMenuItem();
        jMenu7 = new javax.swing.JMenu();
        jMenuItem12 = new javax.swing.JMenuItem();
        jMenuItem13 = new javax.swing.JMenuItem();
        jMenuItem14 = new javax.swing.JMenuItem();
        jMenuItem19 = new javax.swing.JMenuItem();
        jMenu6 = new javax.swing.JMenu();
        jMenuItem8 = new javax.swing.JMenuItem();
        jMenuItem9 = new javax.swing.JMenuItem();
        jMenuItem10 = new javax.swing.JMenuItem();
        jMenuItem18 = new javax.swing.JMenuItem();
        jMenu5 = new javax.swing.JMenu();
        jMenuItem5 = new javax.swing.JMenuItem();
        jMenuItem6 = new javax.swing.JMenuItem();
        jMenuItem7 = new javax.swing.JMenuItem();
        jMenuItem17 = new javax.swing.JMenuItem();
        jMenu2 = new javax.swing.JMenu();
        jMenuItem11 = new javax.swing.JMenuItem();
        jMenu1 = new javax.swing.JMenu();
        jMenuItem1 = new javax.swing.JMenuItem();
        jScrollPane6 = new javax.swing.JScrollPane();
        jTextArea4 = new javax.swing.JTextArea();
        
        jMenu3.setActionCommand("\u4eba\u5458\u4fe1\u606f");
          jMenu3.setText("\u4eba\u5458\u7ba1\u7406");
          jMenu3.addActionListener(new java.awt.event.ActionListener() {
              public void actionPerformed(java.awt.event.ActionEvent evt) {
                  jMenu3ActionPerformed(evt);
              }
          }
          );
          
          jMenuItem2.setText("\u6dfb\u52a0");
            jMenuItem2.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem2ActionPerformed(evt);
                }
            }
            );
            jMenu3.add(jMenuItem2);
            
          jMenuItem3.setActionCommand("\u66f4\u65b0");
            jMenuItem3.setText("\u66f4\u65b0");
            jMenuItem3.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem3ActionPerformed(evt);
                }
            }
            );
            jMenu3.add(jMenuItem3);
            
          jMenuItem4.setText("\u5220\u9664");
            jMenuItem4.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem4ActionPerformed(evt);
                }
            }
            );
            jMenu3.add(jMenuItem4);
            
          jMenuItem16.setText("\u67e5\u8be2");
            jMenuItem16.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem16ActionPerformed(evt);
                }
            }
            );
            jMenu3.add(jMenuItem16);
            jMenuBar1.add(jMenu3);
          
        jMenu7.setLabel("\u4f4f\u623f\u4fe1\u606f\u7ba1\u7406");
          jMenu7.setText("\u4f4f\u623f\u7ba1\u7406");
          jMenu7.addActionListener(new java.awt.event.ActionListener() {
              public void actionPerformed(java.awt.event.ActionEvent evt) {
                  jMenu7ActionPerformed(evt);
              }
          }
          );
          
          jMenuItem12.setText("\u6dfb\u52a0");
            jMenuItem12.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem12ActionPerformed(evt);
                }
            }
            );
            jMenu7.add(jMenuItem12);
            
          jMenuItem13.setText("\u66f4\u65b0");
            jMenuItem13.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem13ActionPerformed(evt);
                }
            }
            );
            jMenu7.add(jMenuItem13);
            
          jMenuItem14.setText("\u5220\u9664");
            jMenuItem14.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem14ActionPerformed(evt);
                }
            }
            );
            jMenu7.add(jMenuItem14);
            
          jMenuItem19.setText("\u67e5\u8be2");
            jMenuItem19.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem19ActionPerformed(evt);
                }
            }
            );
            jMenu7.add(jMenuItem19);
            jMenuBar1.add(jMenu7);
          
        jMenu6.setText("\u6536\u8d39\u7ba1\u7406");
          jMenu6.addActionListener(new java.awt.event.ActionListener() {
              public void actionPerformed(java.awt.event.ActionEvent evt) {
                  jMenu6ActionPerformed(evt);
              }
          }
          );
          
          jMenuItem8.setText("\u6dfb\u52a0");
            jMenuItem8.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem8ActionPerformed(evt);
                }
            }
            );
            jMenu6.add(jMenuItem8);
            
          jMenuItem9.setText("\u66f4\u65b0");
            jMenuItem9.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem9ActionPerformed(evt);
                }
            }
            );
            jMenu6.add(jMenuItem9);
            
          jMenuItem10.setText("\u5220\u9664");
            jMenuItem10.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem10ActionPerformed(evt);
                }
            }
            );
            jMenu6.add(jMenuItem10);
            
          jMenuItem18.setText("\u67e5\u8be2");
            jMenuItem18.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem18ActionPerformed(evt);
                }
            }
            );
            jMenu6.add(jMenuItem18);
            jMenuBar1.add(jMenu6);
          
        jMenu5.setText("\u623f\u4ea7\u7ba1\u7406");
          jMenu5.addActionListener(new java.awt.event.ActionListener() {
              public void actionPerformed(java.awt.event.ActionEvent evt) {
                  jMenu5ActionPerformed(evt);
              }
          }
          );
          
          jMenuItem5.setText("\u6dfb\u52a0");
            jMenuItem5.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem5ActionPerformed(evt);
                }
            }
            );
            jMenu5.add(jMenuItem5);
            
          jMenuItem6.setText("\u66f4\u65b0");
            jMenuItem6.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem6ActionPerformed(evt);
                }
            }
            );
            jMenu5.add(jMenuItem6);
            
          jMenuItem7.setText("\u5220\u9664");
            jMenuItem7.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem7ActionPerformed(evt);
                }
            }
            );
            jMenu5.add(jMenuItem7);
            
          jMenuItem17.setText("\u67e5\u8be2");
            jMenuItem17.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem17ActionPerformed(evt);
                }
            }
            );
            jMenu5.add(jMenuItem17);
            jMenuBar1.add(jMenu5);
          
        jMenu2.setText("\u5e2e\u52a9");
          jMenu2.addActionListener(new java.awt.event.ActionListener() {
              public void actionPerformed(java.awt.event.ActionEvent evt) {
                  jMenu2ActionPerformed(evt);
              }
          }
          );
          
          jMenuItem11.setText("\u5e2e\u52a9");
            jMenuItem11.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem11ActionPerformed(evt);
                }
            }
            );
            jMenu2.add(jMenuItem11);
            jMenuBar1.add(jMenu2);
          
        jMenu1.setText("\u8fd4\u56de");
          jMenu1.addActionListener(new java.awt.event.ActionListener() {
              public void actionPerformed(java.awt.event.ActionEvent evt) {
                  jMenu1ActionPerformed(evt);
              }
          }
          );
          
          jMenuItem1.setText("\u8fd4\u56de");
            jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jMenuItem1ActionPerformed(evt);
                }
            }
            );
            jMenu1.add(jMenuItem1);
            jMenuBar1.add(jMenu1);
          getContentPane().setLayout(new java.awt.FlowLayout());
        setTitle("\u7ba1\u7406\u5458\u754c\u9762");
        addWindowListener(new java.awt.event.WindowAdapter() {
            public void windowClosing(java.awt.event.WindowEvent evt) {
                exitForm(evt);
            }
        }
        );
        
        
        jTextArea4.setColumns(30);
          jTextArea4.setRows(10);
          jScrollPane6.setViewportView(jTextArea4);
          
          
        getContentPane().add(jScrollPane6);
        
        setJMenuBar(jMenuBar1);
        
    }//GEN-END:initComponents

  private void jMenuItem11ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem11ActionPerformed
      String s="                            欢迎进入管理系统                      \n"+
               "     管理员在这里可以查询和修改关于人员，住房，收费和房产方面的信息，\n"+
               "系统功能使用说明如下：\n"+
               "     1。管理员有查询和修改两种权限，可从菜单选择所需的权限。\n"+
               "     2。管理系统主要有人员管理，住房管理，收费管理，房产管理，帮助和\n"+
               "返回六大主要菜单。管理员可根据所需功能进行选择。\n"+
               "     3。人员，住房，收费和房产菜单下的查询功能是直接在对话框内输入\n"+
               "select查询语句按确定按钮进行查询。\n"+
               "     4。人员，住房，收费和房产菜单下的插入，修改和删除功能管理员要\n"+
               "注意正确使用，并注意维护数据库中数据的一致。\n"+
               "     5。查询结果和修改结果都在输出框内显示。\n"+
               "     6。用户可通过帮助菜单选择帮助项得到有关管理系统使用的说明。\n";
      jTextArea4.setText(s);
      // Add your handling code here:
  }//GEN-LAST:event_jMenuItem11ActionPerformed

  private void jMenu2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu2ActionPerformed
// Add your handling code here:
  }//GEN-LAST:event_jMenu2ActionPerformed

  private void jMenuItem18ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem18ActionPerformed
      String input=null;
      javax.swing.JFrame f=new javax.swing.JFrame();
      input=javax.swing.JOptionPane.showInputDialog(f,"请输入sql查询语句","Input",javax.swing.JOptionPane.QUESTION_MESSAGE);
      //int returnValue=javax.swing.JOptionPane.CANCEL_OPTION;
      System.out.println("数据查询.........");
      if((input!=null)&&(input.length()!=0)){
              System.out.println(input);
              //进行数据库查询
              try{
                  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
              }
              catch(ClassNotFoundException ce){
                    System.out.println("SQLException:"+ce.getMessage());
              }
             try{
                 Connection con=DriverManager.getConnection("jdbc:odbc:houqin");
                 Statement stmt=con.createStatement();
                 ResultSet rs=stmt.executeQuery(input);
                // System.out.println(zc.face.MySqlUnit.printMetaData(rs));
                 System.out.println(zc.face.MySqlUnit.printResultSet(rs));
                 stmt.close();
                 con.close();
              }
              catch(SQLException e){
                     System.out.println("SQLException:"+e.getMessage());
              }
             catch(IOException e2){
                     System.out.println("IOException:"+e2.getMessage());
              }
      }
  

           
      else 
          System.out.println("输入正确的sql查询语句.");
      // Add your handling code here:
  }//GEN-LAST:event_jMenuItem18ActionPerformed

  private void jMenuItem9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem9ActionPerformed
      String input=null;
      javax.swing.JFrame f=new javax.swing.JFrame();