In this post, I will explain how to perform CRUD operations using MyBatis’s annotation support without needing to configure queries in XML mapper files.
MyBatis Tutorial: Part1 – CRUD Operations
MyBatis Tutorial: Part-2: CRUD operations Using Annotations
MyBatis Tutorial: Part 3 – Mapping Relationships
MyBatis Tutorial : Part4 – Spring Integration
Step#1: Create a table BLOG and a java domain Object Blog.
CREATE TABLE  blog 
(
      blog_id int(10) unsigned NOT NULL auto_increment,
      blog_name varchar(45) NOT NULL,
      created_on datetime NOT NULL,
      PRIMARY KEY  (blog_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
package com.sivalabs.mybatisdemo.domain;

import java.util.Date;

public class Blog 
{
     private Integer blogId;
     private String blogName;
     private Date createdOn;
     
     //Setters and getters
     
     @Override
     public String toString() {
      return "Blog [blogId=" + blogId + ", blogName=" + blogName
        + ", createdOn=" + createdOn + "]";
     }
}
Step#2: Create UserMapper.java interface with SQL queries in Annotations.

Test

A step-by-step guide to performing CRUD operations in MyBatis using Java annotations instead of XML mapper files. Covers creating a BlogMapper interface with @Insert, @Select, @Update, and @Delete annotations, configuring the mapper in mybatis-config.xml, building a BlogService with SqlSession management, and writing JUnit tests to verify all operations.