del_dialog1.java~12~

该文件中包含有源代码及一部分的文档,该系统是一个小型的英语单词字典的系统.

package logindemo;

import java.awt.BorderLayout;
import java.awt.Frame;
import javax.swing.JDialog;
import javax.swing.JPanel;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import javax.swing.JTextField;
import javax.swing.JLabel;
import javax.swing.JButton;
import java.awt.Dimension;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import java.sql.SQLException;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
//删除功能
public class Del_Dialog1 extends JDialog implements ActionListener {
    JPanel panel1 = new JPanel();
    BorderLayout borderLayout1 = new BorderLayout();
    JPanel jPanel1 = new JPanel();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel1 = new JLabel();
    JButton jButton1 = new JButton();
    JPanel jPanel3 = new JPanel();
    public Del_Dialog1(Frame parent) {
        super(parent);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public Del_Dialog1() {
         this(null);
    }

    private void jbInit() throws Exception {
        panel1.setLayout(borderLayout1);
        setTitle("请输入删除的书的ISBN");
        jTextField1.setPreferredSize(new Dimension(100, 20));
        jLabel1.setText("书的ISBN");
        jButton1.setText("确定");
        jButton1.addActionListener(new Del_Dialog1_jButton1_actionAdapter(this));
        getContentPane().add(panel1);
        jPanel1.add(jLabel1);
        jPanel1.add(jTextField1);
        jPanel3.add(jButton1);
        panel1.add(jPanel1, java.awt.BorderLayout.NORTH);
        panel1.add(jPanel3, java.awt.BorderLayout.SOUTH);
    }
    public void actionPerformed(ActionEvent actionEvent) {
        if (actionEvent.getSource() == jButton1) {
            dispose();
        }
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        String ISBN = jTextField1.getText().trim();
        int no = 0;
        Database database = new Database();
        String sql = "del reader from book where ISBN =? " +ISBN;
        ResultSet rs = database.query(sql);
         if (ISBN != null) {

            try {
                 no = Integer.parseInt(ISBN);
            }
            catch ( NumberFormatException e) {
                e.printStackTrace();
                no = 0;
            }
         }
         else {
                no = 0;
                JOptionPane.showMessageDialog(this,"请输入ISBN码");
                 }
        if (no == 0 )
        {
            JOptionPane.showMessageDialog(this,"无此书");
        }
        else {
            try {
                PreparedStatement deleteInfo = database.createPreparedStatement("delete from book where ISBN = ?");
                deleteInfo.setInt(1,no);
                deleteInfo.execute();
                deleteInfo.close();
            }
            catch (SQLException sql) {
                sql.printStackTrace();
            }
        }

}


class Del_Dialog1_jButton1_actionAdapter implements ActionListener {
    private Del_Dialog1 adaptee;
    Del_Dialog1_jButton1_actionAdapter(Del_Dialog1 adaptee) {
        this.adaptee = adaptee;
    }

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