queryscore.java~37~

java语言写的

package scoremis;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.*;
import javax.swing.table.*;
import javax.swing.event.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2007</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class QueryScore extends JFrame{
  String kc, bj, xq, sql;
  JPanel p = new JPanel();
  JLabel l1 = new JLabel("课程:");
  JComboBox course = new JComboBox();
  JLabel l2 = new JLabel("班级:");
  JComboBox tgreade = new JComboBox();
  JLabel l3 = new JLabel("学期:");
  JComboBox term = new JComboBox();
  JButton sure = new JButton("查询");
  JButton quxian = new JButton("查看成绩分布");
  ResultSet rs = null;
  Vector tempvector = new Vector(1, 1);
  DefaultTableModel model = new DefaultTableModel();
  JTable dbtable = new JTable(model);
  JScrollPane jScrollPanel = new JScrollPane(dbtable);
  String tname, psd, sf;
    public QueryScore(String name,String psd,String sf)  {
      try{
        tname = name;
        this.psd = psd;
        this.sf = sf;
        jbInit();
      }catch (Exception execption) {execption.printStackTrace();}
    }
   private void jbInit() throws Exception {
     this.getContentPane().setLayout(new BorderLayout());    //添加组件
     l1.setFont(new java.awt.Font("Dialog", 0, 12));
     course.setFont(new java.awt.Font("Dialog", 0, 12));
     l2.setFont(new java.awt.Font("Dialog", 0, 12));
     tgreade.setFont(new java.awt.Font("Dialog", 0, 12));
     l3.setFont(new java.awt.Font("Dialog", 0, 12));
     term.setFont(new java.awt.Font("Dialog", 0, 12));
     sure.setFont(new java.awt.Font("Dialog", 0, 12));
     quxian.setFont(new java.awt.Font("Dialog", 0, 12));
     p.add(l1);p.add(course); p.add(l2);p.add(tgreade);p.add(l3); p.add(term);
     p.add(sure);p.add(quxian);
     this.getContentPane().add(p,"North");
     model.addColumn("学号");
     model.addColumn("姓名");
     model.addColumn("成绩");
     this.getContentPane().add(jScrollPanel,"Center");
     sure.addActionListener(new chaxun());  //给按钮添加事件监视器
     quxian.addActionListener(new chaxun());
     quxian.setEnabled(false);
     course.addItem("请选择课程");
     course.addActionListener(new cquery());
     tgreade.addItem("请选择班级");
     term.addItem("请选择学期");
     if (sf.equals("教师")) {         //给课程添加项目
       sql="select distinct T_C.cname from T_C,teacher where teacher.name='"+tname+"' and teacher.ID=T_C.tID";
     }
     else {
       sql="select distinct T_C.cname from T_C";
     }
     try {
       dbconn db = new dbconn();
       rs = db.Query(sql);
       while(rs.next()) {
         course.addItem(rs.getString(1));
       }
     }catch (Exception er) {System.out.println(er.toString());}
     }
   class cquery implements ActionListener{      //给班级和学期添加项目
      public void actionPerformed (ActionEvent e) {
        dbconn db = new dbconn();
      if(e.getSource()==course) {
        kc=(String)course.getSelectedItem();
      if(sf.equals("教师")){
        sql="select T_C.Cgreade from T_C,teacher where teacher.name='"+tname+"' and teacher.ID=T_C.tID and T_C.Cname='"+kc+"'";
      }else{
        sql="select T_C.Cgreade from T_C";
      }
      try{
        tgreade.removeAllItems();
        tgreade.addItem("请选择班级");
        rs=db.Query(sql);
        while (rs.next()) {
          tgreade.addItem(rs.getString(1));
        }
        sql="select distinct Term from T_C where cname='"+kc+"'";
        term.removeAllItems();
        term.addItem("请选择学期");
        rs = db.Query(sql);
        while(rs.next()){
          term.addItem(rs.getString(1));
          }
        }catch(Exception e2){System.out.println(e2.toString());}
      }
    }
   }
   class chaxun implements ActionListener{
      public void actionPerformed(ActionEvent e) {
        dbconn db=new dbconn();
        kc = (String)course.getSelectedItem();
        bj = (String)tgreade.getSelectedItem();
        xq = (String)term.getSelectedItem();
        if (e.getSource()==sure) {    //查询
         sql = "select SID,Sname,score from S_C where Tgreade='"+bj+"' and CID='"+kc+"' and Term='"+xq+"'";
        try {
          int j=model.getRowCount();
          if(j>0) {
            for (int i=0;i<j;i++)
              model.removeRow(0);
          }
          rs=db.Query(sql);
          int i=0;
          while(rs.next()) {
            tempvector = new Vector(1, 1);
            tempvector.add(rs.getString(1));
            tempvector.add(rs.getString(2));
            tempvector.add(rs.getString(3));
            model.addRow(tempvector);
            i++;
          }
          if(i==0)
            JOptionPane.showMessageDialog(null, "未录入该门课程成绩! !");
          else
            quxian.setEnabled(true);
            dbtable.setEnabled(false);     //表中数据不能修改
        }
        catch (Exception e2) {System.out.println(e2.toString() ); }
      }else if(e.getSource()==quxian){    //查询成绩分布
        String k = kc;
        String b = bj;
        JFrame f = new JFrame();
        Toolkit tk = Toolkit.getDefaultToolkit();
        Dimension sSize=tk.getScreenSize();
        int sh = sSize.height;
        int sw = sSize.width;
        f.setSize(500,400);
        f.setLocation(sw/4, sh/4);
        drawTu d=new drawTu(k,b);
        f.getContentPane().add(d);
        f.setVisible(true);
        f.setBackground(Color.white) ;
      }
    }
  }
}