delchoicecourseinfohandler.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 DelChoiceCourseInfoHandler
{
	private DelChoiceCourseInfo delChoiceCourseInfo; 
	
	private JComboBox comboBox;
	private String id;
	
	//private OpenCourseInfoBean openCourseInfoBean=null;
	
	public DelChoiceCourseInfoHandler(DelChoiceCourseInfo delChoiceCourseInf,String Id)
	{
		this.delChoiceCourseInfo=delChoiceCourseInf;
		
		comboBox=delChoiceCourseInfo.getComboBox();
		this.id=Id;

		comboBox.removeAllItems();					
		
		String sql1="select * from choiceCourseInfo";
		ChoiceCourseInfoDAO choiceCourseInfoDAO=new ChoiceCourseInfoDAO();
		ArrayList list=choiceCourseInfoDAO.excuteQuery(sql1);
		
		//本人已经选了哪些课		
		
		ChoiceCourseInfoBean choiceCourseInfoBean=null;					
		
		for(int i=0;i<list.size();i++)
		{			
			choiceCourseInfoBean=(ChoiceCourseInfoBean)list.get(i);
			if(choiceCourseInfoBean.getStuID().trim().equals(id))
			{
				//choiceCourList.add(choiceCourseInfoBean);
					
				comboBox.addItem(choiceCourseInfoBean.getOpenCourseID());
			}
		}		
		//System.out.println(choiceCourList.size());
		
		/*
		int flag=0;
		String sql2="select * from openCourseInfo";
		OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
		ArrayList openCourseList=openCourseInfoDAO.excuteQuery(sql2);
		OpenCourseInfoBean openCourseInfoBean=null;	
		for(int i=0;i<openCourseList.size();i++)
		{
			openCourseInfoBean=(OpenCourseInfoBean)openCourseList.get(i);
			System.out.println("开课信息表中:开课编号="+openCourseInfoBean.getOpenCourseID());
			for(int j=0;j<choiceCourList.size();j++)
			{
				choiceCourseInfoBean=(ChoiceCourseInfoBean)choiceCourList.get(j);
				System.out.println("本人选课的:开课编号:"+choiceCourseInfoBean.getOpenCourseID());
				if(openCourseInfoBean.getOpenCourseID().trim().equals(choiceCourseInfoBean.getOpenCourseID().trim()))
				{
					flag=1;
					break;				
				}
			}
			
			if(flag==0)
			{
				
				comboBox.addItem(openCourseInfoBean.getOpenCourseID());
			}
			
			if(flag==1)
			{
				flag=0;
			}
		}
		*/
		delChoiceCourseInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{					
					ChoiceCourseInfoDAO choiceCourseInfoDAO=new ChoiceCourseInfoDAO();
										
					boolean BOK=false;
					String sql3="delete * from choiceCourseInfo where stuID='"+id+"' and openCourseID='"+comboBox.getSelectedItem().toString()+"'";
					BOK=choiceCourseInfoDAO.delete(sql3);
					if(BOK)
					{
						JOptionPane.showMessageDialog(null,"删除选课信息成功!");
					}
					
					else
					{
						JOptionPane.showMessageDialog(null,"删除选课信息失败!");
					}
					
					delChoiceCourseInfo.setVisible(false);
				}
			}
		);
		
		delChoiceCourseInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)	
				{
					delChoiceCourseInfo.setVisible(false);
				}
			}
		);						
	}
}