MyBatis Tutorial

A SQL-First Persistence Framework MyBatis is a Java persistence framework that keeps you in control of your SQL instead of hiding it behind a query language. You write the exact ...

Adding the Dependency Add the MyBatis library to your project. Both the core library and the Spring Boot starter are available on Maven Central. For Spring Boot Add a JDBC Driver ...

mybatis-config.xml The central configuration file declares environments, mappers and global settings. Built With the XML Builder Using a Session Always close sessions. The ...

The Mapper Interface A mapper is a simple Java interface. Each method corresponds to one SQL statement declared in XML (or via annotations). The XML Mapping File The namespace ...

Select Insert With Generated Keys useGeneratedKeys + keyProperty writes the auto-generated key back into the Java object (Customer.getId() returns it). Update and Delete Returning ...

Automatic Mapping Helps When the column names match or simply map from snake_case to camelCase, MyBatis fills the object for you. Explicit resultMap For needed control use an ...

SQL That Adapts Dynamic SQL builds different statements depending on the input. An optional filter is the perfect example - no more clicking through empty conditions. The <where> ...

The Two Parameter Styles MyBatis offers two ways to substitute values into SQL, and they are not interchangeable. #{user}: Safe PreparedStatement Binding #{} becomes a ? ...

Two Levels of Cache MyBatis ships with two in-memory caches to avoid re-running the same SQL. First-Level Cache (Session) Enabled by default, it caches query results inside a ...

The Starter Handles the Wiring mybatis-spring-boot-starter auto-configures SqlSessionFactory, a transaction manager and mapper scanning. You only provide a DataSource and mappers. ...

An XML-Free Mapper For simple statements, MyBatis lets you put SQL directly on the interface with annotations - no XML file needed. When Annotations Work Well Short, stable CRUD ...

Patterns That Scale One mapper per entity or aggregate keeps files small and navigable. Name statements after the method ; namespaces must match interfaces. Map results explicitly ...