dialog1.java~2~

是个管理员管理系统

package 图书管理;

import java.awt.BorderLayout;
import java.awt.Frame;

import javax.swing.JDialog;
import javax.swing.JPanel;
import javax.swing.JButton;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.JLabel;
import javax.swing.JTextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import java.sql.Connection;

public class Dialog1 extends JDialog {
    JPanel panel1 = new JPanel();
    JPanel jPanel1 = new JPanel();
    XYLayout xYLayout2 = new XYLayout();
    JPanel jPanel2 = new JPanel();
    XYLayout xYLayout1 = new XYLayout();
    XYLayout xYLayout3 = new XYLayout();
    JButton jButton1 = new JButton();
    JLabel jLabel1 = new JLabel();
    JTextField jTextField1 = new JTextField();

    public Dialog1(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public Dialog1() {
        this(new Frame(), "Dialog1", false);
    }

    private void jbInit() throws Exception {
        panel1.setLayout(xYLayout2);
        jPanel2.setLayout(xYLayout1);
        jPanel1.setLayout(xYLayout3);
        jButton1.setText("查询");
        jButton1.addActionListener(new Dialog1_jButton1_actionAdapter(this));
        jLabel1.setText("书籍编号");
        getContentPane().add(panel1);
        panel1.add(jPanel1, new XYConstraints(0, 0, 397, 148));
        panel1.add(jPanel2, new XYConstraints(14, 167, 376, 115));
        jPanel2.add(jButton1, new XYConstraints(147, 34, -1, -1));
        jPanel1.add(jTextField1, new XYConstraints(188, 68, 146, 35));
        jPanel1.add(jLabel1, new XYConstraints(111, 71, 63, 28));
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        jTextArea1.setText(" ");
        boolean f=false;
        int id=Integer.parseInt(jTextField1.getText());
        jTextArea1.append("编号"+'\t'+"名称"+'\t'+"作者"+'\t'+"出版社"+'\t'+"出版日期"+'\n');
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:qqqq");
            Statement stmt = con.createStatement();
            ResultSet rs = null;
            rs=stmt.executeQuery("select * from tushu where book_id="+id+"");
            while(rs.next()){
                f=true;
                jTextArea1.append(rs.getString(1)+'\t');
                jTextArea1.append(rs.getString(2)+'\t');
                jTextArea1.append(rs.getString(3)+'\t');
                jTextArea1.append(rs.getString(4)+'\t');
                jTextArea1.append(rs.getString(5)+'\t'+'\n');
            }
            if(f==false)
                JOptionPane.showMessageDialog(this,"没有这本书!");
            stmt.close();
            rs.close();
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
    }

    }
}


class Dialog1_jButton1_actionAdapter implements ActionListener {
    private Dialog1 adaptee;
    Dialog1_jButton1_actionAdapter(Dialog1 adaptee) {
        this.adaptee = adaptee;
    }

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