can someone tell me how does preparedstatement works? its
an interface and where is the implementation?

Answers were Sorted based on User's Feedback



can someone tell me how does preparedstatement works? its an interface and where is the implementa..

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

can someone tell me how does preparedstatement works? its an interface and where is the implementa..

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

can someone tell me how does preparedstatement works? its an interface and where is the implementa..

Answer / sreekanth madamanchi

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

Post New Answer

More J2EE Interview Questions

What is a panel java?

0 Answers  


Whats the O/p of the below code snippet ? And explain how does it imply the concept of call-by-value/call-by reference. (PS : Pls ignore syntax errors) public class One { public oneA(){ sop ("Into One--");} } public class Two extends One{ public twoT(){ sop ("Into Two--"); } } public class Home { One a; Two t; public static void main(argv[]) { sop ("In Home--"); sop(a.oneA()); sop(t.oneA()); sop(a.twoT()); sop(t.twoT()); } }

4 Answers   Wipro,


Who is java developer?

0 Answers  


What are the main components of multi-tier architecture?

0 Answers  


What is filter chain?

0 Answers  






What is the difference between sendRedirect() and forward()? in what situations do we have to use send redirect() instead of forward().

13 Answers   Honeywell, Mind Tree, Samsung, Wipro,


What is java application server?

0 Answers  


What is document root?

0 Answers  


What is general entity?

0 Answers  


What is the difference between java and core java?

0 Answers  


What is java actionlistener?

0 Answers  


What is a gui in java?

0 Answers  


Categories