scorelistcommand.java

北大青鸟在线考试系统,包括在线考试模块,教师管理模块,系统管理模块

package TestClass;

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

public class ScoreListCommand implements Command
{
	private String NextPage=null;
	public ScoreListCommand(String next)
	{
		this.NextPage=next;
	}
	public String execute(ServletRequest request,ServletResponse response)
	{
		//取出传来的参数信息
		String rdoType=request.getParameter("rdoType");
		String mID=request.getParameter("txtNo");
		String mPwd=request.getParameter("txtPwd");
		//实例状态组件
		ManagerBean bean=null;
		bean=new ManagerBean();
		//实例数据操作组件
		ManagerDBbean dbBean=null;
		dbBean=new ManagerDBbean();
		ExamDBbean exDBbean=new ExamDBbean();
		//查询管理员信息
		bean=dbBean.GetData(mID);
		if(mID.equals(bean.getStuID()) && mPwd.equals(bean.getStuPwd()) && rdoType.equals(bean.getStuPro()))
			request.setAttribute("ListScore",exDBbean.GetAllData());
		else
		{
			request.setAttribute("ListScore",exDBbean.GetAllData());
		}
		dbBean.Close();
		return NextPage;
	}
	private String ToCn(String strvalue) 
	{
		String restr = null;
		try{
			if(strvalue!=null)
				restr = new String(strvalue.getBytes("ISO8859_1"), "GBK");
		}
		catch(Exception e){}
		return restr;
	}
}