exam-master/src/org/mmxbb/exam/dao/ExamineeChooserDAO.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.business.program.ChooseExamineeActionForm;
import org.mmxbb.exam.util.DBConn;


public class ExamineeChooserDAO {

  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 EXAMINEE_ID,NAME FROM EX_EXAMINEE WHERE ORGANIZATION_ID LIKE ? AND STATE='063'";
  private static final String GET_SHARCH_RESULT2 =
      "SELECT EXAMINEE_ID,NAME FROM EX_EXAMINEE WHERE ORGANIZATION_ID LIKE ? AND POST_INDEX = ? AND STATE='063'";
  private static final String UPDATE_LIST =
      "UPDATE EX_EXAMINATIONPAPER SET E_EXAMINEELIST = ? WHERE E_ID = ?";
  private static final String ADD_TO_LIST =
      "UPDATE EX_EXAMINATIONPAPER SET E_EXAMINEELIST = ( SELECT concat(E_EXAMINEELIST,?) FROM EX_EXAMINATIONPAPER WHERE E_ID = ? ) WHERE E_ID = ?";
  private static final String GET_LIST =
      "SELECT E_EXAMINEELIST FROM EX_EXAMINATIONPAPER WHERE E_ID = ?";

  /**
   * get a connection from a DB pool
   * @return Connection
   */
  public ExamineeChooserDAO() {
    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 = "";