searchoicecourinfohandler.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 SearChoiceCourInfoHandler extends JInternalFrame
{
	private JTable table;
	
	private SearChoiceCourInfo searChoiceCourInfo;
	private String id;
	
	public SearChoiceCourInfoHandler(SearChoiceCourInfo searChoiceCourInf,String Id)  
	{	
		this.searChoiceCourInfo=searChoiceCourInf;
		this.id=Id;
		
		String[] ccolumnNames={"课程编号","课程名称","教师姓名","学期","学年"
		};

		DefaultTableModel tableModel=new DefaultTableModel(ccolumnNames,0);		
		
		String sql1="select * from choiceCourseInfo where stuID='"+id+"'";
		
		ChoiceCourseInfoDAO choiceCourseInfoDAO=new ChoiceCourseInfoDAO();
		ArrayList list=choiceCourseInfoDAO.excuteQuery(sql1);
		
		ChoiceCourseInfoBean choiceCourseInfoBean=null;
		
		if(list.size()<=0)
		{
			JOptionPane.showMessageDialog(null,"你还没有选任何课程!");
		}
		
		
		else
		{
			//int t=0;
			for(int j=0;j<list.size();j++)
			{
				choiceCourseInfoBean=(ChoiceCourseInfoBean)list.get(j);
				//if(choiceCourseInfoBean.getStuID().trim().equals(id))
				{
					//t++;
					
					String sql2="select * from openCourseInfo where openCourseID='"+choiceCourseInfoBean.getOpenCourseID()+"'";
		
					OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
					ArrayList openCourlist=openCourseInfoDAO.excuteQuery(sql2);
					OpenCourseInfoBean openCourseInfoBean=null;
					
					//for(int i=0;i<openCourlist.size();i++)
					{
						openCourseInfoBean=(OpenCourseInfoBean)openCourlist.get(0);
						//if(choiceCourseInfoBean.getOpenCourseID().trim().equals(openCourseInfoBean.getOpenCourseID().trim()))
						{
							//System.out.println("课程编号是"+openCourseInfoBean.getCourseID());
							String sql3="select * from courseInfo where courseID='"+openCourseInfoBean.getCourseID()+"'";
		
							CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
							ArrayList courlist=courseInfoDAO.excuteQuery(sql3);
							CourseInfoBean courseInfoBean=null;
							
						//	for(int k=0;k<courlist.size();k++)
							{
								courseInfoBean=(CourseInfoBean)courlist.get(0);
							//	if(openCourseInfoBean.getCourseID().trim().equals(courseInfoBean.getCourseID().trim()))
								{
									System.out.println("课程名称是"+courseInfoBean.getCourseName());
									String sql4="select * from teaInfo where teaID='"+openCourseInfoBean.getTeaID()+"'";
		
									TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
									ArrayList tealist=teaInfoDAO.excuteQuery(sql4);
									TeaInfoBean teaInfoBean=null;
									
									//for(int n=0;n<tealist.size();n++)
									{
										teaInfoBean=(TeaInfoBean)tealist.get(0);
										//if(teaInfoBean.getTeaID().trim().equals(openCourseInfoBean.getTeaID().trim()))
										{
											System.out.println("教师姓名是"+teaInfoBean.getTeaName());
											String[] object={courseInfoBean.getCourseID(),courseInfoBean.getCourseName(),teaInfoBean.getTeaName(),openCourseInfoBean.getOpenXQ(),openCourseInfoBean.getOpenYear()
											};
											tableModel.addRow(object);
										}
									}
								}
							}						
						}				
					}			
				}
				
			}
			
			
			System.out.println("选课信息中，选了"+list.size()+"门课");			
			table=new JTable(tableModel);
			
			JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
			searChoiceCourInfo.add(scrollPanel,BorderLayout.CENTER);
			searChoiceCourInfo.setSize(450,451);
			searChoiceCourInfo.setVisible(true);
		
		}
	/*
		
		searChoiceCourInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					searChoiceCourInfo.setVisible(false);
				}
			}
		);
	*/

	}

}