MyBatis : Using Multipe inputs from List

Question

Passing List to MyBatis. can we pass multiple input to IN for SELECT statement as mentioned below. please correct me

dao interface:

public List<Integer> getObjects(List<Test> testList)


Mybatis :
<select id="getObjects" resultType = "Integer">
 SELECT KEY FROM TABLEA WHERE number IN(<foreach collection="TEST" 
  index="index" item="item" separator=", ">
  #{number}
</foreach>)

score 0 · Answer 1 · answered Aug 04 '17 at 08:39

0

Following code would work :

<select id="getObjects" resultType = "Integer">
 SELECT KEY FROM TABLEA WHERE number IN
 (<foreach collection="list" 
   index="index" item="item" separator=", ">
   #{item.number}
   </foreach>)
</select>

answered Aug 04 '17 at 08:39

Vamsi Krishna

9
5

1 Answers1