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

	private SearChoiceCourInfoByOpenCourID searChoiceCourInfoByOpenCourID;
	private JComboBox comboBox;

	public SearChoiceCourInfoByOpenCourIDHandler(SearChoiceCourInfoByOpenCourID searChoiceCourInfByOpenCourID)  //,String Id
	{
		this.searChoiceCourInfoByOpenCourID=searChoiceCourInfByOpenCourID;
		comboBox=searChoiceCourInfoByOpenCourID.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);
			comboBox.addItem(openCourseInfoBean.getOpenCourseID());		
		}		
		
		searChoiceCourInfoByOpenCourID.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 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);
						if(openCourseInfoBean.getOpenCourseID().trim().equals(comboBox.getSelectedItem().toString().trim()))
						{
							String sql2="select * from teaInfo";
							TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
							ArrayList tealist=teaInfoDAO.excuteQuery(sql2);
							TeaInfoBean teaInfoBean=null;
						
							for(int j=0;j<tealist.size();j++)
							{
								teaInfoBean=(TeaInfoBean)tealist.get(j);
								if(teaInfoBean.getTeaID().trim().equals(openCourseInfoBean.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()))
												{
													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(),teaInfoBean.getTeaName(),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);
						searChoiceCourInfoByOpenCourID.add(scrollPanel,BorderLayout.CENTER);
						searChoiceCourInfoByOpenCourID.setSize(450,451);	
					}
				
								
				}
			
			}
		);	
		
		searChoiceCourInfoByOpenCourID.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					searChoiceCourInfoByOpenCourID.setVisible(false);	
				}
			}
		);	
	}
}