What is the difference between ExecuteUpdate and
ExecuteQuery?
Answers were Sorted based on User's Feedback
Answer / anji
executeUpdate() - is used to update or modify the table, it
will returns howmany rows added/updated in the table.
executeQuery() - is used to retrieve the data from the
table. only for "select" query, this will return a
Resultset metadata
| Is This Answer Correct ? | 42 Yes | 2 No |
Answer / vishnuvardhan
ExecuteUpdate method will return integer value.
ExecuteQuery method will return ResultSet value.
| Is This Answer Correct ? | 45 Yes | 7 No |
Answer / balu
executeUpdate() --is used for executing non-select
statements
executeQuery() - is used for executing select statements
The above two are valid in SQLServer
Note: but i think in case of Oracle executequery()may also
accept non-select statements
| Is This Answer Correct ? | 19 Yes | 2 No |
Answer / fiza
when we seach any record from database we call the execute
query and when we write in database we call the update
method
| Is This Answer Correct ? | 15 Yes | 3 No |
Can filter be used as request or response?
what is the difference between servlets and struts?
List out the difference between ServletConfig and ServletContext?
Write a program to show the functionality of servlets.
What are the exceptions thrown by Servlets?
Does servlet have main method?
How values can be passed from HTML page to servlet?
Directive Include and Action Include how both are working in JSP, what is the difference between both?In which suituation we have to choose these elements?
What are the differences between servlet context vs servlet config?
How to make sure a servlet is loaded at the application startup?
How many objects of a servlet is created?
What is the difference between encodeRedirectUrl and encodeURL?