第 0 章 Readme

朱雀 2023-01-17 15:55 105阅读 0赞

# 第 0 章 Readme #

## 1、参考资料 ##

[尚硅谷MyBatisPlus教程(mybatis-plus框架精讲)][MyBatisPlus_mybatis-plus]

[MyBatis-Plus][]

## 2、笔记地址 ##

[Mybatis][]

## 3、项目地址 ##

[Oneby][] **/** [mybatis-plus-learn][]

## 4、SQL 脚本 ##

注：每个章节的实体类和数据库表都在不一样，以下是最终数据库表的 schema 和 data 脚本

CREATE TABLE `t_user` (                                                                                                                                                                                                                                                                                                                                                                                                                    
        `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',                                                                                                                                                                                                                                                                                                                                                                              
        `username` varchar(30) DEFAULT NULL COMMENT '姓名',                                                                                                                                                                                                                                                                                                                                                                                    
        `age` int(11) DEFAULT NULL COMMENT '年龄',                                                                                                                                                                                                                                                                                                                                                                                             
        `email` varchar(50) DEFAULT NULL COMMENT '邮箱',                                                                                                                                                                                                                                                                                                                                                                                       
        `version` int(11) DEFAULT NULL,                                                                                                                                                                                                                                                                                                                                                                                                          
        `deleted` int(11) DEFAULT '0',                                                                                                                                                                                                                                                                                                                                                                                                           
        `create_time` datetime DEFAULT NULL,                                                                                                                                                                                                                                                                                                                                                                                                     
        PRIMARY KEY (`id`)                                                                                                                                                                                                                                                                                                                                                                                                                       
    ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1   
    
    insert into `t_user` (`id`, `username`, `age`, `email`, `version`, `deleted`, `create_time`) values('1','Jone','18','test1@baomidou.com','0','0','2021-04-28 21:51:50');
    insert into `t_user` (`id`, `username`, `age`, `email`, `version`, `deleted`, `create_time`) values('2','Jack','20','test2@baomidou.com','0','0','2021-04-28 21:51:53');
    insert into `t_user` (`id`, `username`, `age`, `email`, `version`, `deleted`, `create_time`) values('3','Tom','28','test3@baomidou.com','0','0','2021-04-28 21:51:53');
    insert into `t_user` (`id`, `username`, `age`, `email`, `version`, `deleted`, `create_time`) values('4','Sandy','21','test4@baomidou.com','0','0','2021-04-28 21:51:54');
    insert into `t_user` (`id`, `username`, `age`, `email`, `version`, `deleted`, `create_time`) values('5','Billie','24','test5@baomidou.com','0','0','2021-04-28 21:51:54');
    insert into `t_user` (`id`, `username`, `age`, `email`, `version`, `deleted`, `create_time`) values('6','Oneby','21',NULL,'0','0','2021-04-28 21:51:55');
    insert into `t_user` (`id`, `username`, `age`, `email`, `version`, `deleted`, `create_time`) values('7','Heygo',NULL,'Heygo@baomidou.com','0','0','2021-04-28 21:51:57');

[MyBatisPlus_mybatis-plus]: https://www.bilibili.com/video/BV1Ds411E76Y
[MyBatis-Plus]: https://mybatis.plus/
[Mybatis]: https://blog.csdn.net/oneby1314/category_11026446.html
[Oneby]: https://gitee.com/Heygogo
[mybatis-plus-learn]: https://gitee.com/Heygogo/mybatis-plus-learn