マルチ条件のファジイクエリの実装

     select *  from  choice_question,type_of_test,question_types,knowledge_point
     
       choice_question.type_id=type_of_test.type_id AND
       choice_question.question_id=question_types.question_id AND
       choice_question.knowledge_id=knowledge_point.knowledge_id AND
       
           question_name  LIKE  CONCAT('%','${questionName}','%')
       
       
          AND  choice_degree  LIKE  CONCAT('%','${choiceDegree}','%')
       
       
          AND type_name LIKE CONCAT('%','${typeName}','%')
       
     
  

 List selectLike(Map map);

public List selectLike(Map map) {
        String a = map.get("questionName");
        String b = map.get("choiceDegree");
        String c = map.get("typeName");
        Integer d = Integer.parseInt(map.get("number"));
        System.out.println(a + b + c + d);
        Map map1 = new HashMap();
        map1.put("questionName", a);
        map1.put("choiceDegree", b);
        map1.put("typeName", c);
        List list = choiceQuestionEntityMapper.selectLike(map1);
        List list3 = new ArrayList(); //       
        List list2 = new ArrayList<>();//       
        while (list2.size() < d) {
            int i = (int) (Math.random() * list.size());//     
            if (!list2.contains(i)) {
                list2.add(i);
            }
        }
        for (int j = 0; j < list2.size(); j++) {
            list2.get(j);
            list3.add(list.get(list2.get(j)));
        }
        return list3;
    }
}