mybatis 新增返回主键

 <select id="addRecycleRecord" parameterType="cn.eshore.dataCenter.pojo.RecycleRecord" resultType="cn.eshore.dataCenter.pojo.RecycleRecord" >
	    insert into t_ob_recycle_record (belong_project,task_name,recycle_time,recycle_people,recycle_type,recycler,recycle_count,recycle_cause,activity_name) value
	     (#{belongProject},#{taskName},#{recycleTime},#{recyclePeople},#{recycleType},#{recycler},#{recycleCount},#{recycleCause},#{activityName});
        select @@IDENTITY as id;
	</select >

  

 

 public int addRecycleRecord(RecycleRecord recycleRecord){
         List<RecycleRecord> recordList= getSqlSession().selectList("addRecycleRecord", recycleRecord);
         return recordList.get(0).getId();
    }

  

posted @ 2021-01-21 14:27  Lost blog  阅读(180)  评论(0编辑  收藏  举报