adduser.java

java编辑的学籍管理系统

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

public class AddUser
    extends JFrame
    implements ActionListener {
  Label label1 = new Label();
  TextField textField1 = new TextField();
  Label label2 = new Label();
  Label label3 = new Label();
  JPasswordField pass1 = new JPasswordField();
  JPasswordField pass2 = new JPasswordField();
  
  Button button1 = new Button();
  Button button2 = new Button();

  public AddUser() {
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    label1.setText("用户名:");
    label1.setBounds(new Rectangle(30, 11, 51, 33));
    this.getContentPane().setLayout(null);
    textField1.setText("");
    textField1.setBounds(new Rectangle(86, 16, 74, 22));
    label2.setBounds(new Rectangle(31, 53, 49, 33));
    label2.setText("密码:");
    pass1.setText("");
    pass1.setBounds(new Rectangle(86, 58, 74, 22));
    label3.setText("重复密码:");
    pass2.setText(""); 
    label3.setBounds(new Rectangle(15, 94, 70, 40));
    pass2.setBounds(new Rectangle(86, 98, 75, 25));
    
    this.setDefaultCloseOperation(HIDE_ON_CLOSE);
    this.setEnabled(true);
    this.setResizable(false);
    this.setTitle("增加用户信息");
    
    button1.setLabel("增加");
    button1.setVisible(true);
    button1.setBounds(new Rectangle(36, 144, 69, 22));
    button1.addActionListener(this);
    button2.setLabel("取消");
    button2.setVisible(true);
    button2.setBounds(new Rectangle(106, 144, 69, 22));
    button2.addActionListener(this);
    this.getContentPane().add(label3, null);
    this.getContentPane().add(label2, null);
    this.getContentPane().add(label1, null);
    this.getContentPane().add(textField1, null);
    this.getContentPane().add(pass2,null);
    this.getContentPane().add(pass1,null);

    this.getContentPane().add(button1, null);
    this.getContentPane().add(button2, null);
    
    this.setSize(300,240);
    this.setLocation(300,200);
    //this.setVisible(true);
    
  }

  public void actionPerformed(ActionEvent e) {
    if (e.getSource()==button1)
    {
    	try {
      String strurl =
          "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/student.mdb";
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection conn = DriverManager.getConnection(strurl);
      Statement stmt = conn.createStatement();
      if(pass2.getText().equals(pass1.getText())){
      ResultSet rs = stmt.executeQuery("select username from admin where username='" +
                                       textField1.getText() + "'");
      if (rs.next()) {
        JOptionPane.showMessageDialog(null, "此用户已经被注册.", "警告",
                                      JOptionPane.WARNING_MESSAGE);
        return;
      }
      stmt.execute(
          "insert into admin (username,password) values ('" +
          textField1.getText() + "','" + pass1.getText() + "')");
      textField1.setText("");
      pass1.setText("");
      pass2.setText("");
      JOptionPane.showMessageDialog(null, "增加用户成功!");
    }
    else { 
    JOptionPane.showMessageDialog(null, "重复密码不正确!");
    pass1.setText("");
    pass2.setText("");
     }
   }
    catch (Exception eg) {
      JOptionPane.showMessageDialog(null, "请认真检查各项(不能为空).", "异常警告",
                                    JOptionPane.WARNING_MESSAGE);
      eg.printStackTrace();
    }
   }
   else if(e.getSource()==button2) System.exit(0);
  }

}