记录Springboot+Mybatis_Plus进行CRUD与分页的注意点

对于mybatis_plus来说,进行CRUD非常的方便,但是最近遇使用其分页插件时遇到了一个问题,记录一下.

当进行Mybatis_plus的版本升级时,需要查看升级文档. 比如当版本从3.0.6升级到3.1.0时,文档中说明移除对mybatis-plus-generator包的依赖，自己按需引入.导致当时升级部分报错(如java.lang.NoSuchMethodError: com.baomidou.mybatisplus.core.metadata.IPage.setTotal(Ljava/lang/Long;)Lcom/baomidou/mybatisplus/core/metadata/IPage;).

1.需要的依赖:

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-core</artifactId>
    <version>3.1.0</version>
</dependency>
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-generator</artifactId>
    <version>3.1.0</version>
</dependency>
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.1.0</version>
</dependency>

2.分页配置文件:

package com.goodwe.daomain.configure;

import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@EnableTransactionManagement
@Configuration
@MapperScan("com.goodwe.daomain.plus.mapper")

public class MybatisPlusConfiguration {

        /**
         * 分页插件
         */
        @Bean
        public PaginationInterceptor paginationInterceptor() {
                return new PaginationInterceptor();
        }
}

3.代码构造器:

package com.goodwe.daomain;




import com.baomidou.mybatisplus.core.exceptions.MybatisPlusException;
import com.baomidou.mybatisplus.core.toolkit.StringPool;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.InjectionConfig;
import com.baomidou.mybatisplus.generator.config.*;
import com.baomidou.mybatisplus.generator.config.po.TableInfo;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;

import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

/**
 * 代码生成器
 */
public class Generator {
        /**
         * <p>
         * 读取控制台内容
         * </p>
         */
        public static String scanner(String tip) {
                Scanner scanner = new Scanner(System.in);
                StringBuilder help = new StringBuilder();
                help.append("请输入" + tip + "：");
                System.out.println(help.toString());
                if (scanner.hasNext()) {
                        String ipt = scanner.next();
                        if (null!=ipt&&ipt.length()>0) {
                                return ipt;
                        }
                }
                throw new MybatisPlusException("请输入正确的" + tip + "！");
        }

        public static void main(String[] args) {
                // 代码生成器
                AutoGenerator mpg = new AutoGenerator();

                // 全局配置
                GlobalConfig gc = new GlobalConfig();
                String projectPath = System.getProperty("user.dir");
                gc.setOutputDir(projectPath + "/daomain/src/main/java");
                gc.setAuthor("goodwe");
                gc.setOpen(false);
                gc.setSwagger2(true);
                //gc.setIdType(IdType.AUTO);
                gc.setFileOverride(true);   //覆盖文件
                mpg.setGlobalConfig(gc);

                // 数据源配置
                DataSourceConfig dsc = new DataSourceConfig();
                dsc.setUrl("jdbc:mysql://192.168.1.141:3306/wblog");
                dsc.setDriverName("com.mysql.cj.jdbc.Driver");
                dsc.setUsername("bigdata");
                dsc.setPassword("Goodwe!123");
                mpg.setDataSource(dsc);

                // 包配置
                PackageConfig pc = new PackageConfig();
                pc.setModuleName("plus");
                pc.setParent("com.goodwe.daomain");
                mpg.setPackageInfo(pc);

                // 自定义配置
                InjectionConfig cfg = new InjectionConfig() {
                        @Override
                        public void initMap() {
                                // to do nothing
                        }
                };
                List<FileOutConfig> focList = new ArrayList<>();
                focList.add(new FileOutConfig("/templates/mapper.xml.ftl") {
                        @Override
                        public String outputFile(TableInfo tableInfo) {
                                // 自定义输入文件名称
                                return projectPath + "/daomain/src/main/resources/mapper/" + pc.getModuleName()
                                        + "/" + tableInfo.getEntityName() + "Mapper" + StringPool.DOT_XML;
                        }
                });
                cfg.setFileOutConfigList(focList);
                mpg.setCfg(cfg);
                mpg.setTemplate(new TemplateConfig().setXml(null).setController(null));

                // 策略配置
                StrategyConfig strategy = new StrategyConfig();
                strategy.setNaming(NamingStrategy.underline_to_camel);
                strategy.setColumnNaming(NamingStrategy.underline_to_camel);
                strategy.setInclude(scanner("表名"));
                strategy.setControllerMappingHyphenStyle(true);
                strategy.setTablePrefix("wblog_");//去除数据库表前缀
                mpg.setStrategy(strategy);
                mpg.setTemplateEngine(new FreemarkerTemplateEngine());
                mpg.execute();
        }
}

转载于:https://my.oschina.net/u/4100033/blog/3032342