mybatis and,or复合查询操作

 UserExample example=new UserExample(); example.or().orAgeLike("%"+searchParam+"%").andNameEqualTo(userName); example.or().orCityLike("%"+searchParam+"%").andNameEqualTo(userName);

 @Test public void TestMutil(){ Species species = new Species(); ArrayList arrayList = new ArrayList(); arrayList.add("长喙蚤"); arrayList.add("尤氏"); List querySpeciesesListByMutilCondition = this.speciesMapper.querySpeciesesListByMutilCondition(arrayList, species.getEnglishName(), species.getHost(), species.getPosition(), species.getLocation(), species.getPhylum(), species.getClassName(), species.getOrder(), species.getFamily(), species.getJenus()); for (Species s : querySpeciesesListByMutilCondition) { System.out.println(s); } System.out.println(querySpeciesesListByMutilCondition.size()); }

  SELECT * FROM t_json_species  AND englishName like CONCAT('%',#{englishName},'%') OR sameName like CONCAT('%',#{englishName},'%')AND host like CONCAT('%',#{host},'%')AND position like CONCAT('%',#{position},'%')AND location like CONCAT('%',#{location},'%')AND phylumName = #{phylumName}AND className = #{className}AND orderName = #{orderName}AND familyName = #{familyName}AND jenusName = #{jenusName} AND name like CONCAT('%',#{name},'%') OR sameName like CONCAT('%',#{name},'%')

  SELECT * FROM t_json_species  AND englishName like CONCAT('%',#{englishName},'%') OR sameName like CONCAT('%',#{englishName},'%')AND host like CONCAT('%',#{host},'%')AND position like CONCAT('%',#{position},'%')AND location like CONCAT('%',#{location},'%')AND phylumName = #{phylumName}AND className = #{className}AND orderName = #{orderName}AND familyName = #{familyName}AND jenusName = #{jenusName} AND (name like CONCAT('%',#{name},'%') OR sameName like CONCAT('%',#{name},'%'))