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

	private SearOpenCourInfoByMajorID searOpenCourInfoByMajorID;
	private JComboBox comboBox;

	public SearOpenCourInfoByMajorIDHandler(SearOpenCourInfoByMajorID searOpenCourInfByMajorID)  //,String Id
	{
		this.searOpenCourInfoByMajorID=searOpenCourInfByMajorID;
		comboBox=searOpenCourInfoByMajorID.getComboBox();
		
		String sql1="select * from majorInfo";
		MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
		ArrayList majorlist=majorInfoDAO.excuteQuery(sql1);
		MajorInfoBean majorInfoBean=null;
		
		for(int i=0;i<majorlist.size();i++)
		{
			majorInfoBean=(MajorInfoBean)majorlist.get(i);
			comboBox.addItem(majorInfoBean.getMajorID());		
		}		
		
		searOpenCourInfoByMajorID.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{	
					String[] columnNames={"开课编号","课程名称","学期","学年","教师姓名"};
					DefaultTableModel tableModel=new DefaultTableModel(columnNames,0);	
					
					//int flag=0;				
					String sql1="select * from courseInfo where majorID='"+comboBox.getSelectedItem().toString().trim()+"'";
					CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
					ArrayList courlist=courseInfoDAO.excuteQuery(sql1);
					CourseInfoBean courseInfoBean=null; 
					
					for(int i=0;i<courlist.size();i++)
					{
						courseInfoBean=(CourseInfoBean)courlist.get(i);
						System.out.println("课程编号:"+courseInfoBean.getCourseID());
						
						String sql2="select * from openCourseInfo where courseID='"+courseInfoBean.getCourseID().trim()+"'";
						OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
						ArrayList openCourList=openCourseInfoDAO.excuteQuery(sql2);
						
						if(openCourList!=null && openCourList.size()>0)
						{
							System.out.println("执行");
							OpenCourseInfoBean openCourseInfoBean=(OpenCourseInfoBean)openCourseInfoDAO.excuteQuery(sql2).get(0);
							
							String sql3="select * from teaInfo where teaID='"+openCourseInfoBean.getTeaID()+"'";
							TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
						//	ArrayList courScolist=courseScoreInfoDAO.excuteQuery(sql2);
							TeaInfoBean teaInfoBean=(TeaInfoBean)teaInfoDAO.excuteQuery(sql3).get(0);
							
							String[] object={openCourseInfoBean.getOpenCourseID().trim(),courseInfoBean.getCourseName(),openCourseInfoBean.getOpenXQ(),openCourseInfoBean.getOpenYear(),teaInfoBean.getTeaName()
							};
							tableModel.addRow(object);							
						}
						
						else 
						{							
							JOptionPane.showMessageDialog(null,"该专业还没有开课信息!");
							searOpenCourInfoByMajorID.setVisible(false);	
						}
					}
					
					
					table=new JTable(tableModel);
			
					JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
					searOpenCourInfoByMajorID.add(scrollPanel,BorderLayout.CENTER);
					searOpenCourInfoByMajorID.setSize(450,451);
				}
			
			}
		);	
		
		searOpenCourInfoByMajorID.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					searOpenCourInfoByMajorID.setVisible(false);	
				}
			}
		);	
	}
}