<select id="getYear" parameterType="java.lang.String" resultMap="BaseResultMap">
SELECT
t1.grainannual,
sum(storecount) as storecount
FROM
t_store t1
LEFT JOIN t_depot t2 on t2.graindepot=t1.graindepot
<where>
<if test="_parameter!=null and _parameter!=''">
t2.id=#{_parameter}
</if>
</where>
GROUP BY grainannual
</select>
解决方法1:
将xml里的传参数替换为”_parameter”
解决方法2:
Dao层接口方法的参数声明加上@Param(“parentId”)
如:List findInnerByPid(@Param(“parentId”) String parentId);