{"id":8574,"date":"2024-03-14T08:21:45","date_gmt":"2024-03-14T08:21:45","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/"},"modified":"2025-08-03T06:48:52","modified_gmt":"2025-08-03T06:48:52","slug":"how-to-establish-a-connection-between-java-and-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/","title":{"rendered":"Java MySQL Connection: JDBC Tutorial"},"content":{"rendered":"<p>In Java, connecting to MySQL is typically achieved using JDBC (Java Database Connectivity). Below is a simple example code:<\/p>\n<pre class=\"post-pre\"><code class=\"lang-java\">import java.sql.Connection;\r\nimport java.sql.DriverManager;\r\nimport java.sql.SQLException;\r\n\r\npublic class Main {\r\n    public static void main(String[] args) {\r\n        \/\/ JDBC\u8fde\u63a5URL\uff0c\u6570\u636e\u5e93\u540d\u4e3atest\r\n        String url = \"jdbc:mysql:\/\/localhost:3306\/test\";\r\n        \/\/ \u6570\u636e\u5e93\u7528\u6237\u540d\u548c\u5bc6\u7801\r\n        String username = \"root\";\r\n        String password = \"root\";\r\n\r\n        try {\r\n            \/\/ \u52a0\u8f7dMySQL\u9a71\u52a8\u7a0b\u5e8f\r\n            Class.forName(\"com.mysql.cj.jdbc.Driver\");\r\n            \/\/ \u5efa\u7acb\u4e0e\u6570\u636e\u5e93\u7684\u8fde\u63a5\r\n            Connection conn = DriverManager.getConnection(url, username, password);\r\n            \/\/ \u6267\u884cSQL\u67e5\u8be2\u7b49\u64cd\u4f5c\r\n            \/\/ ...\r\n\r\n            \/\/ \u5173\u95ed\u8fde\u63a5\r\n            conn.close();\r\n        } catch (ClassNotFoundException e) {\r\n            e.printStackTrace();\r\n        } catch (SQLException e) {\r\n            e.printStackTrace();\r\n        }\r\n    }\r\n}\r\n<\/code><\/pre>\n<p>In the example above, first load the MySQL driver, then establish a connection to the database using the DriverManager.getConnection method, where the URL is the connection URL, username is the database username, and password is the database password. You can then execute SQL queries and operations, and remember to close the connection when finished.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Java, connecting to MySQL is typically achieved using JDBC (Java Database Connectivity). Below is a simple example code: import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class Main { public static void main(String[] args) { \/\/ JDBC\u8fde\u63a5URL\uff0c\u6570\u636e\u5e93\u540d\u4e3atest String url = &#8220;jdbc:mysql:\/\/localhost:3306\/test&#8221;; \/\/ \u6570\u636e\u5e93\u7528\u6237\u540d\u548c\u5bc6\u7801 String username = &#8220;root&#8221;; String password = &#8220;root&#8221;; try { \/\/ \u52a0\u8f7dMySQL\u9a71\u52a8\u7a0b\u5e8f [&hellip;]<\/p>\n","protected":false},"author":9,"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":[1788,87,180,121,298],"class_list":["post-8574","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-connection","tag-java","tag-java-programming","tag-jdbc","tag-mysql"],"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>Java MySQL Connection: JDBC Tutorial - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to connect Java to MySQL using JDBC with step-by-step code examples and best practices.\" \/>\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-establish-a-connection-between-java-and-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Java MySQL Connection: JDBC Tutorial\" \/>\n<meta property=\"og:description\" content=\"Learn how to connect Java to MySQL using JDBC with step-by-step code examples and best practices.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/\" \/>\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-14T08:21:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-03T06:48:52+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\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=\"Ava Mitchell\" \/>\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-establish-a-connection-between-java-and-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"Java MySQL Connection: JDBC Tutorial\",\"datePublished\":\"2024-03-14T08:21:45+00:00\",\"dateModified\":\"2025-08-03T06:48:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/\"},\"wordCount\":79,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Database Connection\",\"Java\",\"Java programming\",\"JDBC\",\"MySQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/\",\"name\":\"Java MySQL Connection: JDBC Tutorial - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T08:21:45+00:00\",\"dateModified\":\"2025-08-03T06:48:52+00:00\",\"description\":\"Learn how to connect Java to MySQL using JDBC with step-by-step code examples and best practices.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java MySQL Connection: JDBC Tutorial\"}]},{\"@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\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Java MySQL Connection: JDBC Tutorial - Blog - Silicon Cloud","description":"Learn how to connect Java to MySQL using JDBC with step-by-step code examples and best practices.","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-establish-a-connection-between-java-and-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Java MySQL Connection: JDBC Tutorial","og_description":"Learn how to connect Java to MySQL using JDBC with step-by-step code examples and best practices.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T08:21:45+00:00","article_modified_time":"2025-08-03T06:48:52+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"Java MySQL Connection: JDBC Tutorial","datePublished":"2024-03-14T08:21:45+00:00","dateModified":"2025-08-03T06:48:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/"},"wordCount":79,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Database Connection","Java","Java programming","JDBC","MySQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/","name":"Java MySQL Connection: JDBC Tutorial - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T08:21:45+00:00","dateModified":"2025-08-03T06:48:52+00:00","description":"Learn how to connect Java to MySQL using JDBC with step-by-step code examples and best practices.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-establish-a-connection-between-java-and-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Java MySQL Connection: JDBC Tutorial"}]},{"@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\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8574","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=8574"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8574\/revisions"}],"predecessor-version":[{"id":153394,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8574\/revisions\/153394"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=8574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=8574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=8574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}