{"id":135272,"date":"2024-05-08T15:46:13","date_gmt":"2024-05-08T10:16:13","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=135272"},"modified":"2024-05-08T15:46:13","modified_gmt":"2024-05-08T10:16:13","slug":"how-to-retrieve-an-image-from-database-using-java-jdbc","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/","title":{"rendered":"How to Retrieve an Image From Database using Java JDBC"},"content":{"rendered":"<h3>Program 1<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">package view;\r\nimport java.io.*;\r\nimport java.sql.*;\r\npublic class TestImage1 \r\n{\r\n    public static void main(String[] args) \r\n    {\r\n     try\r\n     {     \r\n       File F=new File(\"F:\/\/myimages\/newdog.jpg\");    \r\n       FileOutputStream fos=new FileOutputStream(F);\r\n       Connection con=null;\r\n       PreparedStatement ps=null;\r\n       ResultSet rs=null;\r\n        Class.forName(\"com.mysql.cj.jdbc.Driver\");\r\n        System.out.println(\"Driver load....\");\r\n        con=DriverManager.getConnection(\"jdbc:mysql:\/dataflair\", \"root\", \"root@data\");\r\n        System.out.println(\"Database connected....\");\r\n        String sql;\r\n        sql=\"select * from imagedata where img_name='dog'\";\r\n        ps=con.prepareStatement(sql);\r\n        rs=ps.executeQuery();\r\n        if(rs.next())\r\n        {\r\n             byte b[];\r\n            System.out.println(\"Iamge Name: \"+rs.getString(1));\r\n            b=rs.getBytes(2);\r\n            fos.write(b);\r\n            System.out.println(\"Image retrive......\");\r\n        }\r\n        else\r\n             System.out.println(\"Image not found......\");\r\n        \r\n     }\r\n     catch(Exception e)\r\n     {\r\n         System.out.println(e);\r\n     }   \r\n    }\r\n    \r\n}<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Program 1 package view; import java.io.*; import java.sql.*; public class TestImage1 { public static void main(String[] args) { try { File F=new File(&#8220;F:\/\/myimages\/newdog.jpg&#8221;); FileOutputStream fos=new FileOutputStream(F); Connection con=null; PreparedStatement ps=null; ResultSet rs=null; Class.forName(&#8220;com.mysql.cj.jdbc.Driver&#8221;); System.out.println(&#8220;Driver&#46;&#46;&#46;<\/p>\n","protected":false},"author":86671,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31448],"tags":[31873,31871,31872,31889,31887,31875,31888,31890],"class_list":["post-135272","post","type-post","status-publish","format-standard","hentry","category-advanced-java-tutorials","tag-advanced-java","tag-advanced-java-practical","tag-advanced-java-program","tag-how-to-retrieve-an-image-from-database","tag-how-to-retrieve-an-image-from-database-using-java-jdbc","tag-java-database-connectivity","tag-java-jdbc","tag-retrieve-an-image-from-database-using-java-jdbc"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Retrieve an Image From Database using Java JDBC - DataFlair<\/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:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Retrieve an Image From Database using Java JDBC - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Program 1 package view; import java.io.*; import java.sql.*; public class TestImage1 { public static void main(String[] args) { try { File F=new File(&quot;F:\/\/myimages\/newdog.jpg&quot;); FileOutputStream fos=new FileOutputStream(F); Connection con=null; PreparedStatement ps=null; ResultSet rs=null; Class.forName(&quot;com.mysql.cj.jdbc.Driver&quot;); System.out.println(&quot;Driver&#046;&#046;&#046;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-08T10:16:13+00:00\" \/>\n<meta name=\"author\" content=\"TechVidvan Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TechVidvan Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Retrieve an Image From Database using Java JDBC - DataFlair","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:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/","og_locale":"en_US","og_type":"article","og_title":"How to Retrieve an Image From Database using Java JDBC - DataFlair","og_description":"Program 1 package view; import java.io.*; import java.sql.*; public class TestImage1 { public static void main(String[] args) { try { File F=new File(\"F:\/\/myimages\/newdog.jpg\"); FileOutputStream fos=new FileOutputStream(F); Connection con=null; PreparedStatement ps=null; ResultSet rs=null; Class.forName(\"com.mysql.cj.jdbc.Driver\"); System.out.println(\"Driver&#46;&#46;&#46;","og_url":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2024-05-08T10:16:13+00:00","author":"TechVidvan Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"TechVidvan Team","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/"},"author":{"name":"TechVidvan Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/0e594f928e31fc96628ac40f6ae74f49"},"headline":"How to Retrieve an Image From Database using Java JDBC","datePublished":"2024-05-08T10:16:13+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/"},"wordCount":12,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"keywords":["advanced java","advanced java practical","advanced java program","how to retrieve an image from database","how to retrieve an image from database using java jdbc","java database connectivity","java jdbc","retrieve an image from database using java jdbc"],"articleSection":["Advanced Java Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/","url":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/","name":"How to Retrieve an Image From Database using Java JDBC - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"datePublished":"2024-05-08T10:16:13+00:00","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-an-image-from-database-using-java-jdbc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Advanced Java Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/advanced-java-tutorials\/"},{"@type":"ListItem","position":3,"name":"How to Retrieve an Image From Database using Java JDBC"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/0e594f928e31fc96628ac40f6ae74f49","name":"TechVidvan Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c89190da3d4010c71ba476b618ab10fdc2335c82cdfa0ad5002d98d0f2473444?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c89190da3d4010c71ba476b618ab10fdc2335c82cdfa0ad5002d98d0f2473444?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c89190da3d4010c71ba476b618ab10fdc2335c82cdfa0ad5002d98d0f2473444?s=96&d=mm&r=g","caption":"TechVidvan Team"},"description":"TechVidvan Team provides high-quality content &amp; courses on AI, ML, Data Science, Data Engineering, Data Analytics, programming, Python, DSA, Android, Flutter, full stack web dev, MERN, and many latest technology.","url":"https:\/\/data-flair.training\/blogs\/author\/test001\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/135272","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/86671"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=135272"}],"version-history":[{"count":4,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/135272\/revisions"}],"predecessor-version":[{"id":136952,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/135272\/revisions\/136952"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=135272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=135272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=135272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}