delstuinfohandler.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 DelStuInfoHandler
{
	private DelStuInfo delStuInfo; 
	private JTextField field;

	public DelStuInfoHandler(DelStuInfo delStuInf)
	{
		this.delStuInfo=delStuInf;
		field=delStuInfo.getField();
		
		delStuInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					StuInfoDAO stuInfoDAO=new StuInfoDAO();
					String sql1="select * from stuInfo where stuID='"+field.getText().trim()+"'";
					
					ArrayList stuList=stuInfoDAO.excuteQuery(sql1);
					StuInfoBean stuInfoBean=null;
					
					if(stuList.size()<=0)
					{
						JOptionPane.showMessageDialog(null,"没有该学生!");
					}
					//int flag=0;	
					else
					{
						boolean BOK=false;
								
						//for(int i=0;i<stuList.size();i++)
						//{
							stuInfoBean=(StuInfoBean)stuList.get(0);					
						
							//if(stuInfoBean.getStuID().trim().equals(field.getText().trim()))
							//{							
								if(stuInfoBean.getState().equals("在编"))
								{
									JOptionPane.showMessageDialog(null,"该学生没有退学!");
								}
								
								if(stuInfoBean.getState().equals("不在编"))
								{
									String sql2="update stuInfo set delRecord='是' where stuID='"+field.getText().trim()+"'";
									BOK=stuInfoDAO.update(sql2);
									if(BOK)
									{
										BOK=false;
										UsersDAO usersDAO=new UsersDAO();
										String sql3="update usersLogin set delRecord='是' where id='"+field.getText().trim()+"'";
										BOK=usersDAO.update(sql3);
										if(BOK)
										{
											JOptionPane.showMessageDialog(null,"删除学生信息成功!");
										}
									}
								}
								
							//}						
						//}
					
					}					
				
					delStuInfo.setVisible(false);
				}
				
			}
		);
	}
}