1》mybatis出现Result Maps collection already contains value for…BaseResultMap的错误
看是否存在两个id为BaseResultMap的resultMap,删除多余的,只保留一个就可以解决问题。
2. mybatis实现表字段增长
<update id="updateCredits" parameterType="im.jinquan.my.model.TUser">
UPDATE t_user set credits = credits + #{credits} where uid=1002
</update>
3.mybatis插入某三个字段时一直报错,各种尝试直到
<insert id="insertMyData" parameterType="im.jinquan.my.model.TBank">
insert into t_bank (subject_id, chapter_id,
question_type, question_name, option_1,
option_2, option_3, option_4,
option_5, option_6, answer,explain, remark, from
)
values ( #{subjectId,jdbcType=INTEGER}, #{chapterId,jdbcType=INTEGER},
#{questionType,jdbcType=INTEGER}, #{questionName,jdbcType=VARCHAR}, #{option1,jdbcType=VARCHAR},
#{option2,jdbcType=VARCHAR}, #{option3,jdbcType=VARCHAR}, #{option4,jdbcType=VARCHAR},
#{option5,jdbcType=VARCHAR}, #{option6,jdbcType=VARCHAR}, #{answer,jdbcType=VARCHAR},
#{explain,jdbcType=VARCHAR}, #{remark,jdbcType=VARCHAR}, #{from,jdbcType=VARCHAR}
)
</insert>
解决方案 加入 ``
<insert id="insertMyData" parameterType="im.jinquan.my.model.TBank">
insert into t_bank (subject_id, chapter_id,
question_type, question_name, option_1,
option_2, option_3, option_4,
option_5, option_6, answer,`explain`, `remark`, `from`
)
values ( #{subjectId,jdbcType=INTEGER}, #{chapterId,jdbcType=INTEGER},
#{questionType,jdbcType=INTEGER}, #{questionName,jdbcType=VARCHAR}, #{option1,jdbcType=VARCHAR},
#{option2,jdbcType=VARCHAR}, #{option3,jdbcType=VARCHAR}, #{option4,jdbcType=VARCHAR},
#{option5,jdbcType=VARCHAR}, #{option6,jdbcType=VARCHAR}, #{answer,jdbcType=VARCHAR},
#{explain,jdbcType=VARCHAR}, #{remark,jdbcType=VARCHAR}, #{from,jdbcType=VARCHAR}
)
</insert>