适用于数据库具有自增机制:
useGeneratedKeys:mybatis使用主键自增机制
keyColumn:数据主键列使用自增
keyProperty:自动生成的主键值,默认存储到对像的id属性中
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="mapper.UserMapper">
<sql id="baseSql">
id,username,password
</sql>
<sql id="baseSql2">
username,password
</sql>
<select id="selectById" resultType="User">
select
<include refid="baseSql"></include>
from user where id = #{id}
</select>
<!--
适用于数据库具有自增机制:
useGeneratedKeys:mybatis使用主键自增机制
keyColumn:数据主键列使用自增
keyProperty:自动生成的主键值,默认存储到对像的id属性中
-->
<insert id="insert" parameterType="User" useGeneratedKeys="true" keyColumn="ID" keyProperty="id">
insert into USER (username,password) values (#{username},#{password})
</insert>
<!--selectKey用于查询数据生成的主键
数据库不一定是自增性质,也可以是如Oracle的序列方式生成的主键
-->
<insert id="insert2" parameterType="User">
<selectKey keyProperty="id" keyColumn="ID" resultType="User" order="AFTER">
SELECT LAST_INSERT_ID() as ID FROM DUAL
</selectKey>
insert into USER (username,password) values (#{username},#{password})
</insert>
</mapper>