Mybatis传递单个参数判空，需要在参数前加@Param参数绑定

xxMapper.java

List<SysResource> findResourceByPid(Integer pid);

xxMapper.xml

<!-- 通过父节点Id获取子节点资源 -->

<select id="findResourceByPid" resultMap="BaseResultMap" parameterType="java.lang.Integer" >

select

<include refid="Base_Column_List" />

from sys_resource where 1 = 1

<choose>

<when test=" pid!= null">

and PID = #{ pid,jdbcType=INTEGER}

</when>

<otherwise>

and PID is null

</otherwise>

</choose>

</select>

pid传递非空时，报如下错误：

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named ' pid ' in 'class java.lang.Integer'

修改如下解决：

List<SysResource> findResourceByPid( @Param("pid") Integer pid);