searchoicecourinfobyteanamehandler.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 SearChoiceCourInfoByTeaNameHandler extends JInternalFrame
{
	private JTable table;

	private SearChoiceCourInfoByTeaName searChoiceCourInfoByTeaName;
	private JComboBox comboBox;

	public SearChoiceCourInfoByTeaNameHandler(SearChoiceCourInfoByTeaName searChoiceCourInfoByTeaNa)  //,String Id
	{
		this.searChoiceCourInfoByTeaName=searChoiceCourInfoByTeaNa;
		comboBox=searChoiceCourInfoByTeaName.getComboBox();
		
		String sql1="select * from openCourseInfo";
		OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
		ArrayList openCourlist=openCourseInfoDAO.excuteQuery(sql1);
		OpenCourseInfoBean openCourseInfoBean=null;
		
		for(int i=0;i<openCourlist.size();i++)
		{
			openCourseInfoBean=(OpenCourseInfoBean)openCourlist.get(i);
			
			
			String sql2="select * from teaInfo";
			TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
			ArrayList tealist=teaInfoDAO.excuteQuery(sql2);
			TeaInfoBean teaInfoBean=null;
			
			int flag=0;
			for(int j=0;j<tealist.size();j++)
			{
				teaInfoBean=(TeaInfoBean)tealist.get(j);
				if(teaInfoBean.getTeaID().trim().equals(openCourseInfoBean.getTeaID().trim()))
				{
					for(int k=0;k<comboBox.getItemCount();k++)
					{
						System.out.println("教师姓名:"+comboBox.getItemAt(k).toString().trim());
						if(teaInfoBean.getTeaName().trim().equals(comboBox.getItemAt(k).toString().trim()))
						{
							flag=1;
							break;
						}
					}
					
					if(flag==0)
					{
						
						comboBox.addItem(teaInfoBean.getTeaName());	
					}
					
					if(flag==1)
					{
						flag=0;
					}				
				}						
			}	
				
		}
		
		//comboBox
		searChoiceCourInfoByTeaName.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 teaInfo";
					TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
					ArrayList tealist=teaInfoDAO.excuteQuery(sql1);
					TeaInfoBean teaInfoBean=null;
				
					for(int j=0;j<tealist.size();j++)
					{
						teaInfoBean=(TeaInfoBean)tealist.get(j);
						if(teaInfoBean.getTeaName().trim().equals(comboBox.getSelectedItem().toString().trim()))
						{
							String sql2="select * from openCourseInfo";
							OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
							ArrayList openCourlist=openCourseInfoDAO.excuteQuery(sql2);
							OpenCourseInfoBean openCourseInfoBean=null;
							
							for(int i=0;i<openCourlist.size();i++)
							{
								openCourseInfoBean=(OpenCourseInfoBean)openCourlist.get(i);
								if(openCourseInfoBean.getTeaID().trim().equals(teaInfoBean.getTeaID().trim()))
								{
									//找学生姓名
									String sql3="select * from choiceCourseInfo";
									ChoiceCourseInfoDAO choiceCourseInfoDAO=new ChoiceCourseInfoDAO();
									ArrayList choiceCourlist=choiceCourseInfoDAO.excuteQuery(sql3);
									ChoiceCourseInfoBean choiceCourseInfoBean=null;
									
									for(int k=0;k<choiceCourlist.size();k++)
									{
										choiceCourseInfoBean=(ChoiceCourseInfoBean)choiceCourlist.get(k);
										if(choiceCourseInfoBean.getOpenCourseID().trim().equals(openCourseInfoBean.getOpenCourseID().trim()))
										{
											String sql4="select * from stuInfo";
											StuInfoDAO stuInfoDAO=new StuInfoDAO();
											ArrayList stulist=stuInfoDAO.excuteQuery(sql4);
											StuInfoBean stuInfoBean=null;
											
											for(int n=0;n<stulist.size();n++)
											{
												stuInfoBean=(StuInfoBean)stulist.get(n);
												if(stuInfoBean.getStuID().trim().equals(choiceCourseInfoBean.getStuID().trim()))
												{
												//	StuName=stuInfoBean.getStuName();
												//	break;
													
													String sql5="select * from courseInfo";
													CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
													ArrayList courlist=courseInfoDAO.excuteQuery(sql5);
													CourseInfoBean courseInfoBean=null;
													
													for(int m=0;m<courlist.size();m++)
													{
														courseInfoBean=(CourseInfoBean)courlist.get(m);
														if(courseInfoBean.getCourseID().trim().equals(openCourseInfoBean.getCourseID().trim()))
														{	
															String[] object={stuInfoBean.getStuName(),courseInfoBean.getCourseName(),comboBox.getSelectedItem().toString(),openCourseInfoBean.getOpenXQ(),openCourseInfoBean.getOpenYear()
															};
															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);
						searChoiceCourInfoByTeaName.add(scrollPanel,BorderLayout.CENTER);
						searChoiceCourInfoByTeaName.setSize(450,451);	
					}
				
								
				}
			
			}
		);	
		
		searChoiceCourInfoByTeaName.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					searChoiceCourInfoByTeaName.setVisible(false);	
				}
			}
		);	
	}
}