/*
 * 模型之登錄業(yè)務(wù)操作組件
 */
package TestClass;

import javax.servlet.*;
import java.util.*;
import java.io.*;
import java.lang.*;
import java.sql.*;
import javax.sql.*;


public class LoginCommand implements Command
{
	private String NextPage=null;
	public LoginCommand(String nextPage)
	{
		//在構(gòu)造時(shí)定義下一頁面
		this.NextPage=nextPage;
	}
	public String execute(ServletRequest request,ServletResponse response)
	{
		//取出傳來的參數(shù)信息
		String pNo=request.getParameter("txtNo");
		//實(shí)例狀態(tài)組件
		AttendmentBean bean=null;
		bean=new AttendmentBean();
		//實(shí)例數(shù)據(jù)操作組件
		AttendmentDBbean dbBean=null;
		dbBean=new AttendmentDBbean();
		//調(diào)用單個(gè)查詢操作
		bean=dbBean.GetOne(pNo);
		/*
		 *如果查詢不到結(jié)果,會(huì)報(bào)數(shù)據(jù)庫異常,無法繼續(xù)進(jìn)行
		 */
		if(bean==null)
			NextPage="/Remarks.htm";
		request.setAttribute("Login",bean);
		dbBean.Close();
		return NextPage;
	}
}