mybatis 参数为id的坑

 Error querying database.  Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'id' in 'class java.lang.Integer'

 

报错原因：

	<select id="selectUser" parameterType="int" resultType="User">
		select * from user 
		 where 
		 	<if test=" id != null ">id = #{id}</if>
	</select>

 

修改代码：

	<select id="selectUser" parameterType="int" resultType="User">
		select * from user where id=#{id}
	</select>

或者

	<select id="selectUser" parameterType="int" resultType="User">
		select * from user  where
		 	<if test=" _parameter != null ">id = #{_parameter}</if>
	</select>

 

 

 

引起原因，网上说是：

Mybatis默认采用ONGL解析参数，所以会自动采用对象树的形式取Integer.id值，引起报错