service
List<Position> pos = positionMapper.selectPositionStudentByPosId("1,2,3");
mybatis
//注意得用@Param ,否则会在xml中会获取不到ids参数,导致出现问题
public List<Position> selectPositionStudentByPosId(@Param("ids") String ids);
mybatis的xml中
<select id="selectPositionStudentByPosId" resultMap="positionStudentResultMap" parameterType="string">
SELECT *
FROM tb_position p
<if test="ids != null and ids!= ''">
WHERE p.id IN
<foreach item="item" index="index" collection="ids.split(',')" open="(" separator="," close=")">
'${item}'
</foreach>
</if>
</select>
上面的mybatis拼接成的sql语句是这样的