MyBatis Thymeleaf 3 Support

MyBatis Thymeleaf 3 Scripting Support.

Introduction

The mybatis-thymeleaf is a plugin that helps applying a SQL using template provided by Thymeleaf 3. If you are not familiar with Thymeleaf 3 syntax, you can see the Thymeleaf documentations.

• https://www.thymeleaf.org/doc/tutorials/3.0/usingthymeleaf.html#textual-template-modes

Simple bindable 2-way SQL

SELECT * FROM names
  WHERE id = /*[# mb:p="id"]*/ 1 /*[/]*/

Dynamic bindable 2-way SQL

SELECT * FROM names
  WHERE 1 = 1
  /*[# th:if="${not #lists.isEmpty(ids)}"]*/
    AND id IN (
      /*[# mb:p="ids"]*/ 1 /*[/]*/
    )
  /*[/]*/
  ORDER BY id

Dynamic bindable SQL(non 2-way)

SELECT * FROM names
  WHERE 1 = 1
  [# th:if="${not #lists.isEmpty(ids)}"]
    AND id IN (
      [# mb:p="ids" /]
    )
  [/]
  ORDER BY id

Requirements

• Java 8, Java 11+
• MyBatis 3.4.3+ (Recommend to use 3.5+ or 3.4.x latest version)
• Thymeleaf 3.0+ (Recommend to use 3.0.x latest version)

Documentation

• Published User's Guide

• Snapshot User's Guide

Related Resources

• Quick Start
• Code completion
• Usage on framework

Contact us

Question

When there is a question, at first please confirm whether exists same question at following web sites.

• Google group for mybatis user(official mailing list)
• Stack Overflow tagged mybatis

If you cannot find a same question, please post new question to the mailing list or the Stack Overflow.

Report and Request

When you found a bug or want to submit a feature request(new feature or current feature improvement), at first please confirm whether exists same bug or request at following pages.

• Issue List
• Pull Request List

If you cannot find a same report or request, please post new issue to the issue tracker.

IMPORTANT:

When you found a security vulnerability, at first please report it to the mybatis organization members instead of issue tracker.