searcourbymajornamehandler.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.*;


//可以按照专业名称、课程编号、课程名称查询课程信息。
//显示的课程信息包括：课程编号、课程名称、专业名称三个数据项
//数据库课程信息表中:courseID courseName majorID
public class SearCourByMajorNameHandler extends JInternalFrame
{
	private JTable table;
	//private JDesktopPane desktopPane;
	//private JFrame frame;
	//private String id;	
	
	private SearCourByMajorName searCourByMajorName;
	private JTextField field;	
	//private JPanel center;
	
	public SearCourByMajorNameHandler(SearCourByMajorName searCourByMajorNam)  //,String Id
	{
		//super("",true,true,true,true);
		//this.desktopPane=desktopPane;
		//this.frame=frame;
		//this.id=Id;
		this.searCourByMajorName=searCourByMajorNam;
		field=searCourByMajorName.getField();
		
		//center=new JPanel();		
		
		searCourByMajorName.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					String[] ccolumnNames={"课程编号(courseID)","课程名称(courseName)","专业名称(majorName)"
					};
		
					DefaultTableModel tableModel=new DefaultTableModel(ccolumnNames,0);		
					
					
					String sql1="select * from majorInfo";
					
					MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
					ArrayList list=majorInfoDAO.excuteQuery(sql1);
					MajorInfoBean majorInfoBean=null;
					
					
					int flag=0;
					
					for(int i=0;i<list.size();i++)
					{
						majorInfoBean=(MajorInfoBean)list.get(i);
						if(majorInfoBean.getMajorName().trim().equals(field.getText().trim()) && majorInfoBean.getState().trim().equals("在编"))
						{
							String sql2="select * from courseInfo";
					
							CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
							ArrayList courseList=courseInfoDAO.excuteQuery(sql2);
							CourseInfoBean courseInfoBean=null;
							
							for(int j=0;j<courseList.size();j++)
							{
								courseInfoBean=(CourseInfoBean)courseList.get(j);
								if(courseInfoBean.getMajorID().trim().equals(majorInfoBean.getMajorID().trim()))
								{
									String[] object={courseInfoBean.getCourseID(),courseInfoBean.getCourseName(),majorInfoBean.getMajorName()
									};
									tableModel.addRow(object);
									
									flag=1;
									
									System.out.println("GGGGGGGGGGGG");
								}
							}							
							break;
						}						
					}
					
					if(flag==0)
					{
						JOptionPane.showMessageDialog(null,"该专业没有开设课程!");
					}
					
					if(flag==1)
					{
						table=new JTable(tableModel);
						
						JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
						searCourByMajorName.add(scrollPanel,BorderLayout.CENTER);
						searCourByMajorName.setSize(450,451);
					}
				
				}
			}
		);	
		
		searCourByMajorName.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					searCourByMajorName.setVisible(false);
				}
			}
		);
	/*
		this.getContentPane().add(north,BorderLayout.NORTH);
		desktopPane.add(this);
		
		frame.add(desktopPane);
		
		this.setSize(400,400);
		//this.setLocation(100,100);
		this.setVisible(true);
		*/
	}

}