{"id":6259,"date":"2024-03-14T04:02:49","date_gmt":"2024-03-14T04:02:49","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/"},"modified":"2025-08-02T01:18:52","modified_gmt":"2025-08-02T01:18:52","slug":"how-do-you-use-the-mapper-in-mybatis","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/","title":{"rendered":"MyBatis Mapper Tutorial: Step-by-Step Guide"},"content":{"rendered":"

In MyBatis, mapper interfaces are used to define methods for data operations, while the corresponding Mapper XML files are used to configure SQL statements and mapping relationships. Here are the general steps for using a mapper:<\/p>\n

    \n
  1. Create a Mapper interface: Define the methods for data operations within the interface, for example:<\/li>\n
  2. The UserMapper interface provides methods for retrieving, adding, updating, and deleting user data.<\/li>\n
  3. Create the corresponding Mapper XML file: configure SQL statements and mapping relationships in the XML file, for example:<\/li>\n
  4. The following code snippet is written in XML and defines mapping statements for CRUD operations (Create, Read, Update, Delete) for a user entity.<\/li>\n
  5. Configure the MyBatis configuration file: Configure the data source, mapper scan path and other information in the configuration file, for example:<\/li>\n
  6. The configuration includes settings for different environments, with the default set to development. The development environment uses a JDBC transaction manager and a pooled data source connected to a MySQL database. The configuration also includes a mapper for a UserMapper.xml file.<\/li>\n
  7. By utilizing the Mapper interface, one can obtain an instance of the Mapper interface through Mybatis’s SqlSessionFactory in the code, then call methods to manipulate data. For example:
    \n“`java
    \nSqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    \nSqlSession sqlSession = sqlSessionFactory.openSession();
    \nUserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    \n“`<\/li>\n<\/ol>\n

    Retrieve a specific user by ID, change the user’s name to “New Name”, and then update the user information using the userMapper.<\/p>\n

    Save changes and close the session.<\/p>\n

    The above is the general process of using mapper in Mybatis, hope it helps you.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In MyBatis, mapper interfaces are used to define methods for data operations, while the corresponding Mapper XML files are used to configure SQL statements and mapping relationships. Here are the general steps for using a mapper: Create a Mapper interface: Define the methods for data operations within the interface, for example: The UserMapper interface provides […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[101,2688,1459,3509,3134],"class_list":["post-6259","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-operations","tag-java-persistence","tag-mybatis","tag-mybatis-mapper","tag-sql-mapping"],"yoast_head":"\nMyBatis Mapper Tutorial: Step-by-Step Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Complete MyBatis mapper tutorial covering interface creation, XML configuration, and SQL mapping for efficient database operations.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MyBatis Mapper Tutorial: Step-by-Step Guide\" \/>\n<meta property=\"og:description\" content=\"Complete MyBatis mapper tutorial covering interface creation, XML configuration, and SQL mapping for efficient database operations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T04:02:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T01:18:52+00:00\" \/>\n<meta name=\"author\" content=\"Emily Johnson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emily Johnson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/\"},\"author\":{\"name\":\"Emily Johnson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\"},\"headline\":\"MyBatis Mapper Tutorial: Step-by-Step Guide\",\"datePublished\":\"2024-03-14T04:02:49+00:00\",\"dateModified\":\"2025-08-02T01:18:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/\"},\"wordCount\":263,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database operations\",\"Java persistence\",\"MyBatis\",\"MyBatis mapper\",\"SQL mapping\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/\",\"name\":\"MyBatis Mapper Tutorial: Step-by-Step Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T04:02:49+00:00\",\"dateModified\":\"2025-08-02T01:18:52+00:00\",\"description\":\"Complete MyBatis mapper tutorial covering interface creation, XML configuration, and SQL mapping for efficient database operations.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MyBatis Mapper Tutorial: Step-by-Step Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\",\"name\":\"Emily Johnson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"caption\":\"Emily Johnson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MyBatis Mapper Tutorial: Step-by-Step Guide - Blog - Silicon Cloud","description":"Complete MyBatis mapper tutorial covering interface creation, XML configuration, and SQL mapping for efficient database operations.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/","og_locale":"en_US","og_type":"article","og_title":"MyBatis Mapper Tutorial: Step-by-Step Guide","og_description":"Complete MyBatis mapper tutorial covering interface creation, XML configuration, and SQL mapping for efficient database operations.","og_url":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T04:02:49+00:00","article_modified_time":"2025-08-02T01:18:52+00:00","author":"Emily Johnson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Emily Johnson","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/"},"author":{"name":"Emily Johnson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378"},"headline":"MyBatis Mapper Tutorial: Step-by-Step Guide","datePublished":"2024-03-14T04:02:49+00:00","dateModified":"2025-08-02T01:18:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/"},"wordCount":263,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database operations","Java persistence","MyBatis","MyBatis mapper","SQL mapping"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/","url":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/","name":"MyBatis Mapper Tutorial: Step-by-Step Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T04:02:49+00:00","dateModified":"2025-08-02T01:18:52+00:00","description":"Complete MyBatis mapper tutorial covering interface creation, XML configuration, and SQL mapping for efficient database operations.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-the-mapper-in-mybatis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MyBatis Mapper Tutorial: Step-by-Step Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378","name":"Emily Johnson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","caption":"Emily Johnson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=6259"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6259\/revisions"}],"predecessor-version":[{"id":151019,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6259\/revisions\/151019"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=6259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=6259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=6259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}