frame2.java

北大青鸟的内部测试题（感兴趣的一定要看看哦 ）

package studenttext;

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

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.Font;
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.Statement;
import java.sql.ResultSet;
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 Frame2 extends JFrame {
    JPanel contentPane;
    JLabel jLabel1 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JLabel jshow = new JLabel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    public Frame2() {
        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(null);
        setSize(new Dimension(400, 300));
        setTitle("Frame Title");
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel1.setText("班 级：");
        jLabel1.setBounds(new Rectangle(61, 73, 75, 35));
        jTextField1.setBounds(new Rectangle(170, 72, 145, 34));
        jshow.setBounds(new Rectangle(109, 138, 173, 44));
        jButton1.setBounds(new Rectangle(44, 222, 117, 39));
        jButton1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jButton1.setText("  查 询：");
        jButton1.addActionListener(new Frame2_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(212, 222, 117, 39));
        jButton2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jButton2.setText(" 退 出");
        jButton2.addActionListener(new Frame2_jButton2_actionAdapter(this));
        contentPane.add(jLabel1);
        contentPane.add(jTextField1);
        contentPane.add(jshow);
        contentPane.add(jButton1);
        contentPane.add(jButton2);
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        int num = JOptionPane.showConfirmDialog(this,"您确定要退出吗？","请判断",JOptionPane.YES_NO_CANCEL_OPTION);
      if(num==0){
       System.exit(0);
      }

    }

    public void jButton1_actionPerformed(ActionEvent e) {
        String sql = "select avg(javatext) from student where classnumber is not null group by classnumber desc";
    try {
        Statement stm = stu.getConnection().createStatement();
        ResultSet rs = stm.executeQuery(sql);
        while(rs.next()){
            jshow.setText(""+rs.getInt(3));
            }
    } catch (SQLException ex) {
        ex.printStackTrace();
    }



    }
}


class Frame2_jButton1_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton1_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_jButton2_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton2_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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