MyBatis-Plus Mybatis-Plus Comment - Nineya|java/go/python

This is Mybatis-Plus discuss, Welcome your comments!

这里是 Mybatis-Plus 文档的讨论，欢迎留下你的足迹

Comment From: yangyang0507

Hello，Gitalk

Comment From: qmdx

Dyang 威武

Comment From: YouAreCold

可以的

Comment From: bj-huozhe

baseMapper.selectOne(condition)在查询条件如果参数有枚举的情况下，有问题，代码如下：

 Student condition = new Student();
    condition.setOpStatus(opStatus);
  Student student = baseMapper.selectOne(condition);

如果这个opStatus是个枚举，我存数据库数据库的是枚举的name属性，上面的selectone 查询时用的ParameterMapping 获取不到对应的enumtypehandler ，导致查询参数对应不上；

Comment From: liuxun123

mybatisplus-spring-mvc 项目里的这一行根本就无法切入事务

Comment From: fendo8888

            TemplateConfig tc = new TemplateConfig();
            tc.setController("src/main/java/com/fendo/mybatisplus/templates/controller.java.vm");
            tc.setEntity("src/main/java/com/fendo/mybatisplus/templates/entity.java.vm");
            tc.setMapper("src/main/java/com/fendo/mybatisplus/templates/mapper.java.vm");
            tc.setXml("src/main/java/com/fendo/mybatisplus/templates/mapper.java.vm");
            tc.setService("src/main/java/com/fendo/mybatisplus/templates/service.java.vm");
            tc.setServiceImpl("src/main/java/com/fendo/mybatisplus/templates/serviceImpl.java.vm");

我把模板文件放到了src/main/java/com/fendo/mybatisplus/templates包下面了,并没有放到resources下,按以上配置,只生成了文件夹,并没有生成代码

Comment From: fendo8888

            TemplateConfig tc = new TemplateConfig();
            tc.setController("/templates/controller.java.vm");
            tc.setEntity("/templates/entity.java.vm");
            tc.setMapper("/templates/mapper.java.vm");
            tc.setXml("/templates/mapper.java.vm");
            tc.setService("/templates/service.java.vm");
            tc.setServiceImpl("/templates/serviceImpl.java.vm");
            //如上任何一个模块如果设置 空 OR Null 将不生成该模块。
            mpg.setTemplate(tc);

           // 执行生成
           mpg.execute();

使用该配置,不生效,用的还是默认的模板。。。。项目template下的无效

Comment From: qmdx

@fendo8888 你可以试试放在别的目录，正常是有效的。

Comment From: fendo8888

@qmdx @fendo8888 你可以试试放在别的目录，正常是有效的。

解决了,在pom.xml中加入vm文件就行了:

<resources>  
    <resource>  
        <directory>src/main/resources</directory>  
        <includes>  
            <include>**/*.properties</include>  
            <include>**/*.xml</include>  
            <include>**/*.tld</include> 
            <include>**/*.dtd</include> 
            <include>**/*.ftl</include>  
            <include>**/*/*.jpg</include>  
            <include>**/*/*.png</include>
            <include>**/*/*.vm</include>
        </includes>  
        <filtering>false</filtering>  
    </resource>  
    <resource>  
        <directory>src/main/java</directory>  
        <includes>  
            <include>**/*.properties</include>  
            <include>**/*.xml</include>  
            <include>**/*.tld</include>  
            <include>**/*.dtd</include> 
            <include>**/*.vm</include> 
        </includes>  
        <filtering>false</filtering>  
    </resource>  
</resources>

以下两种方式都可以:

            TemplateConfig tc = new TemplateConfig();

// tc.setController("/templates/controller.java"); // tc.setEntity("/templates/entity.java"); // tc.setMapper("/templates/mapper.java"); // tc.setXml("/templates/mapper.java"); // tc.setService("/templates/service.java"); // tc.setServiceImpl("/templates/serviceImpl.java"); tc.setController("/src/main/java/com/fendo/mybatisplus/templates/controller.java"); tc.setEntity("/src/main/java/com/fendo/mybatisplus/templates/entity.java"); tc.setMapper("/src/main/java/com/fendo/mybatisplus/templates/mapper.java"); tc.setXml("/src/main/java/com/fendo/mybatisplus/templates/mapper.java"); tc.setService("/src/main/java/com/fendo/mybatisplus/templates/service.java"); tc.setServiceImpl("/src/main/java/com/fendo/mybatisplus/templates/serviceImpl.java"); //如上任何一个模块如果设置空 OR Null 将不生成该模块。 mpg.setTemplate(tc);

           // 执行生成
           mpg.execute();

Comment From: fendo8888

再次测试发现: tc.setController("/src/main/java/com/fendo/mybatisplus/templates/controller.java"); tc.setEntity("/src/main/java/com/fendo/mybatisplus/templates/entity.java"); tc.setMapper("/src/main/java/com/fendo/mybatisplus/templates/mapper.java"); tc.setXml("/src/main/java/com/fendo/mybatisplus/templates/mapper.java"); tc.setService("/src/main/java/com/fendo/mybatisplus/templates/service.java"); tc.setServiceImpl("/src/main/java/com/fendo/mybatisplus/templates/serviceImpl.java");

这种方式不支持!!!!

Comment From: lupan123

代码生成是不是不支持H2数据库？我跑测试用例用的内嵌数据库，报异常 org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT []"; expected "TOP, LIMIT, DISTINCT, ALL, , NOT, EXISTS, INTERSECTS"; SQL statement: show table status [42001-196]

Comment From: softxiang

怎么取消多租户模式？

Comment From: qmdx

@softxiang 怎么取消多租户模式？

在配置分页插件不注入 sql 解析模块即可。

Comment From: qmdx

@liuxun123 mybatisplus-spring-mvc 项目里的这一行根本就无法切入事务

应该是可以的，不行你试试注解方式。

Comment From: liuxun123

@qmdx

@liuxun123 mybatisplus-spring-mvc 项目里的这一行根本就无法切入事务

应该是可以的，不行你试试注解方式。

我已经解决了，提供的码云上的样例项目里事务配置是不行的，我改成了 execution( com.baomidou...service...(..)) ，去切 jar 里面的方法。

Comment From: liuxun123

这个评论功能居然把一个* 星号吃了。。。

Comment From: LiaoYiWei

版本字段更新后不回写，如何配置版本再执行更新后，回写到更新对象上

Comment From: wuguofeng

我自定义了一个JsonTypeHandler，在调用mapper的updateById的时候，为什么没起作用？

Comment From: wuguofeng

我自定义了一个JsonTypeHandler，在调用mapper的updateById的时候，为什么没起作用？

Comment From: John0915

Hello MyBatis-Plus

Comment From: qmdx

@wuguofeng 我自定义了一个JsonTypeHandler，在调用mapper的updateById的时候，为什么没起作用？

通过 tableFiled el 属性注入，参考源码测试用例部分

Comment From: qmdx

@weiailuxueqi 通过mybatis-plus生成的代码，实体类中有一个属性isDelete，然后通过mapper来insert数据，但是提示“deleted”，但是我这个对象里面的属性是 isDelete 是有正确提供getXXX，setXXXX等方法的，那么这个错误该如何解决？该不会强制要求必须都要改为delete属性吧？？

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'delete' in 'class com.baomidou.springmvc.model.system.User'

不符合规范

Comment From: wuguofeng

@qmdx

@wuguofeng 我自定义了一个JsonTypeHandler，在调用mapper的updateById的时候，为什么没起作用？

通过 tableFiled el 属性注入，参考源码测试用例部分

3q，问题解决了，不过感觉有点别扭，TableField里面的el，只设置属性名，另外增加一个typeHandler的配置项，或者增加一个@TypeHandler会不会好一点？

Comment From: qqliaoxin

springboot mybatis-plus 中怎么设置mybatis-config.xml 全局的配置文件的？

Comment From: pkptzx

postgres jsonb 支持吗?

Comment From: guoqilin2016

很好,很有用!

Comment From: shikaiwen

mybatis-plus-generator-2.1.8.jar AutoGenerator mpg = new AutoGenerator(); // 选择 freemarker 引擎，默认 Veloctiy // mpg.setTemplateEngine(new FreemarkerTemplateEngine()); FreemarkerTemplateEngine 类根本不存在，是还没实现吗，想要用freemarker应该怎么做？

Comment From: lyon91sky

springboot中启动出错 org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'velocityConfigurer' defined in class path resource [org/springframework/boot/autoconfigure/velocity/VelocityAutoConfiguration$VelocityWebConfiguration.class]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: org/apache/velocity/runtime/log/CommonsLogLogChute

配置是 com.baomidou mybatisplus-spring-boot-starter 1.0.5 com.baomidou mybatis-plus 2.1.9 必须要 org.apache.velocity velocity 吗？我看有的sb 项目中也没配置啊。而且配置了velocity controller 请求都成了404

Comment From: qh87846748

性能分析插件 @EnableTransactionManagement @Configuration @MapperScan("com.money.mapper") public class MybatisPlusConfig { / * mybatis-plus SQL执行效率插件【生产环境可以关闭】 / @Bean @Profile({"dev","test"})// 设置 dev test 环境开启 public PerformanceInterceptor performanceInterceptor() { return new PerformanceInterceptor(); } } 启动不会报错,但执行查询语句会报错,org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'statement' in 'class org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy'

Comment From: softxiang

@softxiang 怎么取消多租户模式？

完全取消可注释掉sqlParserList.add(tenantSqlParser);

Comment From: newhoo

你好，请问分页合理化怎么设置？前端传入页数大于总页数时。

Comment From: qmdx

@flylinran 你好，请问分页合理化怎么设置？前端传入页数大于总页数时。 http://mp.baomidou.com/#/page-plugin

Comment From: wenshzhu

这个分页好像不支持多列不同类型排序吧，比如A升序B降序

Comment From: qmdx

@weiailuxueqi 别好像你肯定啊！！不要乱说

Comment From: wenshzhu

@qmdx @weiailuxueqi 别好像你肯定啊！！不要乱说

嗯，肯定

Comment From: damozhiying

@Select({ "select a.id, a.name, a.description, a.status, a.create_time, a.update_time, a.online_time,", "b.product_id, b.category, b.display_name, b.overview, b.developer, b.operator, b.need_contract, b.introduction, b.logo, b.strength", " from dcoos_api_product a", " left join dcoos_api_product_business b on a.id = b.product_id", " where if(#{creatorId}>0, (a.creator_id = #{creatorId}), 1 = 1 )", " and if(length(#{id}) > 0, locate(#{id}, a.id), 1=1) ", " and if(length(#{name}) > 0, locate(#{name}, a.name), 1 = 1) ", " and if(length(#{category}) > 0, locate(#{category}, b.category), 1 = 1) ", " and if(#{beginDate} > 0 and #{endDate} > 0, a.update_time >= #{beginDate} and a.update_time < #{endDate}, 1 = 1) ", " and if(length(#{status}) > 0, a.status = #{status}, 1 = 1) ", }) @Results(value = { @Result(column = "id", property = "id"), @Result(column = "name", property = "name"), @Result(column = "description", property = "description"), @Result(column = "status", property = "status"), // @Result(column = "creator_id", property = "creatorId"), @Result(column = "create_time", property = "createTime"), @Result(column = "update_time", property = "updateTime"), @Result(column = "online_time", property = "onlineTime"), @Result(column = "offline_time", property = "offlineTime"),

        @Result(column = "product_id", property = "businessInfo.productId"),
        @Result(column = "category", property = "businessInfo.category"),
        @Result(column = "display_name", property = "businessInfo.displayName"),
        @Result(column = "overview", property = "businessInfo.overview"),
        @Result(column = "developer", property = "businessInfo.developer"),
        @Result(column = "operator", property = "businessInfo.operator"),
        @Result(column = "need_contract", property = "businessInfo.needContract"),
        @Result(column = "introduction", property = "businessInfo.introduction"),
        @Result(column = "logo", property = "businessInfo.logo"),
        @Result(column = "strength", property = "businessInfo.strength"),


        @Result(column = "id", property = "apiUsages", many = @Many(select = "getApiUsages")),
        //@Result(column = "id", property = "businessInfo", one = @One(select = "com.chinatelecom.dcoos.api.mgt.api.mapper.product.ApiProductBusinessMapper.getProductBusiness")),
})
List<ApiProductVO> getProducts(ApiProductQueryRequest queryRequest);

这种sql

Pagination p = new Pagination(pageNum, pageSize).setOrderByField(orderColumn).setAsc(true); PageHelper.setPagination(p);

        List<ApiProductVO> list = productMapper.getProducts(queryRequest);

        PageInfo<ApiProductVO> result = null;//PageInfo.transferFor((Page) list);

        int total = PageHelper.freeTotal();

        pageInfo.setRecords(list);
        pageInfo.setTotal(total);
        pageInfo.setSize(pageSize);
        pageInfo.setCurrent(pageNum);

会导致在2个sql中加上分页，统计的total也有问题

Comment From: RobinsChens

nice

Comment From: ichavin

有个疑问，自动生成的代码与阿里巴巴java开发规范里面的是保持一致的吗

Comment From: objectboy2016

如果说在mybatis mapper里面 <if test="a==1"></if> 想把此段1换成枚举怎么做, 如 <if test="a==枚举值"></if> 如何更优雅的解决此类问题呢,

Comment From: lyon91sky

java.lang.AbstractMethodError: org.apache.velocity.runtime.resource.loader.ResourceLoader.init(Lorg/apache/velocity/util/ExtProperties

Comment From: lyon91sky

Caused by: java.lang.ClassNotFoundException: org.apache.velocity.runtime.log.CommonsLogLogChute

Comment From: lyon91sky

springboot 启动报错，pom是 com.baomidou mybatisplus-spring-boot-starter 1.0.5 com.baomidou mybatis-plus 2.1.9

Comment From: lyon91sky

有人和我一样的问题吗

Comment From: hostSugar

hi，user表做分表处理，比如 user_01,user_02,user_03.....，这样的情况 mp支持么？mapper接口、pojo 可以设置一个么？

Comment From: newhoo

分页溢出设置无效overflowCurrent，凑合着用https://pagehelper.github.io了。建议完善文档

Comment From: dazhu666

请问一下如何配置到springboot上？乐观锁插件

Comment From: randomGuo

使用@tableName标签后，数据库部分字段，不想跟实体类做映射，有办法处理吗，实体类没有数据库字段的变量，启动就已经报错了。

Comment From: imhuzi

相关 SQL 解析如多租户可通过 @SqlParser(filter=true) 排除 SQL 解析，注意！！全局配置 sqlParserCache 设置为 true 才生效。经过测试官方demo发现，设置成false才生效

Comment From: kanonlemon

@TableField(value="is_list")
private Boolean isList;

这样写，最后的condition就变成 list!=null , 然后在ibatis执行的时候invoke getList 就错误了我写成：

@TableField(value="is_list",strategy=FieldStrategy.IGNORED)
private Boolean isList;

就没有问题了，你看是哪里出了问题

Comment From: leijieaotian

mybatis-plus 插入数据时，如何返回主键？求大神帮忙，没有自动回写到实体类中

Comment From: baibinboss

java.lang.NoSuchMethodError: com.baomidou.mybatisplus.plugins.pagination.Pagination.setTotal(I)Lcom/baomidou/mybatisplus/plugins/pagination/Pagination; 这个是怎么回事呀，找了N久

Comment From: prettywork

EntityWrapper ew=new EntityWrapper<>(); ew.eq("name",name); // ew.setSqlSelect("initial_price"); Classify classify=classifyService.selectOne(ew);

根据名字查询如果名字是汉字加上ew.setSqlSelect("initial_price"); 查询单子字段查询结果为null 去掉可以可能是个bug

Comment From: yybray

user.setId(1); EntityWrapper wrapper = new EntityWrapper<>(user); selectPage(Page page, Wrapper wrapper); 没有正确拼接，sql中不会拼接where id = 1，查询条件失效

Comment From: cnbulong

发现一个小错误：application.yml 如果是放在src/main/java目录下 classpath:/com/yourpackage//mapper/Mapper.xml 改成： classpath:/com/yourpackage/*/mapper/Mapper.xml

多级的目录应该是"**"两个星号。

Comment From: miss-orange

请问分页想要返回List 怎么写

Comment From: uther518

Spring Boot都在去除xml，希望支持properties配置方法

Comment From: firekcc

填充字段支持查询填充字段么，假如我需要将一个pojo中的属性在查询操作后赋值的时候，这个字段只是一个dto不存在数据库中，这种问题是其他的办法去解决么

Comment From: ghost

找不到mapper接口下的方法，application中已经配置MapperScan了

Comment From: lirui874125

问个问题：mapper-locations配置了，但是无法读取jar中的mapper.xml文件,请问该怎么处理？

Comment From: gltolx

将mysql中的tinyint(1)类型自动生成Boolean类，应该如何配置？

Comment From: a931083335

globalConfiguration.setDbColumnUnderline(true) 当设置这个时，java类里面的field属性名不起作用，默认解析成下划线，这个建议优先field里面的value值

Comment From: qmdx

@a931083335 目前是优先使用注解的

Comment From: qmdx

@gltolx 看下文档问题部分

Comment From: hhxyjsj

没提供批量插入接口

Comment From: qmdx

@hhxyjsj 在 serviceImpl 中，至于为什么要放这里看文档问题部分

Comment From: yule333444

生成的kotlin文件package和import代码后面有; 能不能去掉呢，多谢啦

Comment From: rui8832

可不可以在生成 SQL 时自动为 column 参数添加反引号,如下代码的 key 就需要手动添加反引号，否则 SQL 语法错误（虽然在设计数据库的时候不要使用关键字才是最好的办法）。

    @Override
    public Properties selectByKey(String prefix, String key) {
        return selectOne(Condition.create()
            .eq("prefix", prefix)
            .eq("`key`", key));
    }

Comment From: zengdegui

mybatis-plus-2.19不支持批量保存？一下是错误： com.baomidou.mybatisplus.exceptions.MybatisPlusException: Error: Cannot execute insertBatch Method. Cause

Comment From: Chen120322

page.setRecords是无返回值的，文档中怎么return的？

Comment From: qinlonggu

mybatis-plus支持存储过程吗

Comment From: gibsoneko

例如：user对象中包含role对象原来mybatis 中使用resultMap给role.id赋值，在mp中还是只能使用这种方式吗

Comment From: KelinTan

能不能实体注解独立出来，我们的bean不想依赖mybatis-plus，需要纯净的java bean

Comment From: qmdx

@Kelin92 能不能实体注解独立出来，我们的bean不想依赖mybatis-plus，需要纯净的java bean

有哦查看 MP 的包结构

Comment From: DeathH

请问下为什么自定义sql用了分页插件，如果使用orderby分页就有问题，不使用orderby就没问题,是配置的问题还是？

Comment From: cuivip

联合主键怎么搞？

Comment From: cuivip

请问联合主键怎么搞？我注意到文档中有不支持的描述，但是有什么办法弥补吗？不然只能放弃了

Comment From: Peteronly

目前还不支持增删改查自动生产代码吗

Comment From: cuivip

目前看，这个框架各种不成熟，企业应用不建议使用

Comment From: cui19951005

spring aop 拦截不到mapper方法

Comment From: qmdx

@cuivip 建议不管表中 id 是否有实际意义每张表都有自己的独立 id

Comment From: qinxiang01

为什么spring boot方式注入了mybatis分页插件会影响到原本的其他功能queryPage（）方法呢？？

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,10' at line 1

Comment From: qmdx

@qinxiang01 分页插件默认处理 rowbound 参数的 statementId 对应的 sql 然后自动加上分页 limit

Comment From: qinxiang01

@qmdx 你好，现在我两种场景都需要支持，按照上面的文档自定义的sql分页是OK的，但是会造成框架定义的queryPage方法多了一个limit字段，这个应该怎么解决啊？

Comment From: YanxiSir

自己在mapper（&xml）中加了方法，一直报错：Invalid bound statement (not found)。这个是为啥

Comment From: aishangdren

@TableField(condition = SqlCondition.LIKE),怎么用啊?我加了后，这个用法没起作用selectPage(new Query<>(params), new EntityWrapper<>());

Comment From: szhanlee

good

Comment From: aishangdren

这东西 BUG还是不少啊，加了@tablefield(condition = SqlCondition.LIKE)居然没变化

Comment From: zengdegui

还好吧，不要把这个框架当成hibernate功能用，没那么智能发自我的华为手机-------- 原始邮件 --------主题：Re: [baomidou/mybatis-plus] Mybatis-Plus Comment (#248)发件人：aishangdren 收件人：baomidou/mybatis-plus 抄送：zengdegui 845875725@qq.com,Comment 这东西 BUG还是不少啊，加了@tablefield(condition = SqlCondition.LIKE)居然没变化

—You are receiving this because you commented.Reply to this email directly, view it on GitHub, or mute the thread.

{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/baomidou/mybatis-plus","title":"baomidou/mybatis-plus","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/baomidou/mybatis-plus"}},"updates":{"snippets":[{"icon":"PERSON","message":"@aishangdren in #248: 这东西 BUG还是不少啊，加了@tablefield(condition = SqlCondition.LIKE)居然没变化"}],"action":{"name":"View Issue","url":"https://github.com/baomidou/mybatis-plus/issues/248#issuecomment-385301746"}}}

Comment From: qmdx

@aishangdren 这东西 BUG还是不少啊，加了@tablefield(condition = SqlCondition.LIKE)居然没变化

该注解只对 EntityWrapper 传入实体的时候产生 like 效果

Comment From: zhengxingtao

生成的entity类中不能使用引用类型的属性是吗？

Comment From: enterprising666

点赞，点赞，点赞

Comment From: enterprising666

期待持续改进，持续增强，加油

Comment From: likeswinds

怎么在同一个mapper中支持多种数据库，如何配置 databaseId

   <select id="isExist" resultType="Boolean" databaseId="mysql">
        SELECT EXISTS(SELECT 1 FROM `${db}`.test_table WHERE table_id=#{tableId} LIMIT 1)
    </select>

    <select id="isExist" resultType="Boolean" databaseId="oracle">
        SELECT COUNT(*) FROM ${db}."test_table " WHERE "table_id"=#{tableId}
    </select>

Comment From: hanjunchen

发现个问题，使用sharding-jdbc读写分离，分页查询始终到主库中查询，其它全表等查询都可以到从库查，是配置问题吗

Comment From: qmdx

@likeswinds @hanjunchen https://github.com/baomidou/dynamic-datasource-spring-boot-starter

Comment From: hanjunchen

@qmdx @likeswinds @hanjunchen https://github.com/baomidou/dynamic-datasource-spring-boot-starter

extends AbstractRoutingDataSource这种方式可以实现，但是我现在用的是sharding-jdbc的方式，出现分页查询不到slave中查的问题

Comment From: cqwshzj

登陆上来就为了点赞。大力支持

Comment From: hanjunchen

搞定了，分页插件中设置下方言类型就正常了

Comment From: aishangdren

ServletRequestAttributes attributes = (ServletRequestAttributes)RequestContextHolder.getRequestAttributes();在异步线程里面 RequestContextHolder.getRequestAttributes()为null

Comment From: aishangdren

请求示例：xx.selectPage(new Page(1,limit),entityWrapper);

Comment From: uhzgnaw

反手就是一个赞

Comment From: dcy421

多表连接查询分页，插件能完成吗？还是说需要自己写sql，或者生成视图

Comment From: uhzgnaw

@a1540770111 写你自己的连接查询的sql就行，分页插件会自动给你套一层视图以及查询总条数这些的。还需要你写视图，那要分页插件干嘛。

Comment From: dcy421

@uhzgnaw @a1540770111 写你自己的连接查询的sql就行，分页插件会自动给你套一层视图以及查询总条数这些的。还需要你写视图，那要分页插件干嘛。

懂了谢谢大神

Comment From: lhenchem

多表连接查询，如何通过MP实现，有大佬简单说明下或给个简单示例吗？

Comment From: hanjunchen

为什么用CachePaginationInterceptor，分页没有缓存效果？

Comment From: liuyangdxxd

这种noxml的形式好像是对于单表吧多表关联也支持么？

Comment From: qmdx

@liuyangdxxd 这种noxml的形式好像是对于单表吧多表关联也支持么？

多表 xml

Comment From: nightji

使用activerecord模式curd时报这个错是为什么？ java.lang.NullPointerException at com.baomidou.mybatisplus.toolkit.GlobalConfigUtils.currentSessionFactory(GlobalConfigUtils.java:60) at com.baomidou.mybatisplus.mapper.SqlHelper.sqlSession(SqlHelper.java:104) at com.baomidou.mybatisplus.mapper.SqlHelper.sqlSession(SqlHelper.java:58) at com.baomidou.mybatisplus.activerecord.Model.sqlSession(Model.java:373) at com.baomidou.mybatisplus.activerecord.Model.updateById(Model.java:157) 定位到TableInfoHelper.getTableInfo()方法了，但是不知道为什么。有人能解释下吗？

Comment From: renlinjun

spring boot与mybatis集成必须的有那个myconfig类么，那个类的注释上mapper*是什么意思

Comment From: LoBinte

版本 2.1.9 生成MSSQL 的语句 SELECT id,pid,pid_path,name,p_cnname_path,ifyx FROM ，我不需要在Name 列前后添加标识怎么处理

Comment From: qooloop

2.3版本不提供jar了吗？

Comment From: zifeihan

老铁今天我对代码做了混淆后出现了这个问题,大佬能否指点一下。

2018-05-18 16:53:23:025 [main] DEBUG o.s.b.diagnostics.LoggingFailureAnalysisReporter - Application failed to start due to an exception org.springframework.beans.factory.NoUniqueBeanDefinitionException: No qualifying bean of type 'com.baomidou.mybatisplus.mapper.BaseMapper<?>' available: expected single matching bean but found 9: exceptionFileMapper,machineClusterMapper,userClusterMapper,taskDataSnapshotMapper,machineMapper,clusterMapper,taskMapper,taskDataMapper,sysLogMapper at org.springframework.beans.factory.config.DependencyDescriptor.resolveNotUnique(DependencyDescriptor.java:173) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1116) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:585) at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:366) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1264) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:585) at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:366) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1264) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543) at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:693) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:360) at org.springframework.boot.SpringApplication.run(SpringApplication.java:303) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1118) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1107) at com.perf.xlion.start.PerfmaStarter.a(PerfmaStarter.java:15) at com.perf.xlion.WMain.main(WMain.java:7)

Comment From: crayymumu

插件超级好用，感谢感谢

Comment From: 948849440

自定义模板应该这样设置 tc.setEntity("/templates/entity.java");

Comment From: wangfengcool

开源世界里的精神支撑

Comment From: sxz1314

配置了，还是不能热加载是什么原因啊

Comment From: heyaping388

你好，请问一下Long类型主键非自增无法insert是为什么，提示主键没有默认值。 sql语句中未设置主键值

Comment From: kent666a

666

Comment From: KevinCGH

你好，在TenantHandler内如果想查询一个表信息来返回tenant column 和判断是否需要执行filter怎么做啊？我尝试了在里面装配一个Service或者Mapper都会报错。

Comment From: fredshawf

这个如何走关联？关联还得走原始mybatis吗？

Comment From: hualiang0537

代码生成模板引擎那块 org.apache.velocity velocity ${velocity.version}

Comment From: 18281916257

2.在对应的mapper.xml中将原有注释修改为链接式声明，以保证xml文件里的缓存能够正常, 这个是什么意思啊,有没有具体的示例

Comment From: 18281916257

您好,请问集成了mybatis-ehcache, 在MP这边应该怎么处理?

Comment From: qmdx

截稿

Comment From: lun3322

填充模板出错,FreeMarker template error: The following has evaluated to null or missing: ==> mapperInterface [in template "template" at line 5, column 22]

Tip: If the failing expression is known to legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing</#if>. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)??

FTL stack trace ("~" means nesting-related): - Failed at: ${mapperInterface.packageName} [in template "template" at line 5, column 20]

Java stack trace (for programmers):

freemarker.core.InvalidReferenceException: [... Exception message was already printed; see it above ...] at freemarker.core.InvalidReferenceException.getInstance(InvalidReferenceException.java:134) at freemarker.core.UnexpectedTypeException.newDescriptionBuilder(UnexpectedTypeException.java:85) at freemarker.core.UnexpectedTypeException.(UnexpectedTypeException.java:48) at freemarker.core.NonHashException.(NonHashException.java:49) at freemarker.core.Dot._eval(Dot.java:48) at freemarker.core.Expression.eval(Expression.java:101) at freemarker.core.DollarVariable.calculateInterpolatedStringOrMarkup(DollarVariable.java:100) at freemarker.core.DollarVariable.accept(DollarVariable.java:63) at freemarker.core.Environment.visit(Environment.java:331) at freemarker.core.Environment.visit(Environment.java:337) at freemarker.core.Environment.process(Environment.java:310) at freemarker.template.Template.process(Template.java:383) at com.baomidou.plugin.idea.mybatisx.generate.template.FreeMakerFormatter.getFormattedContent(FreeMakerFormatter.java:74) at org.mybatis.generator.api.GeneratedJavaFile.getFormattedContent(GeneratedJavaFile.java:46) at com.baomidou.plugin.idea.mybatisx.generate.template.FreemarkerFile.getFormattedContent(FreemarkerFile.java:24) at com.baomidou.plugin.idea.mybatisx.generate.plugin.IntellijMyBatisGenerator.writeGeneratedJavaFile(IntellijMyBatisGenerator.java:240) at com.baomidou.plugin.idea.mybatisx.generate.plugin.IntellijMyBatisGenerator.generate(IntellijMyBatisGenerator.java:155) at com.baomidou.plugin.idea.mybatisx.generate.template.GenerateCode.generate(GenerateCode.java:136) at com.baomidou.plugin.idea.mybatisx.generate.action.MybatisGeneratorMainAction.generateCode(MybatisGeneratorMainAction.java:81) at com.baomidou.plugin.idea.mybatisx.generate.action.MybatisGeneratorMainAction.actionPerformed(MybatisGeneratorMainAction.java:59) at com.intellij.openapi.actionSystem.ex.ActionUtil.lambda$performActionDumbAware$5(ActionUtil.java:273) at com.intellij.util.SlowOperations.lambda$allowSlowOperations$0(SlowOperations.java:77) at com.intellij.util.SlowOperations.allowSlowOperations(SlowOperations.java:64) at com.intellij.util.SlowOperations.allowSlowOperations(SlowOperations.java:76) at com.intellij.openapi.actionSystem.ex.ActionUtil.performActionDumbAware(ActionUtil.java:273) at com.intellij.openapi.actionSystem.impl.ActionMenuItem$ActionTransmitter.lambda$actionPerformed$0(ActionMenuItem.java:310) at com.intellij.openapi.wm.impl.FocusManagerImpl.runOnOwnContext(FocusManagerImpl.java:286) at com.intellij.openapi.wm.impl.IdeFocusManagerImpl.runOnOwnContext(IdeFocusManagerImpl.java:77) at com.intellij.openapi.actionSystem.impl.ActionMenuItem$ActionTransmitter.actionPerformed(ActionMenuItem.java:299) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1967) at com.intellij.openapi.actionSystem.impl.ActionMenuItem.lambda$fireActionPerformed$0(ActionMenuItem.java:110) at com.intellij.openapi.application.TransactionGuardImpl.performUserActivity(TransactionGuardImpl.java:95) at com.intellij.openapi.actionSystem.impl.ActionMenuItem.fireActionPerformed(ActionMenuItem.java:110) at com.intellij.ui.plaf.beg.BegMenuItemUI.doClick(BegMenuItemUI.java:515) at com.intellij.ui.plaf.beg.BegMenuItemUI$MyMouseInputHandler.mouseReleased(BegMenuItemUI.java:545) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6652) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3345) at java.desktop/java.awt.Component.processEvent(Component.java:6417) at java.desktop/java.awt.Container.processEvent(Container.java:2263) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5027) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2321) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4859) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4918) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4547) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4488) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2307) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2784) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4859) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:778) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:727) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721) at java.base/java.security.AccessController.doPrivileged(Native Method) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:751) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:749) at java.base/java.security.AccessController.doPrivileged(Native Method) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:748) at com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:969) at com.intellij.ide.IdeEventQueue.dispatchMouseEvent(IdeEventQueue.java:906) at com.intellij.ide.IdeEventQueue._dispatchEvent(IdeEventQueue.java:836) at com.intellij.ide.IdeEventQueue.lambda$dispatchEvent$8(IdeEventQueue.java:449) at com.intellij.openapi.progress.impl.CoreProgressManager.computePrioritized(CoreProgressManager.java:808) at com.intellij.ide.IdeEventQueue.lambda$dispatchEvent$9(IdeEventQueue.java:448) at com.intellij.openapi.application.impl.ApplicationImpl.runIntendedWriteActionOnCurrentThread(ApplicationImpl.java:781) at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:502) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)