java进阶|Mybatis系列文章(二)之高级用法Provider

 

一,持久层框架MyBatis介绍

MyBatis 本是apache的一个开源项目iBatis, 2010年这个项目由apache software foundation 迁移到了google code，并且改名为MyBatis 。2013年11月迁移到Github。
iBATIS一词来源于“internet”和“abatis”的组合，是一个基于Java的持久层框架。iBATIS提供的持久层框架包括SQL Maps和Data Access Objects（DAOs）

二，项目搭建所需要的jar依赖信息

       <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.2</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </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>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-aop -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-aop</artifactId>
            <version>2.2.5.RELEASE</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper-spring-boot-starter -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.12</version>
        </dependency>

  三，项目所依赖的application.yaml配置信息如下

server:
  port: 8080
spring:
  application:
    name: mybatis-annotation


  datasource:
    url: jdbc:mysql://localhost:3306/annotation?useSSL=false&serverTimezone=UTC
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
  configuration:
    ##配置项:开启下划线到驼峰的自动转换，作用:将数据库字段根据驼峰规则自动注入到对象属性
    map-underscore-to-camel-case: on
logging:
  level:
    com.wpw.mybatisannotation: debug

四:项目依赖的sql信息如下   

create database annotation;##创建数据库
use annotation;##切换数据库为annotation
select database();##查看当前数据是否为annotation
show tables;##查看当前数据库annotation都有哪些表
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`
(
    `id`         int auto_increment primary key,
    `username`   varchar(50),
    `password`   varchar(50),
    `mobile_num` varchar(15)
);
desc user;##查看表结构
INSERT INTO `user`
VALUES ('1', 'admin001', '123456', '13507660631');
INSERT INTO `user`
VALUES ('