{"id":25528052,"date":"2022-06-12T01:16:15","date_gmt":"2022-06-11T19:46:15","guid":{"rendered":"https:\/\/entri.app\/blog\/?p=25528052"},"modified":"2024-05-29T13:44:24","modified_gmt":"2024-05-29T08:14:24","slug":"difference-between-execute-query-and-update-methods-in-java","status":"publish","type":"post","link":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/","title":{"rendered":"Difference Between Execute(), Query() and Update() Methods In Java"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79_2 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69e7bfa69fedf\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69e7bfa69fedf\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#Methods\" >Methods<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#_execute\" >\u00a0execute()<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#executeQuery\" >executeQuery()<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#_be_a_full_stack_developer_get_a_free_demo_video\" >\u00a0be a full stack developer ! get a free demo video !<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#executeUpdate\" >executeUpdate()<\/a><\/li><\/ul><\/nav><\/div>\n<p>Java is a multi-platform, object-oriented, and network-centric language that can be used as a platform in itself. It is a fast, secure, reliable programming language for coding everything from mobile apps and enterprise software to big data applications and server-side technologies.<\/p>\n<p class=\"intro\">A\u00a0<strong>method<\/strong> is a block of code which only runs when it is called. You can pass data, known as parameters, into a method. Methods are used to perform certain actions, and they are also known as\u00a0<strong>functions<\/strong>.<\/p>\n<p>Once you have created the statement object you can execute it using one of the execute methods of the Statement interface namely, execute(), executeUpdate() and, executeQuery().<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Methods\"><\/span><b>Methods<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>execute()<\/li>\n<li>executeQuery()<\/li>\n<li>executeUpdate()<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td style=\"text-align: center;\" colspan=\"3\">\n<h5><span style=\"color: #ffffff;\"><strong>Are you aspiring for a booming career in IT? If YES, then dive in<\/strong><\/span><\/h5>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<h5><a href=\"https:\/\/entri.app\/course\/full-stack-developer-course\/\"><strong>Full Stack Developer Course<\/strong><\/a><\/h5>\n<\/td>\n<td>\n<h5><a href=\"https:\/\/entri.app\/course\/python-programming-course\/\"><strong>Python Programming Course<\/strong><\/a><\/h5>\n<\/td>\n<td>\n<h5><a href=\"https:\/\/entri.app\/course\/data-science-and-machine-learning-course\/\"><strong>Data Science and Machine Learning Course<\/strong><\/a><\/h5>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"_execute\"><\/span><strong>\u00a0<\/strong>execute()<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><strong>Description: <\/strong>The method used for all types of SQL statements, and that is, returns a Boolean value of TRUE or FALSE.<\/li>\n<li><strong>Return type: <\/strong>This method return a Boolean value. TRUE indicates that query returned a Result Set object and FALSE indicate returned an int value or returned nothing.<\/li>\n<li><strong>Usage: <\/strong>This method is used to execute \u00a0Both select and non select queries.<\/li>\n<li><strong>Example<\/strong>: All SQL statements.<\/li>\n<\/ul>\n<p><strong>Illustration:<\/strong><\/p>\n<ul>\n<li>Java<\/li>\n<\/ul>\n<table width=\"696\">\n<tbody>\n<tr>\n<td width=\"690\">\/\/ Java Program to Illustrate usage of execute() Method<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Loading the driver using forName() method<\/p>\n<p>Class.forName(driver);<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Registering the driver using Drivermanager.getConnection() method<\/p>\n<p>Connection conn = DriverManager.getConnection(&#8220;jdbc:<a href=\"3306\/test\">mysql:\/\/localhost:3306\/test<\/a>&#8220;,<\/p>\n<p>&#8220;root&#8221;, &#8220;1234&#8221;);<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Get database connection<\/p>\n<p>stmt = conn.createStatement();<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Use Connection to create a Statement object<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Execute SQL and return boolean value to<\/p>\n<p>\/\/ indicate whether it contains ResultSet<\/p>\n<p><strong>boolean<\/strong> hasResultSet = stmt.execute(sql);<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Condition holds true till there is a single element<\/p>\n<p><strong>if<\/strong> (hasResultSet)<\/p>\n<p>{<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ If there is a ResultSet result set after execution<\/p>\n<p>rs = stmt.getResultSet();<\/p>\n<p>\/\/ Get the result set<\/p>\n<p>&nbsp;<\/p>\n<p>ResultSetMetaData rsmd = rs.getMetaData();<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ ResultSetMetaData is a metadata interface for analyzing result sets<\/p>\n<p><strong>int<\/strong>\u00a0 columnCount = rsmd.getColumnCount();<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Getting the output ResultSet object<\/p>\n<p>\/\/ with help of object of ResultSet<\/p>\n<p><strong>while<\/strong> (rs.next ())<\/p>\n<p>{<\/p>\n<p>&nbsp;<\/p>\n<p><strong>for<\/strong> (<strong>int<\/strong> i = 0 ; i &lt; columnCount ; i++ )<\/p>\n<p>{<\/p>\n<p>System.out.print(rs.getString(i + 1) + &#8220;\/t&#8221;);<\/p>\n<p>}<\/p>\n<p>System.out.print(&#8220;\/n&#8221;);<\/p>\n<p>}<\/p>\n<p>}<\/p>\n<p><strong>else<\/strong><\/p>\n<p>{<\/p>\n<p>&nbsp;<\/p>\n<p>System.out.println (&#8220;The records affected by this SQL statement are&#8221;<\/p>\n<p>+ stmt.getUpdateCount () + &#8220;Article&#8221;);<\/p>\n<p>}<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/entri.app\/course\/full-stack-developer-course\/\" target=\"_blank\" rel=\"noopener\">Learn to code from expert mentors! Enroll here<\/a><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"executeQuery\"><\/span>executeQuery()<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><strong>Description: <\/strong>Now this method execute statements that returns a result set by fetching some data from the database.<\/li>\n<li><strong>Usage: <\/strong>This method is use to execute select query.<\/li>\n<li><strong>Return type: <\/strong>This method returns a Result Set object which contains the result returned by query.<\/li>\n<li>One of it\u2019s example that is widely common: \u2018SELECT\u2019<\/li>\n<\/ul>\n<p><strong>Illustration:<\/strong><\/p>\n<ul>\n<li>Java<\/li>\n<\/ul>\n<table width=\"696\">\n<tbody>\n<tr>\n<td width=\"635\">\/\/ Java Program to Illustrate execute Query() Method<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Again first step is to load and register drivers<\/p>\n<p>Class.forName(&#8220;com.mysql.jdbc.Driver&#8221;);<\/p>\n<p>&nbsp;<\/p>\n<p>Connection\u00a0 conn = <strong>null<\/strong>;<\/p>\n<p>conn = DriverManager.getConnection(&#8220;jdbc:<a href=\"3306\/test\">mysql:\/\/localhost:3306\/test<\/a>&#8220;,<\/p>\n<p>&#8220;root&#8221;,&#8221;root&#8221;);<\/p>\n<p>\/\/ Using DriverManager to get database connection<\/p>\n<p>&nbsp;<\/p>\n<p>Statement\u00a0 stmt = conn.createStatement();<\/p>\n<p>\/\/ Use Connection to create a Statement object<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Creating an object of ResultSet class<\/p>\n<p>ResultSet rs =stmt.executeQuery(&#8220;select * from teacher&#8221;);<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Execute the query statement and save the result<\/p>\n<p>\/\/ Iterating over elements in above object<\/p>\n<p><strong>while<\/strong> (rs.next())<\/p>\n<p>{<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/ Getting the output the query result<\/p>\n<p>System.out.println(rs.getInt(1) + &#8220;\/t&#8221; +\u00a0\u00a0\u00a0 rs.getString(2));<\/p>\n<p>}<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"_be_a_full_stack_developer_get_a_free_demo_video\"><\/span><strong>\u00a0<a class=\"btn btn-default\" href=\"https:\/\/entri.app\/course\/full-stack-developer-course\/\">be a full stack developer ! get a free demo video !<\/a><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"executeUpdate\"><\/span>executeUpdate()<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><strong>Description: <\/strong>This method is used for execution of DML statement(INSERT, UPDATE and DELETE) which is return int value, count of the affected rows.<\/li>\n<li><strong>Usage:\u00a0<\/strong>This method is use to execute non select query. This method is use to execute select and non select queries.<\/li>\n<li><strong>Return type:<\/strong>An integer value which represent number of rows affected by the query. This will be 0 for statement which are returning nothing.<\/li>\n<li><strong>Example:<\/strong><\/li>\n<\/ul>\n<p>DML-&gt;INSERT , UPDATE and DELETE<\/p>\n<p>DDL-&gt; CREATE, ALTER<\/p>\n<p><strong>Illustration: \u00a0<\/strong><\/p>\n<p>Class.forName(&#8220;com.mysql.jdbc.Driver&#8221;);<\/p>\n<p>\/\/ Load the database driver<\/p>\n<p>Connection\u00a0 conn = null;<\/p>\n<p>conn = DriverManager.getConnection(&#8220;jdbc:mysql:\/\/localhost:3306\/test&#8221;,<\/p>\n<p>&#8220;root&#8221;,&#8221;1234&#8243;);<\/p>\n<p>\/\/ Use DriverManager to get database connection<\/p>\n<p>Statement\u00a0 stmt = conn.createStatement();<\/p>\n<p>\/\/ Use Connection to create a Statement object<\/p>\n<p>return stmt.executeUpdate(sql);<\/p>\n<p>\/\/ Execute the DML statement and return the number of records affected<\/p>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/entri.app\/course\/full-stack-developer-course\/\" target=\"_blank\" rel=\"noopener\">Learn to code from expert mentors! Enroll here<\/a><\/strong><\/p>\n<h3><strong>Differences in return types\u00a0<\/strong><\/h3>\n<ul>\n<li><strong>execute():\u00a0<\/strong>The return type is Boolean, indicating whether ResultSet return<\/li>\n<li><strong>executeQuery():\u00a0<\/strong>Type method returns a ResultSet, execute returns the results of the query, often used to perform the query<\/li>\n<li><strong>executeUpdate():\u00a0<\/strong>The return type is int, that the implementation of a number of rows affected after the sql statement, usually used to execute modification statements.<\/li>\n<\/ul>\n<ul>\n<li>Statement\u00a0<strong>execute(String query)<\/strong>is used to execute any SQL query and it returns TRUE if the result is an ResultSet such as running Select queries. The output is FALSE when there is no ResultSet object such as running Insert or Update queries. We can use\u00a0getResultSet()\u00a0to get the ResultSet and\u00a0getUpdateCount()\u00a0method to retrieve the update count.<\/li>\n<li>Statement\u00a0<strong>executeQuery(String query)<\/strong>is used to execute Select queries and returns the ResultSet. ResultSet returned is never null even if there are no records matching the query. When executing select queries we should use executeQuery method so that if someone tries to execute insert\/update statement it will throw java.sql.SQLException with message \u201cexecuteQuery method can not be used for update\u201d.<\/li>\n<li>Statement\u00a0<strong>executeUpdate(String query<\/strong>) is used to execute Insert\/Update\/Delete (DML) statements or DDL statements that returns nothing. The output is int and equals to the row count for SQL Data Manipulation Language (DML) statements. For DDL statements, the output is 0.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/full-stack-developer-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Learn coding in your Language, Download Entri App!<\/strong><\/a><\/p>\n<table>\n<tbody>\n<tr>\n<td style=\"text-align: center;\" colspan=\"3\"><strong>Our Other Courses<\/strong><\/td>\n<\/tr>\n<tr>\n<td><a href=\"https:\/\/entri.app\/course\/mep-course\/\"><strong>MEP Course<\/strong><\/a><\/td>\n<td><a href=\"https:\/\/entri.app\/course\/quantity-surveying-course\/\"><strong>Quantity Surveying Course<\/strong><\/a><\/td>\n<td><a href=\"https:\/\/entri.app\/course\/montessori-teachers-training-course\/\"><strong>Montessori Teachers Training Course<\/strong><\/a><\/td>\n<\/tr>\n<tr>\n<td><a href=\"https:\/\/entri.app\/course\/performance-marketing-course\/\"><strong>Performance Marketing Course\u00a0<\/strong><\/a><\/td>\n<td><a href=\"https:\/\/entri.app\/course\/practical-accounting-course\/\"><strong>Practical Accounting Course<\/strong><\/a><\/td>\n<td><a href=\"https:\/\/entri.app\/course\/yoga-teachers-training-course\/\"><strong>Yoga Teachers Training Course<\/strong><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Java is a multi-platform, object-oriented, and network-centric language that can be used as a platform in itself. It is a fast, secure, reliable programming language for coding everything from mobile apps and enterprise software to big data applications and server-side technologies. A\u00a0method is a block of code which only runs when it is called. You [&hellip;]<\/p>\n","protected":false},"author":55,"featured_media":25528054,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[802,1903,1841,1882,1881],"tags":[],"class_list":["post-25528052","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles","category-coding","category-entri-skilling","category-java-programming","category-web-android-development"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Difference Between Execute(), Query() and Update() Methods In Java<\/title>\n<meta name=\"description\" content=\"This article discusses about the execute methods\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Difference Between Execute(), Query() and Update() Methods In Java\" \/>\n<meta property=\"og:description\" content=\"This article discusses about the execute methods\" \/>\n<meta property=\"og:url\" content=\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/\" \/>\n<meta property=\"og:site_name\" content=\"Entri Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/entri.me\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-11T19:46:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-29T08:14:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/06\/Difference-Between-Execute-Query-and-Update-Methods-In-Java.png\" \/>\n\t<meta property=\"og:image:width\" content=\"820\" \/>\n\t<meta property=\"og:image:height\" content=\"615\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ayesha Surayya\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@entri_app\" \/>\n<meta name=\"twitter:site\" content=\"@entri_app\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ayesha Surayya\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/\"},\"author\":{\"name\":\"Ayesha Surayya\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/person\/568cc9d6e77fd5d01033b61c88343097\"},\"headline\":\"Difference Between Execute(), Query() and Update() Methods In Java\",\"datePublished\":\"2022-06-11T19:46:15+00:00\",\"dateModified\":\"2024-05-29T08:14:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/\"},\"wordCount\":948,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/entri.app\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/06\/Difference-Between-Execute-Query-and-Update-Methods-In-Java.png\",\"articleSection\":[\"Articles\",\"Coding\",\"Entri Skilling\",\"Java Programming\",\"Web and Android Development\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/\",\"url\":\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/\",\"name\":\"Difference Between Execute(), Query() and Update() Methods In Java\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/06\/Difference-Between-Execute-Query-and-Update-Methods-In-Java.png\",\"datePublished\":\"2022-06-11T19:46:15+00:00\",\"dateModified\":\"2024-05-29T08:14:24+00:00\",\"description\":\"This article discusses about the execute methods\",\"breadcrumb\":{\"@id\":\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#primaryimage\",\"url\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/06\/Difference-Between-Execute-Query-and-Update-Methods-In-Java.png\",\"contentUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/06\/Difference-Between-Execute-Query-and-Update-Methods-In-Java.png\",\"width\":820,\"height\":615,\"caption\":\"Difference Between Execute(), Query() and Update() Methods In Java\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/entri.app\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Coding\",\"item\":\"https:\/\/entri.app\/blog\/category\/coding\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Difference Between Execute(), Query() and Update() Methods In Java\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/entri.app\/blog\/#website\",\"url\":\"https:\/\/entri.app\/blog\/\",\"name\":\"Entri Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/entri.app\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/entri.app\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/entri.app\/blog\/#organization\",\"name\":\"Entri App\",\"url\":\"https:\/\/entri.app\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png\",\"contentUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png\",\"width\":989,\"height\":446,\"caption\":\"Entri App\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/entri.me\/\",\"https:\/\/x.com\/entri_app\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/person\/568cc9d6e77fd5d01033b61c88343097\",\"name\":\"Ayesha Surayya\",\"url\":\"https:\/\/entri.app\/blog\/author\/ayesha-surayya\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Difference Between Execute(), Query() and Update() Methods In Java","description":"This article discusses about the execute methods","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:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/","og_locale":"en_US","og_type":"article","og_title":"Difference Between Execute(), Query() and Update() Methods In Java","og_description":"This article discusses about the execute methods","og_url":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/","og_site_name":"Entri Blog","article_publisher":"https:\/\/www.facebook.com\/entri.me\/","article_published_time":"2022-06-11T19:46:15+00:00","article_modified_time":"2024-05-29T08:14:24+00:00","og_image":[{"width":820,"height":615,"url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/06\/Difference-Between-Execute-Query-and-Update-Methods-In-Java.png","type":"image\/png"}],"author":"Ayesha Surayya","twitter_card":"summary_large_image","twitter_creator":"@entri_app","twitter_site":"@entri_app","twitter_misc":{"Written by":"Ayesha Surayya","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#article","isPartOf":{"@id":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/"},"author":{"name":"Ayesha Surayya","@id":"https:\/\/entri.app\/blog\/#\/schema\/person\/568cc9d6e77fd5d01033b61c88343097"},"headline":"Difference Between Execute(), Query() and Update() Methods In Java","datePublished":"2022-06-11T19:46:15+00:00","dateModified":"2024-05-29T08:14:24+00:00","mainEntityOfPage":{"@id":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/"},"wordCount":948,"commentCount":0,"publisher":{"@id":"https:\/\/entri.app\/blog\/#organization"},"image":{"@id":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#primaryimage"},"thumbnailUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/06\/Difference-Between-Execute-Query-and-Update-Methods-In-Java.png","articleSection":["Articles","Coding","Entri Skilling","Java Programming","Web and Android Development"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/","url":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/","name":"Difference Between Execute(), Query() and Update() Methods In Java","isPartOf":{"@id":"https:\/\/entri.app\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#primaryimage"},"image":{"@id":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#primaryimage"},"thumbnailUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/06\/Difference-Between-Execute-Query-and-Update-Methods-In-Java.png","datePublished":"2022-06-11T19:46:15+00:00","dateModified":"2024-05-29T08:14:24+00:00","description":"This article discusses about the execute methods","breadcrumb":{"@id":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#primaryimage","url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/06\/Difference-Between-Execute-Query-and-Update-Methods-In-Java.png","contentUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2022\/06\/Difference-Between-Execute-Query-and-Update-Methods-In-Java.png","width":820,"height":615,"caption":"Difference Between Execute(), Query() and Update() Methods In Java"},{"@type":"BreadcrumbList","@id":"https:\/\/entri.app\/blog\/difference-between-execute-query-and-update-methods-in-java\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/entri.app\/blog\/"},{"@type":"ListItem","position":2,"name":"Coding","item":"https:\/\/entri.app\/blog\/category\/coding\/"},{"@type":"ListItem","position":3,"name":"Difference Between Execute(), Query() and Update() Methods In Java"}]},{"@type":"WebSite","@id":"https:\/\/entri.app\/blog\/#website","url":"https:\/\/entri.app\/blog\/","name":"Entri Blog","description":"","publisher":{"@id":"https:\/\/entri.app\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/entri.app\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/entri.app\/blog\/#organization","name":"Entri App","url":"https:\/\/entri.app\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png","contentUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png","width":989,"height":446,"caption":"Entri App"},"image":{"@id":"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/entri.me\/","https:\/\/x.com\/entri_app"]},{"@type":"Person","@id":"https:\/\/entri.app\/blog\/#\/schema\/person\/568cc9d6e77fd5d01033b61c88343097","name":"Ayesha Surayya","url":"https:\/\/entri.app\/blog\/author\/ayesha-surayya\/"}]}},"_links":{"self":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25528052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/comments?post=25528052"}],"version-history":[{"count":12,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25528052\/revisions"}],"predecessor-version":[{"id":25584979,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25528052\/revisions\/25584979"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/media\/25528054"}],"wp:attachment":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/media?parent=25528052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/categories?post=25528052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/tags?post=25528052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}