Mybatis查询条件包含List的情况说明

public class FileRequest{

     //文件类型

     private Integer fileType;

     //状态

     private List<Status> statusList;

}

public class Status{

     //注册状态

     private Integer registerStatus;

     //会议状态

     private Integer meetingStatus

}

< select id= "findList" parameterType= "FileRequest" resultMap= "..." >

     select * from tableName where

     1=1

     <if test= "fileType != null " >

         and file_type = #{fileType}

     </if>

     <if test= "statusList != null " >

         and

         <foreach collection= "statusList" index = "index" item= "item" open "(" separator= "or" close = ")" >

             <if test= "item.registerStatus != null " >

                 and register_status= #{item.registerStatus}

             </if>

             <if test= "item.meetingStatus != null " >

                 and meeting_status= #{item.meetingStatus }

             </if>   

         </foreach>

     </if>

</ select >

select * from table where type=?

and code in (?,?,?,?)

List< BaseDictionary > selectByTypeAndCodes(

  @Param("codes") List< Integer > codes,

@Param("type") Integer type);

  Mapper.xml.

< select id = "selectByTypeAndCodes"   resultMap = "BaseResultMap" >

     select

     < include refid = "Base_Column_List" />

     from base_dictionary

     where type = #{type}

     AND code in

     < foreach collection = "codes" index = "index" item = "item" open = "(" separator = "," close = ")" >

      #{item}

     </ foreach >

     AND show_enable=1

     AND obj_status=1

     ORDER BY sort

   </ select >