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（“獲取的查詢(xún)字符串：“?+?action）;
		if?（action?==?null?||?““.equals（action））?{
			return?mapping.findForward（“error“）;
		}?else?if?（“l(fā)essonQuery“.equals（action））?{
			return?lessonQuery（mapping?form?request?response）;

		}?else?if?（“l(fā)essonAdd“.equals（action））?{
			return?lessonAdd（mapping?form?request?response）;
		}?else?if?（“l(fā)essonDel“.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“）;
	}

	//?查詢(xún)課程信息
	private?ActionForward?lessonQuery（ActionMapping?mapping?ActionForm?form
			HttpServletRequest?request?HttpServletResponse?response）?{
		request.setAttribute（“l(fā)essonQuery“?lessonDAO.query（0））;
		return?mapping.findForward（“l(fā)essonQuery“）;
	}

	//?添加課程
	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（“l(fā)essonAdd“）;
		}?else?if?（ret?==?2）?{
			request.setAttribute（“error“?“該課程已經(jīng)添加！“）;
			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（“l(fā)essonDel“）;
		}
	}
	//在線考試時(shí)選擇課程
	private?ActionForward?selectLesson（ActionMapping?mapping?ActionForm?form
			HttpServletRequest?request?HttpServletResponse?response）?{?
		HttpSession?session?=?request.getSession（）;
		String?stu=session.getAttribute（“student“）.toString（）;	//獲取準(zhǔn)考證號(hào)
		List?list=lessonDAO.query（stu）;	//查詢(xún)包括考試題目的課程列表，但不包括已經(jīng)考過(guò)的科目
		if（list.size（）<1）{
			return?mapping.findForward（“noenLesson“）;
		}else{
			request.setAttribute（“l(fā)essonList“l(fā)ist）;
			return?mapping.findForward（“selectLesson“）;
		}
	}
	//準(zhǔn)備考試

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????目錄???????????0??2014-05-23?00:10??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\
?????文件????????7129??2013-08-02?13:12??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\db_exam.sql
?????目錄???????????0??2013-08-02?13:11??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\
?????文件?????????836??2013-08-02?10:02??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\.classpath
?????文件????????1037??2013-08-02?10:02??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\.project
?????目錄???????????0??2013-08-02?13:11??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\.settings\
?????文件?????????503??2013-08-02?10:02??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\.settings\.jsdtscope
?????文件?????????395??2013-08-02?10:02??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\.settings\org.eclipse.jdt.core.prefs
?????文件?????????442??2013-08-02?10:02??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\.settings\org.eclipse.wst.common.component
?????文件?????????345??2013-08-02?10:02??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2013-08-02?10:02??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2013-08-02?10:02??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2013-08-02?13:11??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\
?????目錄???????????0??2013-08-02?13:11??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\
?????目錄???????????0??2013-08-02?13:11??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\
?????文件?????????110??2013-08-02?10:08??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\connDB.properties
?????目錄???????????0??2013-08-02?13:11??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\
?????目錄???????????0??2013-08-02?13:11??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\action\
?????目錄???????????0??2013-08-02?13:11??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\actionForm\
?????文件????????1320??2013-08-02?10:06??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\actionForm\LessonForm.class
?????文件????????1125??2013-08-02?10:06??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\actionForm\ManagerForm.class
?????文件?????????599??2013-08-02?10:06??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\actionForm\MoreSelect.class
?????文件?????????771??2013-08-02?10:06??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\actionForm\QueryResultIfForm.class
?????文件????????4814??2013-08-02?10:06??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\actionForm\QuestionsForm.class
?????文件????????2622??2013-08-02?10:06??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\actionForm\StudentForm.class
?????文件????????1808??2013-08-02?10:06??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\actionForm\StuResultForm.class
?????文件????????1720??2013-08-02?10:06??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\actionForm\TaoTiForm.class
?????文件????????3975??2013-08-02?10:06??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\action\Lesson.class
?????文件????????4326??2013-08-02?10:06??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\action\Manager.class
?????文件????????4145??2013-08-02?10:06??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\action\Questions.class
?????文件?????????933??2013-08-02?10:06??java?web開(kāi)源項(xiàng)目在線考試系統(tǒng)\Exam\build\classes\com\wgh\action\SelfRequestProcessor.class
............此處省略170個(gè)文件信息