Mybatis

1.mybatis通用插件

通过mapper GitHub地址https://github.com/abel533/Mapper/wiki
使用通用mapper依赖
注解类上加这段，扫描包下mapper接口
@MapperScan(basePackages = “com.example.mybatisdemo”)

# 不加这段会提示无法映射
mybatis:
  mapper-locations: classpath:mapper/*.xml

<dependency>
  <groupId>tk.mybatis</groupId>
  <artifactId>mapper-spring-boot-starter</artifactId>
  <version>2.1.5</version>
</dependency>

<!DOCTYPE generatorConfiguration
    PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
    <properties resource="generator/config.properties"/>
    <context id="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat">
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>
        <plugin type="tk.mybatis.mapper.generator.MapperPlugin">
            <property name="mappers" value="tk.mybatis.mapper.common.Mapper"/>
            <property name="caseSensitive" value="true"/>
            <property name="lombok" value="Getter,Setter,ToString"/>
        </plugin>
        <jdbcConnection driverClass="${jdbc.driverClass}"
                        connectionURL="${jdbc.url}"
                        userId="${jdbc.user}"
                        password="${jdbc.password}">
        </jdbcConnection>
        <!--实体-->
        <javaModelGenerator targetPackage="com.itmuch.contentcenter.domain.entity.${moduleName}"
                            targetProject="src/main/java"/>
        <!--mapper.xml-->
        <sqlMapGenerator targetPackage="com.itmuch.contentcenter.dao.${moduleName}"
                         targetProject="src/main/resources"/>
        <!--mapper接口-->
        <javaClientGenerator targetPackage="com.itmuch.contentcenter.dao.${moduleName}"
                             targetProject="src/main/java"
                             type="XMLMAPPER"/>
        <!--为哪张表生成代码-->
        <table tableName="${tableName}">
            <generatedKey column="id" sqlStatement="JDBC"/>
        </table>
    </context>
</generatorConfiguration>

不加时区会出现异常

jdbc.driverClass=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/content_center?serverTimezone=UTC
jdbc.user=root
jdbc.password=newrootpassword
moduleName=messaging
tableName=rocketmq_transaction_log

<plugin>
  <groupId>org.mybatis.generator</groupId>
  <artifactId>mybatis-generator-maven-plugin</artifactId>
  <version>1.3.6</version>
  <configuration>
    <configurationFile>
      ${basedir}/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>8.0.16</version>
    </dependency>
    <dependency>
      <groupId>tk.mybatis</groupId>
      <artifactId>mapper</artifactId>
      <version>4.1.5</version>
    </dependency>
  </dependencies>
</plugin>

执行maven插件即可

2.分页插件PageHelper

注意和mybatis的版本对应

<dependency>
  <groupId>com.github.pagehelper</groupId>
  <artifactId>pagehelper-spring-boot-starter</artifactId>
  <version>1.2.13</version>
</dependency>
<dependency>
  <groupId>org.mybatis.spring.boot</groupId>
  <artifactId>mybatis-spring-boot-starter</artifactId>
  <version>2.1.0</version>
</dependency>

使用起来很简单

// 在sql语句上面加这句
PageHelper.startPage(1, 1);
// 将查询到list数据放到这里边
PageInfo<PayInfoForm> pageInfo = new PageInfo<>(payInfoFormList);

这是返回字段的说明：