ibatis iterate 数组

最新推荐文章于 2021-02-01 04:56:31 发布

ytuwlg

最新推荐文章于 2021-02-01 04:56:31 发布

阅读量182

点赞数

分类专栏： ibatis 文章标签： iBATIS

本文链接：https://blog.csdn.net/ytuwlg/article/details/83465269

版权

ibatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

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.