delteainfohandler.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 DelTeaInfoHandler
{
	private DelTeaInfo delteaInfo; 
	private JTextField field;

	public DelTeaInfoHandler(DelTeaInfo delteaInf)
	{
		this.delteaInfo=delteaInf;
		field=delteaInfo.getField();
		
		delteaInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					TeaInfoDAO teaInfoDAO=new TeaInfoDAO();
					String sql1="select * from teaInfo where teaID='"+field.getText().trim()+"'";
					
					ArrayList teaList=teaInfoDAO.excuteQuery(sql1);
					TeaInfoBean teaInfoBean=null;
					
					if(teaList.size()<=0)
					{
						JOptionPane.showMessageDialog(null,"没有该教师!");
					}
					
					else
					{
						boolean BOK=false;
							
						//for(int i=0;i<teaList.size();i++)
						//{/
							teaInfoBean=(TeaInfoBean)teaList.get(0);					
						
							//if(teaInfoBean.getTeaID().trim().equals(field.getText().trim()))
							//{							
								if(teaInfoBean.getState().equals("在编"))
								{
									JOptionPane.showMessageDialog(null,"该教师在职!");
								}
								
								if(teaInfoBean.getState().equals("不在编"))
								{
									String sql2="update teaInfo set delRecord='是' where teaID='"+field.getText().trim()+"'";
									BOK=teaInfoDAO.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,"删除教师信息成功!");
										}
									}
								}
								
							//}						
					//	}
					}
				
					
					delteaInfo.setVisible(false);
				}
				
			}
		);
	}
}