{"id":540,"date":"2014-09-12T09:38:49","date_gmt":"2014-09-12T09:38:49","guid":{"rendered":"http:\/\/codethataint.com\/blog\/?p=540"},"modified":"2014-09-12T09:38:49","modified_gmt":"2014-09-12T09:38:49","slug":"how-to-test-decimal-value-for-db-junit","status":"publish","type":"post","link":"https:\/\/codethataint.com\/blog\/how-to-test-decimal-value-for-db-junit\/","title":{"rendered":"How to Test Decimal Value for DB JUnit"},"content":{"rendered":"<p><strong>DBUtilsTest.java<\/strong><\/p>\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\r\npublic class DBUtilsTest\r\n{\t\r\n\tpublic void getDBRecordsSQLTest()\r\n\t{\t\r\n\t\tDBUtils objDBUtils \t = new DBUtils();\r\n\t\tResultSet resultSet  = objDBUtils.getDBRecordsSQL(&quot;SELECT 78985450.1245487986418648 decimal_val FROM dual&quot;);\r\n\t\t\r\n\t\tdouble expectedValue   = 1245.654618764;\r\n\t\tdouble dbValue \t \t   = 0; \r\n\t\tdouble toleranceLimit  = 0.000000001;\r\n\t\t\r\n\t\ttry\r\n\t\t{\r\n\t\t\t while(resultSet.next())\r\n\t\t\t {\r\n\t\t\t\tdbValue =  resultSet.getDouble(&quot;decimal_val&quot;);\r\n\t\t\t\tassertEquals(expectedValue, dbValue, toleranceLimit);\r\n\t\t\t }\r\n\t\t} catch (SQLException e)\r\n\t\t{\r\n\t\t\te.printStackTrace();\r\n\t\t}\r\n\t\t\r\n\t\tobjDBUtils.closeConnection();\r\n\t}\r\n\t\r\n\t@Test\r\n\tpublic void getDBRecordsProcTest()\r\n\t{\t\r\n\t\tDBUtils objDBUtils \t = new DBUtils();\r\n\t\tResultSet resultSet  = objDBUtils.getDBRecordsProc(&quot;{call TESTJUNIT.junitproc(?)}&quot;);\r\n\t\t\r\n\t\tdouble expectedValue   = 7.89854501245488E7;\r\n\t\tdouble dbValue \t \t   = 0; \r\n\t\tdouble toleranceLimit  = 0.000000001;\r\n\t\t\r\n\t\ttry\r\n\t\t{\r\n\t\t\t while(resultSet.next())\r\n\t\t\t {\r\n\t\t\t\tdbValue =  (double) resultSet.getDouble(1);\t\t\t\t\r\n\t\t\t\tassertEquals(expectedValue, dbValue, toleranceLimit);\r\n\t\t\t }\r\n\t\t} catch (SQLException e)\r\n\t\t{\r\n\t\t\te.printStackTrace();\r\n\t\t}\r\n\t\t\r\n\t\tobjDBUtils.closeConnection();\r\n\t}\r\n}\r\n<\/pre>\n<p><strong>DBUtils.java<\/strong><\/p>\n<pre class=\"brush: java; title: ; notranslate\" title=\"\">\r\nimport java.sql.CallableStatement;\r\nimport java.sql.Connection;\r\nimport java.sql.DriverManager;\r\nimport java.sql.ResultSet;\r\nimport java.sql.SQLException;\r\nimport java.sql.Statement;\r\n\r\nimport oracle.jdbc.OracleTypes;\r\n\r\npublic class DBUtils\r\n{\r\n\tConnection  conn  = null;\r\n    Statement \tstmt  = null;\r\n    ResultSet   rs    = null;\r\n\t\r\n\tpublic ResultSet getDBRecordsSQL(String pQuery)\r\n\t{    \r\n\t    try\r\n\t    {\r\n\t    \tconn = DriverManager.getConnection(&quot;hostname&quot;, &quot;admin&quot;, &quot;admin123&quot;);\r\n\t        stmt = (Statement)conn.createStatement();\r\n\t        rs \t = stmt.executeQuery(pQuery);\r\n\t     \t\r\n\t    } catch (SQLException e)\r\n\t\t{\r\n\t\t\te.printStackTrace();\r\n\t\t}\r\n\t    \r\n\t\treturn rs;\r\n\t}\r\n\t\r\n\tpublic ResultSet getDBRecordsProc(String pQuery)\r\n\t{\t\r\n\t\tCallableStatement stmt  = null; \r\n\t\t\r\n\t\ttry\r\n\t    {\r\n\t    \tconn = DriverManager.getConnection(&quot;hostname&quot;, &quot;admin&quot;, &quot;admin123&quot;);\t        \r\n\t        stmt = conn.prepareCall(pQuery);\t        \r\n\t        stmt.registerOutParameter(1, OracleTypes.CURSOR);\r\n\t        stmt.execute();\r\n\t        rs = (ResultSet) stmt.getObject(1);\r\n\t    } catch (SQLException e)\r\n\t\t{\r\n\t\t\te.printStackTrace();\r\n\t\t}\r\n\t\t\r\n\t\treturn rs;\r\n\t}\r\n\t\r\n\tpublic void closeConnection()\r\n\t{\r\n\t\tif (rs  != null) try { rs.close();  } catch (SQLException ignore) {}\r\n        if (stmt  != null) try { stmt.close();  } catch (SQLException ignore) {}\r\n        if (conn != null) try { conn.close(); } catch (SQLException ignore) {}\r\n\t}\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>DBUtilsTest.java public class DBUtilsTest { public void getDBRecordsSQLTest() { DBUtils objDBUtils = new DBUtils(); ResultSet resultSet = objDBUtils.getDBRecordsSQL(&quot;SELECT 78985450.1245487986418648 decimal_val FROM dual&quot;); double expectedValue = 1245.654618764; double dbValue = 0; double toleranceLimit = 0.000000001; try { while(resultSet.next()) { dbValue = resultSet.getDouble(&quot;decimal_val&quot;); assertEquals(expectedValue, dbValue, toleranceLimit); } } catch (SQLException e) { e.printStackTrace(); } objDBUtils.closeConnection(); } @Test&hellip; <a href=\"https:\/\/codethataint.com\/blog\/how-to-test-decimal-value-for-db-junit\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[48],"tags":[],"class_list":["post-540","post","type-post","status-publish","format-standard","hentry","category-junit"],"_links":{"self":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/540","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/comments?post=540"}],"version-history":[{"count":1,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/540\/revisions"}],"predecessor-version":[{"id":541,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/540\/revisions\/541"}],"wp:attachment":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/media?parent=540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/categories?post=540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/tags?post=540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}