{"id":11259,"date":"2024-03-14T13:41:35","date_gmt":"2024-03-14T13:41:35","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/"},"modified":"2025-08-04T09:32:27","modified_gmt":"2025-08-04T09:32:27","slug":"how-to-modify-a-stored-procedure-in-mybatis","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/","title":{"rendered":"Modify Stored Procedures in MyBatis"},"content":{"rendered":"<p>To modify a stored procedure, you first need to locate its definition and then make changes to it. In MyBatis, you can use SQL queries to call stored procedures, and modify them by calling them in this way.<\/p>\n<p>Here is a sample code demonstrating how to use MyBatis to call a stored procedure and modify it.<\/p>\n<ol>\n<li>Create an interface and mapping file for a stored procedure.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">interface<\/span> <span class=\"hljs-title class_\">MyProcedureMapper<\/span> {\r\n    <span class=\"hljs-keyword\">void<\/span> <span class=\"hljs-title function_\">callMyProcedure<\/span><span class=\"hljs-params\">(Map&lt;String, Object&gt; parameters)<\/span>;\r\n}\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"hljs-meta\">&lt;?xml version=<span class=\"hljs-string\">\"1.0\"<\/span> encoding=<span class=\"hljs-string\">\"UTF-8\"<\/span> ?&gt;<\/span>\r\n<span class=\"hljs-meta\">&lt;!DOCTYPE <span class=\"hljs-keyword\">mapper<\/span>\r\n        <span class=\"hljs-keyword\">PUBLIC<\/span> <span class=\"hljs-string\">\"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"<\/span>\r\n        <span class=\"hljs-string\">\"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\"<\/span>&gt;<\/span>\r\n<span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">mapper<\/span> <span class=\"hljs-attr\">namespace<\/span>=<span class=\"hljs-string\">\"com.example.MyProcedureMapper\"<\/span>&gt;<\/span>\r\n    <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">select<\/span> <span class=\"hljs-attr\">id<\/span>=<span class=\"hljs-string\">\"callMyProcedure\"<\/span> <span class=\"hljs-attr\">statementType<\/span>=<span class=\"hljs-string\">\"CALLABLE\"<\/span>&gt;<\/span>\r\n        { call my_procedure(#{param1, mode=IN, jdbcType=INTEGER}, #{param2, mode=IN, jdbcType=VARCHAR}, #{outParam, mode=OUT, jdbcType=INTEGER}) }\r\n    <span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">select<\/span>&gt;<\/span>\r\n<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">mapper<\/span>&gt;<\/span>\r\n<\/code><\/pre>\n<ol>\n<li>Write Java code to call a stored procedure.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-type\">SqlSession<\/span> <span class=\"hljs-variable\">sqlSession<\/span> <span class=\"hljs-operator\">=<\/span> sqlSessionFactory.openSession();\r\n<span class=\"hljs-type\">MyProcedureMapper<\/span> <span class=\"hljs-variable\">myProcedureMapper<\/span> <span class=\"hljs-operator\">=<\/span> sqlSession.getMapper(MyProcedureMapper.class);\r\n\r\nMap&lt;String, Object&gt; parameters = <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-title class_\">HashMap<\/span>&lt;&gt;();\r\nparameters.put(<span class=\"hljs-string\">\"param1\"<\/span>, <span class=\"hljs-number\">123<\/span>);\r\nparameters.put(<span class=\"hljs-string\">\"param2\"<\/span>, <span class=\"hljs-string\">\"abc\"<\/span>);\r\nparameters.put(<span class=\"hljs-string\">\"outParam\"<\/span>, <span class=\"hljs-literal\">null<\/span>);\r\n\r\nmyProcedureMapper.callMyProcedure(parameters);\r\n\r\n<span class=\"hljs-type\">Integer<\/span> <span class=\"hljs-variable\">outParamValue<\/span> <span class=\"hljs-operator\">=<\/span> (Integer) parameters.get(<span class=\"hljs-string\">\"outParam\"<\/span>);\r\nSystem.out.println(<span class=\"hljs-string\">\"Output parameter value: \"<\/span> + outParamValue);\r\n\r\nsqlSession.close();\r\n<\/code><\/pre>\n<p>In this example, we defined a stored procedure called my_procedure and then accessed and modified it using MyBatis. It is important to note that the process of updating a stored procedure may vary, and adjustments should be made according to the definition of the stored procedure and specific requirements.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To modify a stored procedure, you first need to locate its definition and then make changes to it. In MyBatis, you can use SQL queries to call stored procedures, and modify them by calling them in this way. Here is a sample code demonstrating how to use MyBatis to call a stored procedure and modify [&hellip;]<\/p>\n","protected":false},"author":12,"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":[90,87,1459,125,607],"class_list":["post-11259","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-programming","tag-java","tag-mybatis","tag-sql","tag-stored-procedure"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Modify Stored Procedures in MyBatis - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Step-by-step guide to modify stored procedures in MyBatis with code examples for mapper interfaces and XML.\" \/>\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-to-modify-a-stored-procedure-in-mybatis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Modify Stored Procedures in MyBatis\" \/>\n<meta property=\"og:description\" content=\"Step-by-step guide to modify stored procedures in MyBatis with code examples for mapper interfaces and XML.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-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-14T13:41:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T09:32:27+00:00\" \/>\n<meta name=\"author\" content=\"Liam\" \/>\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=\"Liam\" \/>\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\/how-to-modify-a-stored-procedure-in-mybatis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"Modify Stored Procedures in MyBatis\",\"datePublished\":\"2024-03-14T13:41:35+00:00\",\"dateModified\":\"2025-08-04T09:32:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/\"},\"wordCount\":129,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database programming\",\"Java\",\"MyBatis\",\"SQL\",\"Stored Procedure\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/\",\"name\":\"Modify Stored Procedures in MyBatis - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T13:41:35+00:00\",\"dateModified\":\"2025-08-04T09:32:27+00:00\",\"description\":\"Step-by-step guide to modify stored procedures in MyBatis with code examples for mapper interfaces and XML.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Modify Stored Procedures in MyBatis\"}]},{\"@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\/23786905eb7b377f45ddb01c17da7671\",\"name\":\"Liam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"caption\":\"Liam\"},\"sameAs\":[\"http:\/\/Wilson\"],\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Modify Stored Procedures in MyBatis - Blog - Silicon Cloud","description":"Step-by-step guide to modify stored procedures in MyBatis with code examples for mapper interfaces and XML.","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-to-modify-a-stored-procedure-in-mybatis\/","og_locale":"en_US","og_type":"article","og_title":"Modify Stored Procedures in MyBatis","og_description":"Step-by-step guide to modify stored procedures in MyBatis with code examples for mapper interfaces and XML.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T13:41:35+00:00","article_modified_time":"2025-08-04T09:32:27+00:00","author":"Liam","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Liam","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"Modify Stored Procedures in MyBatis","datePublished":"2024-03-14T13:41:35+00:00","dateModified":"2025-08-04T09:32:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/"},"wordCount":129,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database programming","Java","MyBatis","SQL","Stored Procedure"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/","name":"Modify Stored Procedures in MyBatis - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T13:41:35+00:00","dateModified":"2025-08-04T09:32:27+00:00","description":"Step-by-step guide to modify stored procedures in MyBatis with code examples for mapper interfaces and XML.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-modify-a-stored-procedure-in-mybatis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Modify Stored Procedures in MyBatis"}]},{"@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\/23786905eb7b377f45ddb01c17da7671","name":"Liam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","caption":"Liam"},"sameAs":["http:\/\/Wilson"],"url":"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11259","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\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=11259"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11259\/revisions"}],"predecessor-version":[{"id":155031,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11259\/revisions\/155031"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=11259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=11259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=11259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}