public TestSpecif findTestSpecif(int testIdVal) {
    int tempTestIdVal = 0;
    List<Integer> idTestSpecValue = new ArrayList<Integer>();
    List<Integer> questionIdList = new ArrayList<Integer>();
    try {

      Connection cn = pool.getConnection();
      PreparedStatement st = null;
      try {
        st = cn.prepareStatement(Resource.getDBProperties("query.testspec.find"));
        st.setInt(1, testIdVal);
        ResultSet rs = null;
        try {
          rs = st.executeQuery();
          while (rs.next()) {
            tempTestIdVal = rs.getInt(Resource.getDBProperties("testsquestions.field.idtest"));
            idTestSpecValue.add(
                rs.getInt(Resource.getDBProperties("testsquestions.field.idtestquest")));
            questionIdList.add(
                rs.getInt(Resource.getDBProperties("testsquestions.field.idquestion")));
          }
        } finally {
          if (rs != null) rs.close();
          else logger.error(Resource.getStrErr("error.notload.result"));
        }
      } finally {
        if (st != null) st.close();
        else logger.error(Resource.getStrErr("error.notload.statement"));
      }
    } catch (SQLException e) {
      logger.error(e);
    }
    pool.close();
    return new TestSpecif(idTestSpecValue, tempTestIdVal, questionIdList);
  }
  public void insertTestSpecif(int testIdVal, int[] questionIdListVal) {

    try {

      Connection cn = pool.getConnection();
      PreparedStatement st = null;
      try {

        for (int i = 0; i < questionIdListVal.length; i++) {
          st = cn.prepareStatement(Resource.getDBProperties("query.testspec.insert"));
          st.setInt(1, testIdVal);
          st.setInt(2, questionIdListVal[i]);
          st.executeUpdate();
        }
      } finally {
        if (st != null) st.close();
        else logger.error(Resource.getStrErr("error.notload.statement"));
      }
    } catch (SQLException e) {
      logger.error(e);
    }
    pool.close();
  }
  public static boolean addUser(
      String login,
      String password,
      String lastname,
      String firstname,
      String accesstype,
      String role)
      throws UnsupportedEncodingException, ClassNotFoundException {

    boolean additionResult = false;

    if (role.equals(Resource.getJspParams("param.register.usertype.tutor"))) {
      String currPost = "";
      for (int i = 0; i < 4; i++) {
        if (accesstype.equals(Resource.getJspParams("param.testcreate.avar") + i)) {
          currPost =
              new String(
                  Resource.getJspParams("param.register.accesoryvar" + (i + 1) + ".tutor")
                      .getBytes("ISO-8859-1"),
                  "UTF-8");
        }
      }
      TutorDAO currentTutor = mysqlFactory.getTutorDAO();
      additionResult = currentTutor.insertTutor(lastname, firstname, currPost, login, password);
    } else if (role.equals(Resource.getJspParams("param.register.usertype.student"))) {
      String currGroup = "";
      for (int i = 0; i < 4; i++) {
        if (accesstype.equals(Resource.getJspParams("param.testcreate.avar") + i)) {
          currGroup =
              new String(
                  Resource.getJspParams("param.register.accesoryvar" + (i + 1) + ".student")
                      .getBytes("ISO-8859-1"),
                  "UTF-8");
        }
      }
      StudentDAO currentStudent = mysqlFactory.getStudentDAO();
      additionResult =
          currentStudent.insertStudent(lastname, firstname, currGroup, login, password);
    }
    return additionResult;
  }