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

	private SearStuInfoByStuName searStuInfoByStuName;
	private JTextField field;
	
	public SearStuInfoByStuNameHandler(SearStuInfoByStuName searStuInfoByStuNa)  //,String Id
	{
		this.searStuInfoByStuName=searStuInfoByStuNa;
		field=searStuInfoByStuName.getField();
	
		searStuInfoByStuName.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					String[] ccolumnNames={"学生学号","学生姓名","班级名称","专业名称","院系名称"
					};
		
					DefaultTableModel tableModel=new DefaultTableModel(ccolumnNames,0);		
					
					String sql1="select * from stuInfo";
					
					StuInfoDAO stuInfoDAO=new StuInfoDAO();
					ArrayList stuList=stuInfoDAO.excuteQuery(sql1);
					StuInfoBean stuInfoBean=null;
					int flag=0;
					
					//用到学生 班级 专业信息
					for(int j=0;j<stuList.size();j++)
					{
						stuInfoBean=(StuInfoBean)stuList.get(j);
						if(stuInfoBean.getStuName().trim().equals(field.getText().trim()))  //&& courseInfoBean.getState().trim().equals("在编")
						{
							String sql2="select * from classInfo";
				
							ClassInfoDAO classInfoDAO=new ClassInfoDAO();
							ArrayList classlist=classInfoDAO.excuteQuery(sql2);
							ClassInfoBean classInfoBean=null;
							
							for(int i=0;i<classlist.size();i++)
							{
								classInfoBean=(ClassInfoBean)classlist.get(i);
								if(classInfoBean.getClassID().trim().equals(stuInfoBean.getClassID().trim()))
								{
									String sql3="select * from majorInfo";
				
									MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
									ArrayList majorlist=majorInfoDAO.excuteQuery(sql3);
									MajorInfoBean majorInfoBean=null;
									
									for(int k=0;k<majorlist.size();k++)
									{
										majorInfoBean=(MajorInfoBean)majorlist.get(k);
										{
											if(majorInfoBean.getMajorID().trim().equals(classInfoBean.getMajorID().trim()))
											{
												String[] object={stuInfoBean.getStuID(),stuInfoBean.getStuName(),classInfoBean.getClassName(),majorInfoBean.getMajorName(),majorInfoBean.getBelongTo()
												};
												tableModel.addRow(object);
												//break;
											}
										}
									}
									//break;								
								}							
							}
							
							flag=1;							
						}
						//break;
					}
					
					if(flag==0)
					{
						JOptionPane.showMessageDialog(null,"没有该学生!");
						searStuInfoByStuName.setVisible(false);
					}
					
					if(flag==1)
					{
						table=new JTable(tableModel);
					
						JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
						searStuInfoByStuName.add(scrollPanel,BorderLayout.CENTER);
						searStuInfoByStuName.setSize(450,451);
					}		
									
				}
			}
		);	
		
		searStuInfoByStuName.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					searStuInfoByStuName.setVisible(false);
				}
			}
		);

	}

}