<insert id="insert" parameterType="com.mjs.mojisishop.entity.ItemCat" useGeneratedKeys="true" keyProperty="id">
insert into mj_item_cat (typeName, superType, typeSort,
showStatus, created, updated
)
values (#{typename,jdbcType=VARCHAR}, #{supertype,jdbcType=BIGINT}, #{typesort,jdbcType=INTEGER},
#{showstatus,jdbcType=INTEGER}, #{created,jdbcType=TIMESTAMP}, #{updated,jdbcType=TIMESTAMP}
)
</insert>
加上 useGeneratedKeys=“true” keyProperty=“id” 这两个属性