aftercheckevent.java~14~

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

package stumanage.events;
import java.util.ResourceBundle;
import javax.servlet.http.HttpServletRequest;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletContext;
import java.sql.*;
import javax.servlet.http.HttpSession;
import stumanage.beans.*;
import java.io.*;

/**
 * <p>Title: 处理论文批改后提交分数</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class AfterCheckEvent
    extends EventHandleBase {
  private PaperInfo paper = new PaperInfo();
  private boolean checkSuccess = false;
  private RegInfo regInfo = new RegInfo();
  public AfterCheckEvent() {
  }

  /**
   * override process:根据论文的作者将评语和分数存回数据库
   * @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();
    paper = (PaperInfo)session.getAttribute("paper");
    System.out.println(paper.getSNo());
    try {
      Connection con = null;
      PreparedStatement pstmt = null;
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
      String dsn = "jdbc:odbc:info";
      con = DriverManager.getConnection(dsn);
      String sqls = "Update Paperinfo Set comment = ? ,score = ?, flag = 'yes'  where (sno = ?);";
      pstmt = con.prepareStatement(sqls);
      //pstmt.setString(1,request.getParameter("paperComment"));
      String temp = request.getParameter("paperComment");
      Reader reader = new StringReader(temp);
      pstmt.setCharacterStream(1,reader,temp.length());
      Float scores = Float.valueOf(request.getParameter("score").trim());
      pstmt.setFloat(2,scores.floatValue());
      pstmt.setString(3,paper.getSNo());
      //Clob clob;
      //clob的开始位置为0还是1？？
      //clob.setString(1,request.getParameter("comment"));
      //int i = (int)clob.length();
      //pstmt.setCharacterStream(1,clob.getCharacterStream(),i);
      pstmt.executeUpdate();
      checkSuccess = true;
    } catch (Exception e) {
      regInfo.setInfo("数据库操作发生异常");
      System.out.println("发生异常 " + e );
    }
    session.setAttribute("regInfo",regInfo);
    //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 = new String();
    if(checkSuccess) {
      temp =  rd.getString("CHECKSUC");
    }
    else  {
      temp = rd.getString("REGERROR");
    }

    return temp;
  }
}