<select id="test" parameterType="java.util.List" resultType="user"> select * from jk_user where <foreach collection="list" item="id" open="" close="" separator="or"> id=#{id} </foreach> </select>
