searallcoursescorehandler.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 SearAllCourseScoreHandler
{
	private SearAllCourseScore searAllCourseScore; 
	
	private String id;
	private JTable table;

	
	public SearAllCourseScoreHandler(SearAllCourseScore searAllCourseSco,String Id)
	{
		this.searAllCourseScore=searAllCourseSco;	
		this.id=Id;

			
		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;					
		
		
		if(list.size()<=0)
		{
			JOptionPane.showMessageDialog(null,"还没有登记成绩!");
			//searAllCourseScore.setVisible(false);
		}
		
		else 
		{
			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(courseScoreInfoBean.getCourseID().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);
			searAllCourseScore.add(scrollPanel,BorderLayout.CENTER);
			searAllCourseScore.setSize(450,451);
								
		}
		
	}
}