MyBatis Generator plugins
AddComplexCriteriaPlugin
Adds custom criterion to specified *Example-class.
AddCriteriaActionsPlugin
List<Foo> list = new FooExample().createCriteria().and.....list(sql);
AnyCriteriaPlugin
new FooExample().createCriteria().andIf("lower(lastname)","like",lastName.toLowerCase());
BooleanTypePlugin
Provides a converter (type handler) from Java Boolean type to VARCHAR and NUMBER(x,0) columns.
CommonTablePropertiesPlugin
Provides global configuration parameters (alias, ignoreQualifiersAtRuntime, modelOnly, runtimeCatalog, runtimeSchema) for <table>
DistinctPlugin
List<Integer> list = Foo.distinctBarId(fooList);
ExampleMethodsChainPlugin
sql.getMapper(FooMapper.class).selectByExample(
new FooExample().createCriteria().andBarIdEqualTo(123).criteria().setOrderByClause("id desc")
);
or
new FooExample().setOrderByClause("id desc").createCriteria().andBarIdEqualTo(123).list(sql);
JDBCTypesPlugin
Provides the ability to remap awkward SQL Type to more convenient one (e.g. NUMBER(18,0) - from DECIMAL and java.math.BigDecimal to BIGINT and Long; TIMESTAMP (3) WITH LOCAL TIME ZONE from OTHER and java.lang.Object to TIMESTAMP and java.util.Date).
JoinPlugin
new FooExample().addFromClause("join bar b on b.id=foo.bar_id").createCriteria().andIf("b.code","=",....);
MapPlugin
Map<Integer, Foo> map = Foo.mapByBarId(fooList);
Map<Integer, List<Foo>> map = Foo.mapAllByBarId(fooList);
ModelSettersChainPlugin
Foo foo = new Foo().setAnswer(42);
NullableInCriteriaPlugin
Modifies Example class to allow using null and empty lists as parameter of andXxxIn(List) and andXxxNotIn(List) methods.
PaginationPlugin
Adds limit and offset (top, first...skip, offset...row...fetch next, etc) clause to the Example class.
SelectiveWithNullPlugin
Provides the ability to store modified fields (including null-values) using insertSelective and updateBy*Selective methods.
fooMapper.updateByPrimaryKeySelectiveWithNull(new Foo().setId(42).setComment(null));
SimpleOrCriteriaPlugin
Provides the ability to use criteria like "... and (a or b or c) and ..."