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

	private SearAllOpenCourInfo searAllOpenCourInfo;

	public SearAllOpenCourInfoHandler(SearAllOpenCourInfo searAllOpenCourInf)  //,String Id
	{
		this.searAllOpenCourInfo=searAllOpenCourInf;
		
		String[] columnNames={"开课编号","课程名称","学期","学年","教师姓名"};
		DefaultTableModel tableModel=new DefaultTableModel(columnNames,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);
		
			String sql2="select * from teaInfo where teaID='"+openCourseInfoBean.getTeaID()+"'";
			TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
			TeaInfoBean teaInfoBean=(TeaInfoBean)teaInfoDAO.excuteQuery(sql2).get(0);
			
			String sql3="select * from courseInfo where courseID='"+openCourseInfoBean.getCourseID().trim()+"'";
			CourseInfoDAO courseInfoDAO=new	CourseInfoDAO();
			CourseInfoBean courseInfoBean=(CourseInfoBean)courseInfoDAO.excuteQuery(sql3).get(0);
			
			String[] object={openCourseInfoBean.getOpenCourseID(),courseInfoBean.getCourseName(),openCourseInfoBean.getOpenXQ(),openCourseInfoBean.getOpenYear(),teaInfoBean.getTeaName()
			};
			tableModel.addRow(object);		
		
		}
			
		table=new JTable(tableModel);

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

	}
}