chachengjiframe1.java~128~

Student management system

package student;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JPanel;
import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Statement;
import java.sql.*;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.awt.event.InputMethodEvent;
import java.awt.event.InputMethodListener;
import javax.swing.table.JTableHeader;
import javax.swing.table.DefaultTableModel;

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(18, 13, 434, 493));
        jPanel1.setLayout(null);
        xuehao.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        xuehao.setBounds(new Rectangle(32, 19, 107, 27));
        xuehao.addActionListener(new chachengjiFrame1_xuehao_actionAdapter(this));
        jButton1.setBounds(new Rectangle(171, 17, 80, 29));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton1.setText("查询");
        jButton1.addActionListener(new chachengjiFrame1_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(268, 16, 80, 29));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton2.setText("取消");
        jButton2.addActionListener(new chachengjiFrame1_jButton2_actionAdapter(this));
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel1.setText("课程名称");
        jLabel1.setBounds(new Rectangle(23, 59, 109, 29));
        kecheng.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        kecheng.setEditable(false);
        kecheng.setText("");
        kecheng.setBounds(new Rectangle(146, 58, 133, 29));
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel2.setText("课程成绩");
        jLabel2.setBounds(new Rectangle(22, 98, 89, 27));
        sorce.setEnabled(false);
        sorce.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        sorce.setEditable(false);
        sorce.setText("");
        sorce.setBounds(new Rectangle(146, 94, 133, 29));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel3.setText("系部名称");
        jLabel3.setBounds(new Rectangle(23, 137, 91, 27));
        xingming.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        xingming.setDoubleBuffered(true);
        xingming.setEditable(false);
        xingming.setText("");
        xingming.setBounds(new Rectangle(146, 135, 133, 29));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel4.setText("联系电话");
        jLabel4.setBounds(new Rectangle(23, 180, 85, 29));
        dianhua.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        dianhua.setEditable(false);
        dianhua.setText("");
        dianhua.setBounds(new Rectangle(147, 177, 131, 31));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel5.setText("入学时间");
        jLabel5.setBounds(new Rectangle(23, 223, 70, 21));
        zhuanye.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        zhuanye.setEditable(false);
        zhuanye.setText("");
        zhuanye.setBounds(new Rectangle(147, 214, 153, 32));
        jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel6.setText("学生姓名");
        jLabel6.setBounds(new Rectangle(23, 263, 75, 31));
        ruxue.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        ruxue.setToolTipText("");
        ruxue.setEditable(false);
        ruxue.setText("");
        ruxue.setBounds(new Rectangle(143, 259, 136, 32));
        jButton3.setBounds(new Rectangle(22, 313, 93, 30));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton3.setText("补考名单");
        jButton3.addActionListener(new chachengjiFrame1_jButton3_actionAdapter(this));
        jTable1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jTable1.setBounds(new Rectangle(135, 331, 289, 135));
        jTableHeader2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jTableHeader2.setBounds(new Rectangle(135, 304, 291, 28));
        this.getContentPane().add(jPanel1);
        jPanel1.add(jButton1);
        jPanel1.add(jButton2);
        jPanel1.add(xuehao);
        jPanel1.add(jLabel1);
        jPanel1.add(sorce);
        jPanel1.add(jLabel3);
        jPanel1.add(jLabel4);
        jPanel1.add(kecheng);
        jPanel1.add(xingming);
        jPanel1.add(jLabel5);
        jPanel1.add(jLabel6);
        jPanel1.add(ruxue);
        jPanel1.add(dianhua);
        jPanel1.add(zhuanye);
        jPanel1.add(jLabel2);
        jPanel1.add(jTable1);
        jPanel1.add(jTableHeader2);
        jPanel1.add(jButton3);
    }

    JPanel jPanel1 = new JPanel();
    JComboBox xuehao = new JComboBox();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JLabel jLabel1 = new JLabel();
    JTextField kecheng = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField sorce = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField xingming = new JTextField();
    JLabel jLabel4 = new JLabel();
    JTextField dianhua = new JTextField();
    JLabel jLabel5 = new JLabel();
    JTextField zhuanye = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField ruxue = new JTextField();
    JButton jButton3 = new JButton();
    Object [][] cells={
                       {" "," "," "},
    };
    String tableheader[] = {"学生姓名", "课程名称","学生成绩"};
    JTable jTable1 = new JTable(cells,tableheader);
    JTableHeader jTableHeader1=jTable1.getTableHeader();
    JTableHeader jTableHeader2 = jTable1.getTableHeader();
    public void xuehao_actionPerformed(ActionEvent e) {
        try{
                           Connectionsql c=new Connectionsql();
                           Connection con=c.getConnection();
                           Statement pstmt=con.createStatement();
                           String sql="select xuehao from xueshengxuanke ";
                           ResultSet rs=pstmt.executeQuery(sql);
                            while (rs.next()){
                              xuehao.addItem(rs.getString(1));
                            }
                        }catch(Exception xx){
                            xx.getStackTrace();
           }
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        try{
                     String SH=(String)xuehao.getSelectedItem();
                     Connectionsql c=new Connectionsql();
                     Connection con=c.getConnection();
                     Statement pstmt=con.createStatement();
                     String sql="SELECT xueshengxuanke.kechengbm, xueshengxuanke.chengji, student.name, student.dianhua, student.zhuanye, student.ruxue FROM xueshengxuanke, student where  xueshengxuanke.xuehao = student.num and xueshengxuanke.xuehao like '"+SH+"'";
                     ResultSet rs=pstmt.executeQuery(sql);
                     while(rs.next()){
                     kecheng.setText(rs.getString(1));
                     sorce.setText((String)rs.getString(2));
                     xingming.setText(rs.getString(5));
                     dianhua.setText(rs.getString(4));
                     zhuanye.setText(rs.getString(6));
                     ruxue.setText(rs.getString(3));
                 }
                     }catch(Exception xx){
                                    xx.getStackTrace();
           }
    }

    public void jButton3_actionPerformed(ActionEvent e) {
    try{
        Connectionsql c=new Connectionsql();
        Connection con=c.getConnection();
        Statement pstmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
        String sql="SELECT student.name, xueshengxuanke.kechengbm, xueshengxuanke.chengji from xueshengxuanke INNER JOIN student ON xueshengxuanke.xuehao = student.num WHERE (xueshengxuanke.chengji < 60 )";
        ResultSet rs=pstmt.executeQuery(sql);
        DefaultTableModel model1 = new DefaultTableModel();
        model1.setColumnIdentifiers(tableheader);
        while(rs.next())
           {
            model1.addRow(new Object[]{rs.getString(1),rs.getString(2),rs.getString(3)});
            }
          jTable1.setModel(model1);
    }catch(Exception s5){
        s5.printStackTrace();
    }
    }

    public void jButton2_actionPerformed(ActionEvent e) {
     this.dispose();
    }
}


class chachengjiFrame1_jButton2_actionAdapter implements ActionListener {
    private chachengjiFrame1 adaptee;
    chachengjiFrame1_jButton2_actionAdapter(chachengjiFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class chachengjiFrame1_jButton3_actionAdapter implements ActionListener {
    private chachengjiFrame1 adaptee;
    chachengjiFrame1_jButton3_actionAdapter(chachengjiFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class chachengjiFrame1_jButton1_actionAdapter implements ActionListener {
    private chachengjiFrame1 adaptee;
    chachengjiFrame1_jButton1_actionAdapter(chachengjiFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class chachengjiFrame1_xuehao_actionAdapter implements ActionListener {
    private chachengjiFrame1 adaptee;
    chachengjiFrame1_xuehao_actionAdapter(chachengjiFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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