addchoicecourseinfohandler.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 AddChoiceCourseInfoHandler
{
	private AddChoiceCourseInfo addChoiceCourseInfo; 
	
	private JComboBox comboBox;
	private String id;
	
	//private OpenCourseInfoBean openCourseInfoBean=null;
	
	public AddChoiceCourseInfoHandler(AddChoiceCourseInfo addChoiceCourInf,String Id)
	{
		this.addChoiceCourseInfo=addChoiceCourInf;
		
		comboBox=addChoiceCourseInfo.getComboBox();
		this.id=Id;

		comboBox.removeAllItems();					
		
		String sql1="select * from choiceCourseInfo";
		ChoiceCourseInfoDAO choiceCourseInfoDAO=new ChoiceCourseInfoDAO();
		ArrayList list=choiceCourseInfoDAO.excuteQuery(sql1);
		ArrayList choiceCourList=new ArrayList();
		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);	
				//System.out.println("开课编号="+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;
			}
		}
		
		addChoiceCourseInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{	
					//String sql3="select * from choiceCourseInfo";
					ChoiceCourseInfoDAO choiceCourseInfoDAO=new ChoiceCourseInfoDAO();
					//ArrayList list=choiceCourseInfoDAO.excuteQuery(sql1);
					//ArrayList choiceCourList=new ArrayList();
					//ChoiceCourseInfoBean choiceCourseInfoBean=null;					
					boolean BOK=false;
					String sql3="insert into choiceCourseInfo values('"+id+"','"+comboBox.getSelectedItem().toString().trim()+"')";
					BOK=choiceCourseInfoDAO.insert(sql3);
					if(BOK)
					{
						JOptionPane.showMessageDialog(null,"添加选课信息成功!");
					}
					
					else
					{
						JOptionPane.showMessageDialog(null,"添加选课信息失败!");
					}
					
					addChoiceCourseInfo.setVisible(false);
				}
			}
		);
		
		addChoiceCourseInfo.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					addChoiceCourseInfo.setVisible(false);
				}
			}
		);								
	}
}