examframe.java~63~

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

package prjExam;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JCheckBox;
import javax.swing.JToggleButton;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import prjsystementer.DBManager;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.sql.*;
import prjClassInfo.AddClassFrame;
import javax.swing.JDialog;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import java.awt.Color;
import java.awt.SystemColor;

public class ExamFrame extends JDialog {
    public ExamFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    String sql = " select * from T_EXAM";
    public void fillTable(String sql) {
        DBManager db = new DBManager();

        ResultSet rs = db.ExecuteQuery(sql);
        ArrayList al = new ArrayList();
        try {
            while (rs.next()) {
                String examID = rs.getString("examID");
                String stuID = rs.getString("stuID");
                String courseID = rs.getString("courseID");
                String WrittenScore = rs.getString("WrittenScore");
                String LabScore = rs.getString("LabScore");

                Exam e = new Exam();
                e.setExamID(examID);
                e.setStuID(stuID);
                e.setCourseID(courseID);
                e.setWrittenScore(WrittenScore);
                e.setLabScore(LabScore);

                al.add(e);

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
        jLabel1.setText("考试成绩列表");
        jLabel1.setBounds(new Rectangle(153, 9, 128, 38));
        jCheckBox1.setBackground(Color.white);
        jCheckBox1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jCheckBox1.setText("考试编号");
        jCheckBox1.setBounds(new Rectangle(19, 343, 85, 23));
        jCheckBox1.addActionListener(new ExamFrame_jCheckBox1_actionAdapter(this));
        jCheckBox2.setBackground(Color.white);
        jCheckBox2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jCheckBox2.setText("课程编号");
        jCheckBox2.setBounds(new Rectangle(19, 379, 85, 23));
        jCheckBox3.setBackground(Color.white);
        jCheckBox3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jCheckBox3.setText("学生编号");
        jCheckBox3.setBounds(new Rectangle(244, 343, 85, 23));
        btnLook.setBackground(Color.white);
        btnLook.setBounds(new Rectangle(292, 377, 83, 25));
        btnLook.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnLook.setText("查询");
        btnLook.addActionListener(new ExamFrame_btnLook_actionAdapter(this));
        btnAdd.setBackground(Color.white);
        btnAdd.setBounds(new Rectangle(42, 434, 83, 25));
        btnAdd.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnAdd.setText("添加");
        btnAdd.addActionListener(new ExamFrame_btnAdd_actionAdapter(this));
        btnDel.setBackground(Color.white);
        btnDel.setBounds(new Rectangle(163, 434, 83, 25));
        btnDel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnDel.setText("删除");
        btnDel.addActionListener(new ExamFrame_btnDel_actionAdapter(this));
        btnCancel.setBackground(Color.white);
        btnCancel.setBounds(new Rectangle(286, 434, 83, 25));
        btnCancel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnCancel.setText("退出");
        btnCancel.addActionListener(new ExamFrame_btnCancel_actionAdapter(this));
        txtCourseId.setBounds(new Rectangle(112, 375, 105, 27));
        txtStuId.setBounds(new Rectangle(333, 341, 85, 27));
        txtExamId.setBounds(new Rectangle(112, 342, 104, 25));
        this.getContentPane().setBackground(SystemColor.textHighlightText);
        this.setTitle("考试成绩查询");
        jScrollPane1.getViewport().setBackground(Color.white);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(jCheckBox3);
        this.getContentPane().add(jCheckBox2);
        this.getContentPane().add(jCheckBox1);
        this.getContentPane().add(txtStuId);
        this.getContentPane().add(txtExamId);
        this.getContentPane().add(txtCourseId);
        this.getContentPane().add(btnDel);
        this.getContentPane().add(btnAdd);
        this.getContentPane().add(btnCancel);
        this.getContentPane().add(btnLook);
        jScrollPane1.getViewport().add(tblInfo);
        jScrollPane1.setBounds(new Rectangle(21, 54, 402, 264));

        fillTable(this.sql);
    }

    public static void main(String[] args) {
        ExamFrame examframe = new ExamFrame();
    }

    JLabel jLabel1 = new JLabel();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable tblInfo = new JTable();
    JCheckBox jCheckBox1 = new JCheckBox();
    JCheckBox jCheckBox2 = new JCheckBox();
    JCheckBox jCheckBox3 = new JCheckBox();
    JButton btnLook = new JButton();
    JButton btnAdd = new JButton();
    JButton btnDel = new JButton();
    JButton btnCancel = new JButton();
    JTextField txtCourseId = new JTextField();
    JTextField txtStuId = new JTextField();
    JTextField txtExamId = new JTextField();

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

    public void btnAdd_actionPerformed(ActionEvent e) {
        AddExamFrame a = new AddExamFrame();
        a.setSize(400, 450);
        a.setLocation(200, 200);
        a.setDefaultCloseOperation(a.DISPOSE_ON_CLOSE);
        a.setModal(true);
        a.setVisible(true);
        fillTable(this.sql);
    }

    public void btnDel_actionPerformed(ActionEvent e) {

        int x = this.tblInfo.getSelectedRow();
        if (x < 0) {
            JOptionPane.showMessageDialog(this, "请选择要删除的行。");
            return;
        }
        int quesn = JOptionPane.showConfirmDialog(this, "是否删除", "确认",
                                                  JOptionPane.YES_NO_OPTION,
                                                  JOptionPane.WARNING_MESSAGE);
        if (quesn == JOptionPane.NO_OPTION) {
            return;
        }

        ExamModel tm = (ExamModel)this.tblInfo.getModel();
        String id = (String) tm.getValueAt(x, 0);
        String sql = "delete from T_EXAM where examID='" + id + "'";
        DBManager db = new DBManager();
        db.ExecuteUpdate(sql);

        fillTable(this.sql);
    }

    public void btnRWritten_actionPerformed(ActionEvent e) {
        this.txtCourseId.setText("");
        this.txtExamId.setText("");
        this.txtStuId.setText("");
        this.jCheckBox1.setSelected(false);
        this.jCheckBox2.setSelected(false);
        this.jCheckBox3.setSelected(false);
        fillTable(sql);
//        this.jCheckBox1.removeAll();
//        this.jCheckBox2.removeAll();
//        this.jCheckBox3.removeAll();

    }

    public void btnLook_actionPerformed(ActionEvent e) {
//        String ExamId = this.jCheckBox1.getText();
//        String StuId = this.jCheckBox2.getText();
//        String CourseId = this.jCheckBox3.getText();

        String txtCourseId = this.txtCourseId.getText();
        String txtExamId = this.txtExamId.getText();
        String txtStuId = this.txtStuId.getText();
        if (txtCourseId.equals("") && txtExamId.equals("") &&
            txtStuId.equals("")) {
            fillTable(this.sql);
        }
        DBManager db = new DBManager();
        String sql = "select * from T_EXAM";
        String sql2 = "";
        if (this.jCheckBox1.isSelected()) {
            sql2 += "examID='" + this.txtExamId.getText() + "' and ";
        }
        if (this.jCheckBox2.isSelected()) {
            sql2 += "courseID='" + this.txtCourseId.getText() + "' and ";
        }
        if (this.jCheckBox3.isSelected()) {
            sql2 += "stuID='" + this.txtStuId.getText() + "' and ";
        }
        if (!(sql2.equals(""))) {
            sql2 = sql2.substring(0, sql2.length() - 4);
            sql += " where " + sql2;
        }
        fillTable(sql);

//        String sql = "";
//        if (this.jCheckBox1.isSelected()) {
//            sql = "select * from T_EXAM where courseID='" + txtCourseId +
//                  "'";
//        } else if (this.jCheckBox2.isSelected()) {
//            sql = "select * from T_EXAM where examID='" + txtExamId +
//                  "'";
//        } else if (this.jCheckBox3.isSelected()) {
//            sql = "select * from T_EXAM where stuID='" + txtStuId +
//                  "'";
//        }
//        DBManager db = new DBManager();
//        db.ExecuteQuery(sql);
//
//        fillTable(sql);
    }

    public void jCheckBox1_actionPerformed(ActionEvent e) {
        this.jCheckBox1.setSelected(true);
    }
}


class ExamFrame_jCheckBox1_actionAdapter implements ActionListener {
    private ExamFrame adaptee;
    ExamFrame_jCheckBox1_actionAdapter(ExamFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ExamFrame_btnLook_actionAdapter implements ActionListener {
    private ExamFrame adaptee;
    ExamFrame_btnLook_actionAdapter(ExamFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ExamFrame_btnDel_actionAdapter implements ActionListener {
    private ExamFrame adaptee;
    ExamFrame_btnDel_actionAdapter(ExamFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ExamFrame_btnAdd_actionAdapter implements ActionListener {
    private ExamFrame adaptee;
    ExamFrame_btnAdd_actionAdapter(ExamFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ExamFrame_btnCancel_actionAdapter implements ActionListener {
    private ExamFrame adaptee;
    ExamFrame_btnCancel_actionAdapter(ExamFrame adaptee) {
        this.adaptee = adaptee;
    }

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