SpringBoot使⽤Mybatis逆向⼯程⽣成项⽬(图⽂讲解)前⾔
本篇博客旨在教学SpringBoot使⽤Mybatis逆向⼯程⽣成项⽬
环境配置:
MySQL 5.7.28
SpringBoot 2.3.1.RELEASE
数据库配置:
create database mysqltest;
use mysqltest;
springboot推荐算法
create table t_user(
`id`int primary key auto_increment,
`username`varchar(30)not null unique,
`password`varchar(40)not null,
`email`varchar(50)
);
## 插⼊初始化测试数据
insert into t_user(`username`,`password`,`email`)values('admin','admin','admin@qq'); insert into t_user(`username`,`password`,`email`)values('wzg168','123456','admin@qq'); insert into t_user(`username`,`password`,`email`)values('admin168','123456','admin@qq'); insert into t_user(`username`,`password`,`email`)values('lisi','123456','admin@qq'); insert into t_user(`username`,`password`,`email`)values('wangwu','123456','admin@qq');
create table t_book(
`id`int primary key auto_increment,
`name`varchar(50),
`author`varchar(50),
`price`decimal(11,2),
`sales`int,
`stock`int
);
## 插⼊初始化测试数据
insert into t_book(`id`,`name`,`author`,`price`,`sales`,`stock`)
values(null,'java从⼊门到放弃','国哥',80,9999,9);
insert into t_book(`id`,`name`,`author`,`price`,`sales`,`stock`)
values(null,'数据结构与算法','严敏君',78.5,6,13);
insert into t_book(`id`,`name`,`author`,`price`,`sales`,`stock`)
values(null,'怎样拐跑别⼈的媳妇','龙伍',68,99999,52);
insert into t_book(`id`,`name`,`author`,`price`,`sales`,`stock`)
values(null,'⽊虚⾁盖饭','⼩胖',16,1000,50);
insert into t_book(`id`,`name`,`author`,`price`,`sales`,`stock`)
values(null,'C++编程思想','刚哥',45.5,14,95);
insert into t_book(`id`,`name`,`author`,`price`,`sales`,`stock`)
values(null,'蛋炒饭','周星星',9.9,12,53);
insert into t_book(`id`,`name`,`author`,`price`,`sales`,`stock`)
values(null,'赌神','龙伍',66.5,125,535);
⼀、创建SpringBoot项⽬
创建好之后导⼊依赖如下:
<parent>
<artifactId>spring-boot-dependencies</artifactId>
<groupId>org.springframework.boot</groupId>
<version>2.3.1.RELEASE</version>
</parent>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- 逆向⼯程核⼼jar包 -->
<dependency>
<groupId&ator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.7</version>
</dependency>
<!-- 连接数据库的jar包,如果没有会报错 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
</dependencies>
<build>
<plugins>
<!-- 逆向⼯程的插件,没有的话会报错 -->
<plugin>
<groupId&ator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.2</version>
<configuration>
<verbose>true</verbose>
<overwrite>true</overwrite>
</configuration>
</plugin>
</plugins>
</build>
⼆、创建⼦Module⽤于准备⽣成pojo和mapper⽂件

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198,我们将在24小时内删除。