searallteainfohandler.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 SearAllTeaInfoHandler extends JInternalFrame
{
	private JTable table;	
	
	private SearAllTeaInfo searAllTeaInfo;	
	
	public SearAllTeaInfoHandler(SearAllTeaInfo searAllTeaInf)  //,String Id
	{
		this.searAllTeaInfo=searAllTeaInf;		
	
		
		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;

		for(int i=0;i<tealist.size();i++)
		{
			teaInfoBean=(TeaInfoBean)tealist.get(i);
			
			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(teaInfoBean.getMajorID().trim()) && teaInfoBean.getDelRecord().trim().equals("否"))
				{					
					String[] object={teaInfoBean.getTeaID(),teaInfoBean.getTeaName(),majorInfoBean.getMajorName(),majorInfoBean.getBelongTo()
					};									
					tableModel.addRow(object);	
				}
			}		
		}
		
			
		table=new JTable(tableModel);
		
		JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
		searAllTeaInfo.add(scrollPanel,BorderLayout.CENTER);
		searAllTeaInfo.setSize(450,451);					
			
	}

}