在设置好主键自增的基础上
dao 层
void saveFormwork(Map<String, Object> params);
xml文件中
<insert id="saveFormwork" parameterType="java.util.Map" >
<selectKey resultType="java.lang.Long" order="AFTER" keyProperty="mbid">
SELECT SEQ_EIS_TJMB.CURRVAL as mbid FROM DUAL
</selectKey>
insert into eis_tjmb
(mbmc,mbfl,sfqs,xh,mbbz,zt,mblx,create_time,create_id,create_name,
ym_sfxs,ym_mb,ym_position,ym_hx,ym_ym,ym_ym_position,
yj_sfxs,yj_mb,yj_position,yj_hx,yj_ym,yj_ym_position)
values
(#{mbmc},#{mbfl},#{sfqs},#{xh},#{mbbz},#{zt},#{mblx},#{create_time},#{create_id},#{create_name},
#{ym_sfxs},#{ym_mb},#{ym_position},#{ym_hx},#{ym_ym},#{ym_ym_position},
#{yj_sfxs},#{yj_mb},#{yj_position},#{yj_hx},#{yj_ym},#{yj_ym_position})
</insert>
service层
this.formworkDao.saveFormwork(map);
Long newMbid = (Long) map.get("mbid");//插入数据后得到该条数据的主键