目录
1.1在User表中添加datetime类型的新的字段 create_time、update_time
2.4通过MybatisPlusConfig 配置类往容器中放入组件
4.3元对象处理器接口添加deleted的insert默认值
一、创建并初始化数据库
1、创建数据库:
create database if not exists mybatis_plus;
2、创建 User
表
use mybatis_plus;
CREATE TABLE user
(
id InT(11) primary key auto_increment COMMENT '主键ID',
name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名',
age INT(11) NULL DEFAULT NULL COMMENT '年龄',
email VARCHAR(30) NULL DEFAULT NULL COMMENT '邮箱',
);
3、插入数据
DELETE FROM user;
INSERT INTO user (id, name, age, email) VALUES
(1, 'Jone', 18, 'test1@baomidou.com'),
(2, 'Jack', 20, 'test2@baomidou.com'),
(3, 'Tom', 28, 'test3@baomidou.com'),
(4, 'Sandy', 21, 'test4@baomidou.com'),
(5, 'Billie', 24, 'test5@baomidou.com');
二、创建SpringBoot项目
1、引入依赖
<dependencies>
<!--mybatis-plus-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.0.5</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!--开发者工具-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
<optional>true</optional>
</dependency>
<!--lombok用来简化实体类-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<excludes>
<exclude>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</exclude>
</excludes>
</configuration>
</plugin>
</plugins>
</build>
2、添加application.yml配置文件
spring:
datasource:
url: jdbc:mysql://localhost:3306/mybatis_plus?useSSL=false&serverTimezone=UTC
username: root #数据库账号
password: 1234 #数据库密码
driver-class-name: com.mysql.cj.jdbc.Driver #mysql8.0使用cj包下的
mybatis-plus:
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #mybatis日志输出
3、创建实体类User
@Data
public class User {
private Long id;
private String name;
private Integer age;
private String email;
}
4、创建UserMapper
@Repository
public interface UserMapper extends BaseMapper<User> {
}
5、在主启动类上添加@MapperScan
@MapperScan("chang.map