Mybatis Plus 文档学习
前期准备
导入sql
/*
Navicat Premium Data Transfer
Source Server : [mysql] localhost
Source Server Type : MySQL
Source Server Version : 50724
Source Host : localhost:3306
Source Schema : mybatis_test
Target Server Type : MySQL
Target Server Version : 50724
File Encoding : 65001
Date: 02/09/2020 13:02:57
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- create database
CREATE DATABASE `mybatis_test`;
-- use database
USE `mybatis_test`;
-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
`book_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '书编号',
`book_name` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '书名称',
`price` float NULL DEFAULT NULL COMMENT '书价格',
`content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '书内容',
PRIMARY KEY (`book_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES (1, '《Java编程思想》', 87.5, 'Java编程圣经,每一位Java程序员必读');
INSERT INTO `book` VALUES (2, '《JavaScript高级程序设计》', 108.7, '学习JavaScript的经典书籍,非常畅销');
INSERT INTO `book` VALUES (3, '《Linux 菜鸟教程:基础篇》', 76.5, '学习Linux基础知识,Linux 入门级书籍');
INSERT INTO `book` VALUES (4, '《Linux 菜鸟教程:服务器篇》', 77, '教你在Linux中搭建各种服务器,如:Nginx、Tomcat、Apache等等');
-- ----------------------------
-- Table structure for book_ext
-- ----------------------------
DROP TABLE IF EXISTS `book_ext`;
CREATE TABLE `book_ext` (
`book_id` int(10) UNSIGNED NOT NULL COMMENT '书编号',
`book_summary` varchar(1000) CHARACTER