searclassinfobymajornamehandler.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 SearClassInfoByMajorNameHandler extends JInternalFrame
{
	private JTable table;
	
	private DefaultTableModel tableModel;
	
	private SearClassInfoByMajorName searClassInfoByMajorName;
	private JTextField field;	
	
	public SearClassInfoByMajorNameHandler(SearClassInfoByMajorName searClassInfoByMajorNa)  //,String Id
	{
		this.searClassInfoByMajorName=searClassInfoByMajorNa;
		field=searClassInfoByMajorName.getField();
	
		searClassInfoByMajorName.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					int flag=0;
					
					String[] ccolumnNames={"班级编号","班级名称","专业名称","院系名称"
					};
		
					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 classInfo";
					
							ClassInfoDAO classInfoDAO=new ClassInfoDAO();
							ArrayList classList=classInfoDAO.excuteQuery(sql2);
							ClassInfoBean classInfoBean=null;
							
							for(int j=0;j<classList.size();j++)
							{
								classInfoBean=(ClassInfoBean)classList.get(j);
								if(classInfoBean.getMajorID().trim().equals(majorInfoBean.getMajorID().trim()))
								{
									String[] object={classInfoBean.getClassID(),classInfoBean.getClassName(),majorInfoBean.getMajorName(),majorInfoBean.getBelongTo()
									};
									tableModel.addRow(object);
									//flag=1;
								}
							}						
						}
						
						if(majorInfoBean.getMajorName().trim().equals(field.getText().trim()))
						{
							if(majorInfoBean.getState().trim().equals("不在编"))	
							{
								flag=1;
								JOptionPane.showMessageDialog(null,"该专业没有开设!");
							}
						}
						
					}
					
					if(flag!=1)
					{
						table=new JTable(tableModel);
					
						JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
						searClassInfoByMajorName.add(scrollPanel,BorderLayout.CENTER);
						searClassInfoByMajorName.setSize(450,451);
					}
				
				}
			}
		);	
		
		searClassInfoByMajorName.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					//table.removeColumnSelectionInterval(0,3);
					//table.remove(tableModel);
					//table.removeAll();
					//searClassInfoByMajorName.setVisible(false);
					//table.getColumnModel()
					searClassInfoByMajorName.setVisible(false);
				}
			}
		);
	}
}