mybatis分页插件，自动生成代码插件

素颜马尾好姑娘i 2021-11-10 12:16 335阅读 0赞

### 1.分页插件 ###

在上一篇介绍拦截器中尝试了封装分页插件，其实有更好的mybatis分页插件PageHelper，具体用法：

1.导包

![1602537-20190801111326043-358710295.png][]

2.注册拦截器

![1602537-20190801111404502-1005378480.png][]

3.写mapper

![1602537-20190801111426249-2007944454.png][]

4.调用

![1602537-20190801111443732-1460759682.png][]

结果如下：

![1602537-20190801111502913-1472126763.png][]

结果pageInfo数据解析：

![1602537-20190801111859686-533419252.png][]

还有很多的属性，具体可以自己测试

### 2.自动生成代码 ###

自动生成代码可以帮助我们生成实体类，mapper映射一级dao接口文件，减少代码量，使用方法：

1.导包：

![1602537-20190801112547767-1533120417.png][]

2.编辑配置文件，配置文件的位置与上面配置中的位置要一致：

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    <generatorConfiguration>
        
        <classPathEntry location="D:\work\mysql\mysql-connector-java\5.1.45\mysql-connector-java-5.1.45.jar"/>
        <context id="mysql" targetRuntime="MyBatis3">
            <commentGenerator>
                <property name="suppressDate" value="true"/>
                
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/test"
                            userId="root"
                            password="123456">
            </jdbcConnection>
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.zs.entity" targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources">
                <property name="enableSubPackages" value="true"/>
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.zs.dao" targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
            
            <table tableName="emp" domainObjectName="Emp" enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/>
            <table tableName="dept" domainObjectName="Dept" enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/>
        </context>
    </generatorConfiguration>

3.生成代码：

![1602537-20190801112728711-841889587.png][]

点击后就可以自动生成代码了

转载于:https://www.cnblogs.com/Zs-book1/p/11281451.html

[1602537-20190801111326043-358710295.png]: /images/20211109/923cc563280241d3a8b141282dc8273e.png
[1602537-20190801111404502-1005378480.png]: /images/20211109/8830d6db52da4f5b88506729aa92d34e.png
[1602537-20190801111426249-2007944454.png]: /images/20211109/138cf36da3e446148d63f0af082b69bb.png
[1602537-20190801111443732-1460759682.png]: /images/20211109/767fa354c84b44cf8d5f49c7ff5622f8.png
[1602537-20190801111502913-1472126763.png]: /images/20211109/8fd2ba9d5334437b96aa780af4e149b8.png
[1602537-20190801111859686-533419252.png]: /images/20211109/16cc1828850e407895907fc0c598f753.png
[1602537-20190801112547767-1533120417.png]: /images/20211109/4317a39d8d704a24bc3373b1ef33fc1c.png
[1602537-20190801112728711-841889587.png]: /images/20211109/6b6bb268f3e544c88e55cb5773f097aa.png