exam-master/src/org/mmxbb/exam/dao/ExamineeTestDetailsDAO.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package org.mmxbb.exam.dao;



import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;

import org.mmxbb.exam.bean.TestPaper;
import org.mmxbb.exam.util.DBConn;


public class ExamineeTestDetailsDAO {
  DBConn dbconn = null;
  private Connection conn = null;

  private int rowCount;
  private int pageCount;
  private int length;
  private String pagestr;
  private String conditionStr = "";

  private static final String GET_SHARCH_RESULT =
      "SELECT T.T_STATE AS T_STATE,B.B_VALUE AS T_STATENAME,E.E_NAME AS E_NAME,T.T_BEGIN AS T_BEGIN,T.T_END AS T_END,T.T_PASSVALUE AS T_PASSVALUE,E.E_TOTAL AS E_TOTAL,E.E_STATE AS E_STATE,B1.B_VALUE AS E_STATENAME,EXAMINEE.NAME AS EXAMINEENAME,T.T_TOTAL AS T_TOTAL FROM EX_TESTPAPER T,EX_BASEINFO B,EX_BASEINFO B1,EX_EXAMINATIONPAPER E,EX_EXAMINEE EXAMINEE WHERE B.B_ID = T.T_STATE AND B1.B_ID = E.E_STATE AND E.E_ID = T.E_ID AND EXAMINEE.EXAMINEE_ID = T.EXAMINEE_ID AND T.EXAMINEE_ID = ?";

  public ExamineeTestDetailsDAO() {
    try {
      dbconn = new DBConn();
      conn = dbconn.getConnection();
    } catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  public int getLength() {
    return (this.length);
  }

  public void setLength(int length) {
    this.length = length;
  }

  public String getPagestr(int ipage) {
    String strPage = "";
    if (getLength() > 0) {
      strPage += "共";
      strPage += String.valueOf(rowCount);
      strPage += "条记录，共";
      strPage += String.valueOf(pageCount);
      strPage += "页，当前是第";
      strPage += String.valueOf(ipage);
      strPage += "页，      ";
      int istart, iend;
      istart = ipage - 5;
      if (istart < 0) {
        istart = 0;
      }