JavaWeb完整案例详细步骤( 二 )

  • 【JavaWeb完整案例详细步骤】数据库sql文件
/* Navicat Premium Data Transfer? Source Server         : Mybatis Source Server Type  : MySQL Source Server Version : 50528 Source Host           : localhost:3306 Source Schema         : test? Target Server Type  : MySQL Target Server Version : 50528 File Encoding         : 65001? Date: 16/10/2022 09:32:18*/?SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;?-- ------------------------------ Table structure for brand-- ----------------------------DROP TABLE IF EXISTS `brand`;CREATE TABLE `brand`  (  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',  `brand_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '品牌名',  `company_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '公司名',  `ordered` int(11) NOT NULL COMMENT '排序字段',  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '描述信息',  `status` int(11) NOT NULL COMMENT '状态',  PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 74 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;?-- ------------------------------ Records of brand-- ----------------------------INSERT INTO `brand` VALUES (1, '小潮Team', '上海潮晟文化传播有限公司', 2, '带给别人快乐是一件很酷的事情', 1);INSERT INTO `brand` VALUES (2, '宠物星球', '凌飞科技有限公司', 1, '为理想打造梦幻家园', 1);INSERT INTO `brand` VALUES (3, '小潮Team', '上海潮晟文化传播有限公司', 3, '带给别人快乐是一件很酷的事情', 1);INSERT INTO `brand` VALUES (4, '小潮Team', '上海潮晟文化传播有限公司', 5, '带给别人快乐是一件很酷的事情', 1);INSERT INTO `brand` VALUES (5, '小潮Team', '上海潮晟文化传播有限公司', 10, '带给别人快乐是一件很酷的事情', 1);INSERT INTO `brand` VALUES (6, '宠物星球', '凌飞科技有限公司', 15, '为理想打造梦幻家园', 1);INSERT INTO `brand` VALUES (7, '宠物星球', '凌飞科技有限公司', 18, '为理想打造梦幻家园', 1);INSERT INTO `brand` VALUES (8, '小米', '小米科技有限公司', 102, '为发烧而生', 0);INSERT INTO `brand` VALUES (9, '华为', '华为科技有限公司', 20, '就是割韭菜', 0);INSERT INTO `brand` VALUES (10, '三只松鼠', '三只松鼠股份有限公司', 50, '吃吃吃', 1);INSERT INTO `brand` VALUES (11, '京东', '北京京东世纪贸易有限公司', 34, '嗖嗖嗖', 1);INSERT INTO `brand` VALUES (12, '腾讯', '腾讯计算机系统有限公司', 45, '就是圈钱', 1);INSERT INTO `brand` VALUES (13, '百度', '百度在线网络技术公司', 10, '搜的就是快', 1);INSERT INTO `brand` VALUES (14, 'aa', 'aaa', 23, 'aaa', 0);INSERT INTO `brand` VALUES (15, 'bbb', 'bbb', 24, 'bbb', 1);INSERT INTO `brand` VALUES (16, 'ccc', 'ccc', 25, 'ccc', 0);INSERT INTO `brand` VALUES (17, 'ddd', 'ddd', 26, 'ddd', 1);INSERT INTO `brand` VALUES (18, 'eee', 'eee', 27, 'eee', 1);INSERT INTO `brand` VALUES (19, 'fff', 'fff', 28, 'fff', 1);INSERT INTO `brand` VALUES (20, 'ggg', 'ggg', 29, 'ggg', 1);INSERT INTO `brand` VALUES (21, 'hhh', 'hhh', 30, 'hhh', 0);INSERT INTO `brand` VALUES (22, 'iii', 'iii', 31, 'iii', 1);INSERT INTO `brand` VALUES (23, 'jjj', 'jjj', 32, 'jjj', 0);INSERT INTO `brand` VALUES (24, 'kkk', 'kkk', 33, 'kkk', 1);INSERT INTO `brand` VALUES (25, 'lll', 'lll', 34, 'lll', 1);INSERT INTO `brand` VALUES (26, 'mmm', 'mmm', 35, 'mmm', 1);INSERT INTO `brand` VALUES (27, 'nnn', 'nnn', 36, 'nnn', 1);INSERT INTO `brand` VALUES (28, '111', '111', 37, '111', 0);INSERT INTO `brand` VALUES (29, '222', '222', 38, '222', 0);INSERT INTO `brand` VALUES (30, '333', '333', 39, '333', 0);INSERT INTO `brand` VALUES (31, '444', '444', 40, '444', 0);INSERT INTO `brand` VALUES (32, '555', '555', 41, '555', 0);INSERT INTO `brand` VALUES (33, '666', '666', 42, '666', 1);INSERT INTO `brand` VALUES (34, '777', '777', 43, '777', 0);INSERT INTO `brand` VALUES (35, '888', '888', 44, '888', 1);?SET FOREIGN_KEY_CHECKS = 1;?

经验总结扩展阅读