引言:在mapper.xml中:useGeneratedKeys="true"、keyProperty="id",这两个属性将主键封装到id属性上。sql插入执行成功后从实体getId即可。注意:非insert的返回值(影响行数)
<insert id="addRole" parameterType="com.ycs.community.sysbo.domain.po.RolePo" keyProperty="id" useGeneratedKeys="true">
INSERT INTO t_sys_role(code,
`name`,
data_scope,
`level`,
`desc`,
create_time
)
VALUES (
#{code,jdbcType=VARCHAR},
#{name,jdbcType=VARCHAR},
#{dataScope,jdbcType=VARCHAR},
#{level,jdbcType=VARCHAR},
#{desc,jdbcType=VARCHAR},
#{creTm,jdbcType=BIGINT}
)
</insert>
完