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

	private SearMajInfoByMajID searMajInfoByMajID;
	private JTextField field;
	
	public SearMajInfoByMajIDHandler(SearMajInfoByMajID searMajInfByMajID)  //,String Id
	{
		this.searMajInfoByMajID=searMajInfByMajID;
		field=searMajInfoByMajID.getField();
	
		searMajInfoByMajID.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					String[] ccolumnNames={"专业编号","专业名称","院系名称"
					};
		
					DefaultTableModel tableModel=new DefaultTableModel(ccolumnNames,0);		
					
					String sql1="select * from majorInfo";
				
					MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
					ArrayList majorlist=majorInfoDAO.excuteQuery(sql1);
					MajorInfoBean majorInfoBean=null;
					int flag=0;
					
					for(int k=0;k<majorlist.size();k++)
					{
						majorInfoBean=(MajorInfoBean)majorlist.get(k);
						{
							if(majorInfoBean.getMajorID().trim().equals(field.getText().trim()))
							{
								String[] object={majorInfoBean.getMajorID(),majorInfoBean.getMajorName(),majorInfoBean.getBelongTo()
								};
								tableModel.addRow(object);
								flag=1;
								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);
						searMajInfoByMajID.add(scrollPanel,BorderLayout.CENTER);
						searMajInfoByMajID.setSize(450,451);	
					}		
								
				}
			}
		);	
		
		searMajInfoByMajID.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					searMajInfoByMajID.setVisible(false);
				}
			}
		);

	}

}