介绍/*
,Navicat Premium Data 转移
,Source Server ,,,,,,,,: MySQL8.0
,Source Server Type ,,,: MySQL
,Source Server Version : 80022
,Source Host ,,,,,,,,,,: localhost: 3306
,Source Schema ,,,,,,,,: mybatisplus
,Target Server Type ,,,: MySQL
,Target Server Version : 80022
,File Encoding ,,,,,,,,: 65001
,日期:11/06/2021 17:37:58
*/SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS =, 0;
-,- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
——,Table structure for 用户
-,- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
DROP TABLE IF EXISTS “用户”;
CREATE TABLE ‘用户’,,(
“id”,才能长整型数字(0),NOT NULL COMMENT & # 39;主键id # 39;,
“名字”,才能varchar (30), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT & # 39;姓名& # 39;,
“年龄”,才能int (0), NULL DEFAULT NULL COMMENT & # 39;年龄& # 39;,
“电子邮件”,才能varchar (50), CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT & # 39;邮箱& # 39;,
“create_time”,才能datetime (0), NULL DEFAULT NULL COMMENT & # 39;创建时间& # 39;,
“update_time”,才能datetime (0), NULL DEFAULT NULL COMMENT & # 39;修改时间& # 39;,
“版本”,才能int (0), NULL DEFAULT NULL COMMENT & # 39;版本号& # 39;,
“删除”,才能非常小的整数(1),NULL DEFAULT NULL COMMENT & # 39;用于逻辑删除& # 39;,
PRIMARY 才能;KEY (id), USING BTREE=),ENGINE InnoDB CHARACTER SET =, utf8 COLLATE =, utf8_general_ci ROW_FORMAT =,动态;
-,- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
——,Records of 用户
-,- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
INSERT INTO “用户”,VALUES (1), & # 39;约翰# 39;,,18日,& # 39;test1@baomidou.com& # 39;,,空,,空,,空,,NULL);
INSERT INTO “用户”,VALUES (2), & # 39;杰克# 39;,,20日,& # 39;test2@baomidou.com& # 39;,,空,,空,,空,,NULL);
INSERT INTO “用户”,VALUES (3), & # 39;汤姆# 39;,,38岁,& # 39;test3@baomidou.com& # 39;,,空,,& # 39;2021 - 04 - 11,16:13:56& # 39;,,空,,NULL);
INSERT INTO “用户”,VALUES (4, & # 39;桑迪# 39;,,21日,& # 39;test4@baomidou.com& # 39;,,空,,空,,空,,NULL);
INSERT INTO “用户”,VALUES (5, & # 39;比利# 39;,,24日,& # 39;test5@baomidou.com& # 39;,,空,,空,,空,,NULL);
INSERT INTO “用户”,VALUES (1381145367839522818,, & # 39;李白& # 39;,,28日,& # 39;lucy@qq.com& # 39;,,空,,空,,空,,NULL);
INSERT INTO “用户”,VALUES (1381156317133090817,, & # 39;丽丽# 39;,,28日,& # 39;lucyee@qq.com& # 39;,,空,,空,,空,,NULL);
INSERT INTO “用户”,VALUES (1381157235618492418,, & # 39;丽丽# 39;,,28日,& # 39;lucyee@qq.com& # 39;,,空,,空,,空,,NULL);
INSERT INTO “用户”,VALUES (1381158109963096065,, & # 39;丽丽# 39;,,28日,& # 39;lucyee@qq.com& # 39;,, & # 39; 2021 - 04 - 11, 16:12:09& # 39;,,空,,空,,NULL);
INSERT INTO “用户”,VALUES (1381166877736280066,, & # 39;江小白& # 39;,,200,,& # 39;lucyee@qq.com& # 39;,, & # 39; 2021 - 04 - 11, 16:46:59& # 39;,, & # 39; 2021 - 04 - 11, 16:51:57& # 39;,, 2,, NULL);
INSERT INTO “用户”,VALUES (1381186511252258818,, & # 39;东方不败& # 39;,,200,,& # 39;lucyee@qq.com& # 39;,, & # 39; 2021 - 04 - 11, 18:05:00& # 39;,, & # 39; 2021 - 04 - 11, 18:05:47& # 39;,, 2,, 1);
INSERT INTO “用户”,VALUES (1381225266432524290,, & # 39;东方不败11 & # 39;,,28日,& # 39;lucyee@qq.com& # 39;,, & # 39; 2021 - 04 - 11, 20:39:00& # 39;,, & # 39; 2021 - 04 - 11, 20:39:00& # 39;,, 1,, NULL);
SET FOREIGN_KEY_CHECKS =, 1,
小编给大家分享一下MybatisPlus代码生成器怎么用,希望大家阅读完这篇文章之后都有所收获、下面让我们一起去探讨吧!
搭建测试的数据库和表数据的SQL
引入Maven的配置文件
在这里我多引入了大摇大摆测试接口的依赖,因为在MybatisPlus的配置文件里,可以配置自动添加大摇大摆的注解。用于测试接口时的标识。
