updatestuscoreinfohandler.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 UpdateStuScoreInfoHandler
{
	private UpdateStuScoreInfo updateStuScoreInfo; 	
	private JComboBox[] comboBoxs;
	private JTextField field;
	private String id;
	
	private OpenCourseInfoBean openCourseInfoBean=null;
	
	public UpdateStuScoreInfoHandler(UpdateStuScoreInfo updateStuScoreInf,String Id)
	{
		this.updateStuScoreInfo=updateStuScoreInf;		
		comboBoxs=updateStuScoreInfo.getComboBoxs();
		field=updateStuScoreInfo.getField();		
		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());
			}
		}
		
	
		//（7.开课信息
		//开课编号、课程编号、开课学年、开课学期、教师编号
		//8.课程成绩信息
		//学生学号、课程编号、学年、学期、成绩、教师编号、状态、备注
		//9.选课信息
		//学生学号、开课编号）
		
		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;
						}
					}
				
				}
			}
		);
		
	
		updateStuScoreInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{	
					//表:学生学号、课程编号、学年、学期、成绩、教师编号、状态、备注
					
					//"课程编号      ","学生学号      ","分数      ","状态      ","备注      "
					boolean BOK=false;
					int flag=0;
					String sql3="";
					
					CourseScoreInfoDAO courseScoreInfoDAO=new CourseScoreInfoDAO();
					
					String text=comboBoxs[2].getSelectedItem().toString().trim();
					
					if(text.equals("成绩"))
					{
						sql3="update courseScoreInfo set score='"+field.getText().trim()+"' where stuID='"+comboBoxs[1].getSelectedItem().toString()+"' and courseID='"+comboBoxs[0].getSelectedItem().toString()+"' and teaID='"+id+"'";
					}
					
					if(text.equals("状态"))
					{
						sql3="update courseScoreInfo set state='"+field.getText().trim()+"' where stuID='"+comboBoxs[1].getSelectedItem().toString()+"' and courseID='"+comboBoxs[0].getSelectedItem().toString()+"' and teaID='"+id+"'";
					}
					
					if(text.equals("备注"))
					{
						sql3="update courseScoreInfo set other='"+field.getText().trim()+"' where stuID='"+comboBoxs[1].getSelectedItem().toString()+"' and courseID='"+comboBoxs[0].getSelectedItem().toString()+"' and teaID='"+id+"'";
					
					}
					BOK=courseScoreInfoDAO.update(sql3);
					
					if(BOK)
					{
						JOptionPane.showMessageDialog(null,"修改学生成绩成功!");
					}
					
					else
					{
						JOptionPane.showMessageDialog(null,"修改学生成绩失败!");
					}
					
					updateStuScoreInfo.setVisible(false);			
				}
			}
		);
		
		updateStuScoreInfo.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					updateStuScoreInfo.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);	    
	}	
	

}