研究了通过 Navicat Premium 手动新建表添加字段没有设置主键自增
需要通过 sql 语句建表设置主键 id 自增:
[id] int IDENTITY(1,1) NOT NULL,
具体创建表示例:
CREATE TABLE [dbo].[BSRecord] (
[id] int IDENTITY(1,1) NOT NULL,
[shipmentNo] varchar(11) COLLATE Chinese_PRC_CI_AS NULL,
[fileName] varchar(35) COLLATE Chinese_PRC_CI_AS NULL,
[pageId] int NULL,
[type] int NULL,
PRIMARY KEY CLUSTERED ([id] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO
可以看到实现了 id 自增
项目代码问题,JPA insert 数据报错
需要在 Entity 处 id 添加注解自增
@GeneratedValue(strategy = GenerationType.IDENTITY)