updateclassinfohandler.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 UpdateClassInfoHandler
{
	private UpdateClassInfo updateClassInfo; 
	private JTextField field;
	private JComboBox[] comboBoxs;
	
	public UpdateClassInfoHandler(UpdateClassInfo updateClassInf)
	{
		this.updateClassInfo=updateClassInf;
		field=updateClassInfo.getField();
		comboBoxs=updateClassInfo.getComboBoxs();
		
		String sql1="select * from classInfo";   // where classID='"+comboBoxs[0].getSelectedItem().toString().trim()+"'";
		ClassInfoDAO classInfoDAO=new ClassInfoDAO();
		ArrayList classList=classInfoDAO.excuteQuery(sql1);
	
		ClassInfoBean classInfoBean=null;
		
		for(int i=0;i<classList.size();i++)
		{
			classInfoBean=(ClassInfoBean)classList.get(i);
			comboBoxs[0].addItem(classInfoBean.getClassID());
		}
	
		updateClassInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{				
							
					boolean BOK=false;	
					int flag=0;
					
					ClassInfoDAO classInfoDAO=new ClassInfoDAO();
			
					String sql2="";
				
					String text=comboBoxs[1].getSelectedItem().toString().trim();
					if(text.equals("班级名称"))
					{
						sql2="update classInfo set className='"+field.getText().trim()+"' where classID='"+comboBoxs[0].getSelectedItem().toString().trim()+"'";
						BOK=classInfoDAO.update(sql2);
					}
					
					if(text.equals("专业编号"))
					{
					
						System.out.println("修改的项是专业编号");
						String sql="select * from majorInfo";
						
						MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
						ArrayList majorList=majorInfoDAO.excuteQuery(sql);
						System.out.println("专业信息的个数"+majorList.size());
						MajorInfoBean majorInfoBean=null;
						
						for(int j=0;j<majorList.size();j++)
						{
							majorInfoBean=(MajorInfoBean)majorList.get(j);					
							System.out.println("专业编号是"+majorInfoBean.getMajorID().trim());
							
							if(majorInfoBean.getMajorID().trim().equals(field.getText().trim()))
							{
								flag=1;
								System.out.println("有该专业编号!");
								sql2="update classInfo set majorID='"+field.getText().trim()+"' where classID='"+comboBoxs[0].getSelectedItem().toString().trim()+"'";
								break;
							}																
						}
						
						
						if(flag==1)
						{
							BOK=majorInfoDAO.update(sql2);
						}
						
						if(flag==0)
						{
							JOptionPane.showMessageDialog(null,"不存在该专业!");
							//updateClassInfo.setVisible(false);	
						}
					}
					
					if(text.equals("状态"))
					{
						sql2="update classInfo set state='"+field.getText().trim()+"' where classID='"+comboBoxs[0].getSelectedItem().toString().trim()+"'";
						BOK=classInfoDAO.update(sql2);
					}
						
					
					if(BOK)
					{
						JOptionPane.showMessageDialog(null,"修改班级信息成功!");	
					}
					
					else
					{
						JOptionPane.showMessageDialog(null,"修改班级信息失败!");
					}											
		
					updateClassInfo.setVisible(false);
				}
				
			}
		);
	}
}