Mybatis三剑客——Mybatis-generator、Mybatis-plugin、Mybatis-pagehelper配置

蔚落 2024-04-17 05:55 60阅读 0赞

### 1. **Mybatis-generator** ###

**自动生成基本的pojo、dao、mapper.xml**

(1). pom文件在plugins标签下添加

<plugin>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-maven-plugin</artifactId>
            <version>1.3.2</version>
            <configuration>
              <verbose>true</verbose>
              <overwrite>true</overwrite>
            </configuration>
    </plugin>

(2) recource文件夹下添加**generatorConfig.xml**配置文件

<!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="datasource.properties"></properties>
        
        <classPathEntry location="${db.driverLocation}"/>
        <context id="default" targetRuntime="MyBatis3">
            
            <commentGenerator>
                <property name="suppressDate" value="true"/>
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
            
            <jdbcConnection
                    driverClass="${db.driverClassName}"
                    connectionURL="${db.url}"
                    userId="${db.username}"
                    password="${db.password}">
            </jdbcConnection>
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
            
            
            <javaModelGenerator targetPackage="com.mmall.pojo" targetProject="./src/main/java">
                
                <property name="enableSubPackages" value="false"/>
                
                <property name="constructorBased" value="true"/>
                
                <property name="trimStrings" value="true"/>
                
                <property name="immutable" value="false"/>
            </javaModelGenerator>
            
            
            <sqlMapGenerator targetPackage="mappers" targetProject="./src/main/resources">
                <property name="enableSubPackages" value="false"/>
            </sqlMapGenerator>
            
            
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.mmall.dao" targetProject="./src/main/java">
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
            <table tableName="mmall_shipping" domainObjectName="Shipping" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
            <table tableName="mmall_cart" domainObjectName="Cart" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
            <table tableName="mmall_cart_item" domainObjectName="CartItem" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
            <table tableName="mmall_category" domainObjectName="Category" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
            <table tableName="mmall_order" domainObjectName="Order" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
            <table tableName="mmall_order_item" domainObjectName="OrderItem" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
            <table tableName="mmall_pay_info" domainObjectName="PayInfo" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
            <table tableName="mmall_product" domainObjectName="Product" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">
                <columnOverride column="detail" jdbcType="VARCHAR" />
                <columnOverride column="sub_images" jdbcType="VARCHAR" />
            </table>
            <table tableName="mmall_user" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
            
        </context>
    </generatorConfiguration>

(3) recource文件夹下添加**dataresourceConfig.properties**,里面包含连接数据库的一些配置，让**generatorConfig.xml**读取

db.driverLocation=C:/Users/peter1950/jarDownload/imooc/mysql-connector-java-5.1.6-bin.jar
    db.driverClassName=com.mysql.jdbc.Driver
    db.url=jdbc:mysql://localhost:3306/mmall_learning?characterEncoding=utf-8
    db.username=mmall
    db.password=123456
    
    db.initialSize = 20
    db.maxActive = 50
    db.maxIdle = 20
    db.minIdle = 10
    db.maxWait = 10
    db.defaultAutoCommit = true
    db.minEvictableIdleTimeMillis = 3600000

(4) 点击IDEA右边标签Maven Projects->**plugins->mybatis-generator->双击mybatis-generator:generate**  
注：要是没看到mybatis-generator:generate的图标,可能是添加plugin时放错位置了。  
[——>添加plugin没有对应的插件？][plugin]

### 2. **Mybatis-plugin** ###

**mybatis的接口文件和实现xml自动跳转, 验证正确性, 在xml中智能提示等功能**

IDEA安装：  
setting->plugins->Browse repositories…->搜mybatis plugin->install  
注：(搜不到用free mybatis plugin也可以)

### 3. **Mybatis-pagehelper** Mybatis分页组件 ###

(1) 添加依赖

<dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper</artifactId>
      <version>4.1.0</version>
    </dependency>
    <dependency>
      <groupId>com.github.miemiedev</groupId>
      <artifactId>mybatis-paginator</artifactId>
      <version>1.2.17</version>
    </dependency>
    <dependency>
      <groupId>com.github.jsqlparser</groupId>
      <artifactId>jsqlparser</artifactId>
      <version>0.9.4</version>
    </dependency>

(2) spring配置添加

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"/>
            <property name="mapperLocations" value="classpath*:mappers/*Mapper.xml"></property>
    
            
            <property name="plugins">
                <array>
                    <bean class="com.github.pagehelper.PageHelper">
                        <property name="properties">
                            <value>
                                dialect=mysql
                            </value>
                        </property>
                    </bean>
                </array>
            </property>
        </bean>

(3)代码示例

PageHelper.startPage(pageNum, pageSize);
    List<Shipping> shippingList = shippingMapper.selectByUserId(userId);
     PageInfo pageInfo = new PageInfo(shippingList);

[plugin]: https://blog.csdn.net/qq_41376740/article/details/81030611