writescoreinfohandler.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 WriteScoreInfoHandler
{
	private WriteScoreInfo writeScoreInfo; 
	private JTextField[] fields;
	private JComboBox[] comboBoxs;
	private String id;
	
	private OpenCourseInfoBean openCourseInfoBean=null;
	
	public WriteScoreInfoHandler(WriteScoreInfo writeScoreInf,String Id)
	{
		this.writeScoreInfo=writeScoreInf;
		fields=writeScoreInfo.getFields();
		comboBoxs=writeScoreInfo.getComboBoxs();
		this.id=Id;
	
		for(int i=0;i<fields.length;i++)
		{ 		
			fields[i].addActionListener(				
				new ActionListener()
				{				
					public void actionPerformed(ActionEvent e)
					{
						for(int j=0;j<3;j++)
						{
							if(e.getSource()==fields[j])
							{
								if(j==2)							
									fields[0].grabFocus();				
								
								if(j>=0 && j<2)
									fields[j+1].grabFocus();								
							}
						}						
					}
				}
			);
		}		
		
		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;
						}
					}
				
				}
			}
		);
		
	
		writeScoreInfo.getButtonsPanel().getButton(0).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{	
					//表:学生学号、课程编号、学年、学期、成绩、教师编号、状态、备注
					
					//"课程编号      ","学生学号      ","分数      ","状态      ","备注      "
					boolean BOK=false;
					int flag=0;
					
					CourseScoreInfoDAO courseScoreInfoDAO=new CourseScoreInfoDAO();
					String sql3="select * from courseScoreInfo";
					
					ArrayList couScoList=courseScoreInfoDAO.excuteQuery(sql3);
					CourseScoreInfoBean courseScoreInfoBean=null;
					
					for(int i=0;i<couScoList.size();i++)
					{
						courseScoreInfoBean=(CourseScoreInfoBean)couScoList.get(i);
						
						if(courseScoreInfoBean.getStuID().trim().equals(comboBoxs[1].getSelectedItem().toString().trim()) && courseScoreInfoBean.getCourseID().trim().equals(comboBoxs[0].getSelectedItem().toString().trim()) && courseScoreInfoBean.getTeaID().trim().equals(id))
						{
							flag=1;
							break;
						}
					}
					
					
					if(flag==1)
					{
						JOptionPane.showMessageDialog(null,"该学生已有成绩!");
					}
					
					if(flag==0)
					{
						String sql4="insert into courseScoreInfo values('"+comboBoxs[1].getSelectedItem().toString().trim()+"','"+comboBoxs[0].getSelectedItem().toString().trim()+"','"+openCourseInfoBean.getOpenYear().trim()+"','"+openCourseInfoBean.getOpenXQ().trim()+"','"+fields[0].getText().trim()+"','"+id+"','"+fields[1].getText().trim()+"','"+fields[2].getText().trim()+"')";
						BOK=courseScoreInfoDAO.insert(sql4);
						
						if(BOK);
						{
							JOptionPane.showMessageDialog(null,"录入学生成绩成功!");
						}
					}					
					writeScoreInfo.setVisible(false);					
				}
			}
		);
		
		writeScoreInfo.getButtonsPanel().getButton(1).addActionListener
		(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					writeScoreInfo.setVisible(false);
				}
			}
		);
	}
	
	
	public static void main(String args[])
	{
		JFrame frame=new JFrame();
	    JDesktopPane desktopPane=new JDesktopPane();
	    WriteScoreInfo app=new WriteScoreInfo(frame,desktopPane,"t002");
	    
	    frame.setSize(500,500);
	    frame.setVisible(true);	    
	}
}