ibatis中传入数组的解决方案(转载)

 

版权声明 ：转载时请以超链接形式标明文章原始出处和作者信息及本声明
http://feipingzhao.blogbus.com/logs/33394105.html

It's very simple, however iBATIS documentation does not state this. Suppose you need to issue a query with an IN (....) criterion and you need to pass an array of values into it:

 

  <select id="getSmth" resultClass="myclass">


    select name, body from myclass_table where name in (


      <iterate conjunction=",">#[]#</iterate>


    )


  </select>

 

The essential condition for success is - don't specify the parameterClass attribute in select and don't specify property in iterate , otherwise the query won't work.