server的自增主键返回函数 sql_Mybatis 使用foreach向sql server插入数据，返回自增主键只有最后一条的问题和解决...

MyBatis version

3.5.5

Database vendor and version

MS Sql Server 2008 R2，MS Sql Server 2019

com.microsoft.sqlserver:mssql-jdbc:8.4.0.jre8

com.microsoft.sqlserver:mssql-jdbc:7.4.1.jre8

Test case or example project

Table:

CREATE TABLE [dbo].[student](

[id] [int] IDENTITY(1,1) NOT NULL,

[name] [varchar](50) NOT NULL,

CONSTRAINT [PK_student] PRIMARY KEY CLUSTERED

(

[id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

Entity:

public class Student implements Serializable {

private static final long serialVersionUID = -9113130818289196330L;

private Integer id;

private String name;

}