Mybatis-Plus学习

官方网站:点击进入

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus</artifactId>
    <version>undefined</version>
</dependency>
复制代码

1:测试环境

1.1:数据库创建

创建db_mybatis_plus数据库。再创建user表,user表如下

image.png

插入如下数据:

image.png

1.2:springboot项目创建

依赖引入

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.3.1</version>
        </dependency>

        <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>
        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-classic</artifactId>
            <version>1.2.3</version>
        </dependency>
    </dependencies>
复制代码

yml配置文件

spring:
  datasource:
    username: root
    password: yfy57609
    url: jdbc:mysql://1.15.57.103:3306/db_mybatis_plus?serverTimezone=GMT%2B8
    driver-class-name: com.mysql.cj.jdbc.Driver


#mybatis_plus日志配置
mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
复制代码

logback的配置文件

<?xml version="1.0" encoding="UTF-8"?>
<configuration>

    <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
        <encoder>
            <Pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</Pattern>
        </encoder>
    </appender>

    <logger name="com.base22" level="TRACE"/>

    <root level="info">
        <appender-ref ref="STDOUT"/>
    </root>

</configuration>
复制代码

mapper

记得要在启动类上@MapperScan注解

@Repository
public interface UserMapper extends BaseMapper<user> {
}
复制代码

实体类

@Data
public class user {
    private int id;
    private String name;
    private Integer age;
    private String email;
}
复制代码
© 版权声明
THE END
喜欢就支持一下吧
点赞0 分享