searallstuinfohandler.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 SearAllStuInfoHandler extends JInternalFrame
{
	private JTable table;	
	
	private SearAllStuInfo searAllStuInfo;	
	
	public SearAllStuInfoHandler(SearAllStuInfo searAllStuInf)  //,String Id
	{
		this.searAllStuInfo=searAllStuInf;		
	
		
		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;

		for(int i=0;i<stulist.size();i++)
		{
			stuInfoBean=(StuInfoBean)stulist.get(i);
			
			String sql2="select * from classInfo";
	
			ClassInfoDAO classInfoDAO=new ClassInfoDAO();
			ArrayList classList=classInfoDAO.excuteQuery(sql2);
			ClassInfoBean classInfoBean=null;
			
			for(int j=0;j<classList.size();j++)
			{
				classInfoBean=(ClassInfoBean)classList.get(j);
				if(classInfoBean.getClassID().trim().equals(stuInfoBean.getClassID().trim()) && stuInfoBean.getDelRecord().trim().equals("否")) 
				{
					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);
						}
					}
				}
			}		
		}
		
			
		table=new JTable(tableModel);
		
		JScrollPane scrollPanel=new JScrollPane(table,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
		searAllStuInfo.add(scrollPanel,BorderLayout.CENTER);
		searAllStuInfo.setSize(450,451);					
			
	}

}