PreparedStatement is a pre compiled statement but where it's
pre compiled ?
Answers were Sorted based on User's Feedback
Answer / aravind
Hi Manikandansit
There is a small correction in my answer prepared statement
will be parsed for the first time when it executes any query
and there onwards parsed query will be maintained in some
sort of pool....hence next time when it tries to execute
mutilple queries with different values parsing will not
happen again...that's how we say it as precompiled...so this
will reduce the processing time when u have multiple rows of
data to insert..
I hope this will help you...if u r not satisfied with the
answer please do let me know.
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / aravind
Hi,
in prepared statement when u mention the query that time
only statement will be internaly sent to DB and checks for
the query syntax, so when u execute it directly executes
the statement.
PreparedStatement pstmt = conn.prepareStatement("insert
into table (column2) values ("My Value") where id = 1000");
//pstmt is already compiled
pstmt.execute();
Is This Answer Correct ? | 5 Yes | 7 No |
What are the different types of resultset?
Is not bound in this context unable to find jdbc spring boot?
What is a jdbctemplate?
What is execute(), executeUpdate() and executeQuery() methods?
What is jdbc odbc connection?
How MS-Access DB can be accessed over a network, using JDBC API?
What are the main components of JDBC ?
How many isolation levels are supported in JDBC and what are they?
What is the return type of class.forname() method?
Can I enable requests to a jdbc connection pool for a database connection to wait until a connection is available?
How data can be inserted into long row column of database?
What are restrictions on triggers?