一、在mysql中创建对应的sql
create table `test_user`(
`id` int not null auto_increment comment '主键',
`user_name` varchar(50) character set utf8mb4 not null comment '用户名',
`password` varchar(31) character set utf8mb4 not null comment '密码',
`email` varchar(50) character set utf8mb4 default null comment '邮箱',
`auto_create_case_job_name` varchar(50) character set utf8mb4 default null comment '自动生成用例job名称,不为空时表示已经创建job',
`start_test_job_name` varchar(50) character set utf8mb4 default null comment '执行测试job名称 不为空时表示已经创建job',
`default_jekins_id` varchar(50) character set utf8mb4 default null comment '默认jekins服务器',
`create_time` datetime not null comment '创建时间',
`update_time` datetime not null comment '更新时间',
primary key(id) using BTREE
)engine = InnoDB AUTO_INCREMENT =1 default charset=utf8mb4 collate=utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
二、添加maven依赖
pom.xml
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.2</version>
<configuration>
<configurationFile>src/main/resources/generator/generatorConfig.xml</configurationFile>
<overwrite>true</overwrite>
<verbose>true</verbose>
</configuration>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper</artifactId>
<version>3.4.6</version>
</dependency>
</dependencies>
</plugin>
整体:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.4.5</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.example</groupId>
<artifactId>SpringBootTest</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>SpringBootTest</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
<!-- MyBatis Generator -->
<!-- Java接口和实体类 -->
<targetJavaProject>${
basedir}/src/main/java</targetJavaProject>
<targetMapperPackage>tk.mybatis.mapper.mapper</targetMapperPackage>
<targetModelPackage>