package?com.wgh.action;

import?java.util.List;

import?javax.servlet.http.*;

import?org.apache.struts.action.*;
import?com.wgh.actionForm.LessonForm;
import?com.wgh.dao.LessonDAO;

public?class?Lesson?extends?Action?{
	private?LessonDAO?lessonDAO?=?null;

	public?Lesson（）?{
		this.lessonDAO?=?new?LessonDAO（）;
	}
	public?ActionForward?execute（ActionMapping?mapping?ActionForm?form
			HttpServletRequest?request?HttpServletResponse?response）?{
		String?action?=?request.getParameter（“action“）;
		System.out.println（“獲取的查詢字符串：“?+?action）;
		if?（action?==?null?||?““.equals（action））?{
			return?mapping.findForward（“error“）;
		}?else?if?（“lessonQuery“.equals（action））?{
			return?lessonQuery（mapping?form?request?response）;

		}?else?if?（“lessonAdd“.equals（action））?{
			return?lessonAdd（mapping?form?request?response）;
		}?else?if?（“lessonDel“.equals（action））?{
			return?lessonDel（mapping?form?request?response）;
		}else?if（“selectLesson“.equals（action））{
			return?selectLesson（mapping?form?request?response）;
		}else?if（“ready“.equals（action））{
			return?ready（mapping?form?request?response）;
		}
		request.setAttribute（“error“?“操作失敗！“）;
		return?mapping.findForward（“error“）;
	}

	//?查詢課程信息
	private?ActionForward?lessonQuery（ActionMapping?mapping?ActionForm?form
			HttpServletRequest?request?HttpServletResponse?response）?{
		request.setAttribute（“lessonQuery“?lessonDAO.query（0））;
		return?mapping.findForward（“lessonQuery“）;
	}

	//?添加課程
	private?ActionForward?lessonAdd（ActionMapping?mapping?ActionForm?form
			HttpServletRequest?request?HttpServletResponse?response）?{
		LessonForm?lessonForm?=?（LessonForm）?form;
		int?ret?=?lessonDAO.insert（lessonForm）;
		System.out.println（“返回值ret：“?+?ret）;
		if?（ret?==?1）?{
			return?mapping.findForward（“lessonAdd“）;
		}?else?if?（ret?==?2）?{
			request.setAttribute（“error“?“該課程已經添加！“）;
			return?mapping.findForward（“error“）;
		}?else?{
			request.setAttribute（“error“?“添加課程失敗！“）;
			return?mapping.findForward（“error“）;
		}
	}
	//?刪除課程
	private?ActionForward?lessonDel（ActionMapping?mapping?ActionForm?form
			HttpServletRequest?request?HttpServletResponse?response）?{
		LessonForm?lessonForm?=?（LessonForm）?form;
		int?ret?=?lessonDAO.delete（lessonForm）;
		if?（ret?==?0）?{
			request.setAttribute（“error“?“刪除課程失敗！“）;
			return?mapping.findForward（“error“）;
		}?else?{
			return?mapping.findForward（“lessonDel“）;
		}
	}
	//在線考試時選擇課程
	private?ActionForward?selectLesson（ActionMapping?mapping?ActionForm?form
			HttpServletRequest?request?HttpServletResponse?response）?{?
		HttpSession?session?=?request.getSession（）;
		String?stu=session.getAttribute（“student“）.toString（）;	//獲取準考證號
		List?list=lessonDAO.query（stu）;	//查詢包括考試題目的課程列表，但不包括已經考過的科目
		if（list.size（）<1）{
			return?mapping.findForward（“noenLesson“）;
		}else{
			request.setAttribute（“lessonList“list）;
			return?mapping.findForward（“selectLesson“）;
		}
	}
	//準備考試

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1471??2012-04-25?08:34??BiShe\.classpath

?????文件????????288??2012-04-24?18:50??BiShe\.mymetadata

?????文件????????262??2012-03-29?11:44??BiShe\.mystrutsdata

?????文件???????1361??2012-03-29?11:51??BiShe\.project

?????文件???????3538??2007-12-27?09:07??BiShe\src\com\wgh\action\Lesson.java

?????文件???????4167??2012-04-27?09:40??BiShe\src\com\wgh\action\Manager.java

?????文件???????4537??2007-12-28?14:57??BiShe\src\com\wgh\action\Questions.java

?????文件????????531??2007-12-12?14:34??BiShe\src\com\wgh\action\SelfRequestProcessor.java

?????文件???????6941??2007-12-28?14:21??BiShe\src\com\wgh\action\StartExam.java

?????文件???????5722??2012-04-28?17:54??BiShe\src\com\wgh\action\Student.java

?????文件???????1819??2007-12-07?19:07??BiShe\src\com\wgh\action\StuResult.java

?????文件???????3858??2007-12-24?10:16??BiShe\src\com\wgh\action\TaoTi.java

?????文件????????760??2007-12-22?22:20??BiShe\src\com\wgh\action\temp.java

?????文件????????870??2007-12-14?16:43??BiShe\src\com\wgh\actionForm\LessonForm.java

?????文件????????682??2007-12-13?14:30??BiShe\src\com\wgh\actionForm\ManagerForm.java

?????文件????????246??2007-12-21?15:57??BiShe\src\com\wgh\actionForm\MoreSelect.java

?????文件????????419??2007-12-17?18:23??BiShe\src\com\wgh\actionForm\QueryResultIfForm.java

?????文件???????3577??2012-04-28?12:30??BiShe\src\com\wgh\actionForm\QuestionsForm.java

?????文件???????2042??2012-04-28?16:13??BiShe\src\com\wgh\actionForm\StudentForm.java

?????文件???????1338??2007-12-17?18:23??BiShe\src\com\wgh\actionForm\StuResultForm.java

?????文件???????1079??2007-12-20?14:48??BiShe\src\com\wgh\actionForm\TaoTiForm.java

?????文件???????1056??2007-12-25?12:56??BiShe\src\com\wgh\core\ChStr.java

?????文件???????3492??2012-04-26?09:36??BiShe\src\com\wgh\core\ConnDB.java

?????文件???????4195??2012-04-26?16:57??BiShe\src\com\wgh\dao\LessonDAO.java

?????文件???????3524??2012-05-08?12:10??BiShe\src\com\wgh\dao\ManagerDAO.java

?????文件???????5701??2012-05-04?11:21??BiShe\src\com\wgh\dao\QuestionsDAO.java

?????文件???????4632??2012-05-08?12:21??BiShe\src\com\wgh\dao\StartExamDAO.java

?????文件???????8023??2012-05-08?11:41??BiShe\src\com\wgh\dao\StudentDAO.java

?????文件???????2647??2012-05-04?09:46??BiShe\src\com\wgh\dao\StuResultDAO.java

?????文件???????4055??2012-05-04?09:53??BiShe\src\com\wgh\dao\TaoTiDAO.java

............此處省略176個文件信息