searopencourseinfohandler.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 SearOpenCourseInfoHandler extends JInternalFrame
{
	private JTable table;
	
	private String id;	
	
	private SearOpenCourseInfo searOpenCourseInfo;
	
	public SearOpenCourseInfoHandler(SearOpenCourseInfo searOpenCourseInf,String Id)  //
	{
		this.searOpenCourseInfo=searOpenCourseInf;
		this.id=Id;
		
		
		//显示的开课信息包括：开课编号、课程名称、学期、学年四个数据项
		String[] ccolumnNames={"开课编号","课程名称","学期","学年"
		};

		DefaultTableModel tableModel=new DefaultTableModel(ccolumnNames,0);		
		
		String sql1="select * from openCourseInfo";
		
		OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
		ArrayList list=openCourseInfoDAO.excuteQuery(sql1);
		OpenCourseInfoBean openCourseInfoBean=null;
		
		int flag=0;
		
		for(int j=0;j<list.size();j++)
		{
			openCourseInfoBean=(OpenCourseInfoBean)list.get(j);
			if(openCourseInfoBean.getTeaID().trim().equals(id))
			{	
				String sql2="select * from courseInfo";
		
				CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
				ArrayList courseList=courseInfoDAO.excuteQuery(sql2);
				CourseInfoBean courseInfoBean=null;
				for(int i=0;i<courseList.size();i++)
				{
					courseInfoBean=(CourseInfoBean)courseList.get(i);
					if(openCourseInfoBean.getCourseID().trim().equals(courseInfoBean.getCourseID().trim()))
					{
						String[] object={openCourseInfoBean.getOpenCourseID(),courseInfoBean.getCourseName(),openCourseInfoBean.getOpenYear(),openCourseInfoBean.getOpenXQ()
						};
						tableModel.addRow(object);
					}
				}						
				flag=1;				
			}
		}
		
		
		if(flag==0)
		{
			JOptionPane.showMessageDialog(null,"您还没有开设任何课程!");
			searOpenCourseInfo.setVisible(false);
		}
		
		else if(flag==1)
		{
							
			table=new JTable(tableModel);
			
			JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
			searOpenCourseInfo.add(scrollPanel,BorderLayout.CENTER);
			searOpenCourseInfo.setSize(450,451);
				
			searOpenCourseInfo.setVisible(true);
		}
		
	}

}