frame8.java~10~

大二做的实训. 纯Java程序

package bookmanagesystem;

import java.awt.BorderLayout;
import java.sql.*;
import javax.swing.JFrame;
import java.awt.Color;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frame8 extends JFrame {
    public Frame8() {
        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);
        jLabel1.setForeground(Color.white);
        jLabel1.setText("书籍名称：");
        jLabel1.setBounds(new Rectangle(44, 124, 61, 25));
        jButton2.setBounds(new Rectangle(302, 124, 70, 25));
        jButton2.setText("退出");
        jButton2.addActionListener(new Frame8_jButton2_actionAdapter(this));
        jButton1.setBounds(new Rectangle(227, 124, 70, 25));
        jButton1.setText("删除");
        jButton1.addActionListener(new Frame8_jButton1_actionAdapter(this));
        jLabel2.setForeground(Color.green);
        jLabel2.setBounds(new Rectangle(71, 159, 195, 23));
        jLabel3.setForeground(Color.green);
        jLabel3.setBounds(new Rectangle(82, 162, 243, 23));
        jLabel4.setForeground(Color.green);
        jLabel4.setBounds(new Rectangle(109, 163, 195, 30));
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel4);
        jTextField1.setBounds(new Rectangle(99, 124, 122, 25));
    }

    JLabel jLabel1 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    public void jButton2_actionPerformed(ActionEvent e) {
dispose();
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        DataBaseManager dbm = new DataBaseManager();
        ResultSet rs;
       int f;
       String str1;
       String str0="",str8="";
if(jTextField1.getText().equals(""))
       {JOptionPane.showMessageDialog(this,"书名不能为空！","警告对话框",JOptionPane.WARNING_MESSAGE);}
       else
       {
           str1=jTextField1.getText();
           str0="SELECT * FROM books WHERE BookName='"+str1+"'";
           rs=dbm.getResult(str0);
           try
           {
               if(rs.next())
               {
                   str8="DELETE FROM books WHERE BookName='"+str1+"'";
                   f=dbm.updateSql(str8);
                   JOptionPane.showMessageDialog(this,"删除成功！","警告对话框",JOptionPane.INFORMATION_MESSAGE);
                   dispose();
               }
               else
               {JOptionPane.showMessageDialog(this,"书籍不存在或者书名错误！","警告对话框",JOptionPane.WARNING_MESSAGE);
               jTextField1.setText(null);
               }
           }
           catch(SQLException e4){}
           dbm.closeConnection();
       }

    }
}


class Frame8_jButton1_actionAdapter implements ActionListener {
    private Frame8 adaptee;
    Frame8_jButton1_actionAdapter(Frame8 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame8_jButton2_actionAdapter implements ActionListener {
    private Frame8 adaptee;
    Frame8_jButton2_actionAdapter(Frame8 adaptee) {
        this.adaptee = adaptee;
    }

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