博客

public List<SurveryQuestion> getSurveryQuestion(String surveryQuestionnaireId) {
    List<SurveryQuestion> questions = dborm.getEntities(SurveryQuestion.class, "select * from survery_question where survery_questionnaire_id = ?", surveryQuestionnaireId);
    StringBuilder questionIdBuilder = new StringBuilder();
    for (SurveryQuestion question : questions) {
        questionIdBuilder.append(question.getId());
        questionIdBuilder.append(",");
    }

    if (StringUtils.isNotEmpty(questionIdBuilder.toString())) {
        String questionIds = StringUtils.cutLastSign(questionIdBuilder.toString(), ",");
        List<SurveryQuestionOption> options = dborm.getEntities(SurveryQuestionOption.class, "select * from survery_question_option where survery_question_id in("+questionIds+")");
        for (SurveryQuestion question : questions) {
            String questionId = question.getId();
            for (SurveryQuestionOption option : options) {
                if (questionId.equals(option.getSurveryQuestionId())) {
                    question.getOptions().add(option);
                }
            }
        }
    }
    return questions;
}