exam-master/src/org/mmxbb/exam/dao/ExamineeDAO.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.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;

import org.mmxbb.exam.bean.Examinee;
import org.mmxbb.exam.business.LogonForm;
import org.mmxbb.exam.business.examinee.ExamineeActionForm;
import org.mmxbb.exam.business.program.RandomDistributeExamPaperForm;
import org.mmxbb.exam.util.DBConn;


public class ExamineeDAO {
  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 ADD_EXAMINEE =
      "INSERT INTO EX_EXAMINEE (examinee_id,password,name,sex,age,organization_id,post_index,state,operation,education_index,address,phone,email,remark) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
  private static final String UPDATE_EXAMINEE =
      "UPDATE ex_examinee set NAME=?,SEX=?,AGE=?,ORGANIZATION_ID=?,POST_INDEX=?,STATE=?,OPERATION=?,EDUCATION_INDEX=?,ADDRESS=?,PHONE=?,EMAIL=?,REMARK=? WHERE EXAMINEE_ID=?";
  //************
  private static final String GET_SHARCH_RESULT =
      "select ex.examinee_id as examinee_id,ex.password as password,ex.name as name,ex.sex as sex,b1.b_value as sexName,ex.age as age,ex.organization_id as organization_id,o.org_name as organizationName,ex.post_index as post_index,p.post_name as postName,ex.state as state,b2.b_value as stateName,ex.operation as operation,b3.b_value as operationName,ex.education_index as education_index,e.education_name as educationName,ex.address as address,ex.phone as phone,ex.mobile as mobile,ex.email as email,ex.remark as remark from ex_examinee ex,b_organization o,b_post_type p,b_education_type e,ex_baseinfo b1,ex_baseinfo b2,ex_baseinfo b3 where b1.b_id = ex.sex and o.organization_id = ex.organization_id and p.post_index = ex.post_index and b2.b_id = ex.state and b3.b_id = ex.operation and e.education_index = ex.education_index AND ex.examinee_id LIKE ? AND ex.name LIKE ? AND ex.sex LIKE ? AND ex.organization_id LIKE ? AND ex.state LIKE ? AND ex.operation LIKE ?";
  private static final String GET_SHARCH_RESULT2 =
      "select ex.examinee_id as examinee_id,ex.password as password,ex.name as name,ex.sex as sex,b1.b_value as sexName,ex.age as age,ex.organization_id as organization_id,o.org_name as organizationName,ex.post_index as post_index,p.post_name as postName,ex.state as state,b2.b_value as stateName,ex.operation as operation,b3.b_value as operationName,ex.education_index as education_index,e.education_name as educationName,ex.address as address,ex.phone as phone,ex.mobile as mobile,ex.email as email,ex.remark as remark from ex_examinee ex,b_organization o,b_post_type p,b_education_type e,ex_baseinfo b1,ex_baseinfo b2,ex_baseinfo b3 where b1.b_id = ex.sex and o.organization_id = ex.organization_id and p.post_index = ex.post_index and b2.b_id = ex.state and b3.b_id = ex.operation and e.education_index = ex.education_index AND ex.examinee_id LIKE ? AND ex.name LIKE ? AND ex.sex LIKE ? AND ex.organization_id LIKE ? AND ex.state LIKE ? AND ex.operation LIKE ? AND ex.post_index = ?";
  private static final String GET_ALL_RESULT =
      "select ex.examinee_id as examinee_id,ex.password as password,ex.name as name,ex.sex as sex,b1.b_value as sexName,ex.age as age,ex.organization_id as organization_id,o.org_name as organizationName,ex.post_index as post_index,p.post_name as postName,ex.state as state,b2.b_value as stateName,ex.operation as operation,b3.b_value as operationName,ex.education_index as education_index,e.education_name as educationName,ex.address as address,ex.phone as phone,ex.mobile as mobile,ex.email as email,ex.remark as remark from ex_examinee ex,b_organization o,b_post_type p,b_education_type e,ex_baseinfo b1,ex_baseinfo b2,ex_baseinfo b3 where b1.b_id = ex.sex and o.organization_id = ex.organization_id and p.post_index = ex.post_index and b2.b_id = ex.state and b3.b_id = ex.operation and e.education_index = ex.education_index";
  private static final String FIND_BY_KEY =
      "SELECT * FROM EX_EXAMINEE WHERE examinee_id = ?";
  private static final String RE_INIT_PWD =
      "UPDATE EX_EXAMINEE SET password = examinee_id WHERE examinee_id = ?";
  private static final String UPDATE_PWD =
      "UPDATE EX_EXAMINEE SET password = ? WHERE examinee_id = ? AND password = ?";
  private static final String IS_USER =
      "SELECT password FROM EX_EXAMINEE WHERE examinee_id = ?";
  private static final String IS_ADMINUSER =
    "SELECT name,password FROM ex_adminuser where name=? and password=?";
  
  private static final String HAS_USER =
      "SELECT EXAMINEE_ID FROM EX_EXAMINEE WHERE EXAMINEE_ID = ?";
  private static final String GET_SHARCH_RESULT_WITHOUT_PAGE =
      "select ex.examinee_id as examinee_id,ex.password as password,ex.name as name,ex.sex as sex,b1.b_value as sexName,ex.age as age,ex.organization_id as organization_id,o.org_name as organizationName,ex.post_index as post_index,p.post_name as postName,ex.state as state,b2.b_value as stateName,ex.operation as operation,b3.b_value as operationName,ex.education_index as education_index,e.education_name as educationName,ex.address as address,ex.phone as phone,ex.mobile as mobile,ex.email as email,ex.remark as remark from ex_examinee ex,b_organization o,b_post_type p,b_education_type e,ex_baseinfo b1,ex_baseinfo b2,ex_baseinfo b3 where b1.b_id = ex.sex and o.organization_id = ex.organization_id and p.post_index = ex.post_index and b2.b_id = ex.state and b3.b_id = ex.operation and e.education_index = ex.education_index AND ex.examinee_id LIKE ? AND ex.name LIKE ? AND ex.sex LIKE ? AND ex.organization_id LIKE ? AND ex.state LIKE ? AND ex.operation LIKE ? AND  EX.STATE='063'";
  private static final String GET_SHARCH_RESULT2_WITHOUT_PAGE =
      "select ex.examinee_id as examinee_id,ex.password as password,ex.name as name,ex.sex as sex,b1.b_value as sexName,ex.age as age,ex.organization_id as organization_id,o.org_name as organizationName,ex.post_index as post_index,p.post_name as postName,ex.state as state,b2.b_value as stateName,ex.operation as operation,b3.b_value as operationName,ex.education_index as education_index,e.education_name as educationName,ex.address as address,ex.phone as phone,ex.mobile as mobile,ex.email as email,ex.remark as remark from ex_examinee ex,b_organization o,b_post_type p,b_education_type e,ex_baseinfo b1,ex_baseinfo b2,ex_baseinfo b3 where b1.b_id = ex.sex and o.organization_id = ex.organization_id and p.post_index = ex.post_index and b2.b_id = ex.state and b3.b_id = ex.operation and e.education_index = ex.education_index AND ex.examinee_id LIKE ? AND ex.name LIKE ? AND ex.sex LIKE ? AND ex.organization_id LIKE ? AND ex.state LIKE ? AND ex.operation LIKE ? AND ex.post_index = ? AND  EX.STATE='063'";

  /**
   * get a connection from a DB pool
   * @return Connection
   */