teacherhandler.java

在本系统中

package jin.handler;

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

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


public class TeacherHandler
{
	private Teacher teacher;	
	private String id;
	
	public TeacherHandler(Teacher teach,String Id)
	{
		this.teacher=teach;	
		this.id=Id;
		
		
		CourseInfoDAO courseInfoDAO=new CourseInfoDAO();
		String sql1="select * from courseInfo";
		ArrayList list1=courseInfoDAO.excuteQuery(sql1);		
	
		if(list1.size()==0)  //&& list2.size()==0
		{
			teacher.getAddItem(0).setEnabled(false);
			teacher.getSearchItem(0).setEnabled(false);
			teacher.getSearchItem(1).setEnabled(false);
			teacher.getSearchItem(2).setEnabled(false);			
		}
		
		else
		{
			teacher.getAddItem(0).setEnabled(true);
			teacher.getSearchItem(0).setEnabled(true);
			teacher.getSearchItem(1).setEnabled(true);
			teacher.getSearchItem(2).setEnabled(true);	
		}
		
		
		OpenCourseInfoDAO openCourseInfoDAO=new OpenCourseInfoDAO();
		String sql2="select * from openCourseInfo where teaID='"+id+"'";
		ArrayList openCourList=openCourseInfoDAO.excuteQuery(sql2);
		
		if(openCourList.size()==0)
		{
			teacher.getAddItem(1).setEnabled(false);	
			teacher.getAddItem(2).setEnabled(false);
			
			teacher.getDelItem(0).setEnabled(false);			
		}
				
		else if(openCourList.size()>0)
		{
			teacher.getDelItem(0).setEnabled(true);			
			int flag=0;
			for(int i=0;i<openCourList.size();i++)
			{
				OpenCourseInfoBean openCourseInfoBean=(OpenCourseInfoBean)openCourList.get(i);
				
				ChoiceCourseInfoDAO choiceCourseInfoDAO=new ChoiceCourseInfoDAO();
				String sql3="select * from choiceCourseInfo where openCourseID='"+openCourseInfoBean.getOpenCourseID()+"'";
				ArrayList choiceCourList=choiceCourseInfoDAO.excuteQuery(sql3);
				if(choiceCourList.size()>0)
				{
					teacher.getAddItem(1).setEnabled(true);	
					teacher.getAddItem(2).setEnabled(true);	
					flag=1;
					break;
				}
			}
			
			if(flag==0)
			{
				teacher.getAddItem(1).setEnabled(false);	
				teacher.getAddItem(2).setEnabled(false);
			}
		}
		
		
		////查询学生成绩信息
		//teacher.getSearchItem(4)
		
		
		//查询本人所任课程的学生成绩信息		
		//teacher.getSearchItem(5)
		
		CourseScoreInfoDAO courseScoreInfoDAO=new CourseScoreInfoDAO();
		String sql4="select * from courseScoreInfo where teaID='"+id+"'";
		ArrayList courScolist=courseScoreInfoDAO.excuteQuery(sql4);		
	
		if(courScolist.size()==0)  //&& list2.size()==0
		{
			teacher.getDelItem(1).setEnabled(false);
			teacher.getSearchItem(4).setEnabled(false);
			teacher.getSearchItem(5).setEnabled(false);			
		}
		
		else
		{
			teacher.getDelItem(1).setEnabled(true);	
			teacher.getSearchItem(4).setEnabled(true);	
			teacher.getSearchItem(5).setEnabled(true);	
		}
		
		
		
		
		//添加开课信息
		teacher.getAddItem(0).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					AddOpenCourseInfo addOpenCourseInfo=new AddOpenCourseInfo(teacher.getFrame(),teacher.getDesktopPane(),id);			
				}
			}	
		);
		
		
		//录入学生成绩
		teacher.getAddItem(1).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					WriteScoreInfo writeScoreInfo=new WriteScoreInfo(teacher.getFrame(),teacher.getDesktopPane(),id);	
							
				}
			}	
		);
		//修改学生成绩信息
		teacher.getAddItem(2).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					UpdateStuScoreInfo updateStuScoreInfo=new UpdateStuScoreInfo(teacher.getFrame(),teacher.getDesktopPane(),id);			
				}
			}	
		);
		
		//删除开课信息
		teacher.getDelItem(0).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					DelOpenCourseInfo delOpenCourseInfo=new DelOpenCourseInfo(teacher.getFrame(),teacher.getDesktopPane(),id);			
				}
			}	
		);
		
		//删除录入的学生成绩信息
		teacher.getDelItem(1).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					DelStuScoreInfo delStuScoreInfo=new DelStuScoreInfo(teacher.getFrame(),teacher.getDesktopPane(),id);			
				}
			}	
		);
		
	
		//按专业名称查询课程信息
		teacher.getSearchItem(0).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					SearCourByMajorName searCourByMajorName=new SearCourByMajorName(teacher.getFrame(),teacher.getDesktopPane());	
				}
			}	
		);
		
		//按课程编号查询课程信息
		teacher.getSearchItem(1).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					SearCourByCourseID searCourByCourseID=new SearCourByCourseID(teacher.getFrame(),teacher.getDesktopPane());	
				}
			}	
		);
		
		//按课程名称查询课程信息
		teacher.getSearchItem(2).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					SearCourByCourseName searCourByCourseName=new SearCourByCourseName(teacher.getFrame(),teacher.getDesktopPane());	
				}
			}	
		);
		
		//查询开课信息
		teacher.getSearchItem(3).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					SearOpenCourseInfo searOpenCourseInfo=new SearOpenCourseInfo(teacher.getFrame(),teacher.getDesktopPane(),id);	
				}
			}	
		);

		//查询学生成绩信息
		teacher.getSearchItem(4).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					SearStuScoreByStuID searStuScoreByStuID=new SearStuScoreByStuID(teacher.getFrame(),teacher.getDesktopPane(),id);	
				}
			}	
		);
		
		//查询本人所任课程的学生成绩信息
		
		teacher.getSearchItem(5).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					SearStuScoOfMyself searStuScoOfMyself=new SearStuScoOfMyself(teacher.getFrame(),teacher.getDesktopPane(),id);	
				}
			}	
		);
		/*
		
		//删除专业信息
		admin.getDelItem(0).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					DelMajorInfo delMajorInfo=new DelMajorInfo(admin.getFrame(),admin.getDesktopPane());			
				}
			}	
		);
		
		
		//删除班级信息
		admin.getDelItem(1).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					DelClassInfo delClassInfo=new DelClassInfo(admin.getFrame(),admin.getDesktopPane());			
				}
			}	
		);
		
		
		//删除学生信息
		admin.getDelItem(2).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					DelStuInfo delStuInfo=new DelStuInfo(admin.getFrame(),admin.getDesktopPane());			
				}
			}	
		);
		
		//删除教师信息
		admin.getDelItem(3).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					DelTeaInfo delTeaInfo=new DelTeaInfo(admin.getFrame(),admin.getDesktopPane());			
				}
			}	
		);
		
		//修改信息
		admin.getUpdateItem(2).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					//UpdatePasswordDialog dialog=new UpdatePasswordDialog(admin.getFrame(),id);			
				}
			}	
		);
		
		//查询信息
		admin.getUpdateItem(3).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					//SearchStudInfoDialog dialog=new SearchStudInfoDialog(admin.getFrame());				
				}
			}	
		);
		
		/*
		//按学号查询成绩
		admin.getScoreItem(0).addActionListener(
			new ActionListener()
			{
				public void actionPerformed(ActionEvent e)
				{
					//SearchStudInfoDialog dialog=new SearchStudInfoDialog(admin.getFrame());
					ScoreTableByID scoreTable=new ScoreTableByID(admin.getDesktopPane(),admin.getFrame());				
				}
			}	
		);
		*/
	}
}