searonecoursescorehandler.java

在本系统中

package jin.handler;

import java.awt.BorderLayout;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.util.*;
import javax.swing.table.DefaultTableModel;

import jin.internalFrame.*;
import jin.dao.*;
import jin.bean.*;

//可以按照课程编号查询自己在该门课程中的考试成绩。也可以查询自己选择的所有课程的考试成绩。
//显示的成绩信息包括课程名称、教师姓名、学期、学年、成绩五个数据项

public class SearOneCourseScoreHandler
{
	private SearOneCourseScore searOneCourseScore; 
	
	private JComboBox comboBox;
	private String id;
	private JTable table;
	//private OpenCourseInfoBean openCourseInfoBean=null;
	
	public SearOneCourseScoreHandler(SearOneCourseScore searOneCourseSco,String Id)
	{
		this.searOneCourseScore=searOneCourseSco;
		
		comboBox=searOneCourseScore.getComboBox();
		this.id=Id;

		comboBox.removeAllItems();					
		
		String sql1="select * from courseScoreInfo";
		CourseScoreInfoDAO courseScoreInfoDAO=new CourseScoreInfoDAO();
		ArrayList list=courseScoreInfoDAO.excuteQuery(sql1);
		
		CourseScoreInfoBean courseScoreInfoBean=null;					
		
		for(int i=0;i<list.size();i++)
		{			
			courseScoreInfoBean=(CourseScoreInfoBean)list.get(i);
			if(courseScoreInfoBean.getStuID().trim().equals(id))
			{
				comboBox.addItem(courseScoreInfoBean.getCourseID());
			}
		}
		
	
		//可以按照课程编号查询自己在该门课程中的考试成绩。也可以查询自己选择的所有课程的考试成绩。
		//显示的成绩信息包括课程名称、教师姓名、学期、学年、成绩五个数据项
		searOneCourseScore.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{	
					String[] ccolumnNames={"课程名称","教师姓名","学期","学年","成绩"
					};
			
					DefaultTableModel tableModel=new DefaultTableModel(ccolumnNames,0);		
					
					String sql2="select * from courseScoreInfo";
					CourseScoreInfoDAO courseScoreInfoDAO=new CourseScoreInfoDAO();
					ArrayList list=courseScoreInfoDAO.excuteQuery(sql2);
					
					CourseScoreInfoBean courseScoreInfoBean=null;					
					
					for(int i=0;i<list.size();i++)				
					{
						courseScoreInfoBean=(CourseScoreInfoBean)list.get(i);
						if(courseScoreInfoBean.getStuID().trim().equals(id) && courseScoreInfoBean.getCourseID().trim().equals(comboBox.getSelectedItem().toString().trim()))
						{							
							String sql3="select * from teaInfo";
	
							TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
							ArrayList tealist=teaInfoDAO.excuteQuery(sql3);
							TeaInfoBean teaInfoBean=null;
							
							//显示的成绩信息包括课程名称、教师姓名、学期、学年、成绩五个数据项
							for(int j=0;j<tealist.size();j++)
							{
								teaInfoBean=(TeaInfoBean)tealist.get(j);
								if(teaInfoBean.getTeaID().trim().equals(courseScoreInfoBean.getTeaID().trim()))
								{														
									String sql4="select * from courseInfo";
				
									CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
									ArrayList courlist=courseInfoDAO.excuteQuery(sql4);
									CourseInfoBean courseInfoBean=null;
									
									for(int k=0;k<courlist.size();k++)
									{
										courseInfoBean=(CourseInfoBean)courlist.get(k);
										if(courseInfoBean.getCourseID().trim().equals(comboBox.getSelectedItem().toString().trim()))
										{
											String[] object={courseInfoBean.getCourseName(),teaInfoBean.getTeaName(),courseScoreInfoBean.getStudyTeam(),courseScoreInfoBean.getStudyYear(),courseScoreInfoBean.getScore()
											};
											
											System.out.println("学期"+courseScoreInfoBean.getStudyTeam());
											System.out.println("学年"+courseScoreInfoBean.getStudyYear());
											tableModel.addRow(object);											
										}
									}						
								}				
							}			
						}		
					}
					
					table=new JTable(tableModel);
					
					JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
					searOneCourseScore.add(scrollPanel,BorderLayout.CENTER);
					searOneCourseScore.setSize(450,451);
					
					//searOneCourseScore.setVisible(false);
				}
			}
		);
		
		searOneCourseScore.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					searOneCourseScore.setVisible(false);
				}
			}
		);								
	}
}