mybatis映射文件中三种设置id的方式

<!-- 1.自己指定主键 -->
<insert id="insertUser" parameterType="com.yuer.bean.Users">
insert into users
values(#{userId},#{userName},#{userPwd},#{userAge},#{userSex},#{addr})
</insert>


<!-- 2.数据库自增 -->
<insert id="insertUser02" parameterType="com.yuer.bean.Users">
insert into
users(userName,userPwd,userAge,userSex,userAddr)
values(#{userName},#{userPwd},#{userAge},#{userSex},#{addr})
</insert>


<!-- 3.通过程序获取 -->
<insert id="insertUser03" parameterType="com.yuer.bean.Users">
<!--selectKey:生成key 将查询的结果，赋值给对应的属性 -->
<selectKey keyProperty="userId" resultType="int" order="BEFORE">
select LAST_INSERT_ID()
</selectKey>
insert into
users(userId,userName,userPwd,userAge,userSex,userAddr)
values(#{userId},#{userName},#{userPwd},#{userAge},#{userSex},#{addr})
</insert>