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

	private SearTeaInfoByTeaName searTeaInfoByTeaName;
	private JTextField field;
	
	public SearTeaInfoByTeaNameHandler(SearTeaInfoByTeaName searTeaInfoByTeaNa)  //,String Id
	{
		this.searTeaInfoByTeaName=searTeaInfoByTeaNa;
		field=searTeaInfoByTeaName.getField();
	
		searTeaInfoByTeaName.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					String[] ccolumnNames={"教师编号","教师姓名","专业名称","院系名称"
					};
		
					DefaultTableModel tableModel=new DefaultTableModel(ccolumnNames,0);		
					
					String sql1="select * from teaInfo";
					
					TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
					ArrayList teaList=teaInfoDAO.excuteQuery(sql1);
					TeaInfoBean teaInfoBean=null;
					int flag=0;
					
					//用到教师、 专业信息
					for(int j=0;j<teaList.size();j++)
					{
						teaInfoBean=(TeaInfoBean)teaList.get(j);
						if(teaInfoBean.getTeaName().trim().equals(field.getText().trim()))  //&& courseInfoBean.getState().trim().equals("在编")
						{
							String sql2="select * from majorInfo";
				
							MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
							ArrayList majorlist=majorInfoDAO.excuteQuery(sql2);
							MajorInfoBean majorInfoBean=null;
					
							for(int i=0;i<majorlist.size();i++)
							{
								majorInfoBean=(MajorInfoBean)majorlist.get(i);
								if(majorInfoBean.getMajorID().trim().equals(teaInfoBean.getMajorID().trim()))
								{
									
									String[] object={teaInfoBean.getTeaID(),teaInfoBean.getTeaName(),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);
						searTeaInfoByTeaName.add(scrollPanel,BorderLayout.CENTER);
						searTeaInfoByTeaName.setSize(450,451);			
					}			
						
				}
			}
		);	
		
		searTeaInfoByTeaName.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					searTeaInfoByTeaName.setVisible(false);
				}
			}
		);

	}

}