/* 点击爆炸效果*/

Mybatis数据添加返回主键返回为1的问题

<insert id="saveWorksReport" useGeneratedKeys="true" keyProperty="worksReportId" parameterType="com.supplychain.entity.WorksReport">
<!-- <selectKey resultType="int" order="AFTER" keyProperty="worksReportId">
SELECT LAST_INSERT_ID();
</selectKey>-->
insert into works_report (original_papers,user_id,works_id,start_date,report_detail,original_works_url) values
(#{originalPapers},#{userId},#{worksId},now(),#{reportDetail},#{originalWorksUrl})

</insert>
第一种<insert id="saveWorksReport" useGeneratedKeys="true" keyProperty="worksReportId" parameterType="com.supplychain.entity.WorksReport">
第二种
<selectKey resultType="int" order="AFTER" keyProperty="worksReportId">
SELECT LAST_INSERT_ID();
</selectKey>


WorksReport worksReport = new WorksReport();
Integer saveWorksReport = worksReportMapper.saveWorksReport(worksReport);
之前的代码返回的是saveWorksReport所以一直是1,正确返回应该是worksReport.getWorksReportId();
posted @ 2020-04-27 10:39  tom的猫  阅读(745)  评论(0编辑  收藏  举报