lookstudentexaminfoframe.java~44~

用java 写的学生信息管理系统

package prjsystementer;

import java.awt.BorderLayout;
import java.util.*;
import javax.swing.*;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTabbedPane;
import javax.swing.JTextField;
import javax.swing.*;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextArea;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.*;
import javax.swing.JDialog;
import java.awt.Font;
import java.awt.Color;

public class LookStudentExamInfoFrame extends JDialog {
    JLabel lblMain = new JLabel();
    JLabel lblNumber = new JLabel();
    JTextField txtStuId = new JTextField();
    JButton btnOk = new JButton();
    JPanel jPanel1 = new JPanel();
    JButton btnCancel = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable tblExam = new JTable();
    public LookStudentExamInfoFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        lblMain.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblMain.setText("考试成绩查询");
        lblMain.setBounds(new Rectangle(166, 9, 97, 48));
        btnOk.setBackground(Color.white);
        btnOk.setBounds(new Rectangle(298, 70, 98, 31));
        btnOk.setText("查询");
        btnOk.addActionListener(new
                                LookStudentExamInfoFrame_btnOk_actionAdapter(this));
        txtStuId.setBounds(new Rectangle(121, 70, 165, 30));
        jPanel1.setBackground(Color.white);
        jPanel1.setBounds(new Rectangle(11, 51, 396, 71));
        btnCancel.setBackground(Color.white);
        btnCancel.setBounds(new Rectangle(304, 386, 92, 31));
        btnCancel.setText("退出");
        btnCancel.addActionListener(new
                                    LookStudentExamInfoFrame_btnCancel_actionAdapter(this));
        jScrollPane1.getViewport().setBackground(Color.white);
        jScrollPane1.setBounds(new Rectangle(22, 127, 375, 243));
        this.setTitle("查询学生考试信息 ");
        this.getContentPane().add(txtStuId);
        this.getContentPane().add(btnOk);
        this.getContentPane().add(lblMain, null);
        this.getContentPane().add(lblNumber);
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(jPanel1);
        this.getContentPane().add(btnCancel);
        jScrollPane1.getViewport().add(tblExam);
        lblNumber.setText("学生编号：");
        lblNumber.setBounds(new Rectangle(48, 68, 71, 34));

    }

    String stuID;
    private void fillTable() {
        stuID = txtStuId.getText();
        DBManager db = new DBManager();
        //this.stuID;
        String sql = "select * from T_EXAM where stuID='" + stuID + "'";
        ResultSet rs = db.ExecuteQuery(sql);
        ArrayList al = new ArrayList();

        try {
            try {
                if (rs.next() == false) {
                    JOptionPane.showMessageDialog(this, "没有记录");
                    return;
                }
            } catch (SQLException ex1) {
                ex1.printStackTrace();
            }

            String DBexamID = rs.getString("examID");
            String DBstuID = rs.getString("stuID");
            String DBcourseID = rs.getString("courseID");
            String DBWrittenScore = rs.getString("WrittenScore");
            String DBLabScore = rs.getString("LabScore");
            SearchStuExam sse = new SearchStuExam();
            sse.setExamID(DBexamID);
            sse.setStuID(DBstuID);
            sse.setCourseID(DBcourseID);
            sse.setWrittenScore(DBWrittenScore);
            sse.setLabScore(DBLabScore);
            al.add(sse);

            ExamModal em = new ExamModal();
            em.al = al;
            this.tblExam.setModel(em);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

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

    public void btnOk_actionPerformed(ActionEvent e) {
        //调用上面的fillTable方法用于执行查询按钮的功能
        fillTable();
        MainFrame d = new MainFrame(stuID);
        System.out.println(stuID);
    }
}


class LookStudentExamInfoFrame_btnOk_actionAdapter implements ActionListener {
    private LookStudentExamInfoFrame adaptee;
    LookStudentExamInfoFrame_btnOk_actionAdapter(LookStudentExamInfoFrame
                                                 adaptee) {
        this.adaptee = adaptee;
    }

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


class LookStudentExamInfoFrame_btnCancel_actionAdapter implements
        ActionListener {
    private LookStudentExamInfoFrame adaptee;
    LookStudentExamInfoFrame_btnCancel_actionAdapter(LookStudentExamInfoFrame
            adaptee) {
        this.adaptee = adaptee;
    }

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