SQL Server - mapper实现主键自增

方案1：使用useGenerateKeys

<insert id="insertStudent" parameterType="com.xxx.Student" useGeneratedKeys="true" keyProperty="id">
	insert into student
	(
		name,
		sex
	)
	values
	(
		#{name},
		#{sex}
	)
</insert>

方案2：使用 @@IDENTITY

<insert id="insertStudent" parameterType="com.xxx.Student">
	insert into student
	(
		name,
		sex
	)
	values
	(
		#{name},
		#{sex}
	)
	SELECT @@IDENTITY AS sizerUnid
</insert>

方案3：使用 selectKey

<insert id="insertStudent" parameterType="com.xxx.Student">
	insert into student
	(
		name,
		sex
	)
	values
	(
		#{name},
		#{sex}
	)
	<selectKey keyColumn="id" keyProperty="id" order="AFTER" resultType="java.lang.Integer">
			SELECT IDENT_CURRENT('table') AS id
	</selectKey>
</insert>