tqueryscoreevent.java~11~

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

package stumanage.events;

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

public class TQueryScoreEvent
    extends EventHandleBase {
  private ScoreInfo scoreInfo = new ScoreInfo();
  private RegInfo regInfo = new RegInfo();
  public TQueryScoreEvent() {
  }

  public void process (ServletContext sc,
                       HttpServletRequest request, HttpServletResponse response)
    throws IOException, ServletException {
    HttpSession session = request.getSession();
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      String dsn = "jdbc:odbc:Info";
      Connection con = DriverManager.getConnection(dsn);
      String sql = "Select count(Sno) from paperInfo where flag = 'yes'";
      PreparedStatement stmt = con.prepareStatement(sql);
      ResultSet rs = stmt.executeQuery();
      ResultSetMetaData md = rs.getMetaData();
      System.out.println("stmt.executeQuery();");
      int i = 1;
      if(rs.next()){
        i = rs.getInt(1);
      }
      System.out.println(i);
      scoreInfo.setRows(i);
      sql = "select sno,subject,score from paperinfo where flag = 'yes'";
      stmt = con.prepareStatement(sql);
      rs = stmt.executeQuery();

      i = 0;
      while(rs.next()) {
        System.out.println("enter while");
        String SNo = rs.getString(1);
        scoreInfo.setSNo(SNo,i);
        scoreInfo.setSubject(rs.getString(2),i);
        scoreInfo.setScore(rs.getFloat(3),i);
        String sql2 = "select SName from SInfo where sNo = ? ";
        PreparedStatement pstmt = con.prepareStatement(sql2);
        pstmt.setString(1,SNo);
        ResultSet rs2 = pstmt.executeQuery();
        if(rs2.next()) {
          scoreInfo.setSName(rs2.getString(1),i);
        }
        System.out.println("sNo=" + scoreInfo.getSNo(i) + ";SName=" + scoreInfo.getSName(i)); //for test
        i ++;
      }
      scoreInfo.setRow(i);

    }catch(Exception e) {
      System.out.println("发生异常" + e);
    }
    session.setAttribute("scoreInfo",scoreInfo);
    //Debug.log (this, "process", "Using default process");
  }

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