delopencourseinfohandler.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.*;

//（7.开课信息
//开课编号、课程编号、开课学年、开课学期、教师编号
public class DelOpenCourseInfoHandler
{
	private DelOpenCourseInfo delOpenCourseInfo; 	
	private JComboBox comboBox;
	
	private String id;
	
	private OpenCourseInfoBean openCourseInfoBean=null;
	
	public DelOpenCourseInfoHandler(DelOpenCourseInfo delOpenCourseInf,String Id)
	{
		this.delOpenCourseInfo=delOpenCourseInf;		
		comboBox=delOpenCourseInfo.getComboBox();
			
		this.id=Id;
	
	
		String sql="select * from openCourseInfo";
		OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
		ArrayList openCourseList=openCourseInfoDAO.excuteQuery(sql);
	//	OpenCourseInfoBean openCourseInfoBean=null;
		
		for(int i=0;i<openCourseList.size();i++)
		{
			openCourseInfoBean=(OpenCourseInfoBean)openCourseList.get(i);
			if(openCourseInfoBean.getTeaID().trim().equals(id))
			{
				comboBox.addItem(openCourseInfoBean.getCourseID().trim());
			}
		}
		
	
		/*
		comboBox.addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					comboBoxs[1].removeAllItems();
					
					
					String sql1="select * from openCourseInfo";
					OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
					ArrayList list=openCourseInfoDAO.excuteQuery(sql1);
					//OpenCourseInfoBean openCourseInfoBean=null;
					
					boolean BOK=false;
					
					for(int i=0;i<list.size();i++)
					{
						openCourseInfoBean=(OpenCourseInfoBean)list.get(i);
						if(openCourseInfoBean.getTeaID().trim().equals(id) && comboBox.getSelectedItem().toString().equals(openCourseInfoBean.getCourseID().trim()))
						{
							String sql2="delete * from openCourseInfo";
							OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
							ArrayList choiceList=choiceCourseInfoDAO.excuteQuery(sql2);
							ChoiceCourseInfoBean choiceCourseInfoBean=null;
							for(int j=0;j<choiceList.size();j++)
							{
								choiceCourseInfoBean=(ChoiceCourseInfoBean)choiceList.get(j);
								if(choiceCourseInfoBean.getOpenCourseID().trim().equals(openCourseInfoBean.getOpenCourseID().trim()))
								{									
									comboBoxs[1].addItem(choiceCourseInfoBean.getStuID().trim());								
								}
							}
							
							break;
						}
					}
				
				}
			}
		);
		*/
		
		//（7.开课信息
		//开课编号、课程编号、开课学年、开课学期、教师编号	
		delOpenCourseInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{					
					String sql1="select * from openCourseInfo";
					OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
					ArrayList list=openCourseInfoDAO.excuteQuery(sql1);
					//OpenCourseInfoBean openCourseInfoBean=null;
					
					boolean BOK=false;
					
					for(int i=0;i<list.size();i++)
					{
						openCourseInfoBean=(OpenCourseInfoBean)list.get(i);
						if(openCourseInfoBean.getTeaID().trim().equals(id) && comboBox.getSelectedItem().toString().equals(openCourseInfoBean.getCourseID().trim()))
						{
							String sql2="delete * from openCourseInfo where openCourseID='"+openCourseInfoBean.getOpenCourseID()+"'";
						//	OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
							
							BOK=openCourseInfoDAO.delete(sql2);
							
							if(BOK)
							{
								JOptionPane.showMessageDialog(null,"删除开课信息成功!");
							}
							
							else
							{
								JOptionPane.showMessageDialog(null,"删除开课信息失败!");
							}
					
						}
					}
					
				
					delOpenCourseInfo.setVisible(false);			
				}
			}
		);
		
		delOpenCourseInfo.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					delOpenCourseInfo.setVisible(false);
				}
			}
		);
	}
	
	public static void main(String args[])
	{
		JFrame frame=new JFrame();
	    JDesktopPane desktopPane=new JDesktopPane();
	    UpdateStuScoreInfo app=new UpdateStuScoreInfo(frame,desktopPane,"t002");
	    
	    frame.setSize(500,500);
	    frame.setVisible(true);	    
	}	
	

}