frame5.java~11~

大二做的实训. 纯Java程序

package bookmanagesystem;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import java.awt.Color;
import javax.swing.JButton;
import java.awt.Rectangle;
import javax.swing.JLabel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import java.sql.SQLException;
import java.awt.Font;
import java.awt.event.MouseEvent;
import java.awt.event.MouseMotionAdapter;
import java.awt.event.MouseAdapter;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frame5 extends JFrame {
    JLabel jLabel2 = new JLabel();
    JButton jButton1 = new JButton();
    JLabel jLabel1 = new JLabel();
    JButton jButton2 = new JButton();
    JPasswordField jPasswordField1 = new JPasswordField();
    JLabel jLabel3 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    public Frame5() {
        try {
            setBounds(300,250,400,300);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.getContentPane().setBackground(new Color(0, 66, 92));
        this.setResizable(false);
        this.setTitle("删除用户");
        this.setVisible(true);
        jLabel2.setForeground(Color.white);
        jLabel2.setText("用户名：");
        jLabel2.setBounds(new Rectangle(83, 55, 56, 21));
        jButton1.setBackground(Color.lightGray);
        jButton1.setBounds(new Rectangle(223, 191, 70, 25));
        jButton1.setText("退出");
        jButton1.addMouseListener(new Frame5_jButton1_mouseAdapter(this));
        jButton1.addMouseMotionListener(new Frame5_jButton1_mouseMotionAdapter(this));
        jButton1.addActionListener(new Frame5_jButton1_actionAdapter(this));
        jButton2.addActionListener(new Frame5_jButton2_actionAdapter(this));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel4.setForeground(Color.red);
        jLabel4.setText("*");
        jLabel4.setBounds(new Rectangle(300, 110, 16, 21));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel5.setForeground(Color.red);
        jLabel5.setText("*");
        jLabel5.setBounds(new Rectangle(299, 55, 16, 21));
        jLabel6.setForeground(Color.green);
        jLabel6.setBounds(new Rectangle(146, 85, 147, 15));
        jLabel7.setForeground(Color.green);
        jLabel7.setBounds(new Rectangle(146, 146, 147, 15));
        jLabel8.setForeground(Color.green);
        jLabel8.setBounds(new Rectangle(95, 227, 269, 15));
        jLabel9.setForeground(Color.green);
        jLabel9.setBounds(new Rectangle(141, 226, 167, 15));
        jTextField1.addMouseMotionListener(new
                Frame5_jTextField1_mouseMotionAdapter(this));
        jTextField1.addMouseListener(new Frame5_jTextField1_mouseAdapter(this));
        jPasswordField1.addMouseMotionListener(new
                Frame5_jPasswordField1_mouseMotionAdapter(this));
        jPasswordField1.addMouseListener(new
                                         Frame5_jPasswordField1_mouseAdapter(this));
        jButton2.addMouseMotionListener(new Frame5_jButton2_mouseMotionAdapter(this));
        jButton2.addMouseListener(new Frame5_jButton2_mouseAdapter(this));
        this.getContentPane().add(jButton1);
        jTextField1.setBounds(new Rectangle(146, 55, 147, 21));
        jLabel3.setForeground(Color.white);
        jLabel3.setText("用户名：");
        jLabel3.setBounds(new Rectangle(83, 55, 56, 21));
        jPasswordField1.setBounds(new Rectangle(146, 106, 147, 25));
        jButton2.setBackground(Color.lightGray);
        jButton2.setBounds(new Rectangle(146, 192, 70, 25));
        jButton2.setText("确定");
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jPasswordField1);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jLabel7);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(jLabel9);
        jLabel1.setForeground(Color.white);
        jLabel1.setText("密码：");
        jLabel1.setBounds(new Rectangle(83, 110, 42, 21));
    }

    public void jButton1_actionPerformed(ActionEvent e) {
dispose();
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        DataBaseManager dbm = new DataBaseManager();
                       ResultSet rs;
                       int m,n;
                       String str1,str2,str0,str8;
                       str1=jTextField1.getText();
                       str2=new String(jPasswordField1.getPassword());
               if(jTextField1.getText().equals(""))
                       {JOptionPane.showMessageDialog(this,"用户名为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
                       else if(str2.equals(""))
                       {JOptionPane.showMessageDialog(this,"密码为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
                       else
                       {
                           str0="SELECT * FROM UserTable WHERE UserName ="+"'"+str1+"'"+"AND Password ="+"'"+str2+"'";
                           try
                           {
                               rs=dbm.getResult(str0);
                               if(rs.next())
                               {
                                   str0="DELETE FROM UserTable WHERE UserName ="+"'"+str1+"'"+"AND Password ="+"'"+str2+"'";
                                   str8="DELETE FROM bookBrowse WHERE StudentName ="+"'"+str1+"'";
                                   m=dbm.updateSql(str0);
                                   m=dbm.updateSql(str8);
                                   JOptionPane.showMessageDialog(this,"删除成功！","信息提示",JOptionPane.INFORMATION_MESSAGE);
                                  dispose();
                               }
                               else
                               {
                                   JOptionPane.showMessageDialog(this,"用户名不存在或者原密码错误！","警告对话框",JOptionPane.WARNING_MESSAGE);
                                   jTextField1.setText(null);
                                   jPasswordField1.setText(null);
                               }
                               dbm.closeConnection();
                           }
                           catch(SQLException e0){}
        }
    }

    public void jTextField1_mouseMoved(MouseEvent e) {
        jLabel5.setText("请输入用户名，且不能为空");
    }

    public void jTextField1_mouseExited(MouseEvent e) {
        jLabel5.setText("");
    }

    public void jPasswordField1_mouseMoved(MouseEvent e) {
        jLabel6.setText("请输入密码，且不能为空");
    }

    public void jPasswordField1_mouseExited(MouseEvent e) {
        jLabel6.setText("");
    }

    public void jButton2_mouseMoved(MouseEvent e) {
        jLabel7.setText("点击[确定]，将删除用户的所有信息（注册、借阅等）");
    }

    public void jButton2_mouseExited(MouseEvent e) {
        jLabel7.setText("");
    }

    public void jButton1_mouseMoved(MouseEvent e) {
        jLabel8.setText("点击[退出]，将返回系统主界面");
    }

    public void jButton1_mouseExited(MouseEvent e) {
        jLabel8.setText("");
    }
}


class Frame5_jPasswordField1_mouseAdapter extends MouseAdapter {
    private Frame5 adaptee;
    Frame5_jPasswordField1_mouseAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseExited(MouseEvent e) {
        adaptee.jPasswordField1_mouseExited(e);
    }
}


class Frame5_jPasswordField1_mouseMotionAdapter extends MouseMotionAdapter {
    private Frame5 adaptee;
    Frame5_jPasswordField1_mouseMotionAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(MouseEvent e) {
        adaptee.jPasswordField1_mouseMoved(e);
    }
}


class Frame5_jButton2_mouseMotionAdapter extends MouseMotionAdapter {
    private Frame5 adaptee;
    Frame5_jButton2_mouseMotionAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(MouseEvent e) {
        adaptee.jButton2_mouseMoved(e);
    }
}


class Frame5_jTextField1_mouseAdapter extends MouseAdapter {
    private Frame5 adaptee;
    Frame5_jTextField1_mouseAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseExited(MouseEvent e) {
        adaptee.jTextField1_mouseExited(e);
    }
}


class Frame5_jTextField1_mouseMotionAdapter extends MouseMotionAdapter {
    private Frame5 adaptee;
    Frame5_jTextField1_mouseMotionAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(MouseEvent e) {
        adaptee.jTextField1_mouseMoved(e);
    }
}


class Frame5_jButton2_actionAdapter implements ActionListener {
    private Frame5 adaptee;
    Frame5_jButton2_actionAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton2_actionPerformed(e);
    }
}


class Frame5_jButton1_mouseMotionAdapter extends MouseMotionAdapter {
    private Frame5 adaptee;
    Frame5_jButton1_mouseMotionAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(MouseEvent e) {
        adaptee.jButton1_mouseMoved(e);
    }
}


class Frame5_jButton2_mouseAdapter extends MouseAdapter {
    private Frame5 adaptee;
    Frame5_jButton2_mouseAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseExited(MouseEvent e) {
        adaptee.jButton2_mouseExited(e);
    }
}


class Frame5_jButton1_actionAdapter implements ActionListener {
    private Frame5 adaptee;
    Frame5_jButton1_actionAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}


class Frame5_jButton1_mouseAdapter extends MouseAdapter {
    private Frame5 adaptee;
    Frame5_jButton1_mouseAdapter(Frame5 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseExited(MouseEvent e) {
        adaptee.jButton1_mouseExited(e);
    }
}