myBatis一些问题

mapper：

MyselfSatisfactionPage getGoodInfo(String coachId, String month);

xml:

<select id="getGoodInfo" parameterType="string" resultMap="coachMap">
SELECT
round((t1.good_evalute_num / t1.total_evalute_num) * 100,1) as level, ‘‘ as dsf
FROM sm_coach_month_evaluate t1 WHERE t1.coach_id = #{coachId} AND t1.month =#{month}
</select>

会报：

Parameter ‘coachId‘ not found. Available parameters are [1, 0, param1, param2]

多个参数传入不能识别，需要用#{0}，#{1}。也可以用parameterMap

如果是<if text=‘_parameter.get("0") == 1‘></if>

myBatis一些问题

原文：http://www.cnblogs.com/mqy1/p/6647584.html