{"id":13507,"date":"2024-03-15T07:17:24","date_gmt":"2024-03-15T07:17:24","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/"},"modified":"2025-08-05T19:26:11","modified_gmt":"2025-08-05T19:26:11","slug":"what-are-the-commonly-used-mybatis-annotations-and-their-purposes","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/","title":{"rendered":"Key MyBatis Annotations Explained"},"content":{"rendered":"

Some commonly used MyBatis annotations include the following:<\/p>\n

    \n
  1. @Select: Used for configuring query statements, mapping SQL queries to methods.<\/li>\n
  2. @Insert: Used to configure an insert statement, mapping SQL statements to methods.<\/li>\n
  3. @Update: Used for configuring update statements, mapping SQL statements to methods.<\/li>\n
  4. @Delete: Used to configure a delete statement to map SQL statements to methods.<\/li>\n
  5. @Results: used to configure the mapping relationship of result sets, mapping the query results to Java objects.<\/li>\n
  6. @Result: Used to configure the mapping relationship of a single field, mapping the fields of the query result to properties of a Java object.<\/li>\n
  7. @Param: Used to give an alias to a parameter, which can be used to retrieve the parameter value in SQL statements.<\/li>\n
  8. @InsertProvider: Used to dynamically build insertion statements by generating the statement through a provider class.<\/li>\n
  9. @UpdateProvider: Used to dynamically build update statements by generating update statements through provider classes.<\/li>\n
  10. @DeleteProvider: Used for dynamically constructing delete statements by generating them through a provider class.<\/li>\n
  11. @Options: Used to configure additional settings, such as returning the primary key value after inserting data.<\/li>\n<\/ol>\n

    These annotations are used to configure SQL statements and their corresponding result mappings, making it easier for developers to write Mapper files and perform database operations. With these annotations, SQL statements can be directly mapped to Java methods, making the code more concise, readable, and maintainable.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Some commonly used MyBatis annotations include the following: @Select: Used for configuring query statements, mapping SQL queries to methods. @Insert: Used to configure an insert statement, mapping SQL statements to methods. @Update: Used for configuring update statements, mapping SQL statements to methods. @Delete: Used to configure a delete statement to map SQL statements to methods. […]<\/p>\n","protected":false},"author":7,"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":[18019,2797,1459,18018,3134],"class_list":["post-13507","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-select-annotation","tag-java-orm","tag-mybatis","tag-mybatis-annotations","tag-sql-mapping"],"yoast_head":"\nKey MyBatis Annotations Explained - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn essential MyBatis annotations: @Select, @Insert, @Update, @Delete, @Results. Master SQL-to-Java 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\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Key MyBatis Annotations Explained\" \/>\n<meta property=\"og:description\" content=\"Learn essential MyBatis annotations: @Select, @Insert, @Update, @Delete, @Results. Master SQL-to-Java mapping for efficient database operations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/\" \/>\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-15T07:17:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T19:26:11+00:00\" \/>\n<meta name=\"author\" content=\"Sophia Anderson\" \/>\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=\"Sophia Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"Key MyBatis Annotations Explained\",\"datePublished\":\"2024-03-15T07:17:24+00:00\",\"dateModified\":\"2025-08-05T19:26:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/\"},\"wordCount\":226,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"@Select annotation\",\"Java ORM\",\"MyBatis\",\"MyBatis annotations\",\"SQL mapping\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/\",\"name\":\"Key MyBatis Annotations Explained - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T07:17:24+00:00\",\"dateModified\":\"2025-08-05T19:26:11+00:00\",\"description\":\"Learn essential MyBatis annotations: @Select, @Insert, @Update, @Delete, @Results. Master SQL-to-Java mapping for efficient database operations.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Key MyBatis Annotations Explained\"}]},{\"@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\/19a24313de9c988db3d69226b4a40a30\",\"name\":\"Sophia Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"caption\":\"Sophia Anderson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Key MyBatis Annotations Explained - Blog - Silicon Cloud","description":"Learn essential MyBatis annotations: @Select, @Insert, @Update, @Delete, @Results. Master SQL-to-Java 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\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/","og_locale":"en_US","og_type":"article","og_title":"Key MyBatis Annotations Explained","og_description":"Learn essential MyBatis annotations: @Select, @Insert, @Update, @Delete, @Results. Master SQL-to-Java mapping for efficient database operations.","og_url":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T07:17:24+00:00","article_modified_time":"2025-08-05T19:26:11+00:00","author":"Sophia Anderson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Sophia Anderson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"Key MyBatis Annotations Explained","datePublished":"2024-03-15T07:17:24+00:00","dateModified":"2025-08-05T19:26:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/"},"wordCount":226,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["@Select annotation","Java ORM","MyBatis","MyBatis annotations","SQL mapping"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/","url":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/","name":"Key MyBatis Annotations Explained - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T07:17:24+00:00","dateModified":"2025-08-05T19:26:11+00:00","description":"Learn essential MyBatis annotations: @Select, @Insert, @Update, @Delete, @Results. Master SQL-to-Java mapping for efficient database operations.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-commonly-used-mybatis-annotations-and-their-purposes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Key MyBatis Annotations Explained"}]},{"@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\/19a24313de9c988db3d69226b4a40a30","name":"Sophia Anderson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","caption":"Sophia Anderson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13507","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\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=13507"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13507\/revisions"}],"predecessor-version":[{"id":157498,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13507\/revisions\/157498"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=13507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=13507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=13507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}