image.png
    MyBatis-plus是mybatis的增强工具,在MyBatis 上只做增强,不做改变,为简化开发,提高效率而生
    image.png
    MyBatis-plus和mybatis就像是魂斗罗中的两个兄弟
    安装MyBatisX插件
    image.png
    1、创建项目
    2、导入依赖

    1. <dependencies>
    2.   <dependency>
    3.     <groupId>org.springframework.boot</groupId>
    4.     <artifactId>spring-boot-starter-web</artifactId>
    5.   </dependency>
    7.   <dependency>
    8.     <groupId>org.projectlombok</groupId>
    9.     <artifactId>lombok</artifactId>
    10.     <optional>true</optional>
    11.   </dependency>
    12.   <dependency>
    13.     <groupId>org.springframework.boot</groupId>
    14.     <artifactId>spring-boot-starter-test</artifactId>
    15.     <scope>test</scope>
    16.   </dependency>
    17.   <dependency>
    18.     <groupId>org.springframework.boot</groupId>
    19.     <artifactId>spring-boot-starter-web</artifactId>
    20.   </dependency>
    21.   <dependency>
    22.     <groupId>org.projectlombok</groupId>
    23.     <artifactId>lombok</artifactId>
    24.     <optional>true</optional>
    25.   </dependency>
    26.   <dependency>
    27.     <groupId>org.springframework.boot</groupId>
    28.     <artifactId>spring-boot-starter-test</artifactId>
    29.     <scope>test</scope>
    30.   </dependency>
    31.   <dependency>
    32.     <groupId>mysql</groupId>
    33.     <artifactId>mysql-connector-java</artifactId>
    34.     <version>8.0.21</version>
    35.   </dependency>
    36.   <dependency>
    37.     <groupId>com.alibaba</groupId>
    38.     <artifactId>druid-spring-boot-starter</artifactId>
    39.     <version>1.1.10</version>
    40.   </dependency>
    41.   <dependency>
    42.     <groupId>com.baomidou</groupId>
    43.     <artifactId>mybatis-plus-boot-starter</artifactId>
    44.     <version>3.5.1</version>
    45.   </dependency>
    46.     </dependencies>

    自动配置的内容
    MyBatis PlusAutoConfiguration配置类,MyBatisPlusProperties配置项前缀 mybatis-plus: 就是对mybatis-plus的参数的设置
    SQLSessionFactory已经配置好
    mapperlocations 自动配置好的,默认值是classpath    :/mapper/    /*.xml 意为任意包路径下所有的mapper包下的xml文件
    @Mapper建议替换成MapperScan
    配置mybatisplus

    1. spring:
    2.   datasource:
    3.     type: com.alibaba.druid.pool.DruidDataSource
    4.     driver-class-name: com.mysql.cj.jdbc.Driver
    5.     url: jdbc:mysql://127.0.0.1:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
    6.     username: root
    7.     password: root
    8.   druid:
    9.     initial-size: 5
    10.     min-idle: 5
    11.     maxActive: 20
    12.     maxWait: 60000
    13.     timeBetweenEvictionRunsMillis: 60000
    14.     minEvictableIdleTimeMillis: 300000
    15.     validationQuery: SELECT 1
    16.     testWhileIdle: true
    17.     testOnBorrow: false
    18.     testOnReturn: false
    19.     poolPreparedStatements: true
    20.     maxPoolPreparedStatementPerConnectionSize: 20
    21.     filters: stat,wall,slf4j
    22.     connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000
    23.     web-stat-filter:
    24.       enabled: true
    25.       url-pattern: "/*"
    26.       exclusions: "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*"
    27.     stat-view-servlet:
    28.       url-pattern: "/druid/*"
    29.       allow: 127.0.0.1,192.168.8.109
    30.       deny: 192.168.1.188
    31.       reset-enable: false
    32.       login-username: admin
    33.       login-password: 123456
    34. mybatis-plus:
    35.   type-aliases-package: com.xiaohui.pojo