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?（“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“）;
	}

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

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

?????文件????????793??2007-12-17?20:50??網(wǎng)絡(luò)在線考試\copyright.jsp

?????文件???????1979??2007-12-20?14:14??網(wǎng)絡(luò)在線考試\CSS\style.css

?????文件????1048576??2008-01-11?13:22??網(wǎng)絡(luò)在線考試\Database\db_netExam_Data.MDF

?????文件????1048576??2008-01-11?13:22??網(wǎng)絡(luò)在線考試\Database\db_netExam_Log.LDF

?????文件????????488??2007-12-21?16:57??網(wǎng)絡(luò)在線考試\dealNull.jsp

?????文件???????1257??2007-12-08?16:09??網(wǎng)絡(luò)在線考試\default.jsp

?????文件????????868??2007-12-07?19:49??網(wǎng)絡(luò)在線考試\error.jsp

?????文件???????2538??2007-12-21?17:05??網(wǎng)絡(luò)在線考試\examRule.jsp

?????文件????????587??2007-12-05?01:10??網(wǎng)絡(luò)在線考試\Images\add.gif

?????文件?????????49??2007-12-17?15:24??網(wǎng)絡(luò)在線考試\Images\bg_01.gif

?????文件?????115145??2007-12-08?08:38??網(wǎng)絡(luò)在線考試\Images\default_bottom.JPG

?????文件?????227556??2007-12-08?10:54??網(wǎng)絡(luò)在線考試\Images\default_mid.JPG

?????文件?????105753??2007-12-08?08:38??網(wǎng)絡(luò)在線考試\Images\default_top.jpg

?????文件??????19902??2007-12-08?03:48??網(wǎng)絡(luò)在線考試\Images\error.jpg

?????文件????????173??2007-12-08?10:43??網(wǎng)絡(luò)在線考試\Images\f_ico.gif

?????文件??????78893??2007-12-07?20:12??網(wǎng)絡(luò)在線考試\Images\login_bottom.jpg

?????文件??????52384??2007-12-07?20:14??網(wǎng)絡(luò)在線考試\Images\login_mid.jpg

?????文件?????102349??2007-12-24?14:03??網(wǎng)絡(luò)在線考試\Images\login_top.jpg

?????文件?????????65??2007-12-17?20:05??網(wǎng)絡(luò)在線考試\Images\m_ico.gif

?????文件?????????59??2007-12-17?20:37??網(wǎng)絡(luò)在線考試\Images\m_ico1.gif

?????文件??????76626??2007-12-08?03:48??網(wǎng)絡(luò)在線考試\Images\m_login.jpg

?????文件??????89527??2007-12-18?08:59??網(wǎng)絡(luò)在線考試\Images\m_top.jpg

?????文件???????3069??2007-12-08?22:47??網(wǎng)絡(luò)在線考試\Images\seedPwd.gif

?????文件??????13360??2007-12-20?13:01??網(wǎng)絡(luò)在線考試\Images\startExam_bottom.jpg

?????文件??????18469??2007-12-20?13:02??網(wǎng)絡(luò)在線考試\Images\startExam_ico.jpg

?????文件??????13318??2007-12-20?13:01??網(wǎng)絡(luò)在線考試\Images\startExam_left.jpg

?????文件??????14295??2007-12-20?12:59??網(wǎng)絡(luò)在線考試\Images\startExam_leftBottom.jpg

?????文件??????14310??2007-12-20?12:57??網(wǎng)絡(luò)在線考試\Images\startExam_leftTop.jpg

?????文件??????13322??2007-12-20?13:01??網(wǎng)絡(luò)在線考試\Images\startExam_right.jpg

?????文件??????14395??2007-12-20?13:00??網(wǎng)絡(luò)在線考試\Images\startExam_rightBottom.jpg

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