chakeframe1.java~7~

Student management system

package student;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JComboBox;
import java.awt.*;
import javax.swing.JPanel;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Statement;
import java.sql.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class chakeFrame1 extends JFrame {
    public chakeFrame1() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jPanel1.setBackground(Color.pink);
        jPanel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(0, 0, 361, 230));
        jPanel1.setLayout(null);
        price.setText("");
        price.setBounds(new Rectangle(128, 183, 169, 27));
        laoshi.setText("");
        laoshi.setBounds(new Rectangle(129, 47, 169, 26));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jLabel4.setText("上课时间");
        jLabel4.setBounds(new Rectangle(17, 135, 75, 31));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jLabel5.setText("上课地点");
        jLabel5.setBounds(new Rectangle(17, 95, 75, 31));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jPanel2.setBackground(Color.pink);
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBounds(new Rectangle( -2, 232, 363, 44));
        jPanel2.setLayout(null);
        jButton1.setBackground(Color.pink);
        jButton1.setBounds(new Rectangle(65, 9, 71, 25));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton1.setForeground(Color.red);
        jButton1.setText("查询");
        jButton1.addActionListener(new chakeFrame1_jButton1_actionAdapter(this));
        jButton2.setBackground(Color.pink);
        jButton2.setBounds(new Rectangle(187, 9, 71, 25));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton2.setForeground(Color.red);
        jButton2.setText("取消");
        jPanel2.add(jButton1);
        jPanel2.add(jButton2);
        this.getContentPane().add(jPanel1);
        name.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        name.setBounds(new Rectangle(213, 11, 85, 26));
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jLabel2.setText("授课老师");
        jLabel2.setBounds(new Rectangle(17, 51, 95, 28));
        time.setBounds(new Rectangle(129, 138, 169, 28));
        jLabel3.setText("上课价格");
        jLabel3.setBounds(new Rectangle(15, 182, 75, 31));
        didian.setText("");
        didian.setBounds(new Rectangle(129, 93, 169, 27));
        jPanel1.add(name);
        jPanel1.add(laoshi);
        jPanel1.add(jLabel3);
        jPanel1.add(price);
        jPanel1.add(time);
        jPanel1.add(jLabel4);
        jPanel1.add(didian);
        jPanel1.add(jLabel5);
        jPanel1.add(jLabel2);
        jPanel1.add(jLabel1);
        this.getContentPane().add(jPanel2);
        jLabel1.setText("课程名称");
        jLabel1.setBounds(new Rectangle(15, 13, 108, 31));
        name.addItem("java");
        name.addItem("C语言");
        name.addItem("英语");
    }

    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JComboBox name = new JComboBox();
    JLabel jLabel2 = new JLabel();
    JTextField time = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField didian = new JTextField();
    JTextField price = new JTextField();
    JTextField laoshi = new JTextField();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JPanel jPanel2 = new JPanel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    public void jButton1_actionPerformed(ActionEvent e) {
    String Name=(String)name.getSelectedItem();
    try{
        Connectionsql c=new Connectionsql();
        Connection con=c.getConnection();
        Statement pstmt=con.createStatement();
        String sql="select * from kechengxinxi where kechengmc='"+Name+"'";
        ResultSet rs=pstmt.executeQuery(sql);
        while(rs.next()){
            laoshi.setText(rs.getString(3));
        }
        con.close();
        pstmt.close();
        rs.close();
    }catch(Exception xx){
        xx.getStackTrace();
    }
    }
}


class chakeFrame1_jButton1_actionAdapter implements ActionListener {
    private chakeFrame1 adaptee;
    chakeFrame1_jButton1_actionAdapter(chakeFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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