MyBatisCodeHelperPro

Compatible with IntelliJ IDEA (Ultimate, Community), Android Studio
Screenshot 2

MyBatisCodeHelperPro plugin for java mybatis framework, provide auto completion inspection, code generation, make mybatis easy to use

最好的Mybatis代码提示,代码检测插件,快速生成代码,测试sql,日志转sql等

Issues |BiliBili |中文文档

中文:

  • 插件可以识别mybatis动态标签,使用mybatis动态标签的sql可以正常提示,检测
  • mybatis几乎所有地方的sql都有代码提示,可以写出安全的sql
  • 从表上生成增删查改代码,在表上加字段后重新生成不会覆盖自己写的方法
  • 使用方法名生成完整的sql,只要一个方法名就可以生成大部分单表操作的sql
  • resultMap column和property代码提示,检测,支持associaction,collection,columnPrefix
  • #{}自动提示,检测
  • 从java类生成建表语句
  • 最好的ognl支持,if test自动提示检测,bind,foreach等
  • 解析select语句中查询的字段,一键从sql生成java类和resultMap
  • 从sql快速生成mybatis xml和java接口方法,可自定义参数
  • 快速给参数添加if test
  • 从接口方法一键生成testcase,可快速测试sql
  • mybatis代码格式化,兼容mybatis的动态标签
  • Spring支持,检测项目配置的mapperscan,识别@Mapper注解,将mybatis的类注入到spring中,注入不再报错
  • mybatis sql log支持,从控制台打印出完整的sql,点击直接执行sql
  • 大量的配置选项,比如某些插件要忽略部分参数解析,useActualParam配置,typeAlias配置等
  • 最好的泛型支持,接口方法或者参数使用泛型在#{} if test等也可以正常解析
  • #{},if test等可重构参数名称
  • 支持mybatis简单的注解,代码提示,检测,可以一键把注解sql挪到xml
  • 兼容mybatisplus,tkmapper等框架
  • 使用方法名生成mybatisplus QueryWrapper
  • 兼容kotlin
  • qq5群:575733084

Features:

  • Full mybatis sql auto complete, recognize mybatis tag in xml, like where trim set include ect,provide sql completion after those tag
  • Generate mybatis crud code by Intellij database table or add a database connection
  • Generate mybatis sql based on mybatis interface method name like spring data jpa, with this, you don't have to write most sql for non join query support generate statement with if test

  • Database generate crud could generate multiple times when you add or delete columns, plugin will auto merge code
  • Jump from mybatis dao interface to mapper xml each other

  • Auto complete for mybatis #{},if test,foreach,resultMap,refid in sql

  • Generate create table sql from java class
  • TypeAlias Support
  • Mybatis #{} refactor and inspection
  • Ognl support, if test when test ${ bind foreach collection, refactor and inspection and auto completion
  • Jump from refid resultMap to their definition, refactor their name as well

  • Generate page query by mapper interface method

  • Spring support for mybatis, inject mybatis mapper to spring bean,support SpringBoot

  • Refid,resultMap,keyProperty,property auto complete
  • Add @param for mapper method
  • Resultmap column complete and inspection by parse reference select statement
  • Auto map resultMap column and property, Check resultMap columns, Quickly add unMaped columns
  • Code Formatter
  • Generate mybatis mapper testcase from mybatis interface method by database connection, make you test method quicker

  • Full inspection for mybatis, like unused sql in xml, mapper method not have sql in xml, check if resultMap property is right ect

  • Sql log from batslog
  • https://github.com/gejun123456/MyBatisCodeHelper-Pro to learn more.

How to use

What’s New

3.3.9
  • [IMPROVE]生成resultMap时id放在第一位
  • [FIX]修复未激活用户使用部分功能报错
  • [IMPROVE]激活代理优化
  • [IMPROVE] Place `id` first when generating `resultMap`
3.3.8
  • [NEW]kotlin方法名生成sql优化
  • [NEW]生成batchInsertOnDuplicate方法
  • [NEW]优化mybatisplus和更多sql insertOrUpdate方法名冲突问题
  • [NEW]点击parameter跳转到最终sql支持配置最大字符避免控制台卡顿
  • [NEW]model class支持配置前缀
  • [IMPROVE]格式化优化
  • [NEW] Optimize Kotlin method name generation for SQL
  • [NEW] Add support for generating `batchInsertOnDuplicate` method
  • [NEW] Resolve method name conflicts for `insertOrUpdate` in MyBatis-Plus and other SQL scenarios
  • [NEW] Support configuring maximum characters for jumping to final SQL from parameters to prevent console lag
  • [NEW] Add prefix configuration support for model classes
  • [IMPROVE] Formatting optimization
3.3.7
  • [NEW]支持多层sql标签代码提示和检测
  • [NEW]支持全局替换$表达式解析
  • [IMPROVE]更好的clickhouse支持
  • [FIX]xml使用enter可能不换行的问题
  • [IMPROVE]更好的2024.3支持
  • [NEW]兼容kotlin k2 mode
  • [NEW] Support for multi-layer SQL tag code completion and inspection
  • [NEW] Support for global replacement of $ expression parsing
  • [IMPROVE] Enhanced support for ClickHouse
  • [FIX] Issue where pressing Enter in XML might not create a new line
  • [IMPROVE]better support for 2024.3
  • [NEW]support kotlin k2 mode
3.3.6
  • [NEW]兼容2024.3
  • [IMPROVE]提示优化
  • [FIX]mybatisplus支持生成updateByPrimaryKey
  • [FIX]updateBatch方法名冲突
  • [NEW] Compatibility with 2024.3
  • [IMPROVE] Prompt optimization
  • [FIX] MyBatisPlus support for generating updateByPrimaryKey
  • [FIX] Name conflict for updateBatch method
3.3.5
  • [FIX]sql标签${}来自include property时代码提示和检测
  • [FIX]2024.1版本后插件的中文失效问题修复
  • [FIX]support ${} from include property completion and inspection
  • [FIX]could configure language for plugin
3.3.4
  • [FIX]2024.1.4写typeHandler时不会补全包名的问题
  • [IMPROVE]把查询的字段加入到resultMap或resultType时会去根据数据库字段的类型给出字段的java类型
  • [NEW]sql log转sql时格式化优化
  • [FIX]resultMap支持多层的columnPrefix解析
  • [IMPROVE]生成代码支持配置xml文件和mapper文件的前缀
  • [IMPROVE]调整测试sql时输入框的大小
  • [FIX]2024.1.4 package is not auto completed when write typeHandler ect
  • [IMPROVE]When add unused selected column to resultMap or resultType will detect column java type by database columns
  • [NEW]Better formatter for mybatis log to sql
  • [FIX]Support multiple columnPrefix when add column to resultMap inspection
  • [IMPROVE]Generate code support xml prefix and mapper prefix
  • [IMPROVE]Run sql better text field size
3.3.3
  • [FIX]2024.1.2生成testcase没反应的问题
  • [IMPROVE]service interface可以自定义类名
  • [NEW]支持注解sql测试
  • [FIX]exception修复
  • [FIX]2024.1.2 Generate testcase not work
  • [IMPROVE]Service interface can customize class name
  • [NEW]Support run sql for mybatis annotation
  • [FIX]exception fix
3.3.2
  • [FIX]idea社区版无法链接数据库的问题
  • [IMPROVE]xml运行sql 支持通过参数来给if test设置值
  • [FIX]exception修复
  • [FIX] Issue with IDEA Community Edition unable to connect to databases
  • [IMPROVE] XML SQL execution now supports setting values for 'if test' conditions via parameters
  • [FIX]exception fix
3.3.1
  • [FIX]2024.1 xml上无法运行sql的问题
  • [IMPROVE]支持select语句以include开头时resultMap column代码提示和检测
  • [IMPROVE]添加选项支持以parameterType作为参数类型解析当接口参数为父类时
  • [FIX]2024 xml execute sql issue
  • [IMPROVE]support resultMap column completion and inspection when select is start with include
  • [IMPROVE]add option to use parameter type to resolve when method parameter type is super class
3.3.0
  • [IMPROVE]兼容2024.1版本
  • [IMPROVE]检测select字段resultType中不存在时可以批量加入到类中
  • [IMPROVE]mybatisplus自动检测主键是否应该设置为Auto
  • [FIX]mybatis ognl单数参数可以任意名字引用当类型是Collection类型的支持
  • [IMPROVE]compatability for 2024.1 version
  • [IMPROVE]inspection on select column add to resultType
  • [IMPROVE]mybatisplus auto detect IdType Auto
  • [FIX]mybatis ognl单数参数可以任意名字引用当类型是Collection类型的支持
3.2.9
  • [IMPROVE]kotlin报错优化
  • [IMPROVE]支持mybatis ognl单个参数可以使用任意名字引用
  • [IMPROVE]提供界面来合并xml代码
  • [FIX]support ognl use any name for single parameter when type is from Collection
  • [IMPROVE]kotlin exception fix
  • [IMPROVE]support ognl use any name for single parameter
  • [IMPROVE]provide ui to merge xml
  • [FIX]select column with dot exception fix
3.2.8
  • [IMPROVE]性能优化,当有大量xml,在创建对应方法的xml后方法没有取消标红问题
  • [FIX]2023.3 当查询为select *时 resultMap column的提示和检测
  • [FIX]使用kotlin时select字段检测优化
  • [FIX]java接口方法返回值类型检测可能出现的null pointer exception
  • [IMPROVE]使用Autowire注解替代Resource注解
  • [IMPROVE]performance improvement when contain many xml
  • [IMPROVE]for 2023.3 version, when select *, resultMap column inspection and auto completion support
  • [FIX]select column inspection when resultType is from kotlin
  • [FIX]java method return type inspection null pointer
  • [IMPROVE]use autowire to replace resource annotation
3.2.6
  • [IMPROVE]从sql生成java接口方法的参数会根据字段类型来做判断
  • [IMPROVE]java接口方法返回值类型和xml resultType或resultMap不一致时可以快速修复java接口方法返回值类型
  • [FIX]从xml生成java类和resultMap报错优化
  • [FIX]支持kotlin接口参数为List类型的解析,支持泛型? extends解析
  • [FIX]select中查询字段检测优化了resultMap中使用columnPrefix的检测
  • [NEW]可以快速添加typeMapper,根据表中未匹配的字段来快速添加
  • [IMPROVE]from sql generate mybatis java method param type will based on query column type
  • [IMPROVE]provide auto fix on java method return type when java method return type is different to xml resultType or resultmap type
  • [FIX]fix exception when use xml generate java class and resultMap
  • [FIX]support param completion and inspection when method is using kotlin with List parameter, support ? extend as well
  • [FIX]select query column inspection will work when resultmap contains columnPrefix
  • [NEW]add typeMapper quicker when table has unmapped columns
3.2.5
  • [IMPROVE]可以从resultmap type快速配置typealias
  • [NEW]从sql快速生成mybatis的java接口方法和xml
  • [NEW]从#{}快速生成if test语句
  • [FIX]兼容2023.3 eap版本
  • [FIX]修复InvalidElementAccessException
  • [IMPROVE]快速修复java接口方法返回类型和xml返回类型不一致
  • [IMPROVE]config typeAlias when resultMap type is not found
  • [NEW]from sql generate mybatis method and xml, replace value to #{}
  • [NEW]add if test for #{}
  • [FIX]compatability for 2023.3 eap version
  • [FIX]fix InvalidElementAccessException
  • [IMPROVE]quick fix for java method return type different from xml return type
3.2.4
  • [IMPROVE]check resultMap columns支持更复杂的resultmap检测
  • [FIX]用户禁用了kotlin插件导致的#{}没有代码提示
  • [IMPROVE]支持idea社区版在xml上填入参数预览sql
  • [IMPROVE]使用convertTextToSql不再限制sql的长度
  • [NEW]方法名生成sql支持mybatis flex框架
  • [IMPROVE]check resultMap columns support more complex resultmap
  • [FIX]fix completion on #{} when disable kotlin plugin
  • [IMPROVE]support preview xml on intellij community version
  • [IMPROVE]convert log to sql wont limit sql length
3.2.3
  • [NEW]like语句后面提示likeUserName这种并且直接bind好
  • [FIX]select * 不再提示把column加到resultMap中
  • [FIX]部分用户密文失败修复
  • [FIX]mybatis log linux系统临时文件夹问题
  • [IMPROVE]修复使用老版本api annotator可能会导致的性能问题
  • [NEW]after like statement will auto bind
  • [FIX]mybatis log linux temp folder issue
  • [IMPROVE]fix potential performance issue
3.2.2
  • [NEW]支持#{}中使用数组操作符解析
  • [IMPROVE]jdbcType会根据java类型来优先提示
  • [NEW]检测查询的字段但是resultMap或者resultType中没有并且可以一键加过去
  • [IMPROVE]支持mybatis generator配置xml后缀
  • [NEW]支持jakarta注解
  • [IMPROVE]方法名生成sql支持resultMap extends
  • [New]从方法名生成到mybatisplus的QueryWrapper
  • [NEW]生成testcase支持生成到mybatisplus
  • [NEW]support #{} use array[] operation
  • [NEW]detect select column not in resultMap or resultType, can add them quickly to resultMap or resultType
  • [IMPROVE]support mybatis generator configure xml suffix
  • [NEW]support jakarta annotation
  • [IMPROVE]method name to sql support resultMap extends
  • [New]mybatis plus method name to QueryWrapper
  • [NEW]generate testcase support mybatisplus
3.2.1
  • [New]一键将cdata语句转换为><这种方便SQL进行代码提示
  • [New]xml上右键可以转换sql到xml,将大于号小于号转换为<>这种
  • [FIX]controller模版import修复
  • [FIX]部分机器离线激活出错
  • [IMPROVE]mybatis log点击parameter log到相同的文件
  • [IMPROVE]resultMap上autoMapProperty会根据java实体类字段的顺序来匹配
  • [New]convert cdata to >< for sql code completion
  • [New]right click on xml to convert cdata to <>
  • [FIX]fix controller template import
  • [IMPROVE]mybatis log click parameter log to same file
  • [IMPROVE]resultMap autoMapProperty will keep the order of java class field
3.2.0
  • [New]支持在map或map.entry类型上foreach
  • [FIX]修复注解script标签解析依赖kotlin插件
  • [FIX]生成代码结束的时候有可能导致项目卡住
  • [FIX]exception修复
  • [New]support using collection foreach on map or map.entry type
  • [FIX]fix annotation sql with script depend on kotlin plugin
  • [FIX]performance issue after generate code
  • [FIX]exception fix
3.1.9
  • [New]支持xml调用枚举或者static变量上的方法解析
  • [NEW]从模版文件生成代码代码提示支持
  • [NEW]支持kotlin注解sql
  • [FIX]mybatis xml未被使用的检测默认开启
  • [FIX]findByXXBetween当if test null and empty勾选时生成问题
  • [FIX]社区版使用mybatis database 自定义driver路径报错的问题
  • [NEW]support xml use static field or enum with method
  • [NEW]code completion when use template to generate
  • [NEW]support kotlin annotation sql
  • [FIX]mybatis xml unused check enable by default
  • [FIX]findByXXBetween when if test null and empty is selected generate problem
  • [FIX]community version use mybatis database driver jar error
3.1.8
  • [FIX]兼容2023.1最新eap版本
  • [NEW]支持自定义lombok注解
  • [IMPROVE]if test代码提示优化
  • [IMPROVE]xml性能优化
  • [NEW]迁移到模版生成代码
  • [FIX]compatability for 2023.1 eap version
  • [NEW]support customize lombok annotation
  • [IMPROVE]if test completion improve
  • [IMPROVE]xml performance improve
3.1.7
  • [FIX]兼容2023.1 eap版本
  • [FIX]修复部分用户激活问题
  • [FIX]compatability for 2023.1 eap version
3.1.6
  • [FIX]修复xml添加注释或空格高亮失效
  • [NEW]xml测试sql添加All if test true和All if test false
  • [NEW]生成代码支持生成javax注解@NotNull@Size
  • [NEW]支持oracle批量插入语句生成
  • [IMPROVE]inspection性能优化
  • [FIX]修复getBean方法exception
  • [FIX]fix highlight loss when edit xml
  • [NEW]test sql add All if test true and All if test false Action
  • [NEW]support generate javax @NotNull @Size annotation
  • [IMPROVE]code inspection performance
  • [FIX]fix getBean method exception
3.1.5
  • [NEW]support parse $ statement by xml tag comment
  • [FIX]fix spring mapperscan exception throw when use +
  • [NEW]add button to expand * and ** packages to package list
  • [IMPROVE]support completion for static field in super class
  • [FIX]exception when use intention preview
  • [IMPROVE]community version can set driver class and driver path
  • 1.支持通过xml标签上的注释来解析$表达式
  • 2.修复当mapperScan使用+号的报错
  • 3.提供按钮可以一键把*和**的typeAlias转换为具体包名
  • 4.支持自动提示父类中的static final字段
  • 5.修复开启intention preview的代码报错
  • 6.idea社区版生成代码数据库支持配置驱动
3.1.3
  • [NEW]support java annotation script tag
  • [NEW]sql log jump to xml
  • [FIX]method name use insertList and insertSelective when resultmap not complete exception
  • [NEW]support kotlin mapper scan spring injection
  • [NEW]support resulthandler type check
  • [IMPROVE]better completion for ognl and #{}
  • 1.支持java注解中使用script的识别
  • 2.可以从日志跳转到xml
  • 3.方法名insertList和insertSelective当属性不一致exception修复
  • 4.支持kotlin mapperscan spring注入
  • 5.支持resulthandler类型的检测
  • 6.代码提示优化
3.1.2
  • [NEW]add option for sql tag auto detect prefix and suffix
  • [NEW]resultMap add check column menu to check unused column in resultMap related select statement
  • [NEW]support icon for base class to xml
  • [NEW]support select * in resultMap auto map and check column
  • [NEW]support to check mybatis interface unused method
  • 1.添加菜单可以自动识别sql标签的前后缀
  • 2.resultMap添加check column菜单来识别当前resultMap对应的select语句里面未使用的列
  • 3.从基类跳转到xml图标支持
  • 4.resultMap auto map和check column支持识别 select *
  • 5.支持检测mybatis接口中未使用的方法
3.1.1
  • [FIX]fix when generate test case line seprator issue
  • 1.修复生成testcase时生成换行符exception
3.1.0
  • [FIX]when open intention preview, create select statement multiple times
  • 1.修复开启intention preview, create select statement重复创建的问题
3.0.9
  • [NEW]mybatis generator save configuration
  • [NEW]mybatis generator configuration export to json and import from json
  • [NEW]support xml include with bind names
  • [NEW]mybatis generator will read line separator from intellij
  • [FIX]some formatter issue
  • [FIX]make string null and empty when reference to field and parameter
  • [IMPROVE] $ replace sql support more pattern
  • 1.mybatis generator支持保存配置,导入导出配置
  • 2.支持xml include带bind变量的解析
  • 3.一键string判断null和空支持当值来自于字段或者方法参数
  • 4.bug修复
3.0.8
  • [FIX]string exception when mybatis log has no parameter
  • [FIX]mybatis log too many memory issue
  • [NEW]support generate all column sql using template
  • 1.修复mybatis log当没有参数时的报错
  • 2.修复mybatis log数量太多时内存占用问题
  • 3.表上右键generate all column sql 可以通过模版来生成
3.0.7
  • [FIX]mybatis interface generate xml when selected interface class name
  • [IMPROVE]mybatis plus generate updateByPrimaryKeySelective
  • [IMPROVE]mybatis plus typehandler will add to model class
  • [IMPROVE]resultMap column auto completion when use with statement
  • [IMPROVE]support swagger3 openapi annotation
  • [IMPROVE]support disable param1,param2 like auto completion
  • [FIX]fix deadLock exception
  • [FIX]fix mybatis log parameter line contain multiple ending space to sql
  • 1.修复从接口类生成xml选中类名无法生成
  • 2.优化mybatisplus生成updateByPrimaryKeySelective
  • 3.mybatisplus定制列中配置的typehandler会生成到TableField注解上
  • 4.select使用with语句的resultMap column自动提示的解析
  • 5.表上生成代码支持swagger3,openapi
  • 6.支持配置禁用param1,param2这种代码提示
  • 7.修复deadLock异常
  • 8.修复mybatis log 部分情况无法解析问题
3.0.6
  • [FIX]sql log parameter contain null value logged sql is null
  • [IMPROVE]postgresql keyword use double quote
  • [IMPROVE]module name can be searched and other ui improvement
  • [FIX]move annotation to xml when xml not exist generate xml issue
  • [IMPROVE]create xml for mapper interface
  • 1.修复sql log 参数值包含null时解析的问题
  • 2.表上生成代码功能module名可以进行搜索和一些其他ui优化
  • 3.修复从注解挪动sql到xml时,xml不存在创建xml
  • 4.优化从接口从生成xml触发问题
  • 5.postgresql使用关键字时使用双引号来转义
3.0.5
  • [FIX]fix editor null pointer exception
  • 1.修复editor为null的exception
3.0.4
  • [FIX]sql log remove duplicate not work in some case
  • [FIX]sql log support more pattern
  • [FIX]sql log support multi insert ect
  • [IMPROVE]better ui
  • 1.修复sql log移除重复的sql某些情况不生效的问题
  • 2.sql log兼容各种sql
  • 3.sql log支持批量模式,一个parepare 多个parameter那种模式
  • 4.更好的ui
3.0.3
  • [NEW]support result map use constructor
  • [IMPROVE]better controller template provide auto completion
  • [IMPROVE]better error reporter
  • [IMPROVE]better performance
  • [NEW]mybatis sql log to real sql support
  • [IMPROVE]support clear table config for mybatis generator
  • [FIX]intelllij community generate code when table use key word
  • [NEW]支持resultmap中使用constructor,提供自动提示,检测等
  • [IMPROVE]controller的模版可以自动提示
  • [IMPROVE]更好的性能
  • [NEW]mybatis日志转sql支持
  • [IMPROVE]支持清除表缓存
  • [FIX]修复idea社区版表生成代码出错 当表含有数据库关键字时
3.0.2
  • [NEW]mybatis annotation constant support
  • [NEW]mybatis annotation param auto completion,inspection,rename ect
  • [NEW]mybatis annotation sql injection
  • [FIX]intention action preview will not show dialog when use genreate testcase ect
  • [NEW]support page query for mybatisplus
  • [FIX]sql formatter for mybatis sql tag with if test
  • [FIX]support type * extends
  • [FIX]type mapper not work
  • [NEW]支持mybatis注解使用常量的解析
  • [NEW]支持mybatis注解 #{} 自动提示,检测,重构等
  • [FIX]修复intention preview 会自动弹出窗口比如使用 generate testcase时
  • [NEW]支持mybatisplus的分页
  • [FIX]修复sql标签if test的格式化
  • [FIX]支持解析接口参数为* extend 这种泛型
  • [FIX]修复typeMapper配置不生效
3.0.1
  • [FIX]mybatis generator set text null pointer
  • [FIX]修复mybatis generator出现null pointer
3.0.0
  • [FIX]mybatis where or trim tag focus change after completion
  • [NEW]add typeMapper for column type and java type mapping
  • [FIX]right click on xml generate all column sql when column using database keyword escape issue
  • [FIX]refactor add param for complex type when type has base class refactor them as well
  • [NEW]update controller template with tableRemark variable
  • [FIX]where和trim等标签在换行光标跳转问题修复
  • [NEW]增加typemapper,可以配置java类型和表字段类型的转换关系
  • [FIX]修复在xml上右键generate all column转义问题
  • [FIX]给复杂类型加一个param注解支持解析父类中的属性
  • [NEW]controller模版添加表注释变量
2.9.9
  • [FIX]xml sql code formatter line issue
  • [NEW]add configuration for if test not split line
  • [IMPROVE]better java type editor for customized column
  • [IMPROVE]controller package and src folder auto completion
  • [FIX]修复xml格式化换行的问题
  • [NEW]可配置if test格式化不换行
  • [IMPROVE]定制列里面更好的java类型编辑器
  • [IMPROVE]生成controller配置src folder和package名可以自动提示
2.9.8
  • [NEW]add support for skip analyze param type
  • [NEW]support ognl array operation
  • [FIX]fix sql generate java class and resutlMap exception when use sqlserver
  • [FIX]fix sql generate java class file not refereshed after generated
  • [NEW]support only generate model in mybatis generator
  • [NEW]添加配置param中忽略解析的类型
  • [NEW]支持ognl数组操作
  • [FIX]修复从sql导出java类和resultMap sqlServer出现的exception
  • [FIX]修复从sql导出java类和resultMap文件没有刷新
  • [NEW]支持mybatis generator只生成java类
2.9.7
  • [NEW]support kotlin add param
  • [NEW]kotlin method not found in xml inspection
  • [FIX]fix error notify location when use mybatis generator
  • [FIX]fix file not refresh in idea when use mybatis generator
  • [NEW]支持kotlin添加param注解
  • [NEW]kotlin接口方法找不到xml中的sql的检测
  • [FIX]修复mybatis genrator文件夹配置为空的提示的位置
  • [FIX]修复使用mybatis generator后idea的文件没有刷新出来
2.9.6
  • [FIX]method generate xml statement exception
2.9.5
  • [FIX]generate java class use swagger exception
  • [IMPROVE]method name generate sql could ignore lacked fields
  • [FIX]resultMap id and result with end tag formatting issue
2.9.4
  • [FIX]sql formatter not work with long sql
  • [NEW]support refactor add a param name to a complex type
  • [NEW]support sql session select multiple xml jump
  • [FIX]fix swagger class comment
2.9.3
  • [FIX]fix sql tag with cadata parsing
  • [IMPROVE]support sqlSession select statement jump to xml
  • [IMPROVE]support apple m1
  • [FIX]fix formatter with $ with cdata issue
2.9.0
  • [IMPROVE]support 2021.1
  • [IMPROVE]could config method name generate sql comment style
  • [NEW]mybatis generator could preview xml
  • [IMPROVE]support mybatisplus table exist false
  • [IMPROVE]method name generate sql support if test select all
  • [FIX]possible null pointer
2.8.9
  • [FIX]intellij community version xml code formatter ognl fix
  • [IMPROVE]support 2020.4 version
  • [IMPROVE]resultMap column duplicate inspection
  • [IMPROVE]better chinese inspection description
  • [IMPROVE]support search scope with module and project
  • [NEW]could config mybatis sql tag ignore sql syntax error
2.8.8
  • [FIX]intellij community version use database generate crud and generate testcase exception
  • [IMPROVE]intellij community version no primary key warning
  • [IMPROVE]method name generate sql @Transient maven location
  • [IMPROVE]resultMap column inspection ignore case
2.8.7
  • [FIX]support chinese or japanese in #{}
  • [FIX]generate insertOnDuplicateKeySelective string empty check
  • [IMPROVE]base support for include with property
  • [IMPROVE]generate from database table warning where table dont have primary key
  • [NEW]support for 2020.3
2.8.6
  • [FIX]fix sql keyword completion after #{}
  • [FIX]fix reformat code missing with comment inside sql
2.8.4
  • [NEW]fix java inspection performance issue
2.8.3
  • [NEW]kotlin method name generate sql
  • [IMPROVE]plugin conflict notification
  • [IMPROVE]sql dialect not configured notification
  • [NEW]could configure to remove some type parameter in mybatis method
  • [NEW]could configure eacape all column
  • [NEW]generate testcase could configure plugin part
  • [NEW]multiple table generate can use actual column name
2.8.2.fix-2
  • [FIX]compatible for 2020.2 eap version
2.8.2.fix
  • [FIX]fix line indent create new statement from java method and when type enter
2.8.2
  • [NEW]better performance
  • [NEW]mybatis sql formatter
  • [NEW]resultMap column go to reference, rename
  • [FIX]fix using lombok plugin rename resultMap property name start with set
  • [FIX]fix mybatis generator with lombok builder annotation
  • [FIX]activation and unbind using socks proxy error
2.8.1
  • [FIX]generate testcase component exception
2.8.0
  • [FIX]fix possible null pointer exception when use project setting page
  • [NEW]support mybatis generator with configure method name generate
  • [NEW]support 2020 version
  • [NEW]better ognl complete and evaluate for bind and collection with method invoke
  • [NEW]support kotlin param completion and inspection
  • [NEW]add @ignore quick fix in mybatis choose when statement
  • [NEW]escape table name when they are keywords
  • [IMPROVE]better method name completion
2.7.8
  • [FIX]fix swagger exception when column comment is null
  • [NEW]support mysql json type
  • [NEW]generate all column sql right click on xml
2.7.7
  • [NEW]database generate could config method name to generate
  • [NEW]support findByAllExceptXXBetween statement
  • [NEW]move sql from annotation to xml
  • [FIX]test sql will add quote when param is string type
  • [NEW]test sql could write and test in the same time
  • [NEW]ognl support reference mybatis properties
  • [NEW]lombok when has extend add @EqualsAndHashCode(callSuper = true)
  • [NEW]support updateBatchSelective
  • [NEW]support simple sql reformat
2.7.6
  • [NEW]typeAlias support for Intellij community and mybatisPlus
  • [NEW]support param using static constant
  • [NEW]extract include refid from sql
  • [NEW]table name to entity support remove table prefix
  • [NEW]generate join support multiple table
  • [NEW]database generate crud support oracle sequence
  • [NEW]method name generate sql use where tag instead of where 1=1
  • [NEW]support 32 system
2.7.5
  • [NEW]method name generate sql will not depend on insert method
  • [FIX]press enter after if test ect error indent
  • [FIX]press enter or delete in blank part cause highlight disappear
  • [NEW]ognl support inner class
  • [FIX]sql parse error when no blank before param
  • [FIX]complete and inspection for param using generic
  • [NEW]support 2019.3 version
2.7.4
  • [FIX]possible substring exception when edit sql
  • [NEW]quick fix for param and ognl
  • [NEW]super class invoke could jump to xml
  • [FIX]resultMap column auto complete support more sql pattern
  • [NEW]generate java method from xml
  • [NEW]generate @sql comment for mybatis sql tag
  • [NEW]java method return type inspection support @MapKey
  • [FIX]if xml select steatment is referenced by resultMap will not show error
  • [FIX]database generate crud entity class will remove field in super class
  • [FIX]quick fix for resultMap property
  • [FIX]param auto completion for unpaid user
2.7.3
  • [NEW]resultmap column inspection support columnPrefix
  • [FIX]mapper interface with super class generic
  • [NEW]use java method to config columnName to propertyName
  • [NEW]resultMap jdbcType and typeHandler better auto complete and inspection
  • [NEW]generate properties on resultMap will auto match column in select tag
2.7.2
  • [NEW]param and ognl refactor
  • [NEW]intellij community version param complete
  • [IMPROVE]better param completion and inspection for typeHandler and mode and resultMap ect
  • [FIX]resultType resultMap inspection
  • [NEW]resultMap column inspection
  • [FIX]resultMap discriminator support
  • [NEW]database generate crud support mybatisPlus2
  • [NEW]better merge ui
  • [FIX]sql extract resultmap support more sql pattern
  • [NEW]kotlin class jump to xml each other
  • [FIX]better generic in mapper interface support
  • [NEW]support ognl use instanceOf
2.7.1
  • [NEW]ognl better completion and inspection for single param no annotation
  • [FIX]intellij community version typed error
  • [FIX]support 2019.2 version
  • [NEW]add checkBlobColumn option
  • [FIX]check conflict for exampleQuery and tkMapper
  • [NEW]comment in sql use xml comment instead of sql
2.7
  • [NEW]ognl support for if test when test foreach collection
  • [FIX]java utils null pointer exception when setter method not return void
  • [IMPROVE]param auto complete in cdata block
  • [FIX]example query generated service List is not import
  • [FIX]java.lang.RunTimeException:After patch:doc
  • [FIX]database generate crud press enter will not exit
  • [FIX]if test string compare with single char inspection
  • [FIX]type safe mybatis sql with @ignoreSql @sql $sql comments
  • [NEW]method return type inspection
  • [NEW]database regenerated java class could merge by ui
  • [FIX]p3c comment id problem
  • [IMPROVE]other fix
2.6.1
  • [FIX]completion kotlin null pointer exception
  • [IMPROVE]better method name auto complete
  • [FIX]fix caret point to method body when generate select statement from method
2.6
  • [NEW]mybatis param inspection
  • [IMPROVE]better param auto complete
  • [IMPROVE]better method name auto complete for method name to sql
  • [IMPROVE]resultMap property auto complete and rename support set method and field
  • [NEW]support bind tag in xml
  • [NEW]mapperScan package auto compelte and inspection
  • [IMPROVE]reformat code after add param action
  • [FIX]oracle findFirst generate sql not right
  • [FIX]generate testcase in maven project exception
  • NEW]support mybatis useActualParamName
  • [FIX]service not import list when database generate crud
  • [FIX]database generate crud resource folder not provide package from resource
  • [FIX]database generate crud mapperAnnotation not remembered
  • [NEW]database to crud support mybatis plus generate service
  • [NEW]generate join query support tk mapper and mybatisplus
  • [FIX]possible exception fix
2.5
  • [NEW]generate join statement from xml
  • [IMPROVE]shorten xml comment
  • [IMPROVE]mark blob column as common column
  • [IMPROVE]database generate crud could generate service interface
  • [NEW]support updateByXXX statement
  • [NEW]better support for sqlServer
  • [NEW]could customize database generate curd methods
  • [IMPROVE]better ui for database generate crud
  • [FIX]null pointer exception ModuleRootManager
  • [FIX]hashMap$Node cast exception
  • [NEW]could config auto fold xml generated methods
  • [NEW]auto complete for mybatis selectKey
2.4
  • [IMPROVE]generate java class support lombok Serializable ect
  • [IMPROVE]generate testcase will auto config typeAlias
  • [IMPROVE]support findAllByXXX ect
  • [IMPROVE]database generate crud choose not generate jdbcType
  • [IMPROVE]mybatis configuration file mapper resource auto complete
  • [FIX]java to select provider will use current module and dependency
  • [IMPROVE]better performance for typeAlias support
  • [FIX]mybatis datasource use java8 localDate ect not function
  • [NEW]database could generate batchInsert,batchUpdate ect
  • [IMPROVE]add file header when database generate curd like @author
  • [IMPROVE]findByXXIn will use Collection as param instead of List
  • [IMPROVE]database regenerate model will ignore transient field and it's getter and setter
2.3
  • [IMPROVE]springboot typealias support
  • [IMPROVE]xml inspection on resultMap resultType parameterType ect
  • [IMPROVE]sql param auto complete in multiple foreach tag
  • [IMPROVE]regenerate service will merge content
  • [IMPROVE]update delete count could use if test when using method name generate sql
  • [IMPROVE]findByAll generate use domain entity as param
  • [IMPROVE]generate testcase could use database from intellij and history
  • [FIX]fix exception when using typealias
  • [NEW]database generate crud could add batchInsert, batchUpdate, InsertOnDuplicate methods
  • [IMPROVE]support multiple xml with same namespace when using methodName generate sql
  • [FIX]fix oracle param auto complete exception
  • [IMPROVE]better format when using method name generate sql
2.2
  • [FIX]fix mybatis generator regenerate toString equal hashCode not overwrite
  • [FIX]possible exception fix
  • [IMPROVE]method generate sql will escape sql keywords
  • [IMPROVE]mybatis generator mapper suffix could configure
2.1
  • [New]quick execute mybatis sql from sql statement
  • [IMPROVE]java generate crud could use other module path
  • [IMPROVE]support collection array no param auto complete
  • [IMPROVE]auto escape sql keywords for tk mapper and mybatisplus
  • [IMPROVE]method name generate sql could use select get query alias ect
2.0.3
  • [FIX]generate test case database url use utc instead of local time zone
  • [New]use mybatis generator for multiple table generate
  • [IMPROVE]tk mapper could config is super class
  • [NEW]use mybatis generator could generate service
  • [IMPROVE]auto complete for when statement and resultMap jdbcType
  • [IMPROVE]resultMap and refId provide complete from other mybatis file
  • [FIX]oracle using with tk mapper column annotation using ' not recognized
  • [NEW]mybatis sql tag auto complete for columns
  • [NEW]resultMap column auto complete based on property name
  • [NEW]could add schema name to table name
2.0.2
  • [FIX]oracle date type with jdbcType date instead of timeStamp
  • [New]database generate crud support common mapper and mybatisPlus
  • [FIX]indexNotReady exception when generate testcase
  • [FIX]mapper definition search threading exception
  • [FIX]method name generate sql possible exception
  • [IMPROVE]when database contains too many table, connect to database very snow
  • [IMPROVE]better ui for setting page
  • [IMPROVE]mybatis spring support * and ** wildcard
  • [New]method name generate sql support common mapper and mybatisPlus new and old version
  • [IMPROVE]sql param auto complete with jdbcType
  • [FIX]postgresql numeric with no length should use bigDecimal instead of short
  • [IMPROVE]make domain class comment better
  • [IMPROVE]findByLike will add % to it
  • [FIX]possible bug when using ctrl+alt+b to jump to xml
2.0.1
  • [IMPROVE]jump to mapper interface after database generate crud
  • [NEW]support add swagger annotation when database generate crud
  • [NEW]could use ctrl+alt+b to jump from mapper method to xml
  • [New]could jump from resultMap property to java field
  • [IMPROVE]auto detect table generated key when database generate crud
  • [IMPROVE]jump to mapper interface after database generate crud
  • [FIX]exception when use alt+enter generate method xml
  • [IMPROVE]auto add delimter when database generate crud
  • [IMPROVE]support mybatis annotation string concat inject sql language
  • [FIX]possible file not update when generate class already exist
  • [IMPROVE]java generate crud better ui
  • [NEW]customize fields when database generate curd javaType could auto complete
2.0.0
  • recognize mybatis tag in xml, like where trim update ect,provide sql completion after those tag
  • could generate java class for database table
  • generate sql column list base on database table
  • better support for generate page query in mybatis interface method
  • support findByTrue findByFalse for method name generate sql
  • if test completion support list check size and string check empty
  • when use mybatis generator when database, support implement Serializable
1.9.9
  • fix java generate crud just ignore static fields
  • auto inject sql language to mybatis annotation sql statement
  • add mybatis annotation param auto complete
  • support if test on string check null and empty
  • generate all properties base on resultMap type collection javaType ect
  • mybatis annotation sql could auto complete
  • fix some bug
1.9.8
  • use database to generate crud support java8 localDateTimeEct
  • could generate java class and resultMap from xml sql
  • fix log4j class loader bug
1.9.5
  • fix bug with spring using @MapperScan not recognized
  • fix some user might need to reactivate when they change mac address
1.9.4
  • better support for multiple module project
  • fix generate test on multiple module project
  • show user expire date on setting
  • fix postgresql insert statement serial type should not insert primay key
  • fix generate test for mybaits annotation
1.9.3
  • fix method generate sql table name stay the same format
  • could use method name insertList,insertSelective to generate query
  • fix possible null pointer
1.9.2
  • fix using intellij database to generate crud code, mysql dateTime jdbcType is Date instead of TimeStamp
  • database generate crud package name could auto complete
1.9.1
  • fix using intellij database to generate crud code, mysql bigInt the default java type is Integer

1.9.0

  • fix setting not apply after intellij restart

1.8.9

  • better icon
  • database generate support lombok, mapperAnnotation
  • fix bug when using alt+enter on method name
  • improve generate page statement
  • support postgresql for java generate crud code
  • fix checkbox can't select problem
  • improve generate testcase from mybatis mapper
  • improve generate page query from mybatis mapper

1.8.8

  • better indexer
  • generate page query for mybatis method

1.8.7

  • add code inspection for xml result map
  • support more for xml auto complete
  • could use mybatis on Intellij Ultimate database
  • bug fix

1.8.6

  • fix spring integration for 2018.1
  • fix resultMap property auto complete
  • fix check result map warning

1.8.5

  • bug fix

1.8.4

  • could customize when using database to generate
  • support param auto complete
  • better ui from qq group user
  • add support for spring could recognize mapper mapperScan annotation ect

1.8.3

  • generate testcase by one click
  • still show database when can't connect
  • offline activation support
  • unbind support
  • fix no need to focus on table to use mybatis generator
  • other bug fix

1.8.2

  • fix mysql using mybatis generator xml using database name

1.8.1

  • add database support for sqlserver and oracle 10g and mysql8.0
  • fix BaseColumnList duplicate generate
  • fix update when xml has comments
  • using project scope instead of module scope
  • support annotation like insertProvider ect

1.8.0

  • support extend on resultMap
  • add database support oracle and postgresql
  • better ui for using mybatis generator on database
  • import param class
  • fix possible bug

1.7.9

  • bug fix

1.7.8

  • fix qq group id
  • bug fix

1.7.7

  • could jump direct from java class to mapper
  • add param annotation for mybatis mapper
  • update charset to uft8mb4
  • fix findByLike problem

1.7.6

  • mybatis generator using database comment
  • fix error when generate mybatis generator xml file
  • fix use project scope when user use mybatis generator
  • support when one mapper to multiple xml

1.7.5

  • remember user config path
  • add keymap to jump from java to xml and xml to java
  • user could config using project or module search scope
  • fix encoding problem when using with mybatis generator

1.7.4

  • xml not find in method using warn instead of error
  • support add jdbcType when update java class field
  • generate mybatis generator file one click
  • fix like problem

1.7.3

  • fix thread assertion bug
  • mybatis generate not change dao file
  • fix java dateTime jdbcType

1.7.2

  • fix inspection for check mybatis xml not used

1.7.1

  • support bind on mac address on device register
  • fix order by with multiple field
  • fix display probelm on mac when generate files
  • fix exception on intellij on 1.7.3
  • add override when generate service impl
  • add scroll panel for generate by datasource
  • delete multiple unused xml fast

1.7.0

  • generate service add override annotation
  • find first n return list
  • import java class package when generate service interface

1.6.9

  • better method name auto complete
  • fix connect to sql database
  • fix jdbcType for long
  • better way to choose package
  • find one not generate on limit
  • support using transient

1.6.8

  • fix icon in xml miss
  • support more from field comment
  • support change icon
  • generate with jdbcType

1.6.7

  • fix bug service interface import page
  • could generate comment from field comment
  • use better icon
  • support language like updateIncVersion

1.6.6

  • fix bug when generate method xml in service

1.6.5

  • support findWithPage
  • support to configure mapper prefix

1.6.4

  • support sqlite
  • oracle support multiple column index,multiple column unique

1.6.0

  • support generate if test
  • support generate in service and service interface
  • support multiple column index,multiple column unique
  • support generate on function
  • support generate dto when find more than one field
  • not using pojo as default param

1.4.5

  • support with enum type

1.4.4

  • fix exception when start up

1.4.3

  • support multiple method xml generate
  • support for mybatis plus
  • support domain class with protected field and static field
  • support for small resolution
  • bugfix - fix can't generate to path

1.4.2

  • bugfix - fix Could not initialize class com.ccnode.codegenerator.freemarker.b

1.4.1

  • bugfix - oralce insertList
  • bugfix - import issue

1.4

  • add support for oracle
  • config use generate key
  • auto complete for resultMap,refid,keyProperty,property
  • support with java.sql.Timestamp java.sql.Date java.sql.Time Enum LocalDateTime LocalDate
  • support update field with insertSelective
  • add new icon of mybatis jump to xml ect

1.3

  • add index column and hasDefault column when generate mybatis files
  • jump from refid resultMap to their definition in mybatis xml. could refactor as well
  • could refactor method name in xml
  • add insertSelective when generate mybatis files
  • generate for greaterThanOrEqualTo and lessThanOrEqualTo and betweenOrEqualTo
  • add configuration to use with @Mapper
  • fix not null issue for find module - bug fix

1.2

  • add support for unsigned type, small int.
  • check for using object type instead of primitive type
  • support more auto completion for sql
  • double type support - bug fix
  • update field exception -bug fix

Feb 08, 2025
Version 3.3.9+2321

Rating & Reviews

5.0
180 Ratings (1,027,371 Downloads)
5
4
3
2
1

ApiHug

12.11.2024

好用,点赞!

0

yh1522383430

05.11.2024

非常好用,谁用谁知道,建议官方收录

0

眇目鱼

28.08.2024

最好用的mybatis插件,而且作者解决问题非常及时

0

Additional Information

Vendor:
bruce ge(Non-trader)
Plugin ID:
com.ccnode.codegenerator.MyBatisCodeHelperPro