Compatible with: IntelliJ IDEA Android Studio
Oct 10, 2018
40 048



  • Generate mybatis crud and create table sql according to domain class
  • Generate mybatis crud code according to database table
  • 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 with method name start with find,update,delete,count

  • Jump from mybatis dao interface to mapper xml each other

  • generate files provide insert, insertSelective,insertList,update. others can be generated by methodName

  • refactor for mybatis interface method name

  • jump from refid resultMap to their definition, refactor their name as well

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

  • mybatis mapper sql auto completion

  • could generate mybatis generator sample xml file

  • run mybatis generator on database

  • could run mybatis generator base on xml file

  • refid,resultMap,keyProperty,property auto complete
  • could add param with one click

  • generate mybatis mapper testcase from mybatis interface method

  • Support MySQL+Oracle+Sqlite+postgresql+sqlserver

  • to learn more.

How to use

  • alt+insert (generate mybatis files) on domain class to generate mybatis files (ctrl+N on mac)
  • alt+insert (generate mybatis files) on domain class to update mybatis files when domain class add field (ctrl+N on mac)
  • alt+enter on dao interface method to generate mybatis mapper sql
  • view more on
  • qqGroup:542735979

Download plugin

Recent change notes

  • 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

  • use database to generate crud support java8 localDateTimeEct
  • could generate java class and resultMap from xml sql
  • fix log4j class loader bug

  • fix bug with spring using @MapperScan not recognized
  • fix some user might need to reactivate when they change mac address

  • 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

  • fix method generate sql table name stay the same format
  • could use method name insertList,insertSelective to generate query
  • fix possible null pointer

  • fix using intellij database to generate crud code, mysql dateTime jdbcType is Date instead of TimeStamp
  • database generate crud package name could auto complete

  • fix using intellij database to generate crud code, mysql bigInt the default java type is Integer

  • fix setting not apply after intellij restart

  • 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

  • better indexer
  • generate page query for mybatis method

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

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

  • bug fix

  • 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

  • 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

  • fix mysql using mybatis generator xml using database name

  • 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

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

  • bug fix

  • fix qq group id
  • bug fix

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

  • 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

  • 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

  • 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

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

  • fix inspection for check mybatis xml not used

  • 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

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

  • 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

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

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

  • fix bug when generate method xml in service

  • support findWithPage
  • support to configure mapper prefix

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

  • 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

  • support with enum type

  • fix exception when start up

  • 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

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

  • bugfix - oralce insertList
  • bugfix - import issue

  • 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

  • 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

  • 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

1.1 fix doc

1.0 use gradle, fix bugs.