水果库存管理系统

01：数据库设计：

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for fruit
-- ----------------------------
DROP TABLE IF EXISTS `fruit`;
CREATE TABLE `fruit`  (
  `fruitId` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类别',
  `breed` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '品种',
  `area` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '产地',
  `brief` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简介',
  `weight` int(11) NOT NULL COMMENT '总重量',
  `price` float(10, 2) NULL DEFAULT NULL COMMENT '单价',
  PRIMARY KEY (`fruitId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of fruit
-- ----------------------------
INSERT INTO `fruit` VALUES (14, '苹果', '好苹果', '三洞', '磨牙', 10000, 10.00);
INSERT INTO `fruit` VALUES (15, '梨', '好苹果', '三洞', '磨牙', 10000, 10.00);
INSERT INTO `fruit` VALUES (16, '水果', '好苹果', '三洞', '磨牙'