deleteuser.java

java+SQLServer2005编写的学生学籍管理系统

/*
 * deleteuser.java
 *
 * Created on 2007年11月6日, 下午4:38
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package studentsystem;

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

public class deleteuser extends JDialog {   
    Statement ps;
    ResultSet rs;
    Connection con;
    String url;
    JPanel panel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JTextField userF = new JTextField();
    JLabel jLabel2 = new JLabel();
    JButton sure = new JButton();
    JButton cancel = new JButton();
    JLabel jLabel4 = new JLabel();

    public deleteuser(Frame frame, String title, boolean modal) {
        super(frame, title, modal);
        try {
            jbInit();
            pack();
        }
        catch (Exception ex) {
            ex.printStackTrace();
        }
    }

     public deleteuser() {
         this(null, "", true);
     }

     private void jbInit() throws Exception {
         panel1.setLayout(null);
         this.getContentPane().setLayout(null);
         panel1.setBounds(new Rectangle(10, 10, 452, 369));
         jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));
         jLabel1.setText("请输入要删除的用户名");
         jLabel1.setBounds(new Rectangle(2, 17, 201, 35));
         userF.setText("");
         userF.setBounds(new Rectangle(13, 69, 221, 31));
         sure.setBounds(new Rectangle(12, 204, 90, 35));
         sure.setFont(new java.awt.Font("Dialog", 0, 15));
         sure.setText("确  定");
         sure.addActionListener(new deleteuser_sure_actionAdapter(this));
         cancel.setBounds(new Rectangle(132, 204, 90, 38));
         cancel.setFont(new java.awt.Font("Dialog", 0, 15));
         cancel.setText("取 消");
         cancel.addActionListener(new deleteuser_cancel_actionAdapter(this));
         this.setTitle("删除用户");
         getContentPane().add(panel1, null);
         panel1.add(jLabel1, null);
         panel1.add(sure, null);
         panel1.add(cancel, null);
         panel1.add(jLabel2, null);
         panel1.add(userF, null);
         panel1.add(jLabel4, null);
         this.setBounds(300, 300, 300, 300);
         this.setVisible(true);
     }

     void cancel_actionPerformed(ActionEvent e) {
         this.dispose();
     }
     
     void sure_actionPerformed(ActionEvent e) {
         if (userF.getText()!=null)  {
             JOptionPane.showConfirmDialog(null, "确定删除？", "删除用户所有信息", JOptionPane.YES_NO_OPTION);                                
             try {
                 try {  //数据库连接 
                     String name = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
                     String url ="jdbc:sqlserver://localhost:1433; DatabaseName=student";              
                     Class.forName(name);
                     Connection con = DriverManager.getConnection(url, "ss", "123");
                     ps = con.createStatement(ResultSet.
                     TYPE_SCROLL_INSENSITIVE,
                     ResultSet.CONCUR_READ_ONLY);
                 }
                 catch (Exception err) {
                     String error = err.getMessage();
                     JOptionPane.showMessageDialog(null, "连接数据库错误!");
                 }
                 try {
                     ps.executeUpdate("Delete from users where username = '" + userF.getText().trim() + "'" );                                     
                     ps.close();
                     JOptionPane.showMessageDialog(null, "删除成功");
                     this.dispose();
                 }
                 catch (SQLException sqle) {
                     String error = sqle.getMessage();
                     JOptionPane.showMessageDialog(null, error);
                     sqle.printStackTrace();
                 }
             }
            catch (Exception ex) {
                 ex.getMessage();
                 String error = ex.getMessage();
                 JOptionPane.showMessageDialog(null, error);
                 ex.printStackTrace();
            }
        }
    }
}

class deleteuser_cancel_actionAdapter implements java.awt.event.ActionListener {    
    deleteuser adaptee;
    deleteuser_cancel_actionAdapter(deleteuser adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.cancel_actionPerformed(e);
    }
}

class deleteuser_sure_actionAdapter implements java.awt.event.ActionListener {   
    deleteuser adaptee;
    deleteuser_sure_actionAdapter(deleteuser adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.sure_actionPerformed(e);
    }
}