frame5.java~35~

一个简单的学生注册系统 包括学生基本信息和是否缴费等功能

package 学生简易注册管理系统;

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

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author privle
 * @version 1.0
 */

public class Frame5 extends JFrame {
  JPanel contentPane;
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JPanel jPanel1 = new JPanel();
  JTextField jTextField1 = new JTextField();
  JPasswordField jPasswordField1 = new JPasswordField();
  JPasswordField jPasswordField2 = new JPasswordField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JOptionPane jOptionPane1=new JOptionPane();
  JTextArea jTextArea1 = new JTextArea();
  boolean flag=false;

  //Construct the frame
  public Frame5() {
    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, 30));
    jLabel1.setText("欢迎使用注册系统");
    jLabel1.setBounds(new Rectangle(124, 18, 254, 59));
    contentPane.setLayout(null);
    this.setSize(new Dimension(523, 417));
    this.setTitle("Frame Title");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel2.setText("用户名");
    jLabel2.setBounds(new Rectangle(92, 122, 69, 32));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel3.setText("密码");
    jLabel3.setBounds(new Rectangle(91, 173, 73, 28));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel4.setText("确认密码");
    jLabel4.setBounds(new Rectangle(93, 218, 72, 29));
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel5.setText("备注");
    jLabel5.setBounds(new Rectangle(91, 273, 67, 28));
    jPanel1.setBounds(new Rectangle(154, 106, 242, 204));
    jPanel1.setLayout(null);
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(35, 22, 114, 26));
    jPasswordField1.setText("");
    jPasswordField1.setBounds(new Rectangle(36, 66, 113, 26));
    jPasswordField2.setBounds(new Rectangle(37, 113, 111, 28));
    jButton1.setBounds(new Rectangle(218, 341, 74, 27));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 12));
    jButton1.setText("注册");
    jButton1.addActionListener(new Frame5_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(339, 340, 77, 29));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 12));
    jButton2.setText("返回");
    jButton2.addActionListener(new Frame5_jButton2_actionAdapter(this));
    jTextArea1.setBounds(new Rectangle(34, 161, 129, 45));
    contentPane.add(jLabel1, null);
    jPanel1.add(jTextField1, null);
    jPanel1.add(jPasswordField1, null);
    jPanel1.add(jPasswordField2, null);
    jPanel1.add(jTextArea1, null);
    contentPane.add(jLabel2, null);
    contentPane.add(jLabel3, null);
    contentPane.add(jLabel4, null);
    contentPane.add(jLabel5, null);
    contentPane.add(jButton2, null);
    contentPane.add(jButton1, null);
    contentPane.add(jPanel1, null);
  }
  //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) {
    try {
      String url = "jdbc:odbc:account";
      String user = "";
      String password = "";
      String sql;
      String sql_1;
      sql = "select * from account where user='" + jTextField1.getText() + "'";
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      sql_1 = "insert into account(user,password) values('" +
          jTextField1.getText() + "','" +
          jPasswordField2.getText() + "')";
      Connection con = DriverManager.getConnection(url, user, password);
      Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                           ResultSet.CONCUR_READ_ONLY);
      ResultSet rs = stmt.executeQuery(sql);
      if (rs.next()) {
        flag = true;
      }
      else{
        flag=false;
      }
      if (flag) {
        jOptionPane1.showMessageDialog(null, "用户以存在");
      }
      else {
        if (jTextField1.getText().equals(null))
            jOptionPane1.showMessageDialog(null, "用户名不能为空");
          else
           {
          if (jPasswordField1.getText().equals(jPasswordField2.getText())) {
            stmt.executeUpdate(sql_1);
            jOptionPane1.showMessageDialog(null, "注册成功");
          }
          else
            jOptionPane1.showMessageDialog(null, "确认密码有误，请重新输入");
        }
        }

      }


             catch (SQLException sqle) {
               sqle.printStackTrace();
           }
             catch (Exception sql) {
               System.out.println(1 + sql.toString());
      }
    }

  void jButton2_actionPerformed(ActionEvent e) {
      new Application4();
      this.hide();
  }
}

class Frame5_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame5 adaptee;

  Frame5_jButton1_actionAdapter(Frame5 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Frame5_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Frame5 adaptee;

  Frame5_jButton2_actionAdapter(Frame5 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}