Ibatis uses several XML statements for in queries

1. input parameters are Arrays

<select id="Test"  resultClass="dto">             select *             from UserInfo             where userId in                 <iterate open="(" close=")" conjunction="," >                     #[]#                 </iterate>         </select> 

Use

 string[] arrays = new string[] { "1", "2", "3" };  Reader.QueryForList<?>("Ibatisnet.dao.<span style="font-family: Arial, Helvetica, sans-serif;">Test</span><span style="font-family: Arial, Helvetica, sans-serif;">", strValue ); </span>

2. The above array can also be used as an array in the object, which is slightly different in writing.

<select id="Test"  resultClass="dto">             select *             from UserInfo             where userId in                 <iterate open="(" close=")" conjunction="," property="ArrValue" >                      #ArrValue[]#                 </iterate>         </select> 

3. Input data after in using string, but remember to use $ instead ##

<select id="queryAllUserinfo" parameterClass="dto"resultClass="dto">SELECT u.USERID,ui.id,u.USERNAME,u.ACCOUNT,u.SEX,ui.specialty,ui.address,ui.idnumber,ui.school,ui.nation,ui.political_landscape,ui.phone,ui.email,ui.qq,ui.job_category,ui.stu_class,ui.create_tm,ui.modify_tmfrom eauser u,TB_USER_INFO ui         WHERE u.ACCOUNT = ui.ACCOUNT        <dynamic> <isNotEmpty prepend="AND" property="userids">                 ui.id in ($userids$)            </isNotEmpty></dynamic></select>