mybatis主键自动回填的实现对应的业务逻辑就是我们在添加数据时,知道表中的主键为自动递增,但是不知道递增到多少个了,但是我们还需要知道该表中的主键数据才能对另一张关联的表进行操作;
例如下面的案例----->>
添加书籍时候还需要对书籍折扣信息表进行更新,
DROP TABLE IF EXISTS `bookstore`;
CREATE TABLE `bookstore` (
`BookId` int(0) NOT NULL AUTO_INCREMENT,
`BookName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`BookPublish` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`BookPrice` double(10, 2) NULL DEFAULT NULL,
`BookKind` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`BookCount` int(0) NULL DEFAULT NULL,
PRIMARY KEY (`BookId`) USING BTREE,
INDEX `name_index`(`BookName`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1234 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of bookstore
-- ----------------------------
INSERT INTO `bookstore` VALUES (1001, 'java入门', '清华出版社', 180.90, '计算机', 90);
INSERT INTO `bookstore` VALUES (1002, 'python深入', '机械工业出版社', 78.60, '计算机', 130);
INSERT INTO `bookstore` VALUES (1003, '前端html', '清华出版社', 88.80, '计算机', 100);
INSERT INTO `bookstore` VALUES (1004, '废都', '张江出版社', 25.70, '文学名著', 100);
INSERT INTO `bookstore` VALUES