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.
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)
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 will be added one by one.
Recommended Posts