updatemajorinfohandler.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 UpdateMajorInfoHandler
{
	private UpdateMajorInfo updateMajorInfo; 
	private JTextField field;
	private JComboBox[] comboBoxs;
	
	public UpdateMajorInfoHandler(UpdateMajorInfo updateMajorInf)
	{
		this.updateMajorInfo=updateMajorInf;
		field=updateMajorInfo.getField();
		comboBoxs=updateMajorInfo.getComboBoxs();
		
		String sql1="select * from majorInfo";
		MajorInfoDAO majorInfoDAO=new MajorInfoDAO();
		ArrayList majorList=majorInfoDAO.excuteQuery(sql1);
		MajorInfoBean majorInfoBean=null;
	
		for(int i=0;i<majorList.size();i++)
		{
			majorInfoBean=(MajorInfoBean)majorList.get(i);
			comboBoxs[0].addItem(majorInfoBean.getMajorID());
		}		
		
		
		updateMajorInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{			
					boolean BOK=false;	
				
					String sql2="";
					
					if(comboBoxs[1].getSelectedItem().toString().trim().equals("专业名称"))
					{
						sql2="update majorInfo set majorName='"+field.getText().trim()+"' where majorID='"+comboBoxs[0].getSelectedItem().toString().trim()+"'";
					}
					
					if(comboBoxs[1].getSelectedItem().toString().trim().equals("所属院系"))
					{
						sql2="update majorInfo set belongTo='"+field.getText().trim()+"' where majorID='"+comboBoxs[0].getSelectedItem().toString().trim()+"'";
					}
					
					
					if(comboBoxs[1].getSelectedItem().toString().trim().equals("状态"))
					{
						sql2="update majorInfo set state='"+field.getText().trim()+"' where majorID='"+comboBoxs[0].getSelectedItem().toString().trim()+"'";
					}
										
					MajorInfoDAO majorInfoDAO=new MajorInfoDAO();		
					BOK=majorInfoDAO.update(sql2);
					
					if(BOK)
					{
						JOptionPane.showMessageDialog(null,"修改专业信息成功!");	
					}
					
					else
					{
						JOptionPane.showMessageDialog(null,"修改专业信息失败!");	
					}											
				
					updateMajorInfo.setVisible(false);
				}
				
			}
		);
	}
}