当有多个相同类型的参数同时到mapper.xml中去操作的时候
再mapper文件中对参数要加上@Param("接收的参数值")
int getBByTeacherIdAndCategoryIdAndCatsn(@Param("teacherId")int teacherId, @Param("categoryId")int categoryId, @Param("catSn")int catSn);
<select id="getBByTeacherIdAndCategoryIdAndCatsn" resultType="java.lang.Integer"> SELECT id from ms_teacher_upload where teacher_id=#{teacherId,jdbcType=INTEGER} AND category_id=#{categoryId,jdbcType=INTEGER} AND cat_sn=#{catSn,jdbcType=INTEGER} </select>