{"id":28415,"date":"2024-03-16T10:17:01","date_gmt":"2024-03-16T10:17:01","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/"},"modified":"2024-03-22T13:24:14","modified_gmt":"2024-03-22T13:24:14","slug":"what-is-the-method-of-connecting-to-the-database-in-mybatis","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/","title":{"rendered":"What is the method of connecting to the database in MyBatis?"},"content":{"rendered":"<p>MyBatis is a persistence framework that offers various methods for connecting to a database. Here are common ways to connect to a database using MyBatis:<\/p>\n<p>XML configuration file: In MyBatis&#8217;s XML configuration file, you can set up data source and connection information. This includes the database URL, username, password, and more. By configuring this file, MyBatis will connect to the designated database based on your settings.<\/p>\n<pre class=\"post-pre\"><!--&nbsp;\u6570\u636e\u5e93\u8fde\u63a5\u914d\u7f6e&nbsp;-->\r\n<configuration>\r\n&nbsp;&nbsp;<environments&nbsp;default=\"development\">\r\n&nbsp;&nbsp;&nbsp;&nbsp;<environment&nbsp;id=\"development\">\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<transactionmanager&nbsp;type=\"jdbc\">\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<datasource&nbsp;type=\"pooled\">\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<property&nbsp;name=\"driver\"&nbsp;value=\"com.mysql.jdbc.driver\">\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<property&nbsp;name=\"url\"&nbsp;value=\"jdbc:mysql: localhost:3306=\"\" mydatabase\"=\"\">\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<property&nbsp;name=\"username\"&nbsp;value=\"root\">\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<property&nbsp;name=\"password\"&nbsp;value=\"password\">\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;\r\n<\/property&nbsp;name=\"password\"&nbsp;value=\"password\"><\/property&nbsp;name=\"username\"&nbsp;value=\"root\"><\/property&nbsp;name=\"url\"&nbsp;value=\"jdbc:mysql:><\/property&nbsp;name=\"driver\"&nbsp;value=\"com.mysql.jdbc.driver\"><\/datasource&nbsp;type=\"pooled\"><\/transactionmanager&nbsp;type=\"jdbc\"><\/environment&nbsp;id=\"development\"><\/environments&nbsp;default=\"development\"><\/configuration><\/pre>\n<p>2. Annotation approach: In addition to XML configuration files, MyBatis also supports connecting to databases using annotations. By adding relevant annotations to Java objects or methods, you can specify database connection information.<\/p>\n<pre class=\"post-pre\">\/\/&nbsp;\u4f7f\u7528\u6ce8\u89e3\u65b9\u5f0f\u914d\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\r\n@Mapper\r\npublic&nbsp;interface&nbsp;UserMapper&nbsp;{\r\n&nbsp;&nbsp;@Select(\"SELECT&nbsp;*&nbsp;FROM&nbsp;users&nbsp;WHERE&nbsp;id&nbsp;=&nbsp;#{id}\")\r\n&nbsp;&nbsp;User&nbsp;getUserById(int&nbsp;id);\r\n}<\/pre>\n<p>3. Programmatic API: MyBatis also offers a programmatic API, which allows you to directly create and configure database connections in your code. By utilizing the `SqlSessionFactoryBuilder` and `SqlSessionFactory` classes, you can manually establish database connections.<\/p>\n<pre class=\"post-pre\">\/\/&nbsp;\u4f7f\u7528\u7f16\u7a0b\u5f0f&nbsp;API&nbsp;\u914d\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\r\nString&nbsp;resource&nbsp;=&nbsp;\"mybatis-config.xml\";\r\nInputStream&nbsp;inputStream&nbsp;=&nbsp;Resources.getResourceAsStream(resource);\r\nSqlSessionFactory&nbsp;sqlSessionFactory&nbsp;=&nbsp;new&nbsp;SqlSessionFactoryBuilder().build(inputStream);<\/pre>\n<p>Here are three common methods for connecting to a database using MyBatis. You can choose one or more of these methods based on your own needs for connecting and manipulating the database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MyBatis is a persistence framework that offers various methods for connecting to a database. Here are common ways to connect to a database using MyBatis: XML configuration file: In MyBatis&#8217;s XML configuration file, you can set up data source and connection information. This includes the database URL, username, password, and more. By configuring this file, [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-28415","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"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>What is the method of connecting to the database in MyBatis? - Blog - Silicon Cloud<\/title>\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-is-the-method-of-connecting-to-the-database-in-mybatis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is the method of connecting to the database in MyBatis?\" \/>\n<meta property=\"og:description\" content=\"MyBatis is a persistence framework that offers various methods for connecting to a database. Here are common ways to connect to a database using MyBatis: XML configuration file: In MyBatis&#8217;s XML configuration file, you can set up data source and connection information. This includes the database URL, username, password, and more. By configuring this file, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-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-16T10:17:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T13:24:14+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-is-the-method-of-connecting-to-the-database-in-mybatis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"What is the method of connecting to the database in MyBatis?\",\"datePublished\":\"2024-03-16T10:17:01+00:00\",\"dateModified\":\"2024-03-22T13:24:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/\"},\"wordCount\":175,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/\",\"name\":\"What is the method of connecting to the database in MyBatis? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T10:17:01+00:00\",\"dateModified\":\"2024-03-22T13:24:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is the method of connecting to the database 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\/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":"What is the method of connecting to the database in MyBatis? - Blog - Silicon Cloud","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-is-the-method-of-connecting-to-the-database-in-mybatis\/","og_locale":"en_US","og_type":"article","og_title":"What is the method of connecting to the database in MyBatis?","og_description":"MyBatis is a persistence framework that offers various methods for connecting to a database. Here are common ways to connect to a database using MyBatis: XML configuration file: In MyBatis&#8217;s XML configuration file, you can set up data source and connection information. This includes the database URL, username, password, and more. By configuring this file, [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T10:17:01+00:00","article_modified_time":"2024-03-22T13:24:14+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-is-the-method-of-connecting-to-the-database-in-mybatis\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"What is the method of connecting to the database in MyBatis?","datePublished":"2024-03-16T10:17:01+00:00","dateModified":"2024-03-22T13:24:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/"},"wordCount":175,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/","url":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/","name":"What is the method of connecting to the database in MyBatis? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T10:17:01+00:00","dateModified":"2024-03-22T13:24:14+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-of-connecting-to-the-database-in-mybatis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What is the method of connecting to the database 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\/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\/28415","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=28415"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/28415\/revisions"}],"predecessor-version":[{"id":62713,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/28415\/revisions\/62713"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=28415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=28415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=28415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}