addexamframe.java~12~

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

package prjExam;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JComboBox;
import javax.swing.JButton;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import prjsystementer.DBManager;
import javax.swing.JDialog;
import javax.swing.*;

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

    public void fillCbo() {
        String[] names = {"C001_C语言", "C002_SQL", "C003_JAVA语言", "C004_HTML",
                         "C005_JSP"};
        for (int i = 0; i < names.length; i++) {
            this.cboCourseId.addItem(names[i]);
        }
    }

    private void jbInit() throws Exception {

        fillCbo();

        getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
        jLabel1.setText("添加考试成绩");
        jLabel1.setBounds(new Rectangle(157, 11, 116, 36));
        btnRWirrt.setBounds(new Rectangle(151, 358, 83, 25));
        btnRWirrt.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnRWirrt.setText("重置");
        btnRWirrt.addActionListener(new AddExamFrame_btnRWirrt_actionAdapter(this));
        btnCancel.setBounds(new Rectangle(289, 358, 83, 25));
        btnCancel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnCancel.setText("取消");
        btnCancel.addActionListener(new AddExamFrame_btnCancel_actionAdapter(this));
        btnOK.setBounds(new Rectangle(23, 358, 83, 25));
        btnOK.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnOK.setText("确定 ");
        btnOK.addActionListener(new AddExamFrame_btnOK_actionAdapter(this));
        cboCourseId.setBounds(new Rectangle(159, 124, 130, 33));
        txtCourse2.setBounds(new Rectangle(159, 244, 128, 36));
        txtCourse1.setBounds(new Rectangle(159, 188, 127, 29));
        txtStudentId.setBounds(new Rectangle(159, 74, 129, 32));
        jLabel5.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel5.setText("机试成绩");
        jLabel5.setBounds(new Rectangle(44, 243, 66, 35));
        jLabel4.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel4.setText("笔试成绩");
        jLabel4.setBounds(new Rectangle(44, 191, 70, 35));
        jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel3.setText("课程编号");
        jLabel3.setBounds(new Rectangle(43, 124, 64, 35));
        lblStudentId.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblStudentId.setText("学生编号");
        this.getContentPane().add(txtStudentId);
        this.getContentPane().add(txtCourse1);
        this.getContentPane().add(cboCourseId);
        this.getContentPane().add(lblStudentId);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(txtCourse2);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(btnOK);
        this.getContentPane().add(btnRWirrt);
        this.getContentPane().add(btnCancel);
        lblStudentId.setBounds(new Rectangle(44, 79, 65, 26));
    }

    JLabel jLabel1 = new JLabel();
    JLabel lblStudentId = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField txtStudentId = new JTextField();
    JTextField txtCourse1 = new JTextField();
    JTextField txtCourse2 = new JTextField();
    JComboBox cboCourseId = new JComboBox();
    JButton btnOK = new JButton();
    JButton btnCancel = new JButton();
    JButton btnRWirrt = new JButton();
    public void btnOK_actionPerformed(ActionEvent e) {
        String StudentId = this.txtStudentId.getText();
        if (StudentId.equals("")) {
            JOptionPane.showMessageDialog(this, "学生编号不能为空");
        }
        String Course1 = this.txtCourse1.getText();
        String CourseId = (String)this.cboCourseId.getSelectedItem();
        String Course2 = this.txtCourse2.getText();
        DBManager db = new DBManager();
        String sql =
                "insert into T_EXAM(stuID,courseID,WrittenScore,LabScore) values('" +
                StudentId + "','" +
                CourseId + "','" + Course1 + "','" + Course2 + "')";
        db.ExecuteUpdate(sql);
        JOptionPane.showMessageDialog(this, "注册成功.");

    }

    public void btnRWirrt_actionPerformed(ActionEvent e) {
        this.txtCourse1.setText("");
        this.txtCourse2.setText("");
        this.txtStudentId.setText("");
        this.cboCourseId.setSelectedItem("C001_C语言");

    }

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


class AddExamFrame_btnCancel_actionAdapter implements ActionListener {
    private AddExamFrame adaptee;
    AddExamFrame_btnCancel_actionAdapter(AddExamFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class AddExamFrame_btnRWirrt_actionAdapter implements ActionListener {
    private AddExamFrame adaptee;
    AddExamFrame_btnRWirrt_actionAdapter(AddExamFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class AddExamFrame_btnOK_actionAdapter implements ActionListener {
    private AddExamFrame adaptee;
    AddExamFrame_btnOK_actionAdapter(AddExamFrame adaptee) {
        this.adaptee = adaptee;
    }

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