searscoreinfobyteaidhandler.java

在本系统中

//可以按照课程编号、课程名称、教师编号查询成绩信息。
//显示的成绩信息包括：学生姓名、班级名称、课程名称、教师姓名、成绩、备注六个数据项。




//按教师编号查询成绩信息



package jin.handler;

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

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


public class SearScoreInfoByTeaIDHandler extends JInternalFrame
{
	private JTable table;

	private SearScoreInfoByTeaID searScoreInfoByTeaID;
	private JComboBox comboBox;

	public SearScoreInfoByTeaIDHandler(SearScoreInfoByTeaID searScoreInfByTeaID)  //,String Id
	{
		this.searScoreInfoByTeaID=searScoreInfByTeaID;
		comboBox=searScoreInfoByTeaID.getComboBox();
		
		String sql1="select * from courseScoreInfo";
		CourseScoreInfoDAO courseScoreInfoDAO=new CourseScoreInfoDAO();
		ArrayList courScolist=courseScoreInfoDAO.excuteQuery(sql1);
		CourseScoreInfoBean courseScoreInfoBean=null;
		
		int flag=0;
		
		for(int i=0;i<courScolist.size();i++)
		{
			courseScoreInfoBean=(CourseScoreInfoBean)courScolist.get(i);
			
			for(int j=0;j<comboBox.getItemCount();j++)
			{
				if(courseScoreInfoBean.getTeaID().trim().equals(comboBox.getItemAt(j).toString().trim()))
				{
					flag=1;
					break;
				}
			}
			
			if(flag==0)
			{
				comboBox.addItem(courseScoreInfoBean.getTeaID());	
			}		
			
			if(flag==1)
			{
				flag=0;
			}				
		}		
		
		
		searScoreInfoByTeaID.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{	
					String[] columnNames={"学生姓名","班级名称","课程名称","教师姓名","成绩","备注"};
					DefaultTableModel tableModel=new DefaultTableModel(columnNames,0);	
					
					int flag=0;				
					
					String sql1="select * from courseScoreInfo";
					CourseScoreInfoDAO courseScoreInfoDAO=new CourseScoreInfoDAO();
					ArrayList courScolist=courseScoreInfoDAO.excuteQuery(sql1);
					CourseScoreInfoBean courseScoreInfoBean=null;
					
					for(int i=0;i<courScolist.size();i++)
					{
						courseScoreInfoBean=(CourseScoreInfoBean)courScolist.get(i);
						if(courseScoreInfoBean.getTeaID().trim().equals(comboBox.getSelectedItem().toString().trim()))
						{
							String sql2="select * from stuInfo";
							StuInfoDAO stuInfoDAO=new StuInfoDAO();
							ArrayList stulist=stuInfoDAO.excuteQuery(sql2);
							StuInfoBean stuInfoBean=null;
							
							for(int j=0;j<stulist.size();j++)
							{
								stuInfoBean=(StuInfoBean)stulist.get(j);
								if(stuInfoBean.getStuID().trim().equals(courseScoreInfoBean.getStuID().trim()))
								{
									String sql3="select * from classInfo";
									ClassInfoDAO classInfoDAO=new ClassInfoDAO();
									ArrayList classlist=classInfoDAO.excuteQuery(sql3);
									ClassInfoBean classInfoBean=null;
									
									for(int m=0;m<classlist.size();m++)
									{
										classInfoBean=(ClassInfoBean)classlist.get(m);
										if(classInfoBean.getClassID().trim().equals(stuInfoBean.getClassID().trim()))
										{
											String sql4="select * from courseInfo";
											CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
											ArrayList courlist=courseInfoDAO.excuteQuery(sql4);
											CourseInfoBean courseInfoBean=null;
											
											for(int n=0;n<courlist.size();n++)
											{
												courseInfoBean=(CourseInfoBean)courlist.get(n);
												if(courseInfoBean.getCourseID().trim().equals(courseScoreInfoBean.getCourseID().trim()))
												{
													String sql5="select * from teaInfo";
													TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
													ArrayList tealist=teaInfoDAO.excuteQuery(sql5);
													TeaInfoBean teaInfoBean=null;
												
													for(int k=0;k<tealist.size();k++)
													{
														teaInfoBean=(TeaInfoBean)tealist.get(k);
														if(teaInfoBean.getTeaID().trim().equals(comboBox.getSelectedItem().toString().trim()))
														{
															String[] object={stuInfoBean.getStuName(),classInfoBean.getClassName(),courseInfoBean.getCourseName(),teaInfoBean.getTeaName(),courseScoreInfoBean.getScore(),courseScoreInfoBean.getOther()
															};
															tableModel.addRow(object);	
															flag=1;	
														}
													}
												}
											}
										}
									}
								}
							}
						}					
					}
				
					if(flag==0)
					{
						JOptionPane.showMessageDialog(null,"该课程还没有登记成绩!");
					}
					
					if(flag==1)
					{
						table=new JTable(tableModel);
				
						JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
						searScoreInfoByTeaID.add(scrollPanel,BorderLayout.CENTER);
						searScoreInfoByTeaID.setSize(450,451);	
					}								
				}			
			}
		);	
		
		searScoreInfoByTeaID.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					searScoreInfoByTeaID.setVisible(false);	
				}
			}
		);	
	}
}