[JAVA] Things I tend to forget on MyBatis Personal summary

MyBatis is a convenient OR mapper that allows you to compose SQL relatively freely, so I often use it personally, but I tend to forget it once in a while. There are various things, so I summarized it as a memorandum at that time.

Handle header detail type data

SELECT system

How to write MyBatis configuration file and SQL when fetching the data linked in the header table and detail table with one mapper. → Handle header detail type data in MyBatis

When fetching data for pagination, etc., the row range is specified and fetched, but when trying to do it with MyBatis API, an unexpected row is returned, a workaround. → Handle header detail type data in MyBatis (specify line range)

INSERT system

How to write MyBatis configuration file and SQL when writing the data linked in the header table and detail table with one mapper. → INSERT header detail type data with MyBatis (also automatically number)

others

Others will be added one by one.

Recommended Posts

Things I tend to forget on MyBatis Personal summary
I was addicted to looping the Update statement on MyBatis
I want to display background-ground-image on heroku.
Language summary to learn from now on
I want to install PHP 7.2 on Ubuntu 20.04.
I tried to build AdoptOpenjdk 11 on CentOS 7
I was addicted to using RXTX on Sierra
I was addicted to installing Ruby/Tk on MacOS
A story I was addicted to when getting a key that was automatically tried on MyBatis