renyuan1.java

毕业设计_物业管理系统

/*
 * renyuanxx.java
 *
 * Created on 2001年5月31日, 上午11:23
 */
package zc.face;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.io.*;
import java.sql.*;
/**
 *
 * @author  Administrator
 * @version 
 */
public class renyuan1 extends javax.swing.JFrame {
   
    /** Creates new form renyuanxx */
    public renyuan1() {
        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
        jPanel2 = new javax.swing.JPanel();
        jPanel4 = new javax.swing.JPanel();
        jLabel4 = new javax.swing.JLabel();
        jTextField4 = new javax.swing.JTextField();
        jLabel1 = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTextArea2 = new javax.swing.JTextArea();
        jPanel3 = new javax.swing.JPanel();
        jButton1 = new javax.swing.JButton();
        jButton3 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        setTitle("\u4eba\u5458\u4fe1\u606f\u67e5\u8be2\u754c\u97621");
        addWindowListener(new java.awt.event.WindowAdapter() {
            public void windowClosing(java.awt.event.WindowEvent evt) {
                exitForm(evt);
            }
        }
        );
        
        jPanel2.setLayout(new java.awt.BorderLayout());
        
        jPanel4.setLayout(new java.awt.GridBagLayout());
          java.awt.GridBagConstraints gridBagConstraints1;
          
          jLabel4.setText("\u59d3\u540d:");
            gridBagConstraints1 = new java.awt.GridBagConstraints();
            jPanel4.add(jLabel4, gridBagConstraints1);
            
            
          jTextField4.setPreferredSize(new java.awt.Dimension(80, 21));
            jTextField4.setColumns(10);
            jTextField4.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jTextField4ActionPerformed(evt);
                }
            }
            );
            gridBagConstraints1 = new java.awt.GridBagConstraints();
            jPanel4.add(jTextField4, gridBagConstraints1);
            
            jPanel2.add(jPanel4, java.awt.BorderLayout.CENTER);
          
          
        jLabel1.setText("\u8bf7\u8f93\u5165\u4e0b\u5217\u5185\u5bb9\u8fdb\u884c\u67e5\u8be2");
          jPanel2.add(jLabel1, java.awt.BorderLayout.NORTH);
          
          
        
          jTextArea2.setColumns(30);
            jTextArea2.setRows(7);
            jScrollPane1.setViewportView(jTextArea2);
            
            jPanel2.add(jScrollPane1, java.awt.BorderLayout.SOUTH);
          
          
        getContentPane().add(jPanel2, java.awt.BorderLayout.CENTER);
        
        
        
        jButton1.setText("\u67e5\u8be2");
          jButton1.addActionListener(new java.awt.event.ActionListener() {
              public void actionPerformed(java.awt.event.ActionEvent evt) {
                  jButton1ActionPerformed(evt);
              }
          }
          );
          jPanel3.add(jButton1);
          
          
        jButton3.setText("\u7ee7\u7eed\u67e5\u8be2");
          jButton3.addActionListener(new java.awt.event.ActionListener() {
              public void actionPerformed(java.awt.event.ActionEvent evt) {
                  jButton3ActionPerformed(evt);
              }
          }
          );
          jPanel3.add(jButton3);
          
          
        jButton2.setActionCommand("\u53d6\u6d88");
          jButton2.setText("\u53d6\u6d88");
          jButton2.addActionListener(new java.awt.event.ActionListener() {
              public void actionPerformed(java.awt.event.ActionEvent evt) {
                  jButton2ActionPerformed(evt);
              }
          }
          );
          jPanel3.add(jButton2);
          
          
        getContentPane().add(jPanel3, java.awt.BorderLayout.SOUTH);
        
    }//GEN-END:initComponents

  private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
      jTextField4.setText(" ");
      // Add your handling code here:
  }//GEN-LAST:event_jButton3ActionPerformed

  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
             try{
                  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          
              }
              catch(ClassNotFoundException ce){
                    ce.printStackTrace( );
                    jTextArea2.append("\n"+ce.toString( )+"\n");
              }
            try
            {
                
              if(!jTextField4.getText( ).equals(" "))
              {   
                  Connection con=DriverManager.getConnection("jdbc:odbc:houqin");
                  
                  jTextArea2.append("链接成功\n");
                  String query="select * from renyuan"+  " where 姓名='"+jTextField4.getText( )+"'";
                         
                  //进行数据库查询
                  jTextArea2.setText("SQL查询:\n"+query+"\n");
                  
           
                 Statement stmt=con.createStatement();
                 ResultSet rs=stmt.executeQuery(query);
                        
                  try
                  {
                     if(rs.next( ))
                     {
                          jTextArea2.append(rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4)+"\t"+rs.getString(5)+"\t"+rs.getString(6)+rs.getString(7)+"\t"+rs.getString(8)+"\t"+rs.getString(9)+"\n");
                          jTextArea2.append("查询成功\n");
                     }
                     else
                     {
                          jTextArea2.setText("找不到合乎条件的记录\n");
                          jTextArea2.append("查询失败");
                     }
                  }
                  catch(SQLException e3)
                  {
                        e3.printStackTrace( );
                        jTextArea2.append("\n"+e3.toString( )+"\n");
                  }
                 stmt.close();
                 con.close();
              }
              else 
                 jTextArea2.setText("请输入正确的姓名后按查询按钮");
            }
              catch(SQLException e){
                    
                  e.printStackTrace( );
                  jTextArea2.append("\n"+e.toString( )+"\n");
              }
       
  }//GEN-LAST:event_jButton1ActionPerformed
                                     
  private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jRadioButton1ActionPerformed
    
  }//GEN-LAST:event_jRadioButton1ActionPerformed

  private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
      zc.face.userInterface2 jf1=new zc.face.userInterface2();
      jf1.setVisible(true);
      setVisible(false);
      // Add your handling code here:
  }//GEN-LAST:event_jButton2ActionPerformed

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

    /** Exit the Application */
    private void exitForm(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_exitForm
        System.exit (0);
    }//GEN-LAST:event_exitForm

    /**
    * @param args the command line arguments
    */
    public static void main (String args[]) {
        new renyuan1().show ();
    }


    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JTextField jTextField4;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTextArea jTextArea2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton2;
    // End of variables declaration//GEN-END:variables

}