frame_card_delete.java

学生上机系统,请大家多多指教.以后会发

package student_computer;

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

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class Frame_card_delete extends JFrame {
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();

  public Frame_card_delete() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 32));
    jLabel1.setText("用户注销");
    jLabel1.setBounds(new Rectangle(163, 24, 155, 69));
    this.getContentPane().setLayout(null);
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel2.setText("学号：");
    jLabel2.setBounds(new Rectangle(92, 123, 76, 34));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(177, 122, 129, 33));
    jButton1.setBounds(new Rectangle(81, 225, 111, 31));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton1.setText("注销");
    jButton1.addActionListener(new Frame_card_delete_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(229, 225, 111, 31));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton2.setText("取消");
    jButton2.addActionListener(new Frame_card_delete_jButton2_actionAdapter(this));
    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(jTextField1, null);
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jButton2, null);
    this.setSize(400,320);
    this.setLocation(250,190);
  }
////////////注销用户
  void jButton1_actionPerformed(ActionEvent e) {
    String id=jTextField1.getText().trim();
    if(id.equals(""))
    {
      JOptionPane.showMessageDialog(this,"请输入学号!!!","提示",JOptionPane.PLAIN_MESSAGE);
      return;
    }
    try{
      String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
       String dbURL = "jdbc:microsoft:sqlserver://210.30.104.11:1433; DatabaseName=student_computer";
        String userName = "xueli";
       String userPwd = "gejingguo";

       Class.forName(driverName);
       Connection con = DriverManager.getConnection(dbURL, userName, userPwd);

        //System.out.println(apartid+dom_id+date);
        PreparedStatement stmt=con.prepareStatement("delete from student where student_number=?");
        stmt.setString(1,id);
        PreparedStatement stmt1=con.prepareStatement("delete from card where student_number=?");
        stmt1.setString(1,id);
        int a=stmt.executeUpdate();
        int b=stmt1.executeUpdate();
        if(a!=0&&b!=0)
        {
          JOptionPane.showMessageDialog(this,"注销成功!!!","提示",JOptionPane.PLAIN_MESSAGE);
      return;
        }
        else
        {
          JOptionPane.showMessageDialog(this,"注销失败,请确认有该学生记录!!!","提示",JOptionPane.PLAIN_MESSAGE);
      return;
        }

    }catch(Exception e3)
        {
        JOptionPane.showMessageDialog(this,"注销失败,请确认有该学生记录!!!","提示",JOptionPane.PLAIN_MESSAGE);
      return;
    }
  }

  void jButton2_actionPerformed(ActionEvent e) {
   this.show(false);
  }
}

class Frame_card_delete_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame_card_delete adaptee;

  Frame_card_delete_jButton1_actionAdapter(Frame_card_delete adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Frame_card_delete_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Frame_card_delete adaptee;

  Frame_card_delete_jButton2_actionAdapter(Frame_card_delete adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}