@Override
  public Question getQuestion(String id) throws Exception {

    // TODO Auto-generated method stub
    if (!ValidateUtil.isPassSqlFilter(id)) {
      myLogger.error("要查询的实例,questionId通过验证!--->questionId:" + id);
      return null;
    }
    return myQuestionDao.selectQuestion(id);
  }
 @Override
 public int deleteQuestion(String id) throws Exception {
   // TODO Auto-generated method stub
   if (!ValidateUtil.isPassSqlFilter(id)) {
     myLogger.error("要增添的实例,questionId通过验证!");
     return 1;
   }
   int deleteResult = myQuestionDao.deleteQuestion(id);
   if (deleteResult != 0) {
     myLogger.error("删除实例信息时出现错误!--->questionId:" + id);
   }
   return 0;
 }
 @Override
 public int addQuestion(Question question) throws Exception {
   // TODO Auto-generated method stub
   if (ValidateUtil.validateQuestionId(question) != 0) {
     myLogger.error("要增添的实例,questionId通过验证!");
     return 1;
   }
   if (myQuestionDao.insertQuestion(question) != 0) {
     myLogger.error("增添question实例操作出现错误!-->questionInfo:" + question.toString());
     return 2;
   }
   ;
   return 0;
 }
  @Override
  public Question getFirstQuestionByType(String type) throws Exception {

    Question question = new Question();

    if (!ValidateUtil.isPassSqlFilter(type)) {
      myLogger.error("要查询的实例,questionType通过验证!--->questionType:" + type);
      return null;
    }

    question =
        myQuestionDao.selectFirstQuestionByType(changeQuestionTypeToChinese(type)); // 正常跳转下一部分

    return question;
  }
  @Override
  public Question getQuestionByType(String id, String type) throws Exception {
    System.out.println("getQuestionByType:" + id + "--" + type);
    Question question = new Question();

    if (!ValidateUtil.isPassSqlFilter(id)) {
      myLogger.error("要查询的实例,questionId通过验证!--->questionId:" + id);
      return null;
    }
    if (!ValidateUtil.isPassSqlFilter(type)) {
      myLogger.error("要查询的实例,questionType通过验证!--->questionType:" + type);
      return null;
    }

    if (id == null && type == null) {
      question = myQuestionDao.selectFirstQuestionByType("年龄"); // 开始答题

      while (question == null) {
        question =
            myQuestionDao.selectFirstQuestionByType(
                getNextQuestionType(changeQuestionTypeToChinese(type)));
      }

      return question;

    } else if ((id.equals("end") || id == null)
        && !type.equals(changeQuestionTypeToEnglish("守法诚信"))) {
      System.out.println(changeQuestionTypeToEnglish("守法诚信"));
      System.out.println(1);
      System.out.println(type);
      type = getNextQuestionType(changeQuestionTypeToChinese(type));
      System.out.println(type);
      question = myQuestionDao.selectFirstQuestionByType(type); // 正常跳转下一部分

      while (question == null) {
        System.out.println(2);
        System.out.println(type);
        if (!type.equals("守法诚信")) {
          type = getNextQuestionType(type);
        }
        System.out.println(type);

        question = myQuestionDao.selectFirstQuestionByType(type);
        if (type.equals("守法诚信") && question == null) {
          System.out.println(3);
          return null;
        }
      }

      return question;
    } else if ((id.equals("end") || id == null)
        && type.equals(changeQuestionTypeToEnglish("守法诚信"))) { // 答题结束
      System.out.println(4);
      return null;

    }
    // TODO Auto-generated method stub
    else {
      return myQuestionDao.selectQuestion(id); // 正常答题
    }
  }