创建数据库mybatis_plus_1和表product
- CREATE DATABASE `mybatis_plus_1` /*!40100 DEFAULT CHARACTER
- SET utf8mb4 */;
- USE `mybatis_plus_1`;
- CREATE TABLE product (
- id BIGINT ( 20 ) NOT NULL COMMENT '主键ID',
- NAME VARCHAR ( 30 ) NULL DEFAULT NULL COMMENT '商品名称',
- price INT ( 11 ) DEFAULT 0 COMMENT '价格',
- version INT ( 11 ) DEFAULT 0 COMMENT '乐观锁版本号',
- PRIMARY KEY ( id )
- );
添加测试数据
INSERT INTO product (id, NAME, price) VALUES (1, '外星人笔记本', 100);
删除mybatis_plus库product表
- use mybatis_plus;
- DROP TABLE IF EXISTS product;
- <dependency>
- <groupId>com.baomidougroupId>
- <artifactId>dynamic-datasource-spring-