delclassinfohandler.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 DelClassInfoHandler
{
	private DelClassInfo delClassInfo; 
	private JTextField field;

	public DelClassInfoHandler(DelClassInfo delClassInf)
	{
		this.delClassInfo=delClassInf;
		field=delClassInfo.getField();
		
		delClassInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					ClassInfoDAO classInfoDAO=new ClassInfoDAO();
					String sql1="select * from classInfo where classID='"+field.getText().trim()+"'";
					
					ArrayList classList=classInfoDAO.excuteQuery(sql1);
					ClassInfoBean classInfoBean=null;
					if(classList.size()<=0)
					{
						JOptionPane.showMessageDialog(null,"不存在该班级!");		
					}
					
					else if(classList.size()>0)
					{
						int flag=0;	
						boolean BOK=false;
								
						//for(int i=0;i<classList.size();i++)
						//{
							classInfoBean=(ClassInfoBean)classList.get(0);					
						
							//if(classInfoBean.getClassID().trim().equals(field.getText().trim()))
							//{
								if(classInfoBean.getState().trim().equals("在编"))
								{
									JOptionPane.showMessageDialog(null,"该班级还没有毕业!");		
								}
								
								if(classInfoBean.getState().trim().equals("不在编"))
								{
									String sql2="delete * from classInfo where classID='"+field.getText().trim()+"'";
									
									
									BOK=classInfoDAO.delete(sql2);
									
									if(BOK)
									{
										StuInfoDAO stuInfoDAO=new StuInfoDAO();
										String sql3="select * from stuInfo";
										
										ArrayList stuList=stuInfoDAO.excuteQuery(sql3);
										StuInfoBean stuInfoBean=null;							
												
										for(int j=0;j<stuList.size();j++)
										{
											stuInfoBean=(StuInfoBean)stuList.get(j);					
										
											if(stuInfoBean.getClassID().trim().equals(field.getText().trim()))
											{
												//String sql4="delete * from stuInfo where classID='"+field.getText().trim()+"'";
											
												//BOK=stuInfoDAO.delete(sql4);
												String sql4="update stuInfo set delRecord='是' where classID='"+field.getText().trim()+"'";
												BOK=stuInfoDAO.update(sql4);
												if(BOK)
												{
													UsersDAO usersDAO=new UsersDAO();
													String sql5="select * from usersLogin";
											
													ArrayList usersList=usersDAO.excuteQuery(sql5);
													LoginBean loginBean=null;	
													for(int k=0;k<usersList.size();k++)
													{
														loginBean=(LoginBean)usersList.get(k);
														
														if(loginBean.getId().trim().equals(stuInfoBean.getStuID().trim()))
														{
														
															//String sql6="delete * from usersLogin where id='"+loginBean.getId().trim()+"'";
															//BOK=usersDAO.delete(sql6);
															String sql6="update usersLogin set delRecord='是' where id='"+loginBean.getId().trim()+"'";	
															BOK=usersDAO.update(sql6);
															if(BOK)
															{
																JOptionPane.showMessageDialog(null,"删除班级信息成功!");	
															}
														}
													}
												}
											
											}
											
										}
									}			
								
								}
							//}
													
					//	}
					
					}
				
				
					delClassInfo.setVisible(false);
				}
				
			}
		);
	}
}