preparedstatement p= new preparedstatement
is it possible ?

Answers were Sorted based on User's Feedback



preparedstatement p= new preparedstatement is it possible ?..

Answer / satya veni

No.Interfaces can not be instantiated.
PreparedStatement ps=con.PreparedStatement("query");

Is This Answer Correct ?    27 Yes 2 No

preparedstatement p= new preparedstatement is it possible ?..

Answer / suresha

No,It should be following syantx

Preparestatement ps=con.preparestament("some query");

Is This Answer Correct ?    13 Yes 3 No

preparedstatement p= new preparedstatement is it possible ?..

Answer / suresha

correction.

Preparedstatement ps=con.Preparestatement("some query");

suresha

Is This Answer Correct ?    13 Yes 4 No

preparedstatement p= new preparedstatement is it possible ?..

Answer / sivam

No. Because PreparedStatement is an interface. we can not
create direct object instance in this interface, but we can
create reference.

ex:

PreparedStatement pst=con.PrpareStatement("Query");

Is This Answer Correct ?    12 Yes 4 No

preparedstatement p= new preparedstatement is it possible ?..

Answer / venkatesh

Correction. Syntax should be....

PreparedStatement ps = conn.prepareStatement("Query");

Thanks.

Is This Answer Correct ?    10 Yes 2 No

preparedstatement p= new preparedstatement is it possible ?..

Answer / abc

No,Syntax..............
PreparedStatement st=con.prepareStatement("query");
Thanks!

Is This Answer Correct ?    5 Yes 0 No

preparedstatement p= new preparedstatement is it possible ?..

Answer / t.l.n.prasad

no becoz PraparedStatement is an interface we can't
instantiate direcly but we can instantiate like this

PreparedStatement ps=con.PreparedStatement("Query");

where "con" is an Object of Connection interface
ie
Connection con=DriverManager.getConnection();

Is This Answer Correct ?    7 Yes 3 No

preparedstatement p= new preparedstatement is it possible ?..

Answer / surya, samcomm technologies pv

yes, but that is not the way to create object for the
interface. using Anonymous inner class.

syntax...

PreparedStatement ps=new PreparedStatement() {

U should implement all the methods of this
interface inside this block.

};

or if u feel this is overhead, then simply get the
reference for this interface in the following way.

PreparedStatement ps=con.prepareStatement("query");

Is This Answer Correct ?    5 Yes 1 No

preparedstatement p= new preparedstatement is it possible ?..

Answer / guest

dfg

Is This Answer Correct ?    2 Yes 12 No

preparedstatement p= new preparedstatement is it possible ?..

Answer / chandrakala

No, the statement must be look like this

PreparedStatement p=new perpareStatement("query");

Is This Answer Correct ?    6 Yes 16 No

Post New Answer

More JDBC Interview Questions

What is the JDBC?

0 Answers  


What is jdbc and its types?

0 Answers  


Is jdbc and orm?

0 Answers  


What are the advantages of collection pools?

0 Answers  


Compare jdbc and odbc and how is jdbc required in this context.

0 Answers  






Are all the required JDBC drivers to establish connectivity to my database part of the JDK?

0 Answers  


How many jdbc driver types are there?

0 Answers  


What are the factors that the jdbc driver performance depends upon?

0 Answers  


If iam using JDBC API, do I also have to use ODBC?

1 Answers  


What is difference between java.util.Date and java.sql.Date?

0 Answers  


what are design patterns?

3 Answers   CFC, TCS, Wipro,


What is the difference between execute, executeQuery, executeUpdate?

0 Answers  


Categories