queryscoreevent.java~5~

用jsp做的一个简单的论文管理系统。由于时间关系

package stumanage.events;
import java.util.*;
import stumanage.beans.*;
import javax.servlet.http.HttpServletRequest;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletContext;
import javax.servlet.http.HttpSession;
import java.sql.*;
import stumanage.beans.*;
/**
 * <p>Title:处理查询 </p>
 *
 * <p>Description:根据登录学生的学号查询分数 </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class QueryScoreEvent
    extends EventHandleBase {
  //private boolean querySuccess = false;
  private UserInfo student = new UserInfo();
  /**
   * queryInfo   用来记录查询结果信息，如果查询成功，则记录分数，否则记录失败原因
   */
  private RegInfo queryInfo = new RegInfo();
  public QueryScoreEvent() {
  }

  /**
   * @param sc ServletContext
   * @param request HttpServletRequest
   * @param response HttpServletResponse
   * @throws IOException
   * @throws ServletException
   */
  public void process (ServletContext sc,
                       HttpServletRequest request, HttpServletResponse response)
    throws IOException, ServletException {
    HttpSession session = request.getSession();
    student = (UserInfo)session.getAttribute("user");
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
      String dsn = "jdbc:odbc:info";
      Connection con = DriverManager.getConnection(dsn);
      String sqls = "Select Score From PaperInfo where (SNo = ?) And (flag = 'yes')";
      PreparedStatement pstmt = con.prepareStatement(sqls);
      System.out.println(student.getUserID());
      pstmt.setString(1,user.getUserID());
      ResultSet rs = pstmt.executeQuery();
      if(rs.next()) {
        float score = rs.getFloat(1);
        Float Fscore = new Float(score);
        String temp = Fscore.toString();
        queryInfo.setInfo(temp);
      }
      else {
        queryInfo.setInfo("数据库中未找到所对应的记录，您的论文可能尚未提交或者老师尚未批改您的论文");
      }
    } catch (Exception e) {
      queryInfo.setInfo("产生异常,异常原因为：" + e);
      System.out.println("产生异常 " + e);
    }
    session.setAttribute("queryInfo",queryInfo);
    //Debug.log (this, "process", "Using default process");
  }

  /**
     * getURL
     *
     * @return String
     * @todo Implement this stumanage.events.EventHandleBase method
   */
  protected String getURL() {
    ResourceBundle rd = ResourceBundle.getBundle("URL");
    String temp = rd.getString("QUESUC");
    return temp;
  }
}