top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

What is JDBC Statement?

+1 vote
39 views
What is JDBC Statement?
posted Aug 30, 2017 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

A JDBC statement object is used to execute an SQL statement. JDBC API supports three types of JDBC statement object to work with the SQL statements.

In JDBC we get three types of statements:

i Statement Interface

ii PreparedStatement Interface

iii CallableStatement Interface

There is a relationship between above three statements:

enter image description here

The above three Statement Interfaces are given in java.sql package. PreparedStatement Interface extends Statement. It means PreparedStatement interface has more features than that statement interface, Callablestatement (interface) extends Prepared Statement.

Statement

It executes normal SQL statements with no IN and OUT parameters.

PreparedStatement

It executes parameterized SQL statement that supports IN parameter.

CallableStatement

It executes parameterized SQL statement that invokes database procedure or function or supports IN and OUT parameter.

answer Sep 1, 2017 by Manikandan J
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...