searallcourinfohandler.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 SearAllCourInfoHandler extends JInternalFrame
{
	private JTable table;	
	
	private SearAllCourInfo searAllCourInfo;	
	
	public SearAllCourInfoHandler(SearAllCourInfo searAllCourInf)  //,String Id
	{
		this.searAllCourInfo=searAllCourInf;		
	
		
		String[] ccolumnNames={"课程编号","课程名称","专业名称"
		};
	
		DefaultTableModel tableModel=new DefaultTableModel(ccolumnNames,0);		
		
		
		String sql1="select * from courseInfo";
	
		CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
		ArrayList courseList=courseInfoDAO.excuteQuery(sql1);
		CourseInfoBean courseInfoBean=null;

		for(int i=0;i<courseList.size();i++)
		{
			courseInfoBean=(CourseInfoBean)courseList.get(i);
			
			String sql2="select * from majorInfo";
	
			MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
			ArrayList majorlist=majorInfoDAO.excuteQuery(sql2);
			MajorInfoBean majorInfoBean=null;
			
			for(int k=0;k<majorlist.size();k++)
			{
				majorInfoBean=(MajorInfoBean)majorlist.get(k);
				if(majorInfoBean.getMajorID().trim().equals(courseInfoBean.getMajorID().trim()) && courseInfoBean.getState().trim().equals("在编"))
				{
					String[] object={courseInfoBean.getCourseID(),courseInfoBean.getCourseName(),majorInfoBean.getMajorName()
					};									
					tableModel.addRow(object);
				}
			}
	
		
		}
		
			
		table=new JTable(tableModel);
		
		JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
		searAllCourInfo.add(scrollPanel,BorderLayout.CENTER);
		searAllCourInfo.setSize(450,451);				
	}

}