updatestuinfohandler.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 UpdateStuInfoHandler
{
	private UpdateStuInfo updateStuInfo; 
	private JTextField field;
	private JComboBox[] comboBoxs;
	
	public UpdateStuInfoHandler(UpdateStuInfo updateStuInf)
	{
		this.updateStuInfo=updateStuInf;
		field=updateStuInfo.getField();
		comboBoxs=updateStuInfo.getComboBoxs();
		
		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);
			comboBoxs[0].addItem(stuInfoBean.getStuID());
		}
						
		updateStuInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{			
					boolean BOK=false;	
					int flag=0;
					
					StuInfoDAO stuInfoDAO=new StuInfoDAO();
				
					String sql2="";
				
					String text=comboBoxs[1].getSelectedItem().toString().trim();
					if(text.equals("姓名"))
					{
						System.out.println("执行");
						sql2="update stuInfo set stuName='"+field.getText().trim()+"' where stuID='"+comboBoxs[0].getSelectedItem().toString().trim()+"'";
						BOK=stuInfoDAO.update(sql2);
					}
					
					if(text.equals("班级编号"))
					{
						String sql="select * from classInfo";
						
						ClassInfoDAO classInfoDAO=new ClassInfoDAO();
						ArrayList classList=classInfoDAO.excuteQuery(sql);
						
						
						ClassInfoBean classInfoBean=null;
						
						for(int j=0;j<classList.size();j++)
						{
							classInfoBean=(ClassInfoBean)classList.get(j);					
							System.out.println("班级编号是"+classInfoBean.getClassID().trim());
							
							if(classInfoBean.getClassID().trim().equals(field.getText().trim()))
							{
								flag=1;
							
								sql2="update stuInfo set classID='"+field.getText().trim()+"' where stuID='"+comboBoxs[0].getSelectedItem().toString().trim()+"'";
								break;
							}
						}
						
						
						if(flag==1)
						{
							BOK=stuInfoDAO.update(sql2);
	
						}
						
						if(flag==0)
						{
							JOptionPane.showMessageDialog(null,"不存在该班级!");	
						}
					}
					
					if(text.equals("状态"))
					{
						sql2="update stuInfo set state='"+field.getText().trim()+"' where stuID='"+comboBoxs[0].getSelectedItem().toString().trim()+"'";
						BOK=stuInfoDAO.update(sql2);
					}
						
					if(text.equals("删除标记"))
					{
						sql2="update stuInfo set delRecord='"+field.getText().trim()+"' where stuID='"+comboBoxs[0].getSelectedItem().toString().trim()+"'";
						BOK=stuInfoDAO.update(sql2);
					}
					if(BOK)
					{
						JOptionPane.showMessageDialog(null,"修改学生信息成功!");	
					}
					
					else
					{
						JOptionPane.showMessageDialog(null,"修改学生信息失败!");
					}											
				
					updateStuInfo.setVisible(false);
				}
				
			}
		);
	}
}