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

	private SearOpenCourseInfoByStu searOpenCourseInfoByStu;

	private String id;

	public SearOpenCourseInfoByStuHandler(SearOpenCourseInfoByStu searOpenCourseInfByStu,String Id)  
	{
		this.searOpenCourseInfoByStu=searOpenCourseInfByStu;
		this.id=Id;
	

		String[] columnNames={"课程编号","课程名称","教师姓名","学期","学年"};
		DefaultTableModel tableModel=new DefaultTableModel(columnNames,0);		
		
		
		String sql1="select * from openCourseInfo";
		OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
		ArrayList openCourList=openCourseInfoDAO.excuteQuery(sql1);	
		
		if(openCourList.size()<=0)
		{
			JOptionPane.showMessageDialog(null,"还没有开课信息!");
			searOpenCourseInfoByStu.setVisible(false);
		}
		
		else 
		{
			
			OpenCourseInfoBean openCourseInfoBean=null;
		
		
			for(int j=0;j<openCourList.size();j++)
			{
				openCourseInfoBean=(OpenCourseInfoBean)openCourList.get(j);
				
				String sql2="select * from choiceCourseInfo where openCourseID='"+openCourseInfoBean.getOpenCourseID().trim()+"'";
				ChoiceCourseInfoDAO choiceCourseInfoDAO=new ChoiceCourseInfoDAO();
				ArrayList choiceCourList=choiceCourseInfoDAO.excuteQuery(sql2);	
				//ChoiceCourseInfoBean choiceCourseInfoBean=null;
				if(choiceCourList.size()==0)
				{
					System.out.println("没执行");
					String sql3="select * from teaInfo where teaID='"+openCourseInfoBean.getTeaID().trim()+"'";	
					TeaInfoDAO teaInfoDAO=new TeaInfoDAO();		
					TeaInfoBean teaInfoBean=(TeaInfoBean)teaInfoDAO.excuteQuery(sql3).get(0);
					
					
					
					String sql4="select * from courseInfo where courseID='"+openCourseInfoBean.getCourseID().trim()+"'";	
					CourseInfoDAO courseInfoDAO=new CourseInfoDAO();		
					CourseInfoBean courseInfoBean=(CourseInfoBean)courseInfoDAO.excuteQuery(sql4).get(0);
					
					
					
					String[] object={openCourseInfoBean.getCourseID(),courseInfoBean.getCourseName(),teaInfoBean.getTeaName(),openCourseInfoBean.getOpenXQ(),openCourseInfoBean.getOpenYear()
					};
					tableModel.addRow(object);	
					//flag=1;
				}
				
				
				else if(choiceCourList!=null && choiceCourList.size()>0)	
				{
					for(int k=0;k<choiceCourList.size();k++)
					{
						ChoiceCourseInfoBean choiceCourseInfoBean=(ChoiceCourseInfoBean)choiceCourList.get(k);
						System.out.println("11111");
						System.out.println("读出的学号:"+choiceCourseInfoBean.getStuID());
						System.out.println("传进来的学号:"+id);
						System.out.println(!choiceCourseInfoBean.getStuID().equals(id));
						
						if(!choiceCourseInfoBean.getStuID().equals(id))
						{
							String sql4="select * from teaInfo where teaID='"+openCourseInfoBean.getTeaID().trim()+"'";	
							TeaInfoDAO teaInfoDAO=new TeaInfoDAO();		
							TeaInfoBean teaInfoBean=(TeaInfoBean)teaInfoDAO.excuteQuery(sql4).get(0);
							
								
							String sql5="select * from courseInfo where courseID='"+openCourseInfoBean.getCourseID().trim()+"'";	
							CourseInfoDAO courseInfoDAO=new CourseInfoDAO();		
							CourseInfoBean courseInfoBean=(CourseInfoBean)courseInfoDAO.excuteQuery(sql5).get(0);
					
							
							String[] object={courseInfoBean.getCourseID(),courseInfoBean.getCourseName(),teaInfoBean.getTeaName(),openCourseInfoBean.getOpenXQ(),openCourseInfoBean.getOpenYear()
							};
							tableModel.addRow(object);	
							//flag=1;
						}
					}					
				}
			}
		}
				
			

		/*
		if(flag==0)
		{
			JOptionPane.showMessageDialog(null,"还没有开课信息!");
			searOpenCourseInfoByStu.setVisible(false);
		}
		*/
		
	//	if(flag==1)
		//{
		table=new JTable(tableModel);
	
		JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
		searOpenCourseInfoByStu.add(scrollPanel,BorderLayout.CENTER);
		searOpenCourseInfoByStu.setSize(450,451);
	
			
	}
}
		
		
	
	
	
		
		/*
		String sql1="select * from stuInfo where stuID='"+id+"'";
		StuInfoDAO stuInfoDAO=new StuInfoDAO();
		ArrayList stulist=stuInfoDAO.excuteQuery(sql1);
		
		if(stulist.size()>0)
		{
			StuInfoBean stuInfoBean=(StuInfoBean)stulist.get(0);
			
			String sql2="select * from classInfo where classID='"+stuInfoBean.getClassID().trim()+"'";
			ClassInfoDAO classInfoDAO=new ClassInfoDAO();
			ArrayList classList=classInfoDAO.excuteQuery(sql2);
			
			int flag=0;
			
			if(classList.size()>0)
			{
				ClassInfoBean classInfoBean=(ClassInfoBean)classList.get(0);
				
				String sql3="select * from courseInfo where majorID='"+classInfoBean.getMajorID().trim()+"'";
				CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
				
				String sql="select * from courseInfo where majorID='100'";
				//CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
				
				//公选课的
				ArrayList gCourList=courseInfoDAO.excuteQuery(sql);
				
				//专业的	
				ArrayList courList=courseInfoDAO.excuteQuery(sql3);
				
				//总的
				ArrayList list=new ArrayList();
				
				for(int i=0;i<gCourList.size();i++)
				{
					list.add(gCourList.get(i));
				}
				
				for(int i=0;i<courList.size();i++)
				{
					list.add(courList.get(i));
				}
				
				if(list.size()>0)
				{
					CourseInfoBean courseInfoBean=null;
					for(int i=0;i<list.size();i++)
					{
						courseInfoBean=(CourseInfoBean)list.get(i);
						
						String sql4="select * from openCourseInfo where courseID='"+courseInfoBean.getCourseID().trim()+"'";
						OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
						ArrayList openCourList=openCourseInfoDAO.excuteQuery(sql4);	
						
						if(openCourList.size()<=0)
						{
							JOptionPane.showMessageDialog(null,"还没有开课信息!");
							searOpenCourseInfoByStu.setVisible(false);
						}
						
						else 
						{
							
							OpenCourseInfoBean openCourseInfoBean=null;
						
						
							for(int j=0;j<openCourList.size();j++)
							{
								openCourseInfoBean=(OpenCourseInfoBean)openCourList.get(j);
								
								String sql5="select * from choiceCourseInfo where openCourseID='"+openCourseInfoBean.getOpenCourseID().trim()+"'";
								ChoiceCourseInfoDAO choiceCourseInfoDAO=new ChoiceCourseInfoDAO();
								ArrayList choiceCourList=choiceCourseInfoDAO.excuteQuery(sql5);	
								//ChoiceCourseInfoBean choiceCourseInfoBean=null;
								if(choiceCourList.size()==0)
								{
									System.out.println("没执行");
									String sql6="select * from teaInfo where teaID='"+openCourseInfoBean.getTeaID().trim()+"'";	
									TeaInfoDAO teaInfoDAO=new TeaInfoDAO();		
									TeaInfoBean teaInfoBean=(TeaInfoBean)teaInfoDAO.excuteQuery(sql6).get(0);
									
									String[] object={courseInfoBean.getCourseID(),courseInfoBean.getCourseName(),teaInfoBean.getTeaName(),openCourseInfoBean.getOpenXQ(),openCourseInfoBean.getOpenYear()
									};
									tableModel.addRow(object);	
									flag=1;
								}
								
							
								else if(choiceCourList!=null && choiceCourList.size()>0)	
								{
									for(int k=0;k<choiceCourList.size();k++)
									{
										ChoiceCourseInfoBean choiceCourseInfoBean=(ChoiceCourseInfoBean)choiceCourList.get(k);
										System.out.println("11111");
										System.out.println("读出的学号:"+choiceCourseInfoBean.getStuID());
										System.out.println("传进来的学号:"+id);
										System.out.println(!choiceCourseInfoBean.getStuID().equals(id));
										
										if(!choiceCourseInfoBean.getStuID().equals(id))
										{
											String sql6="select * from teaInfo where teaID='"+openCourseInfoBean.getTeaID().trim()+"'";	
											TeaInfoDAO teaInfoDAO=new TeaInfoDAO();		
											TeaInfoBean teaInfoBean=(TeaInfoBean)teaInfoDAO.excuteQuery(sql6).get(0);
											
											String[] object={courseInfoBean.getCourseID(),courseInfoBean.getCourseName(),teaInfoBean.getTeaName(),openCourseInfoBean.getOpenXQ(),openCourseInfoBean.getOpenYear()
											};
											tableModel.addRow(object);	
											flag=1;
										}
									}					
								}	
							}
						}
					
					}
					/*
					if(flag==0)
					{
						JOptionPane.showMessageDialog(null,"还没有开课信息!");
						searOpenCourseInfoByStu.setVisible(false);
					}
					
					
					if(flag==1)
					{
						table=new JTable(tableModel);
			
						JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
						searOpenCourseInfoByStu.add(scrollPanel,BorderLayout.CENTER);
						searOpenCourseInfoByStu.setSize(450,451);
					}
					
				}
			}
		}*/
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
		
		
		
		
		/*		
		ClassInfoBean classInfoBean=(ClassInfoBean)classInfoDAO.excuteQuery(sql2).get(0);
		
		
		String sql3="select * from courseInfo where majorID='"+classInfoBean.getMajorID().trim()+"'";
		CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
		
		String sql="select * from courseInfo where majorID='100'";
		//CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
		
		//公选课的
		ArrayList gCourList=courseInfoDAO.excuteQuery(sql);
		
		//专业的	
		ArrayList courList=courseInfoDAO.excuteQuery(sql3);
		
		
		//总的
		ArrayList list=new ArrayList();
		
		for(int i=0;i<gCourList.size();i++)
		{
			list.add(gCourList.get(i));
		}
		
		for(int i=0;i<courList.size();i++)
		{
			list.add(courList.get(i));
		}
		
		
		CourseInfoBean courseInfoBean=null;
		for(int i=0;i<list.size();i++)
		{
			courseInfoBean=(CourseInfoBean)list.get(i);
			
			String sql4="select * from openCourseInfo where courseID='"+courseInfoBean.getCourseID().trim()+"'";
			OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
			ArrayList openCourList=openCourseInfoDAO.excuteQuery(sql4);	
			OpenCourseInfoBean openCourseInfoBean=null;
			
			
			for(int j=0;j<openCourList.size();j++)
			{
				openCourseInfoBean=(OpenCourseInfoBean)openCourList.get(j);
				
				String sql5="select * from choiceCourseInfo where openCourseID='"+openCourseInfoBean.getOpenCourseID().trim()+"'";
				ChoiceCourseInfoDAO choiceCourseInfoDAO=new ChoiceCourseInfoDAO();
				ArrayList choiceCourList=choiceCourseInfoDAO.excuteQuery(sql5);	
				//ChoiceCourseInfoBean choiceCourseInfoBean=null;
				if(choiceCourList.size()==0)
				{
					System.out.println("没执行");
					String sql6="select * from teaInfo where teaID='"+openCourseInfoBean.getTeaID().trim()+"'";	
					TeaInfoDAO teaInfoDAO=new TeaInfoDAO();		
					TeaInfoBean teaInfoBean=(TeaInfoBean)teaInfoDAO.excuteQuery(sql6).get(0);
					
					String[] object={courseInfoBean.getCourseID(),courseInfoBean.getCourseName(),teaInfoBean.getTeaName(),openCourseInfoBean.getOpenXQ(),openCourseInfoBean.getOpenYear()
					};
					tableModel.addRow(object);	
				}
				
			
				else if(choiceCourList!=null && choiceCourList.size()>0)	
				{
					for(int k=0;k<choiceCourList.size();k++)
					{
						ChoiceCourseInfoBean choiceCourseInfoBean=(ChoiceCourseInfoBean)choiceCourList.get(k);
						System.out.println("11111");
						System.out.println("读出的学号:"+choiceCourseInfoBean.getStuID());
						System.out.println("传进来的学号:"+id);
						System.out.println(!choiceCourseInfoBean.getStuID().equals(id));
						
						if(!choiceCourseInfoBean.getStuID().equals(id))
						{
							String sql6="select * from teaInfo where teaID='"+openCourseInfoBean.getTeaID().trim()+"'";	
							TeaInfoDAO teaInfoDAO=new TeaInfoDAO();		
							TeaInfoBean teaInfoBean=(TeaInfoBean)teaInfoDAO.excuteQuery(sql6).get(0);
							
							String[] object={courseInfoBean.getCourseID(),courseInfoBean.getCourseName(),teaInfoBean.getTeaName(),openCourseInfoBean.getOpenXQ(),openCourseInfoBean.getOpenYear()
							};
							tableModel.addRow(object);	
						}
					}					
				}	
			}
		}
		
	
		table=new JTable(tableModel);

		JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
		searOpenCourseInfoByStu.add(scrollPanel,BorderLayout.CENTER);
		searOpenCourseInfoByStu.setSize(450,451);
		
		*/