"student" table with two columns "id" and "name".
The following is an example query in XML file.
<select id="select" parametertype="HashMap" resulttype="String">
SELECT name FROM student WHERE id IN
<foreach item="item" index="index" collection="studentIds"
open="(" separator="," close=")">
#{item}
</foreach>
</select>
"studentIds" is the name of input list
The following is an example query in XML file.
<select id="select" parametertype="HashMap" resulttype="String">
SELECT name FROM student WHERE id IN
<foreach item="item" index="index" collection="studentIds"
open="(" separator="," close=")">
#{item}
</foreach>
</select>
"studentIds" is the name of input list
Comments
Post a Comment