studenthandler.java

在本系统中

//选课信息（学生的）、


package jin.handler;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.util.*;

import jin.student.*;
import jin.internalFrame.*;
import jin.dao.*;
import jin.bean.*;
//import jin.table.*;


public class StudentHandler
{
	private Student student;	
	private String id;
	
	public StudentHandler(Student stu,String Id)
	{
		this.student=stu;	
		this.id=Id;	

		OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
		String sql1="select * from openCourseInfo";
		ArrayList list=openCourseInfoDAO.excuteQuery(sql1);		
	
		
		if(list.size()==0)
		{
			student.getAddItem().setEnabled(false);	
			student.getDelItem().setEnabled(false);	
			student.getSearchItem(0).setEnabled(false);			
		}
		
		else
		{
			student.getAddItem().setEnabled(true);
			student.getDelItem().setEnabled(true);	
			student.getSearchItem(0).setEnabled(true);   //查询开课信息的按扭	
		}

		CourseScoreInfoDAO courseScoreInfoDAO=new CourseScoreInfoDAO();
		String sql2="select * from courseScoreInfo where stuID='"+id+"'";
		ArrayList scorelist=courseScoreInfoDAO.excuteQuery(sql2);		
	
		
		if(scorelist.size()==0)
		{
			student.getSearchItem(2).setEnabled(false);	
			student.getSearchItem(3).setEnabled(false);	
		}
		
		else
		{
			student.getSearchItem(2).setEnabled(true);
			student.getSearchItem(3).setEnabled(true);
		}
		
		ChoiceCourseInfoDAO choiceCourseInfoDAO=new ChoiceCourseInfoDAO();
		String sql3="select * from choiceCourseInfo where stuID='"+id+"'";
		ArrayList choicelist=choiceCourseInfoDAO.excuteQuery(sql3);		
	
		
		if(choicelist.size()==0)
		{
			student.getSearchItem(1).setEnabled(false);	
			student.getDelItem().setEnabled(false);			
		}
		
		else
		{
			student.getSearchItem(1).setEnabled(true);
			student.getDelItem().setEnabled(true);				
		}
		
		//添加选课信息
		student.getAddItem().addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					//System.out.println("WWWWWWWWWWWWWW");
					AddChoiceCourseInfo addChoiceCourseInfo=new AddChoiceCourseInfo(student.getFrame(),student.getDesktopPane(),id);	
							
				}
			}	
		);
		
		
		//删除选课信息
		student.getDelItem().addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					DelChoiceCourseInfo delChoiceCourseInfo=new DelChoiceCourseInfo(student.getFrame(),student.getDesktopPane(),id);		
				}
			}	
		);
		
		//查询开课信息
		student.getSearchItem(0).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					SearOpenCourseInfoByStu searOpenCourseInfoByStu=new SearOpenCourseInfoByStu(student.getFrame(),student.getDesktopPane(),id);		
				}
			}	
		);
		
		
		
		//查询选修课信息
		student.getSearchItem(1).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					SearChoiceCourInfo searChoiceCourInfo=new SearChoiceCourInfo(student.getFrame(),student.getDesktopPane(),id);		
				}
			}	
		);
		
	
		//按照课程编号查询一门
		student.getSearchItem(2).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					SearOneCourseScore searOneCourseScore=new SearOneCourseScore(student.getFrame(),student.getDesktopPane(),id);	
				}
			}	
		);
		
		//查询所有课程的考试成绩
		student.getSearchItem(3).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					SearAllCourseScore searOneCourseScore=new SearAllCourseScore(student.getFrame(),student.getDesktopPane(),id);	
				}
			}	
		);		
	
	}
}