scoreq.java~7~

S1项目本需求规格说明描述了北大青鸟ACCP教学管理系统项目的要求

package xiangmu;

import java.awt.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.BorderFactory;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.PreparedStatement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Connection;

/**
 * <p>Title: 第四学习小组-教学管理系统</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ScoreQ extends JFrame {
    String cols[]={"  学  号","  课程名","  老  师","  考试日期","  考试编次","  考试成绩","  备  注"};
    DefaultTableModel bg=new DefaultTableModel(cols,0);
    public ScoreQ() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel1.setText("学员编号：");
        jLabel1.setBounds(new Rectangle(234, 17, 86, 19));
        cmbStudentNo.setBounds(new Rectangle(299, 9, 90, 33));
        cmbClassNo.setBounds(new Rectangle(129, 10, 90, 33));
        btnExit.setBounds(new Rectangle(658, 9, 90, 33));
        btnExit.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnExit.setText("退  出");
        btnExit.addActionListener(new ScoreQ_jButton2_actionAdapter(this));
        btnQuery.setBounds(new Rectangle(561, 9, 90, 33));
        btnQuery.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnQuery.setText("查  询");
        btnQuery.addActionListener(new ScoreQ_jButton1_actionAdapter(this));
        jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
        jScrollPane1.setBounds(new Rectangle(8, 45, 789, 401));
        jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel3.setText("考试编次：");
        jLabel3.setBounds(new Rectangle(400, 19, 73, 15));
        cmbExamNo.setBounds(new Rectangle(462, 9, 91, 33));
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(btnExit);
        this.getContentPane().add(btnQuery);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(cmbClassNo);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(cmbStudentNo);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(cmbExamNo);
        jScrollPane1.getViewport().add(jTable1);
        jLabel2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel2.setText("所属班级：");
        jLabel2.setBounds(new Rectangle(67, 11, 80, 30));
        jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
                                                VERTICAL_SCROLLBAR_ALWAYS);
    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    String classno[]={"","T64","T65","T58"};
    JComboBox cmbClassNo = new JComboBox(classno);
    String studentno[]={"","0801","0802","0803","0804","0805","0806"};
    JComboBox cmbStudentNo = new JComboBox(studentno);
    JButton btnQuery = new JButton();
    JButton btnExit = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable(bg);
    JLabel jLabel3 = new JLabel();
    String examno[] = {"", "1", "2", "3","4"};
    JComboBox cmbExamNo = new JComboBox(examno);
    public void jButton2_actionPerformed(ActionEvent e) {
     this.dispose();
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        try {
            //String sql = "select ClassInfo.ClassNo,Score.StudentNo,Score.Course,Score.Teacher,Score.ExamDate,Score.ExamNo,Score.Score,Score.Remark from ClassInfo join Score on ClassInfo.StudentNo = Score.StudentNo  where 1=1";
            String sql = "select * from Score where 1=1";
            //if (!this.cmbClassNo.getSelectedItem().toString().equals("")) {
                //sql += " and ClassInfo.ClassNo ='" +
                        //this.cmbClassNo.getSelectedItem().toString() + "'";
            //}
            if (!this.cmbStudentNo.getSelectedItem().toString().equals("")) {
                sql += " and Score.StudentNo ='" +
                        this.cmbStudentNo.getSelectedItem().toString() + "'";
            }
            if (!this.cmbExamNo.getSelectedItem().toString().equals("")) {
               sql += " and Score.ExamNo ='" +
                       this.cmbExamNo.getSelectedItem().toString() + "'";
           }
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection("jdbc:odbc:xiangmu");
            PreparedStatement ps = conn.prepareStatement(sql);
            ResultSet rs = ps.executeQuery();
            bg.setRowCount(0);
            while (rs.next()) {
                Object val[] = {rs.getString(1), rs.getString(2),
                               rs.getString(3), rs.getString(4), rs.getString(5),
                               rs.getString(6),
                               rs.getString(7)};
                bg.addRow(val);
            }
            jTable1.updateUI();
            rs.close();
            ps.close();
            conn.close();
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(this, "查询失败！");
        }

    }
}


class ScoreQ_jButton1_actionAdapter implements ActionListener {
    private ScoreQ adaptee;
    ScoreQ_jButton1_actionAdapter(ScoreQ adaptee) {
        this.adaptee = adaptee;
    }

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


class ScoreQ_jButton2_actionAdapter implements ActionListener {
    private ScoreQ adaptee;
    ScoreQ_jButton2_actionAdapter(ScoreQ adaptee) {
        this.adaptee = adaptee;
    }

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