<insert id="saveEvidence" parameterType="D_EvidenceInfo" keyProperty="id" >
insert into D_EVIDENCE
(
CUSTOMNUMBER,
PACKAGENO,
NAME,
CONTENT,
EVIDENCEFLAG
)
values
( #{customNumber},
#{packageNo,jdbcType=VARCHAR},
#{name,jdbcType=VARCHAR},
#{content},
#{evidenceFlag}
)
<selectKey resultType="int" keyProperty="id" >
SELECT @@IDENTITY AS ID
</selectKey>
</insert>
调用端java代码
{
D_EvidenceInfo info= new D_EvidenceInfo();
info.setName(“abc”);
//调用Dao做插入操作
Dao.saveEvidence(info);
//返回插入数据库主键调用该实体类get方法里的id字段
SYstem.out.println( "获得插入数据库返回该数据的主键"+info.getId());
}