/*
 * @(#)BusinessBean.java 
 *
 * Copyright 2003 by SYNTC, All rights reserved.
 *
 * This software is the confidential and proprietary information of SYNTC.
 * ("Confidential Information").
 */
package cn.com.syntc.webapp.business;

import javax.servlet.*;
import javax.servlet.http.*;

import cn.com.syntc.common.action.*;
import cn.com.syntc.common.io.*;
import cn.com.syntc.common.util.*;
import cn.com.syntc.common.type.*;
import cn.com.syntc.webapp.taglib.CheckLogin;

import cn.com.syntc.webapp.session.UserSession;

/**
 * 考試信息<br>
 * @author wang yong
 * @version 1.0
 */
public class ExamListBean extends BusinessLogic{
  /**
   * 構造函數(shù)
   */
  public ExamListBean(){
    System.out.println("FrameWork：業(yè)務處理類實例化完成【" + this.getClass().getName() + "】");
  }

  /**
   * 業(yè)務邏輯處理機能
   */
  public void execute(HttpServletRequest request, HttpServletResponse response, Parameters parameters) throws CommonException{
    try{
      String strSql = "";
      ResultSet resultset = null;
      SqlUtil sqlutil = new SqlUtil();

      UserSession USession = (UserSession)request.getSession().getAttribute("UserSession");
      
      strSql = "SELECT LIBID,LIBNAME FROM LIB_TBL WHERE ONOFF='1' ORDER BY CREATETIME";
      resultset = sqlutil.executeQuery(strSql);

      sqlutil.close();

      parameters.setParameters("results","ExamList", resultset);

      parameters.setParameters("results", "ForwardPage", "/framework/exam/examlist.jsp");

    }
    catch(Exception ex){
      System.out.println("error:"+ex.getMessage());;
    }
  }


  /**
   * 頁面表單檢測處理機能
   */
  public void validate(HttpServletRequest request, HttpServletResponse response, Parameters parameters) throws CommonException{


  }

}