delmajorinfohandler.java

在本系统中

package jin.handler;

import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.util.*;

import jin.internalFrame.*;
import jin.dao.*;
import jin.bean.*;

public class DelMajorInfoHandler
{
	private DelMajorInfo delMajorInfo; 
	private JComboBox comboBox;

	public DelMajorInfoHandler(DelMajorInfo delMajorInf)
	{
		this.delMajorInfo=delMajorInf;
		comboBox=delMajorInfo.getComboBox();
		
		
		MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
		String sql1="select * from majorInfo";
		
		ArrayList majorList=majorInfoDAO.excuteQuery(sql1);
		MajorInfoBean majorInfoBean=null;
	
		for(int i=0;i<majorList.size();i++)
		{
			majorInfoBean=(MajorInfoBean)majorList.get(i);	
			comboBox.addItem(majorInfoBean.getMajorID());
		}				
		
		delMajorInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					ClassInfoDAO classInfoDAO=new ClassInfoDAO();
					String sql1="select * from classInfo";
					
					ArrayList classList=classInfoDAO.excuteQuery(sql1);
					ClassInfoBean classInfoBean=null;
					
					int flag=0;	
					boolean BOK=false;
							
					for(int i=0;i<classList.size();i++)
					{
						classInfoBean=(ClassInfoBean)classList.get(i);					
					
						if(classInfoBean.getMajorID().trim().equals(comboBox.getSelectedItem().toString().trim()))
						{
							StuInfoDAO stuInfoDAO=new StuInfoDAO();
							String sql2="select * from stuInfo";
							
							ArrayList stuList=stuInfoDAO.excuteQuery(sql2);
							StuInfoBean stuInfoBean=null;							
									
							for(int j=0;j<stuList.size();j++)
							{
								stuInfoBean=(StuInfoBean)stuList.get(j);					
							
								if(stuInfoBean.getClassID().trim().equals(classInfoBean.getClassID().trim()))
								{	
									if(stuInfoBean.getState().trim().equals("在编") && stuInfoBean.getDelRecord().trim().equals("否"))							
									flag=1;					
									break;
								}
							}						
							
							if(flag==1)
							{
								JOptionPane.showMessageDialog(null,"该专业信息的某个班级存在学生!");
								delMajorInfo.setVisible(false);							
							}						
						}						
					}
					
					if(flag==0)
					{
						String sql3="delete * from majorInfo where majorID='"+comboBox.getSelectedItem().toString().trim()+"'";
						MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
						BOK=majorInfoDAO.delete(sql3);
						if(BOK)
						{
							//ClassInfoDAO classInfoDAO=new ClassInfoDAO();
							//String sql1="select * from classInfo where classID='"+comboBox.getSelectedItem().toString().trim()+"'";
					
							//ArrayList classList=classInfoDAO.excuteQuery(sql1);
							//ClassInfoBean classInfoBean=null;
							
							for(int i=0;i<classList.size();i++)
							{
								classInfoBean=(ClassInfoBean)classList.get(i);					
						
								if(classInfoBean.getMajorID().trim().equals(comboBox.getSelectedItem().toString().trim()))
								{
									String sql4="delete * from classInfo where majorID='"+comboBox.getSelectedItem().toString().trim()+"'";
									BOK=classInfoDAO.delete(sql4);
														
								}
							}
							
							
							if(BOK)
							{
								JOptionPane.showMessageDialog(null,"删除专业信息成功!");	
							}
						}
					}
				
					delMajorInfo.setVisible(false);
				}
				
			}
		);
	}
}