{"id":135278,"date":"2024-05-08T15:54:16","date_gmt":"2024-05-08T10:24:16","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=135278"},"modified":"2024-05-08T15:54:16","modified_gmt":"2024-05-08T10:24:16","slug":"how-to-retrieve-a-text-file-from-table-of-database-in-java-jdbc","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-a-text-file-from-table-of-database-in-java-jdbc\/","title":{"rendered":"How to Retrieve a Text File From Table of Database in 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 TestFileMain \r\n{\r\n    public static void main(String[] args) \r\n    {\r\n        try\r\n        {    \r\n           File F=new File(\"F:\/\/myfile\/myjdbc.txt\");\r\n           FileReader fr=new FileReader(F);\r\n          Class.forName(\"com.mysql.cj.jdbc.Driver\");\r\n           System.out.println(\"Driver load......\");\r\n           Connection con=null;\r\n           PreparedStatement ps=null;\r\n           con=DriverManager.getConnection(\"jdbc:mysql:\/dataflair\", \"root\", \"root@data\");\r\n            System.out.println(\"Database connect.....\");\r\n            String sql=\"insert into filedata values(?,?)\";\r\n            ps=con.prepareStatement(sql);\r\n            ps.setString(1, \"jdbcfile\");\r\n            ps.setCharacterStream(2, fr);\r\n            if(ps.executeUpdate()&gt;0)\r\n            System.out.println(\"File Save in table.......\");\r\n        }\r\n        catch(Exception e)\r\n        {\r\n            System.out.println(e);\r\n        }   \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 TestFileMain { public static void main(String[] args) { try { File F=new File(&#8220;F:\/\/myfile\/myjdbc.txt&#8221;); FileReader fr=new FileReader(F); Class.forName(&#8220;com.mysql.cj.jdbc.Driver&#8221;); System.out.println(&#8220;Driver load&#8230;&#8230;&#8221;); Connection con=null; PreparedStatement ps=null; con=DriverManager.getConnection(&#8220;jdbc:mysql:\/dataflair&#8221;,&#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,31896,31895,31875,31888,31897],"class_list":["post-135278","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-text-file-from-table-of-database","tag-how-to-retrieve-text-file-from-table-of-database-in-java-jdbc","tag-java-database-connectivity","tag-java-jdbc","tag-retrieve-text-file-from-table-of-database-in-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 a Text File From Table of Database in 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-a-text-file-from-table-of-database-in-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 a Text File From Table of Database in Java JDBC - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Program 1 package view; import java.io.*; import java.sql.*; public class TestFileMain { public static void main(String[] args) { try { File F=new File(&quot;F:\/\/myfile\/myjdbc.txt&quot;); FileReader fr=new FileReader(F); Class.forName(&quot;com.mysql.cj.jdbc.Driver&quot;); System.out.println(&quot;Driver load......&quot;); Connection con=null; PreparedStatement ps=null; con=DriverManager.getConnection(&quot;jdbc:mysql:\/dataflair&quot;,&#046;&#046;&#046;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/how-to-retrieve-a-text-file-from-table-of-database-in-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:24:16+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 a Text File From Table of Database in 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-a-text-file-from-table-of-database-in-java-jdbc\/","og_locale":"en_US","og_type":"article","og_title":"How to Retrieve a Text File From Table of Database in Java JDBC - DataFlair","og_description":"Program 1 package view; import java.io.*; import java.sql.*; public class TestFileMain { public static void main(String[] args) { try { File F=new File(\"F:\/\/myfile\/myjdbc.txt\"); FileReader fr=new FileReader(F); Class.forName(\"com.mysql.cj.jdbc.Driver\"); System.out.println(\"Driver load......\"); Connection con=null; PreparedStatement ps=null; con=DriverManager.getConnection(\"jdbc:mysql:\/dataflair\",&#46;&#46;&#46;","og_url":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-a-text-file-from-table-of-database-in-java-jdbc\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2024-05-08T10:24:16+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-a-text-file-from-table-of-database-in-java-jdbc\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-a-text-file-from-table-of-database-in-java-jdbc\/"},"author":{"name":"TechVidvan Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/0e594f928e31fc96628ac40f6ae74f49"},"headline":"How to Retrieve a Text File From Table of Database in Java JDBC","datePublished":"2024-05-08T10:24:16+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-a-text-file-from-table-of-database-in-java-jdbc\/"},"wordCount":15,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"keywords":["advanced java","advanced java practical","advanced java program","how to retrieve text file from table of database","how to retrieve text file from table of database in java jdbc","java database connectivity","java jdbc","retrieve text file from table of database in java jdbc"],"articleSection":["Advanced Java Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/how-to-retrieve-a-text-file-from-table-of-database-in-java-jdbc\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-a-text-file-from-table-of-database-in-java-jdbc\/","url":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-a-text-file-from-table-of-database-in-java-jdbc\/","name":"How to Retrieve a Text File From Table of Database in Java JDBC - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"datePublished":"2024-05-08T10:24:16+00:00","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-a-text-file-from-table-of-database-in-java-jdbc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/how-to-retrieve-a-text-file-from-table-of-database-in-java-jdbc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/how-to-retrieve-a-text-file-from-table-of-database-in-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 a Text File From Table of Database in 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\/135278","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=135278"}],"version-history":[{"count":4,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/135278\/revisions"}],"predecessor-version":[{"id":136956,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/135278\/revisions\/136956"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=135278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=135278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=135278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}