Parameter index out of range (2 ＞ number of parameters, which is 1).

mapper.xml里面如下：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.gzhwebuser.mapper.GatewayMapper">
    <select id="getGatewayByOpenId" resultType="map" parameterType="map">
--         select g.id, g.getway_num, g.working_time, f.name, g.getway_name, g.lng, g.lat
--         from getways g left join fense f on g.fense_id = f.id
--         where g.id in (select getway_id from vip_red where user_id = #{map.operate_openid});
        select g.id, g.getway_num, g.working_time, f.name, g.getway_name, g.lng, g.lat
        from getways g left join fense f on g.fense_id = f.id
        <choose>
            <when test="map.helmetColor == 'red'">
                where g.id in (select getway_id from vip_red where user_id = #{map.userId})
            </when>
            <when test="map.helmetColor == 'white' || map.helmetColor == 'admin' || map.helmetColor == 'visitor'">
                where g.company_id = #{map.companyId}
            </when>
        </choose>
    </select>
</mapper>

报错：

Parameter index out of range (2 > number of parameters, which is 1).

当删除xml文件里面已经注释掉的语句：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.gzhwebuser.mapper.GatewayMapper">
    <select id="getGatewayByOpenId" resultType="map" parameterType="map">
        select g.id, g.getway_num, g.working_time, f.name, g.getway_name, g.lng, g.lat
        from getways g left join fense f on g.fense_id = f.id
        <choose>
            <when test="map.helmetColor == 'red'">
                where g.id in (select getway_id from vip_red where user_id = #{map.userId})
            </when>
            <when test="map.helmetColor == 'white' || map.helmetColor == 'admin' || map.helmetColor == 'visitor'">
                where g.company_id = #{map.companyId}
            </when>
        </choose>
    </select>
</mapper>

运行成功！！！

打印了下SQL语句，发现当有注释的时候，查询语句如下：

-- select g.id, g.getway_num, g.working_time, f.name, g.getway_name, g.lng, g.lat -- from getways g left join fense f on g.fense_id = f.id -- where g.id in (select getway_id from vip_red where user_id = ?); select g.id, g.getway_num, g.working_time, f.name, g.getway_name, g.lng, g.lat from getways g left join fense f on g.fense_id = f.id where g.id in (select getway_id from vip_red where user_id = ?)

似乎是因为整个 getGatewayByOpenId 会把注释也拼接进整个 SQL 语句里面。