can someone tell me how does preparedstatement works? its
an interface and where is the implementation?
Answers were Sorted based on User's Feedback
Answer / sk.bilal ahmed
A SQL statement is precompiled and stored in a
PreparedStatement object. This object can then be used to
efficiently execute this statement multiple times.
Note: The setter methods (setShort, setString, and so on)
for setting IN parameter values must specify types that are
compatible with the defined SQL type of the input
parameter. For instance, if the IN parameter has SQL type
INTEGER, then the method setInt should be used.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / krishna
suppose if the string contains same select statement with
different set of values then fo for PreparedStatement..
ex:String str="select ename,eage from emp where ename=?";
yes it is interface provided by java soft people in their
api specification
Is This Answer Correct ? | 2 Yes | 0 No |
1. Yes PreparedStatement is and interface. It was in
java.sql package.
2. PreparedStatement interface creates an object that
represents a precompiled SQL statement. By using this we
can protect from SQL Injection.
Is This Answer Correct ? | 1 Yes | 3 No |
What is j2ee module?
Hello frds .recently I've got a call for the test in infosys .iam having 1.5 yr exp in java pltfrm.plz can anyone tell the main process( in detail) for infosys experienced professionals
What are the different types of events in java?
What is jaxr client?
What is j2ee technology?
What does resource adapt module contain?
Why is java important for internet?
What is event handling in java?
What is component in java with example?
Hi friends, can u explain Transparent Persistence in hibernate with sample code.
to update a batch in a table in jdbc which method of statement object is used
What is jradiobutton in java?