<insertid="add"parameterType="com.dsm.domain.Blog"><selectKeykeyProperty="id"keyColumn="id"resultType="Integer">
select last_insert_id();
</selectKey>
insert into blog VALUES
(null,#{userModel.id},#{title},#{content},#{blogTypeModel.id},#{insertTime},#{insertUser},#{updateTime},0)
</insert>
第二种:使用主键自增策略
<insertid="add"parameterType="com.dsm.domain.Blog"useGeneratedKeys="true"keyProperty="id">
insert into blog VALUES
(null,#{userModel.id},#{title},#{content},#{blogTypeModel.id},#{insertTime},#{insertUser},#{updateTime},0)
</insert>