- 【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;?
经验总结扩展阅读
-
|儿女结婚之前,准亲家见面,要做到“两问、两不问”
-
|喜欢吃的菜,第二天餐桌上一定有,有一种幸福叫婆婆宠!
-
老阿姨|女孩子有这“3脸型”,请放过“刘海儿”,否则当心被叫“老阿姨”
-
-
也许是幼年时期的我们 也许真心爱过的我们,被失去的情感伤过。不敢继续爱了
-
-
-
-
-
-
-
2023仪器类热门专业有哪些 就业前景比较好的专业
-
-
-
一辈子是一件太漫长的事情|愿意为你做这6件事的男人,值得你爱他一辈子!
-
2022年农历九月初一举办成人仪式吉日 2022年9月26日是举办成人仪式的黄道吉日吗
-
中国不容错过的这几个适合旅游的好地方 中国旅游景点推荐
-
-
-
硫磺硫磺皂每天用来洗脸,“皮肤”会有什么变化,看完你就懂了