deluser.java

java编辑的学籍管理系统

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


public class DelUser
    extends JFrame
    implements ActionListener {
  String strurl;
  Connection conn;
  Statement stmt;
  ResultSet rs;
  Label label1 = new Label();
  TextField textField1 = new TextField();
  Label label2 = new Label();
  TextField textField2 = new TextField();
  Button button1 = new Button();
  TextField textField6 = new TextField();
  Button button2 = new Button();
  Label label10 = new Label();

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

  private void jbInit() throws Exception {
    label1.setText("用户名:");
    label1.setVisible(false);
    label1.setBounds(new Rectangle(30, 11, 51, 33));
    this.getContentPane().setLayout(null);
    textField1.setText("");
    textField1.setVisible(false);
    textField1.setBounds(new Rectangle(86, 16, 74, 22));
    label2.setBounds(new Rectangle(162, 11, 28, 33));
    label2.setText("密码:");
    label2.setVisible(false);
    textField2.setText("");
    textField2.setVisible(false);
    textField2.setBounds(new Rectangle(192, 16, 44, 22));
    
    button1.setLabel("删除");
    button1.setVisible(false);
    button1.setBounds(new Rectangle(80, 81, 94, 22));
    button1.addActionListener(this);
    textField6.setText("");
    textField6.setBounds(new Rectangle(85, 92, 105, 23));
    button2.setFont(new java.awt.Font("Dialog", 1, 15));
    button2.setLabel("下一步");
    button2.setVisible(true);
    button2.setBounds(new Rectangle(95, 148, 89, 23));
    button2.addActionListener(this);
    label10.setFont(new java.awt.Font("Dialog", 1, 15));
    label10.setText("请输入要删除的用户名");
    label10.setBounds(new Rectangle(70, 49, 178, 24));

    this.getContentPane().add(label1, null);
    this.getContentPane().add(textField1, null);
    this.getContentPane().add(label2, null);
    this.getContentPane().add(textField2, null);
    this.getContentPane().add(label10, null);
    this.getContentPane().add(textField6, null);
    this.getContentPane().add(button1, null);
    this.getContentPane().add(button2, null);
          this.setSize(300,240);
     	  this.setLocation(300,200);
    	  this.setVisible(true);
    	  this.setTitle("删除用户信息");

    strurl =
        "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/student.mdb";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    conn = DriverManager.getConnection(strurl);
    stmt = conn.createStatement();
    
  }

  public void actionPerformed(ActionEvent e) {
    if (e.getSource() == button2) {
      try {
        rs = stmt.executeQuery("SELECT * FROM admin where username='" +
                               textField6.getText() + "'");
        if (rs.next()) {
          textField6.setVisible(false);
          button2.setVisible(false);
          label1.setVisible(true);
          label2.setVisible(true);
          textField1.enable(false);
          textField1.setVisible(true);
          textField1.setText(rs.getString("username"));
          textField2.setVisible(true);
          textField2.setText(rs.getString("password"));
          textField2.enable(false);
          button1.setVisible(true);
          label10.setVisible(false);

        }
        else
          JOptionPane.showMessageDialog(null, "无此用户对应信息", "警告",
                                        JOptionPane.WARNING_MESSAGE);
      }
      catch (Exception eg) {
        eg.printStackTrace();
      }
    }
    else if (e.getSource() == button1) {
      try {
        if (JOptionPane.showConfirmDialog(this, "确实要删除该用户信息吗?\n删除的信息将不能恢复,继续?",
                                          "删除确定", JOptionPane.OK_CANCEL_OPTION,
                                          JOptionPane.QUESTION_MESSAGE) == 0) {
          stmt.execute("DELETE * FROM admin where username='" + textField1.getText() +
                       "'");
          JOptionPane.showMessageDialog(null, "删除信息成功!");
          this.setVisible(false);
          this.dispose();
        }
      }
      catch (Exception eg) {
        eg.printStackTrace();
      }
    }
  }
  
}