frame1.java~1~

学生宿舍管理信息系统,大家快来看看,看有什么错误,对你学JAVA有好处的

package studentinfo;
import java.lang.*;
import java.lang.Object.*;
import java.sql.*;
import java.util.*;
import javax.swing.event.*;
import javax.swing.table.*;



import java.awt.*;
import java.awt.event.*;
import javax.swing.*;


/**
 * <p>Title: StudentINFO</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author 杨一宁
 * @version 1.0
 */


public class Frame1 extends JFrame {
  JPanel contentPane;
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JTextField jTextField2 = new JTextField();
  JTextField jTextField3 = new JTextField();
  JTextField jTextField4 = new JTextField();

  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();


  Vector vector;                                         // 声明一个向量对象
  String title[] = {"学号","姓名","所属学院","所属班级"};    // 二维表列名
  Connection connection = null;                           // 声明Connection接口对象connection
  ResultSet rSet = null;                                  // 定义数据库查询的结果集
  Statement statement = null;                             // 定义查询数据库的Statement对象
  AbstractTableModel tm;
  JMenuBar jMenuBar1 = new JMenuBar();
  JMenu jMenu1 = new JMenu();
  JMenu jMenuhelp = new JMenu();
  JMenuItem jMenuabout = new JMenuItem();
  JMenuItem jMenuexit = new JMenuItem();                                  // 声明一个AbstractTableModel类对象tm


  //Construct the frame
  public Frame1() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  //Component initialization
  private void jbInit() throws Exception  {
    contentPane = (JPanel) this.getContentPane();
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel1.setForeground(Color.black);
    jLabel1.setDebugGraphicsOptions(0);
    jLabel1.setToolTipText("");
    jLabel1.setVerifyInputWhenFocusTarget(true);
    jLabel1.setText("学号");
    jLabel1.setBounds(new Rectangle(40, 75, 47, 23));
    contentPane.setLayout(null);
    this.setSize(new Dimension(400, 300));
    this.setTitle("学生基本信息表");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel2.setToolTipText("");
    jLabel2.setText("姓名");
    jLabel2.setBounds(new Rectangle(39, 118, 56, 25));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel3.setToolTipText("");
    jLabel3.setText("所属学院");
    jLabel3.setBounds(new Rectangle(38, 155, 63, 27));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel4.setText("所属班级");
    jLabel4.setBounds(new Rectangle(39, 195, 71, 29));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(106, 77, 91, 23));
    jTextField2.setText("");
    jTextField2.setBounds(new Rectangle(107, 120, 89, 24));
    jTextField3.setText("");
    jTextField3.setBounds(new Rectangle(108, 161, 88, 25));
    jTextField4.setText("");
    jTextField4.setBounds(new Rectangle(107, 201, 91, 26));


    jButton1.setBounds(new Rectangle(252, 73, 73, 25));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton1.setToolTipText("");
    jButton1.setText("添加");
    jButton2.setBounds(new Rectangle(252, 117, 74, 28));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton2.setVerifyInputWhenFocusTarget(true);
    jButton2.setText("更新");
    jButton2.addActionListener(new Frame1_jButton2_actionAdapter(this));
    jButton3.setBounds(new Rectangle(252, 162, 75, 28));
    jButton3.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton3.setToolTipText("");
    jButton3.setText("删除");
    jButton4.setBounds(new Rectangle(254, 204, 73, 30));
    jButton4.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton4.setToolTipText("");
    jButton4.setText("取消");
    jButton4.addActionListener(new Frame1_jButton4_actionAdapter(this));

    jMenu1.setActionCommand("文件");
    jMenu1.setText("文件");
    jMenuhelp.setAction(null);
    jMenuhelp.setActionCommand("帮助");
    jMenuhelp.setText("帮助");
    jMenuabout.setNextFocusableComponent(null);
    jMenuabout.setPreferredSize(new Dimension(55, 21));
    jMenuabout.setToolTipText("");
    jMenuabout.setActionCommand("关于");
    jMenuabout.setSelected(false);
    jMenuabout.setText("关于");
    jMenuabout.addActionListener(new Frame1_jMenuabout_ActionAdapter(this));
    jMenuexit.setActionCommand("退出");
    jMenuexit.setText("退出");
    contentPane.add(jLabel1, null);
    contentPane.add(jLabel2, null);
    contentPane.add(jLabel3, null);
    contentPane.add(jLabel4, null);
    contentPane.add(jTextField1, null);
    contentPane.add(jTextField2, null);
    contentPane.add(jTextField3, null);
    contentPane.add(jTextField4, null);
    contentPane.add(jButton1, null);
    contentPane.add(jButton2, null);
    contentPane.add(jButton3, null);
    contentPane.add(jButton4, null);
    jMenuBar1.add(jMenu1);
    jMenu1.addSeparator();
    jMenu1.add(jMenuexit);
    jMenuBar1.add(jMenuhelp);
    jMenuhelp.add(jMenuabout);
    this.setJMenuBar(jMenuBar1);
  }

  //File | Exit action performed
 public void jMenuexit_ActionPerformed(ActionEvent e) {
   System.exit(0);
 }

 //Help | About action performed
 public void jMenuabout_ActionPerformed(ActionEvent e) {
   Frame1_AboutBox dlg = new Frame1_AboutBox(this);
   Dimension dlgSize = dlg.getPreferredSize();
   Dimension frmSize = getSize();
   Point loc = getLocation();
   dlg.setLocation( (frmSize.width - dlgSize.width) / 2 + loc.x,
                   (frmSize.height - dlgSize.height) / 2 + loc.y);
   dlg.setModal(true);
   dlg.pack();
   dlg.show();
 }

 class Frame1_jMenuabout_ActionAdapter
     implements ActionListener {
   Frame1 adaptee;

   Frame1_jMenuabout_ActionAdapter(Frame1 adaptee) {
     this.adaptee = adaptee;
   }

   public void actionPerformed(ActionEvent e) {
     adaptee.jMenuabout_ActionPerformed(e);
   }

 }




  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      System.exit(0);
    }
  }
  void jButton1_actionPerformed(ActionEvent e) { // 处理添加按钮的ActionEvent
      try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  // 实例化JDBC-ODBC桥的驱动
        connection = DriverManager.getConnection("jdbc:odbc:local","sa","hunterd");  // 连接数据库
        // 创建Statement接口对象
        Statement statement = connection.createStatement();
        statement.executeUpdate("insert * into stu_info  values ('" + jTextField1.getText() +"','" + jTextField2.getText()+"','" +jTextField3.getText()+"','"+jTextField4.getText()+ "')");             // 执行增加新的数据记录语句，向stu_info 表中添加记录

        // 清空信息框
        jTextField1.setText("");
        jTextField2.setText("");
        jTextField3.setText("");
        jTextField4.setText("");
      }
      catch(SQLException ex){                      // 捕捉异常
        System.out.println("\nERROR:----- SQLException -----\n");
        while (ex != null) {
          System.out.println("Message:   " + ex.getMessage());
          System.out.println("SQLState:  " + ex.getSQLState());
          System.out.println("ErrorCode: " + ex.getErrorCode());
          ex = ex.getNextException();
        }
      }
      catch(Exception ex ) {
        ex.printStackTrace();
      }
      finally {
        try {
          if(statement != null) {
            statement.close();                                // 关闭Statement接口实例
          }
          if(connection != null) {
            connection.close();                               // 关闭Connection接口实例
          }
        }
        catch (SQLException ex)  {
          System.out.println("\nERROR:----- SQLException -----\n");
          System.out.println("Message:   " + ex.getMessage( ));
          System.out.println("SQLState:  " + ex.getSQLState());
          System.out.println("ErrorCode: " + ex.getErrorCode());
        }
      }
    }

   void  jButton3_actionPerformed(ActionEvent e) {// 处理删除按钮的ActionEvent
      try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  // 实例化JDBC-ODBC桥的驱动
        connection = DriverManager.getConnection("jdbc:odbc:local","sa","hunterd");  // 连接数据库
        // 创建Statement接口对象
        Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
        rSet = statement.executeQuery("select 学号 from stu_info ");
        if (rSet.next()==true){                       // 判断数据库中是否有要删除的记录，如没有则显示提示框
           statement.executeUpdate("delete from stu_info where 学号='"+jTextField1.getText()+"'");             // 删除stu_info表中对应学号的数据记录
        }
        else {
          JOptionPane msg = new JOptionPane();
         JOptionPane.showMessageDialog(Frame1.this, "数据库中没有您删除的学号", "数据库中没有您删除的学号！", 1);


          // 清空信息框
          jTextField1.setText("");
          jTextField2.setText("");
          jTextField3.setText("");
          jTextField4.setText("");

        }
      }
          catch(SQLException ex){                        // 捕捉异常
        System.out.println("\nERROR:----- SQLException -----\n");
        while (ex != null) {
          System.out.println("Message:   " + ex.getMessage());
          System.out.println("SQLState:  " + ex.getSQLState());
          System.out.println("ErrorCode: " + ex.getErrorCode());
          ex = ex.getNextException();
        }
      }
      catch(Exception ex ) {
        ex.printStackTrace();
      }
      finally {
        try {
          if(statement != null) {
            statement.close();                                // 关闭Statement接口实例
          }
          if(connection != null) {
            connection.close();                               // 关闭Connection接口实例
          }
        }
        catch (SQLException ex)  {
          System.out.println("\nERROR:----- SQLException -----\n");
          System.out.println("Message:   " + ex.getMessage( ));
          System.out.println("SQLState:  " + ex.getSQLState());
          System.out.println("ErrorCode: " + ex.getErrorCode());
        }
      }
    }



  void jButton4_actionPerformed(ActionEvent e) {
    jTextField1.setText("");
    jTextField2.setText("");
    jTextField3.setText("");
    jTextField4.setText("");
  }

  void jButton2_actionPerformed(ActionEvent e) { // 处理jButton2(修改按钮)的ActionEvent
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  // 实例化JDBC-ODBC桥的驱动
      connection = DriverManager.getConnection("jdbc:odbc:local","sa","hunterd");  // 连接数据库
      // 创建Statement接口对象
      statement = connection.createStatement();
      statement.executeUpdate("insert  into stu_info  values ('" + jTextField1.getText() +"','" + jTextField2.getText()+"','" +jTextField3.getText()+"','"+jTextField4.getText()+ "')");             // 更新stu_info表中输入学号的记录

      // 清空信息框
      jTextField1.setText("");
      jTextField2.setText("");
      jTextField3.setText("");
      jTextField4.setText("");
    }
    catch(SQLException ex){                        // 捕捉异常
      System.out.println("\nERROR:----- SQLException -----\n");
      while (ex != null) {
        System.out.println("Message:   " + ex.getMessage());
        System.out.println("SQLState:  " + ex.getSQLState());
        System.out.println("ErrorCode: " + ex.getErrorCode());
        ex = ex.getNextException();
      }
    }
    catch(Exception ex ) {
      ex.printStackTrace();
    }
    finally {
      try {
        if(statement != null) {
          statement.close();                                // 关闭Statement接口实例
        }
        if(connection != null) {
          connection.close();                               // 关闭Connection接口实例
        }
      }
      catch (SQLException ex)  {
        System.out.println("\nERROR:----- SQLException -----\n");
        System.out.println("Message:   " + ex.getMessage( ));
        System.out.println("SQLState:  " + ex.getSQLState());
        System.out.println("ErrorCode: " + ex.getErrorCode());
      }
    }

  }
}

class Frame1_jButton4_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton4_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class Frame1_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton2_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}
class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton1_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}
class Frame1_jButton3_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton3_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}