mybatis-plugin

mybatis plugin

License	The Apache License, Version 2.0
Categories	MyBatis Data ORM
GroupId	cn.weiecho
ArtifactId	mybatis-plugin
Last Version	1.0.2
Release Date	Sep 17, 2019
Type	jar
Description	mybatis-plugin mybatis plugin
Project URL	https://github.com/weiecho/mybatis-plugin
Source Code Management	https://github.com/weiecho/mybatis-plugin

Download mybatis-plugin

Filename	Size
mybatis-plugin-1.0.2.pom
mybatis-plugin-1.0.2.jar	15 KB
mybatis-plugin-1.0.2-sources.jar	9 KB
mybatis-plugin-1.0.2-javadoc.jar	85 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/cn.weiecho/mybatis-plugin/ -->
<dependency>
    <groupId>cn.weiecho</groupId>
    <artifactId>mybatis-plugin</artifactId>
    <version>1.0.2</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/cn.weiecho/mybatis-plugin/
implementation 'cn.weiecho:mybatis-plugin:1.0.2'

Gradle Kotlin

// https://jarcasting.com/artifacts/cn.weiecho/mybatis-plugin/
implementation ("cn.weiecho:mybatis-plugin:1.0.2")

Apache Buildr

'cn.weiecho:mybatis-plugin:jar:1.0.2'

Apache Ivy

<dependency org="cn.weiecho" name="mybatis-plugin" rev="1.0.2">
  <artifact name="mybatis-plugin" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='cn.weiecho', module='mybatis-plugin', version='1.0.2')
)

Scala SBT

libraryDependencies += "cn.weiecho" % "mybatis-plugin" % "1.0.2"

Leiningen

[cn.weiecho/mybatis-plugin "1.0.2"]

Dependencies

compile (2)

Group / Artifact	Type	Version
org.mybatis.spring.boot : mybatis-spring-boot-starter Optional	jar	2.1.0
org.json : json Optional	jar	20190722

Project Modules

There are no modules declared in this project.

mybatis-plugin

根据真实使用场景对mybatis进行的扩展，实现分页、json存储、数组存储、blob存储等支持。

扩展Mybatis数据类型

1、ArrayTypeHandler 支持数组数据的存储和读取

bean定义格式

private String[] tags;

mapper定义格式

<result property="tags" column="tags" typeHandler="ArrayTypeHandler"/>

2、JsonTypeHandler 支持Json对象数据的存储和读取

bean定义格式

/** 图片 如：[{imageUrl:"/1.jpg"}] **/
private Object imagesUrl;

mapper定义格式

<result property="imagesUrl" column="imagesUrl" typeHandler="JsonTypeHandler"/>

3、BlobTypeHandler 支持Blob数据的存储和读取

bean定义格式

/** 文章内容 **/
private String content;

mapper定义格式

<result property="content" column="content" typeHandler="BlobTypeHandler"/>

4、ListTypeHandler 支持List数据的存储和读取(可以视为Array的升级版)

bean定义格式

private List<String> tags;

mapper定义格式

<result property="tags" column="tags" typeHandler="ListTypeHandler"/>

扩展Mybatis自动执行分页SQL处理

1、MysqlPageInterceptor支持mysql数据的分页

PageInterceptor pageInterceptor = new MysqlPageInterceptor();
sessionFactory.setPlugins(new Interceptor[]{pageInterceptor});

2、OraclePageInterceptor支持oracle数据的分页

PageInterceptor pageInterceptor = new OraclePageInterceptor();
sessionFactory.setPlugins(new Interceptor[]{pageInterceptor});

3、PostgresqlPageInterceptor支持postgresql数据的分页

PageInterceptor pageInterceptor = new PostgresqlPageInterceptor();
sessionFactory.setPlugins(new Interceptor[]{pageInterceptor});

ps:如果分页对应的查询语句中不存在from会throw异常分页查询SQL没有找到[from]关键字，from必须为小写且前后加空格。

Wei Echo

Versions

Version
1.0.2 Sep 17, 2019
1.0.1 Sep 17, 2019