frame1.java~12~

是个管理员管理系统

package 图书管理;

import java.awt.BorderLayout;
import java.awt.Dimension;

import javax.swing.JFrame;
import javax.swing.JPanel;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.JButton;
import javax.swing.JTextArea;
import javax.swing.BorderFactory;
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 Frame1 extends JFrame {
    JPanel contentPane;
    JPanel jPanel1 = new JPanel();
    XYLayout xYLayout1 = new XYLayout();
    XYLayout xYLayout2 = new XYLayout();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JTextArea jTextArea1 = new JTextArea();

    public Frame1() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(xYLayout1);
        setSize(new Dimension(400, 300));
        setTitle("Frame Title");
        jPanel1.setLayout(xYLayout2);
        jButton1.setText("显示");
        jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
        jButton2.setText("查询");
        jButton2.addActionListener(new Frame1_jButton2_actionAdapter(this));
        jTextArea1.setBorder(BorderFactory.createLoweredBevelBorder());
        contentPane.add(jPanel1, new XYConstraints(0, 0, -1, -1));
        contentPane.add(jTextArea1, new XYConstraints(12, 10, 760, 223));
        contentPane.add(jButton1, new XYConstraints(147, 242, 125, 28));
        contentPane.add(jButton2, new XYConstraints(437, 242, 127, 28));
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        jTextArea1.setText(" ");
        jTextArea1.append("编号" + '\t' + "名称" + '\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");
            while (rs.next()) {
                jTextArea1.append(rs.getString(1) + '\t');
                jTextArea1.append(rs.getString(2));
                jTextArea1.append(rs.getString(3) + '\t');
                jTextArea1.append(rs.getString(4) + '\t');
                jTextArea1.append(rs.getString(5) + '\n');
            }
            stmt.close();
            rs.close();
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }

    }

    public void jButton2_actionPerformed(ActionEvent e) {
        query q1=new query();
        q1.pack();
        q1.setSize(300,400);
        q1.setVisible(true);

    }

    class Frame1_jButton1_actionAdapter implements ActionListener {
        private Frame1 adaptee;
        Frame1_jButton1_actionAdapter(Frame1 adaptee) {
            this.adaptee = adaptee;
        }

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


class Frame1_jButton2_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton2_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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