{"id":10106,"date":"2015-08-02T03:42:56","date_gmt":"2015-08-02T07:42:56","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=10106"},"modified":"2015-08-04T10:20:54","modified_gmt":"2015-08-04T14:20:54","slug":"fruittest-java-a-class-that-connects-to-either-an-oracle-or-a-sybase-database-and-prints-out-the-values-of-predetermined-columns-in-the-fruits-table","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=10106","title":{"rendered":"FruitTest.java: A class that connects to either an Oracle or a Sybase database and prints out the values of predetermined columns in the &#8220;fruits&#8221; table."},"content":{"rendered":"<pre># FruitTest.java\u00a0 A class that connects to either an Oracle or a Sybase database and prints \r\n  out the values of predetermined columns in the \"fruits\" table. \r\n\r\npackage cwp;\r\n\r\nimport java.sql.*;\r\n\r\n\/** A JDBC example that connects to either an Oracle or\r\n\u00a0*\u00a0 a Sybase database and prints out the values of\r\n\u00a0*\u00a0 predetermined columns in the \"fruits\" table.\r\n\u00a0* \u00a0\r\n\r\n\r\n\u00a0*\/\r\n\r\npublic class FruitTest {\r\n\r\n\u00a0 \/** Reads the hostname, database name, username, password,\r\n\u00a0\u00a0 *\u00a0 and vendor identifier from the command line. It\r\n\u00a0\u00a0 *\u00a0 uses the vendor identifier to determine which\r\n\u00a0\u00a0 *\u00a0 driver to load and how to format the URL. The\r\n\u00a0\u00a0 *\u00a0 driver, URL, username, host, and password are then\r\n\u00a0\u00a0 *\u00a0 passed to the showFruitTable method.\r\n\u00a0\u00a0 *\/\r\n\u00a0 \r\n\u00a0 public static void main(String[] args) {\r\n\u00a0\u00a0\u00a0 if (args.length &lt; 5) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 printUsage();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 return;\r\n\u00a0\u00a0\u00a0 }\r\n\u00a0\u00a0\u00a0 String vendorName = args[4];\r\n\u00a0\u00a0\u00a0 int vendor = DriverUtilities.getVendor(vendorName);\r\n\u00a0\u00a0\u00a0 if (vendor == DriverUtilities.UNKNOWN) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 printUsage();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 return;\r\n\u00a0\u00a0\u00a0 }\r\n\u00a0\u00a0\u00a0 String driver = DriverUtilities.getDriver(vendor);\r\n\u00a0\u00a0\u00a0 String host = args[0];\r\n\u00a0\u00a0\u00a0 String dbName = args[1];\r\n\u00a0\u00a0\u00a0 String url = DriverUtilities.makeURL(host, dbName, vendor);\r\n\u00a0\u00a0\u00a0 String username = args[2];\r\n\u00a0\u00a0\u00a0 String password = args[3];\r\n\u00a0\u00a0\u00a0 showFruitTable(driver, url, username, password);\r\n\u00a0 }\r\n\r\n\u00a0 \/** Get the table and print all the values. *\/\r\n\u00a0 \r\n\u00a0 public static void showFruitTable(String driver,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String url,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String username,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String password) {\r\n\u00a0\u00a0\u00a0 try {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ Load database driver if not already loaded\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 Class.forName(driver);\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ Establish network connection to database\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 Connection connection =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DriverManager.getConnection(url, username, password);\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ Look up info about the database as a whole.\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 DatabaseMetaData dbMetaData = connection.getMetaData();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 String productName =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dbMetaData.getDatabaseProductName();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 System.out.println(\"Database: \" + productName);\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 String productVersion =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dbMetaData.getDatabaseProductVersion();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 System.out.println(\"Version: \" + productVersion + \"\\n\");\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 System.out.println(\"Comparing Apples and Oranges\\n\" +\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \"============================\");\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 Statement statement = connection.createStatement();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 String query = \"SELECT * FROM fruits\";\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ Send query to database and store results\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 ResultSet resultSet = statement.executeQuery(query);\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ Look up information about a particular table\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 ResultSetMetaData resultsMetaData =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 resultSet.getMetaData();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 int columnCount = resultsMetaData.getColumnCount();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ Column index starts at 1 (ala SQL) not 0 (ala Java).\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 for(int i=1; i<\/pre>\n","protected":false},"excerpt":{"rendered":"<p># FruitTest.java\u00a0 A class that connects to either an Oracle or a Sybase database and prints out the values of predetermined columns in the &#8220;fruits&#8221; table. package cwp; import java.sql.*; \/** A JDBC example that connects to either an Oracle or \u00a0*\u00a0 a Sybase database and prints out the values of \u00a0*\u00a0 predetermined columns in &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=10106\">Continue reading<\/a><\/p>\n","protected":false},"author":130,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1417,1424],"tags":[706,308,1448,1447,732,859],"class_list":["post-10106","post","type-post","status-publish","format-standard","hentry","category-code-programming-samples--","category-javaj2eej2me","tag-code","tag-java","tag-sybase","tag-1447","tag-732","tag-859","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":26822,"url":"http:\/\/bangla.sitestree.com\/?p=26822","url_meta":{"origin":10106,"position":0},"title":"FruitTest.java:  A class that connects to either an Oracle or a Sybase database and prints out the values of predetermined columns in the &quot;fruits&quot; table. #Programming Code Examples #Java\/J2EE\/J2ME #JDBC","author":"Author-Check- Article-or-Video","date":"May 2, 2021","format":false,"excerpt":"# FruitTest.java A class that connects to either an Oracle or a Sybase database and prints out the values of predetermined columns in the \"fruits\" table. package cwp; import java.sql.*; \/** A JDBC example that connects to either an Oracle or * a Sybase database and prints out the values\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10110,"url":"http:\/\/bangla.sitestree.com\/?p=10110","url_meta":{"origin":10106,"position":1},"title":"FruitCreation.java: Creates a simple table named fruits in either an Oracle or a Sybase database.","author":"","date":"August 3, 2015","format":false,"excerpt":"FruitCreation.java Creates a simple table named fruits in either an Oracle or a Sybase database. package cwp; import java.sql.*; \/** Creates a simple table named \"fruits\" in either \u00a0*\u00a0 an Oracle or a Sybase database. \u00a0* \u00a0 \u00a0*\/ public class FruitCreation { \u00a0 public static void main(String[] args) { \u00a0\u00a0\u00a0\u2026","rel":"","context":"In &quot;Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8&quot;","block_context":{"text":"Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8","link":"http:\/\/bangla.sitestree.com\/?cat=1417"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26826,"url":"http:\/\/bangla.sitestree.com\/?p=26826","url_meta":{"origin":10106,"position":2},"title":"FruitCreation.java:  Creates a simple table named fruits in either an Oracle or a Sybase database. #Programming Code Examples #Java\/J2EE\/J2ME #JDBC","author":"Author-Check- Article-or-Video","date":"May 2, 2021","format":false,"excerpt":"FruitCreation.java Creates a simple table named fruits in either an Oracle or a Sybase database. ************************************** package cwp; import java.sql.*; \/** Creates a simple table named \"fruits\" in either * an Oracle or a Sybase database. * *\/ public class FruitCreation { public static void main(String[] args) { if (args.length\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10118,"url":"http:\/\/bangla.sitestree.com\/?p=10118","url_meta":{"origin":10106,"position":3},"title":"EmployeeTest.java: A test case for the database utilities. Prints results in plain text.","author":"","date":"August 4, 2015","format":false,"excerpt":"package cwp; import java.sql.*; \/** Connect to Oracle or Sybase and print \"employees\" table. \u00a0* \u00a0 \u00a0*\/ public class EmployeeTest { \u00a0 public static void main(String[] args) { \u00a0\u00a0\u00a0 if (args.length < 5) { \u00a0\u00a0\u00a0\u00a0\u00a0 printUsage(); \u00a0\u00a0\u00a0\u00a0\u00a0 return; \u00a0\u00a0\u00a0 } \u00a0\u00a0\u00a0 String vendorName = args[4]; \u00a0\u00a0\u00a0 int vendor = DriverUtilities.getVendor(vendorName);\u2026","rel":"","context":"In &quot;Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8&quot;","block_context":{"text":"Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8","link":"http:\/\/bangla.sitestree.com\/?cat=1417"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10120,"url":"http:\/\/bangla.sitestree.com\/?p=10120","url_meta":{"origin":10106,"position":4},"title":"EmployeeTest2.java: A test case for the database utilities. Prints results formatted as an HTML table.","author":"","date":"August 5, 2015","format":false,"excerpt":"package cwp; import java.sql.*; \/** Connect to Oracle or Sybase and print \"employees\" table \u00a0*\u00a0 as an HTML table. \u00a0* \u00a0 \u00a0*\/ public class EmployeeTest2 { \u00a0 public static void main(String[] args) { \u00a0\u00a0\u00a0 if (args.length < 5) { \u00a0\u00a0\u00a0\u00a0\u00a0 printUsage(); \u00a0\u00a0\u00a0\u00a0\u00a0 return; \u00a0\u00a0\u00a0 } \u00a0\u00a0\u00a0 String vendorName = args[4];\u2026","rel":"","context":"In &quot;Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8&quot;","block_context":{"text":"Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8","link":"http:\/\/bangla.sitestree.com\/?cat=1417"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26846,"url":"http:\/\/bangla.sitestree.com\/?p=26846","url_meta":{"origin":10106,"position":5},"title":"EmployeeTest2.java:  A test case for the database utilities. Prints results formatted as an HTML table. #Programming Code Examples #Java\/J2EE\/J2ME #JDBC","author":"Author-Check- Article-or-Video","date":"May 3, 2021","format":false,"excerpt":"package cwp; import java.sql.*; \/** Connect to Oracle or Sybase and print \"employees\" table * as an HTML table. * *\/ public class EmployeeTest2 { public static void main(String[] args) { if (args.length < 5) { printUsage(); return; } String vendorName = args[4]; int vendor = DriverUtilities.getVendor(vendorName); if (vendor ==\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/10106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/130"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10106"}],"version-history":[{"count":5,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/10106\/revisions"}],"predecessor-version":[{"id":10625,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/10106\/revisions\/10625"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10106"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}