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

	private SearClassInfoByClassName searClassInfoByClassName;
	private JTextField field;
	
	//private DefaultTableModel tableModel;
///	private String[] columnNames={"班级编号","班级名称","专业名称","院系名称"};
		
	
	public SearClassInfoByClassNameHandler(SearClassInfoByClassName searClassInfByClassNa)  //,String Id
	{
		this.searClassInfoByClassName=searClassInfByClassNa;
		field=searClassInfoByClassName.getField();
	
		searClassInfoByClassName.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{	
					String[] columnNames={"班级编号","班级名称","专业名称","院系名称"};
					DefaultTableModel tableModel=new DefaultTableModel(columnNames,0);	
							
					String sql1="select * from classInfo";
					ClassInfoDAO classInfoDAO=new ClassInfoDAO();
					ArrayList classlist=classInfoDAO.excuteQuery(sql1);
					ClassInfoBean classInfoBean=null;
					int flag=0;
					
					for(int i=0;i<classlist.size();i++)
					{
						classInfoBean=(ClassInfoBean)classlist.get(i);
						if(classInfoBean.getClassName().trim().equals(field.getText().trim()))
						{
							String sql2="select * from majorInfo";
		
							MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
							ArrayList majorlist=majorInfoDAO.excuteQuery(sql2);
							MajorInfoBean majorInfoBean=null;
							
							for(int j=0;j<majorlist.size();j++)
							{
								majorInfoBean=(MajorInfoBean)majorlist.get(j);
								{
									if(majorInfoBean.getMajorID().trim().equals(classInfoBean.getMajorID().trim()))
									{
										String[] object={classInfoBean.getClassID(),classInfoBean.getClassName(),majorInfoBean.getMajorName(),majorInfoBean.getBelongTo()
										};
										tableModel.addRow(object);
										flag=1;									
									}
								}
							}						
						}
					}
					
					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);
						searClassInfoByClassName.add(scrollPanel,BorderLayout.CENTER);
						searClassInfoByClassName.setSize(450,451);	
					}
					
								
				}
			
			}
		);	
		
		searClassInfoByClassName.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					searClassInfoByClassName.setVisible(false);	
				}
			}
		);		
		
		
	}

}