delstuscoreinfohandler.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.开课信息
//开课编号、课程编号、开课学年、开课学期、教师编号
//8.课程成绩信息
//学生学号、课程编号、学年、学期、成绩、教师编号、状态、备注
//9.选课信息
//学生学号、开课编号）
public class DelStuScoreInfoHandler
{
	private DelStuScoreInfo delStuScoreInfo; 	
	private JComboBox[] comboBoxs;
	
	private String id;
	
	private OpenCourseInfoBean openCourseInfoBean=null;
	
	public DelStuScoreInfoHandler(DelStuScoreInfo delStuScoreInf,String Id)
	{
		this.delStuScoreInfo=delStuScoreInf;		
		comboBoxs=delStuScoreInfo.getComboBoxs();
			
		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))
			{
				comboBoxs[0].addItem(openCourseInfoBean.getCourseID().trim());
			}
		}
		
		
		comboBoxs[0].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;					
					
					for(int i=0;i<list.size();i++)
					{
						openCourseInfoBean=(OpenCourseInfoBean)list.get(i);
						if(openCourseInfoBean.getTeaID().trim().equals(id) && comboBoxs[0].getSelectedItem().toString().equals(openCourseInfoBean.getCourseID().trim()))
						{
							String sql2="select * from choiceCourseInfo";
							ChoiceCourseInfoDAO choiceCourseInfoDAO=new ChoiceCourseInfoDAO();
							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.开课信息
		//开课编号、课程编号、开课学年、开课学期、教师编号
		//8.课程成绩信息
		//学生学号、课程编号、学年、学期、成绩、教师编号、状态、备注
		//9.选课信息
		//学生学号、开课编号）
		delStuScoreInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{					
					String sql3="select * from CourseScoreInfo";
					CourseScoreInfoDAO courseScoreInfoDAO=new CourseScoreInfoDAO();
					ArrayList list=courseScoreInfoDAO.excuteQuery(sql3);
					CourseScoreInfoBean courseScoreInfoBean=null;
					
					boolean BOK=false;
					
					for(int i=0;i<list.size();i++)
					{
						courseScoreInfoBean=(CourseScoreInfoBean)list.get(i);
						if(courseScoreInfoBean.getTeaID().trim().equals(id) && comboBoxs[0].getSelectedItem().toString().trim().equals(courseScoreInfoBean.getCourseID().trim()) && comboBoxs[1].getSelectedItem().toString().trim().equals(courseScoreInfoBean.getStuID().trim()))
						{							
							String sql4="delete * from courseScoreInfo where stuID='"+comboBoxs[1].getSelectedItem().toString().trim()+"'and CourseID='"+comboBoxs[0].getSelectedItem().toString().trim()+"' and teaID='"+id+"'";
						//	OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
							
							BOK=courseScoreInfoDAO.delete(sql4);
							
							if(BOK)
							{
								JOptionPane.showMessageDialog(null,"删除学生成绩信息成功!");
							}
							
							else
							{
								JOptionPane.showMessageDialog(null,"删除学生成绩信息失败!");
							}
						
						}
					}
					
				
					delStuScoreInfo.setVisible(false);			
				}
			}
		);
		
		delStuScoreInfo.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					delStuScoreInfo.setVisible(false);
				}
			}
		);
	}
	
		public static void main(String args[])
	{
		JFrame frame=new JFrame();
	    JDesktopPane desktopPane=new JDesktopPane();
	    DelStuScoreInfo app=new DelStuScoreInfo(frame,desktopPane,"t002");
	    
	    frame.setSize(500,500);
	    frame.setVisible(true);	    
	}


}